Cash Book > GL Integration > Cash Book GL Integration

Cash Book GL Integration

You use this program to create General Ledger journals from the transaction journals produced in the Cash Book module.

Toolbar and menu

Field Description
Start Processing

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

If you did not select the option: Create GL journal for the Cash Book (General Ledger Integration), then the journals for the General Ledger are created from the Cash Book transaction journals.

If the option: Create GL journal is not enabled for Cash Book, 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.

[Note]

Once you have started processing, various journal entry programs will be locked out in order to prevent partial Cash Book Journal entries. Once processing has been completed this lock will be lifted and those same journal entry programs will be able to post to the Cash Book Journal.

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
Current GL period This indicates the current period and year of your Cash Book module. This is displayed for information purposes and cannot be changed.
Bank options  
Bank selection Indicate the bank(s) for which you want to process journals.
Bank Indicate the single bank for which to process journals.
Journal options  
Function Indicate the Cash Book journal(s) for which you want to create, or create and post, the General Ledger journal(s).
From cash book year Indicate the Cash Book year from which you want to process the journal.
From cash book month Indicate the Cash Book month (within the selected year) from which you want to process the journal.
From cash book journal Indicate the Cash Book transaction journal from which you want to create, or create and post, the General Ledger journal.

You can select the browse icon to use the Cash Book Journals program to select the transaction journal you want to process.

To cash book year Indicate the Cash Book year to which you want to process the journal.
To cash book month Indicate the Cash Book month (within the selected year) to which you want to process the journal.
To cash book journal Indicate the Cash Book transaction journal to which you want to create, or create and post, the General Ledger journal.

You can select the browse icon to use the Cash Book 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 bank for which the journal was created
  • the year and period of the journal
  • the General Ledger journal number created for the transaction
  • the SYSPRO company ID in which the journal was created.

Notes and warnings

Program access

  • This program can only be accessed if Cash Book 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 Cash Book Journals program to identify the transaction journals for which ledger journals have not yet been created.

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.

Application Help Pane

Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.

You can embed an Application Help Pane:

  • in the main SYSPRO menu

  • in any program with panes, if not using roles

  • when adding a role layout in Design Mode.

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.