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 amount 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 Admin Notepad Editor (Rich Text) 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 general ledger analysis is enabled for the sub-module (General Ledger Integration). |
| 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 Capture GL Analysis Entries 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 Category Code Browse 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.
-
GL analysis entries can only be entered from sub modules if the sub module is linked to the General Ledger in Detail at company level (General Ledger Integration) or at ledger account code level (General Ledger Codes or GL Structure Definition).
-
GL 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) 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 Capture GL Analysis Entries program.
Distribute analysis values
-
From the Capture GL Analysis Entries 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 Category Code Browse 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.
![[Note]](images/note.png)
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 Capture GL Analysis Entries 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 Capture GL Analysis Entries program.