GL Analysis

> GL Analysis

You use this program to distribute values to various analysis category codes within the category types.

A GL Analysis Summary report can be selected from the SYSPRO Reporting Services menu.

This screen is displayed if at least one ledger code in a transaction is defined as requiring analysis (General Ledger Codes or GL Structure Definition).

Field	Description
End Analysis	Select this to complete the analysis allocation(s) and to return to the previous screen. This function is only enabled when the Undistributed value is zero. An analysis number is automatically assigned to each analysis entry processed. Analysis numbers can be viewed using the GL Query program and printed on the GL Trial Balance report.
Play	Select this to use the Multimedia program to view any multimedia objects assigned to the entry currently highlighted in the listview.
Edit	Select this to use the Multimedia program to add or maintain any multimedia objects assigned to the entry currently highlighted in the listview.
Notes	Select this to use the Notepad Editor program to assign free format notes to the entry currently highlighted in the listview.
Undistributed	Select this to distribute the value displayed in the Undistributed amount field to the analysis code selected.
Ask Me Later	Select this if you do not want to enter the GL analysis information at this time. The GL analysis information will be entered using the GL Journal Entry program before the ledger journal for the transaction can be posted. This function is only enabled if the option: Force GL Analysis - GL journal posting is selected for the sub-module (General Ledger Integration - General Ledger tab).

Field	Description
Ledger code	This indicates the ledger code for which the undistributed value must be distributed to the category codes.
Analysis category	This indicates the analysis category defined against the ledger code displayed in the previous field (see General Ledger Codes or GL Structure Definition).
Source	This indicates the source of the transaction if the transaction has arisen from a module other than the General Ledger. If the source of the transaction is the General Ledger (e.g. GL Journal Entry), then the description defined against the ledger code is displayed in this field.
Batch total	This indicates the total amount posted against the ledger account, which needs to be distributed to various analysis codes.
Distributed amount	This indicates the amount currently distributed to analysis codes.
Undistributed amount	This indicates the total value that must still be distributed to the analysis codes for the current category. This amount is displayed in the local currency, irrespective of the currency in which the transaction was processed. The foreign currency transaction value is converted to the local currency equivalent for (analysis purposes) using the rate currently defined in the currency table (Browse on Currencies). This amount must be zero before you can exit the GL Analysis screen.

You use this editable listview to distribute the amounts to the various analysis codes.

Field	Description
Analysis codes 1 - 5	The descriptions for these columns default to the descriptions of the analysis types defined against the category (see GL Analysis Categories and Codes). Use these fields to distribute the transaction values to the analysis codes defined against the analysis types. For each mandatory analysis type you need to enter the value to distribute to the applicable analysis code. You can use the Browse button at each analysis code field to select an analysis code using the GL Analysis Codes program.
Amount	Enter the amount you want to process against the selected analysis category code. This amount can be positive or negative.
Start date	Optionally enter the start date to which the transaction value for this analysis code relates. If you enter a start date, then you must enter a transaction end date. The transaction start date must be before the transaction end date.
End date	Enter the end date to which the transaction value for this analysis code relates. This date must be after the transaction start date.
Comment	Enter a free format comment relating to the transaction for the current analysis code.

General Ledger analysis entries are always distributed in the local currency, irrespective of the currency in which the original transaction is processed.
General Ledger analysis entries cannot be distributed to another company. Therefore, when processing an inter-company journal, you are not requested for General Ledger analysis distribution in the target company, irrespective of whether G/L analysis is required for the account(s) in the target company.
G/L analysis entries are only posted from sub modules if the sub module is linked to the General Ledger in detail at company level (General Ledger Integration - General Ledger tab) or at ledger account code level (General Ledger Codes or GL Structure Definition). This is irrespective of whether you defined analysis distribution entries using the GL Analysis program.

Distribute analysis values

From the GL Analysis program, select the analysis code from the analysis type to which you want to distribute a value.

For each mandatory analysis type you need to enter the value to distribute to the applicable analysis code.

You can use the Browse button at each analysis code field to select an analysis code using the GL Analysis Codes program.
Optionally enter transaction start and end dates.
Optionally enter a comment.
Enter the amount to be distributed to the analysis code selected, or select the Undistributed function to distribute the value in the Undistributed amount field to this analysis code.

When the undistributed value is zero, select the End Analysis function.


	If you selected to distribute a zero value to a ledger code that requires analysis (for example from the AP Invoice Posting program), then the undistributed value in the GL Analysis program is displayed as zero, but you will be unable to end the analysis. You need to process a value to the mandatory analysis code(s). You then need to process a reverse analysis entry to contra the initial entry(ies) and bring the undistributed value back to zero. Only then can you end the analysis and exit the GL Analysis program.