GL Weighted Transfer Processing

General Ledger > Transaction Processing > GL Weighted Transfer Processing

GL Weighted Transfer Processing

You use this program to create and optionally post journals for the rule(s) you selected and defined using the GL Weighted Transfer program.

GL Weighted Transfer Processing

Field

Description

Create Journal

Select this to create the journal(s) for the rule(s) selected in the GL Weighted Transfer Selection listview.

The journals are created based on the balances in the Source and Statistical accounts selected in each rule (GL Weighted Transfer).

The screen of the GL Journal Entry program is automatically displayed, enabling you to view the entries for the journal.

If you selected the Auto postoption, then the journal is automatically posted once it has been created, providing it does not require authorisation.
If you did not select the Auto post option, then from the GL Journal Entry program, you can place the journal on hold or authorize, cancel, print or post the journal.

Journal details

Reference

Enter a reference for the journal.

The entry made here is printed on the GL Journal Report and can be viewed within the GL Query program.

Notation

Enter additional text as a notation against the journal.

This entry is printed on the GL Journal Report and can be viewed within the GL Query program.

Journal type

Indicte the type of journal that must be created using the selected rule(s).

Field	Description
Normal	Select this to create a normal journal. Normal journals are traditional journals which you post once only to the General Ledger module. The journals are posted to the ledger detail file with a source code of JE.
Statistical	Select this to process a statistical journal. If you select this, then you will only be able to process entries to accounts defined as Statistical (General Ledger Codes).
Provision	A provision journal is the same as a normal journal, except that it can be reversed automatically at period and/or year end and it can only be posted into your current period. The journal is posted to the ledger detail file with a source code of PV (if provision journals are to be reversed at period/year end) or RV (if provision journals have been reversed by the GL Period End program at period or year end).
Period end adjustment	This journal enables you to post adjustments to a prior period. The journal is posted to the ledger detail file with a source code of PE.
Auditor's adjustment	This journal enables you to process the final ledger adjustments for the year when you are in the last period of your General Ledger. The journal is posted to the ledger detail file with a source code of AU. This journal can be password-protected
User-defined	A user-defined journal is the same as a normal journal, except that you can specify your own source code for the journal. User defined journal source codes are maintained using the Browse on Journal Source Codes program.

Auto post

Select this to automatically post the journal once it is created.

If you do not select this option, then the journal is only created and you will need to post it using the GL Journal Entry program.


	If authorisation of journals before posting is required (General Ledger Setup - Journals tab) then the journals are not automatically posted. They will need to be authorised first using the GL Journal Entry program and then posted using the same program.

GL Weighted Transfer Selection

This pane enables you to indicate the rule(s) for which you want to create and optionally post journals.

You use the checkbox in the first column of the listview to select the rule(s) for which you want to create journals. When you select a rule, a tick is displayed in the checkbox. Once selected, you deselect the rule by clicking in the checkbox for that rule. The tick is then removed from the checkbox and no journal is created for that rule when you select the Create Journal function.

The details of each rule are displayed for information purposes.

Balance to Balance Calculation

Currently the GL Weighted Transfer Processing program calculates the values for the journal based on the balance in the Source and Statistical ledger accounts selected in the GL Weighted Transfer program.

The value for each destination account is calculated as follows:

(Balance in source account / Sum of balances in statistical accounts) x balance in Statistical account


	The ledger codes used for the Statistical accounts need not be Statistical account types.

The following example illustrates this.

The balance in the Source ledger account for the first period is 1 000.

The balances in the Statistical accounts for the first period are: 20, 15 and 5.

The Destination ledger codes are D1, D2 and D3.

The journal created is:

Account D1 Dr 500 i.e. (1000 / (20 + 15 +5)) x 20

Account D2 Dr 375 i.e. (1000 / (20 + 15 +5)) x 15

Account D3 Dr 125 i.e. (1000 / (20 + 15 +5)) x 5

Source Account Cr 1000

Assume the balances in the statistical accounts for the second period are changed to 25, 15 and 10.

The balance in the Source ledger account for the second period is 1 000.

The journal created is:

Account D1 Dr 500 i.e. (1000 / (25 + 15 +10)) x 25

Account D2 Dr 300 i.e. (1000 / (25 + 15 +10)) x 15

Account D3 Dr 200 i.e. (1000 / (25 + 15 +10)) x 10

Source Account Cr 1000


	If the rule for the second period is Processed and Posted twice in the second period, then the following journals are created and posted:

Account D1 Dr 500 i.e. (1000 / (25 + 15 +10)) x 25

Account D2 Dr 300 i.e. (1000 / (25 + 15 +10)) x 15

Account D3 Dr 200 i.e. (1000 / (25 + 15 +10)) x 10

Source Account Cr 1000

AND

Account D1 Dr 500 i.e. (1000 / (25 + 15 +10)) x 25

Account D2 Dr 300 i.e. (1000 / (25 + 15 +10)) x 15

Account D3 Dr 200 i.e. (1000 / (25 + 15 +10)) x 10

Source Account Cr 1000

This means that the balance in the source ledger account is now a credit of 1 000. The GL Weighted Transfer Processing program does check whether a rule has already been processed in a specific period.

Notes and warnings

Coding considerations

Rules may be processed (and therefore journals created), more than once in a single ledger period. No warnings are displayed when a rule is processed more than once in a single period.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

Open the program for which you want to insert application help into a customized pane.

This functionality is only available for a program that has panes.
Right-click any form field.

You can also click the triangle menu icon that appears in the title area of a pane.
Select Insert Application Help from the context-sensitive menu.

The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

Select the Close icon in the right-hand corner of the application help pane.
Confirm that you want to delete the pane.