Accounts Receivable > GL Integration > AR Invoice GL Integration

AR Invoice GL Integration

You use this program to create General Ledger journals from the transaction journals produced using the AR Invoice Posting, AR Initial Invoice Capture, AR Finance Charge Calculation, Sales Order Entry, Document Print and AR Post Permanent Entries programs.

AR Invoice GL Integration Update

Field Description
Start Processing

Select this to begin processing according to the Journal options you selected.

TheAR Invoice GL Integration program checks that all sales interface entries exist. These include the interfaces for Branch, Warehouse, Product Class and Geographic Area as defined on the Receivables tab of the General Ledger Integration program. You use the Sales Analysis Transaction Maintenance program to correct invalid entries and then rerun the AR Invoice GL Integration program to create the General Ledger journals for the registers.

No General ledger journals are created for invoices processed using the AR Initial Invoice Capture program. The journals can, however, be printed using the AR Invoice Register program.

If sales tax is integrated to General Ledger at tax code level (Tax Options - General tab), then the ledger code held against the tax code is used for integration.

If the option: Create GL journal is not enabled for Accounts Receivable, but the option: Post GL journal (General Ledger Integration) is enabled, then once the journals are created they are automatically posted into the General Ledger. You use the GL Journal Report program to generate a report of these journals.

If you did not select the Post GL journal option, then you need to use the GL Journal Entry program to post the journals once they are created.

See also: Notes and warnings.

Print Select this to print the information currently displayed in the Report pane.
Save Form Values This option is only enabled in Design mode (see Automation Design). Your selections are saved and applied when the program is run in automated mode.

Information

Field Description
Journal options  
Select single journal Select this to process a single journal.

If you do not select this option, then all Accounts Receivable invoice journals are created, or created and posted.

Ledger year Indicate the General Ledger year for which you want to process the journal.
Ledger month Indicate the General Ledger period for which you want to process the journal.
Journal Indicate the Accounts Receivable invoice transaction journal for which you want to create, or to create and post, the General Ledger journal.

You can select the browse icon to use the AR Sales Transaction Journals program to select the transaction journal you want to process.

After processing completed These options are displayed within programs that can be automated. They enable you to indicate the action you want to perform once processing is complete (see Automation Design).

Report

The results of the processing function you selected are displayed in this pane once processing is complete (unless you enabled the option to close the application from the After processing completed section). You use this section to print or email this information.

The details of the General Ledger journal(s) created are displayed and include:

  • the year and period of the journal
  • the General Ledger journal number created for the transaction

The following applies for invoices processed to more than one warehouse control account:

  • *Multiple* is printed on the report instead of the General Ledger codes:

    • when Accounts Receivable is integrated as Not linked to G/L - distribution report (General Ledger Integration)

    • if Accounts Receivable was integrated as Linked to G/L in summary at the time the invoice was posted, even if you subsequently changed this to Linked to G/L in detail.

  • The register number will not print for the warehouse control if Accounts Receivable is integrated as Linked to G/L in summary.

  • 'Wh: is printed in the comment line if Accounts Receivable is integrated as Linked to G/L in summary.

In all other cases, the General Ledger codes for the multiple warehouses are printed on the report.

[Note]

The warehouse codes are taken from the GL Journal Detail file.

If you maintained the Warehouse entries in the GL Journal, then the changed ledger entries are printed on the report and could cause the report not to balance.

Notes and warnings

Program access

  • This program can only be accessed if Accounts Receivable is linked to the General Ledger either in detail or in summary (General Ledger Integration).

Coding considerations

While the transaction journals are created automatically when you successfully process a transaction, the corresponding General Ledger journals are created and posted according to your selections for the module in the General Ledger Integration program. Refer to Effect of automation level selected.

Errors

  • When errors are detected during the creation of the General Ledger journals from the sub-module transaction journals, the journal may or may not be created depending on the type of error.

    Refer to General Ledger Integration Error Handling for additional details.

  • You can use the AR Sales Transaction Journals program to identify the transaction journals for which ledger journals have not yet been created.

  • In process registers found

    This message indicates that at least one operator is currently posting Accounts Receivable invoices.

    If no operators are posting AR invoices, then use the GL Integration Utility program to reset the 'in process' register flags.

  • GL journal cannot be created because the interface records are missing

    If you are running the AR Invoice GL Integration program manually, then a detailed error message is displayed and the details of the missing sales interface records are written to the Job Logging Query program.

    If the AR Invoice GL Integration program is called from within a posting program (i.e. you selected to automatically create GL journals for Accounts Receivable (General Ledger Integration) then the error is only written to the Job Logging Query program.

GL analysis considerations

  • If the GL analysis required option is enabled for a ledger account used in this program (General Ledger Codes or GL Structure Definition) then the GL Analysis program is displayed when you post the transaction, so that you can enter the analysis details.

    The Ask Me Later function is only available when the option: Force GL Analysis - GL journal posting is enabled for the sub-module (General Ledger Integration - General Ledger tab).

    General Ledger analysis entries are always distributed in the local currency, regardless of the currency in which the original transaction is processed.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction Description
GL Create journal from sub module

Controls access to the creation of journals from a sub module journal.

The GL integration programs which are affected by this eSignature are: AR Invoice GL Integration, AR Payments GL Integration, AP Invoice GL Integration, AP Payments GL Integration, Cash Book GL Integration, Asset GL Integration, Inventory GL Integration, TPM GL Integration, GRN GL Integration, WIP Labor GL Integration and Part Billings GL Integration.

GL Create and post journal from sub module

Controls access to the creation and simultaneous posting of journals from a sub module journal.

The GL integration programs which are affected by this eSignature are: AR Invoice GL Integration, AR Payments GL Integration, AP Invoice GL Integration, AP Payments GL Integration, Cash Book GL Integration, Asset GL Integration, Inventory GL Integration, TPM GL Integration, GRN GL Integration, WIP Labor GL Integration and Part Billings GL Integration.

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.

  1. 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.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. 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.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.