General Ledger > GL Integration > GL Integration Utility

GL Integration Utility

You use this program to restore the integrity of the journal numbers and flags for ledger journals created from the sub-module journals.

The GL Integration programs in the sub-modules create General Ledger journals from the sub-module transaction journals. The ledger journal numbers and flags can become corrupt if the processing of the GL Integration programs is interrupted due to operator intervention or network or computer failure.

Corrupt ledger journal numbers and flags prevent the creation and posting of the sub-module journals into the General Ledger.

Toolbar and menu

Field Description
Start Processing Select this to rest the flags and journal numbers as per the Journal options you indicated.

If you are not logged into SYSPRO as ADMIN and you selected the Reset GL integration flag option, then the following message is displayed:

"You are not logged in as ADMIN and may not run this function."

If you selected Reset GL integration flag and operators are processing transactions, then the message: The following operators are accessing files needed exclusively... is displayed and the process is stopped until the locked files are released.

If you are logged into SYSPRO as ADMIN and you selected Reset GL integration flag, then the following message is displayed:

"Once you have run this utility and you are ready to post submodule journals, please ensure that the correct submodule journals are selected to post. Posting the incorrect submodule journals will create duplicate GL journal entries."

This warning is to highlight that the Reset GL integration flag option should only be used when you know which journals have not been posted to the General Ledger.

When you select the Reset GL integration flag option, the program locates all journals for each selected module which have been set to posted, but which have a zero year, period and journal number. The "posted" flag is then reset to "not posted" for all these journals.

Because the Reset GL integration flag option resets a journal from posted to unposted, you could end up duplicating journals in the General Ledger.

For example:

If your GL Integration options were set to Not Integrated, then records would have been created with no period, year or GL journal number, but the posted flag would have been set to 'Y'. If you then change your integration options to 'Integrated' and run the GL Integration Utility program with the Reset GL integration flag, the posted flag is reset to N.

The next time you run a GL Integration program for the module, all these journals will be posted to the GL. You could, however, have previously manually posted the same journals when the ledger was not integrated.

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

Form values and defaults are applied at operator level. They are not saved at role or group level.

Information

Field Description
Journal options  
Function Indicate the function you want to perform.
OptionDescription
Reset GL integration flag
[Note]

The following message is displayed when you enable this option and you have been running your General Ledger module for less than two years:

PLEASE NOTE that it is not advisable to run this utility if your GL integration has been running for less than 2 years.

Under no circumstances (unless instructed by SYSPRO) should you run this utility as your data can be corrupted.

This option was added to the previous version of the software when the Real Time General Ledger Integration functionality was added, because issues with the software caused journals that were not posted to the General Ledger to be flagged as posted

This option will be removed during the lifetime of the current version of the software.

Select this to reset the General Ledger integration flag for the sub-modules you select.

The GL integration flag is reset if the GlYear, GlPeriod and GlJournal are all zeroes against the journal.

Only the sub-module journals for the current year and the previous year are reset.

[Note]
  • It is strongly recommended that you back up your data before using this function.

    The ledger journal numbers and flags can become corrupt if the processing of the GL Integration programs is interrupted due to operator intervention or network or computer failure.

    Corrupt ledger journal numbers and flags prevent the creation and posting of the sub-module journals into the General Ledger.

  • You can only process this function if you log into SYSPRO as ADMIN.

This flag is set by the sub-module GL Integration programs during the first phase of processing. For each sub-module transaction journal, it indicates whether a General Ledger journal was created from the sub-module transaction journal.

The General Ledger period, year and journal number are only allocated during the second phase of processing.

If processing of a sub-module General Ledger integration program is interrupted, then this flag could have been set to "Y" before the General Ledger period, year and journal number are allocated.

Selecting this option resets this flag from "Y" to a space, if no period, year and journal number are allocated. This allows the General Ledger journal to be created from the sub-module journal when next the GL Integration program is run.

Reset lowest unprocessed jnl

Select this to locate the earliest sub module journal that has not been posted for the selected GL Integration program(s) listed below.

The GL Integration programs create and/or post General Ledger journals from sub-module transaction journals according to your General Ledger Integration settings. These GL integration programs use the lowest unprocessed sub-module journal numbers as a starting point to create/post these General Ledger journals.

Selecting this option therefore ensures that no journal for the selected sub-module(s) is skipped when the General Ledger journals are created/posted for the sub-module(s).

Where applicable, resetting the lowest unprocessed journal can also be performed in the sub-module period end programs. However, the processing time in the GL Integration Utility program is faster as it is not combined with any of the other functions performed by the period end programs.

Reset in process flags

Enable this to reset the 'in process' status flag for AP invoices, AR invoices, AR payments, Inventory journals and WIP labor journals.

You indicate which of these journals to reset in the Integration flag setup section.

This only applies in a SQL environment.
Integration flag setup The files selected cannot be in use while the in process flag is being reset.
Selection Indicate the period and year for which you want to reset the GL integration flag.
OptionDescription
AllSelect this to reset the GL Integration flag for all transactions that have no period, year or journal number.
SingleSelect this to reset the GL Integration flag for a single period. You indicate this period in the From year and From month fields.
RangeSelect this to reset the GL Integration flag for the range of periods indicated.
AP invoices Reset the flags and/or journal numbers for transactions created by the AP Invoice GL Integration program.
AP payments Reset the flag and/or journal numbers for transactions created by the AP Payments GL Integration program.
AR invoices Reset the flags and/or journal numbers for transactions created by the AR Invoice GL Integration program.
AR payments Reset the flags and/or journal numbers for transactions created by the AR Payments GL Integration program.
Assets Reset the flag and/or journal numbers for transactions created by the Asset GL Integration program.
Cash book Reset the flag and/or journal numbers for transactions created by the Cash Book GL Integration program.
GRN journals Reset the flag and/or journal numbers for transactions created by the GRN GL Integration program.
Inventory Reset the flags and/or journal numbers for transactions created by the Inventory GL Integration program.
TPM journals Reset the GL integration flag for transactions created by the Trade Promotions GL Integration program.
WIP labor Reset the flags for transactions created by the WIP Labor GL Integration program.
WIP part billings Reset the GL integration flag for transactions created by the WIP Part Billings GL Integration program.
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

This pane displays the results of the processing function you selected once processing is complete (unless you selected the option to close the application from the After processing completed section).

Notes and warnings

Prerequisites

  • Although the GL Integration Utility program can be run at any time, as often as required and for all or selected sub-modules, it is strongly recommended that you back up your data before using the Reset GL integration flag function.

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.