General Ledger > Setup > GL Code Conversion

GL Code Conversion

You use this program to change existing ledger codes throughout the SYSPRO system.

This enables you to restructure your existing General Ledger account codes in all files/tables to match the General Ledger structure definition currently defined.

Toolbar and menu

Field Description
Start processing

Changes the selected ledger account code(s) to the new account code(s) entered. This option is only enabled when no errors are indicated in the entry grid.

See also: Notes and warnings.
Validate Checks that there are no blank entries and that fields are not duplicated or don't already exist.

Ledger Code Conversion

Field Description
Ledger Code Conversion  
Ledger code Enter an existing ledger account code you want to change.
New GL code Enter the new account code you want to assign to the ledger code.
[Note]

The key type must match the key type defined for ledger codes.
Ledger Code Conversion Tickover This pane displays a tick over of the table/file name and description currently being updated by the conversion.

Notes and warnings

Restrictions and limits

  • Only the existing ledger code(s) in the current company are changed, regardless of whether you are sharing General Ledgers across companies.

  • The GL structure definition section settings (GL Structure Definition) are not changed when using the GL Code Conversion program.

    If you want to change your GL codes into a different format (structure) than what is currently defined in the GL Structure Definition, then you need to define the new GL structure before using the GL Code Conversion program to change the GL code.

    If you merely use the GL Code Conversion program to change the GL codes into a different structure than is currently defined, then although the actual GL codes will be changed, SYSPRO will consider the new GL codes as invalid because they do not match the GL structure currently defined.

  • The conversion is aborted if a table/file is in use.

  • Operators will not be able to log into SYSPRO while the conversion program is running.

    The ADMOPR file is locked exclusively during the conversion, to convert the GL fields (ADMOPR-WIPP09-GL and ADMOPR-WIPP07-GL, ADMOPR-WIPP05-GL, ADMOPE-GL-NON) in the ADMOPR. This prevents other operators from logging into the system. Instead, they are prompted with the SYSPRO Setup wizard (as if the ADMOPR file had been deleted).

    The ADMOPR file is a C-ISAM file and is used by all programs and companies.

Coding considerations

  • Special characters in the ledger code (e.g. an apostrophe) can prevent the code from being converted.

  • All data must be valid before you can start processing.