General Ledger Integration Window

 

This window appears when you confirm your replies in the Configuration Window if General Ledger is in use

Purpose

The parameters in this window control postings into General Ledger from:

§   Debtors Ledger.

 

§   Creditors Ledger.

 

§   Cash Manager.

 

These are referred to below as 'sub-modules'.

 

Postings from these modules to General Ledger are made via a transfer file. This can be generated and transferred into General Ledger:

§   Via the 'on-line posting' option, in which the transfer file is automatically generated and transferred into General Ledger whenever a batch in one of the sub-modules is posted. On-line posting is only available for 'BOS' format interfaces.

 

§   By manually invoking the Create GL Transfer File option in the sub-modules, and then the Auto-Entry function in General Ledger. This enables one transfer file to be created in each sub-module at specific intervals, for example, once a week or once a financial period. This method must be used if the modules are on different computers.

Note

In Cash Manager, the on-line option also generates General Ledger transfer files when currency exchange information is confirmed, when a fund transfer is closed, and when a bank reconciliation involving foreign currency transactions is closed.

 

The first parameter in this window controls how these postings are made. When the on-line option is selected, the remaining parameters enable you to enter criteria for the posting report which can be printed when batches are transferred into General Ledger. In the General Ledger Manual, this report is called the Auto-Entry Report.

Note

You need to define the details of the transfer file interfaces in System Parameters in the sub-modules, and in Interface Definitions in General Ledger. The option to print a report of the transfer is only available for interfaces with the 'BOS' format. This format is available when posting from Global 3000 modules version 4.2 or later.

 

The interface definition controls whether the General Ledger batches created by the transfer are automatically posted in General Ledger, thus preventing any further amendments. When this option is not selected you need to post the batches manually in General Ledger after the transfer is complete.

Further information

For further information, see Automatic Transfers and Interface Definitions in the General Ledger Manual.

The prompts are:

On-line posting to General Ledger

(Y/N.) Enter Y to select on-line posting to General Ledger from Debtors Ledger, Creditors Ledger and Cash Manager.

 

Enter N if you want to initiate the transfer from these modules into General Ledger manually. This is necessary if the sub-modules are on different computers from General Ledger.

Note

When this prompt is set to N the remaining prompts in the window are skipped. This is because you have the opportunity to enter selection criteria for the auto-entry report when you run the auto-entry program in General Ledger .

Print detailed/summary/ no posting report

(Only if on-line posting is selected.) When a file is transferred into General Ledger you can print the auto-entry report showing each transaction involved in the transfer, together with control totals. This prompt controls the generation of this report. Enter one of the following:

§   D for a detailed report.

 

§   S for a summary report.

 

§   N for no report.

Standard or maximum width

(Only if on-line posting is selected.) This prompt controls the width of the Auto-Entry report. Enter one of the following:

§   S for a standard width report. This format prints values with up to nine leading decimal places. Values which exceed this appear as asterisks. This format can be printed on most standard printers and can be displayed on the screen. We recommend you use this option except when you are dealing with very large values.

 

§   M for a maximum width report. This format prints values with up to 15 leading decimal places and requires a printer capable of printing at least 202 characters per line. This format cannot be displayed on the screen.

Posting report sequence

(Only if on-line posting is selected.) This prompt controls the sequence of the transactions on the Auto-Entry report. The report always sequences the transactions by company/profit centre/account codes. However you have a choice of the way the report sequences the items posted to each General Ledger account. This is designed to facilitate reconciliation with the originating modules. Enter one of the following:

§   B for batch/item sequence. The transactions are shown in ascending sequence of the sending system daybook batch and item numbers. This option is useful for audit trailing between General Ledger and the other Global 3000 financial modules.

 

§   O for original order number sequence. The transactions are shown in ascending sequence of their sending system order numbers. This option is useful for reconciling postings at Purchase Order Goods Receipt with Purchase Invoice postings which come to General Ledger via Creditors Ledger.

 

§   R for document reference sequence. The transactions are shown in ascending document number sequence. This option is useful for sorting out postings that arise at different points in the business cycle but which are cross-related by document reference.

On confirmation

If Cash Manager is in use Þ Cash Manager Integration Window.

Otherwise Þ Accounting Parameters Window.