RIMAS for UNIX Software Installation

To:            All Users of SLG General Ledger System

From:       The SHARED LOGIC Group, Inc.

Re:           Codes Used in General Ledger Account Templates

Date:        March 26, 1998

General Ledger account numbers are included in many of the A/P and A/R code records.  These accounts in the Codes Master specify the General Ledger account(s) to which a transaction is posted.

 

However, the accounts in the code records can contain letters that indicate where values from other records are to be substituted.  For example, a “Y” in an account number indicates that the “Yard Number” from the source transaction is to be substituted into the position occupied by the “Y”.

 

Many other letter combinations are available to indicate other substitutions.  The following lists are possible letter combinations that may appear in the account number template.

 

In Purchases and Accounts Payable, the following combinations may be used:

 

            A          Division from Vendor Master.

            BBB     Buyer code from the transaction.

            CC       Company Number specified in the MENU.

            DD       Division from the “TS” code.

            I           Division from Commodity Inventory

            TT        Vendor Type Code

            X          Vendor Tax Code

            Y          Yard Number from the transaction.

 

In Sales and Accounts Receivable, the following combinations may be used:

 

            A          Division from Customer Master.

            CC       Company Number specified in the MENU.

            DD       Division from the “TI” code.

            I           Division from Commodity Inventory

            SSS     Salesperson code from the transaction.

            TT        Customer Type Code

            X          Customer Tax Code

            Y          Yard Number from the transaction.

 

Before using one of these letter combinations in a General Ledger account template, you must determine that the value to be substituted will be available to the program.  For example, you may use the “Y” (for yard number) in a purchase, inventory, sales, and/or cost of sales account, as it will be available from the source inbound, outbound or brokerage transaction.  However, you may not use the “Y” in the accounts receivable account, as the yard number will not be available when this account is credited by a cash receipt.

 

Also, it is the user’s responsibility to use letter combinations in the account number template that will generate account numbers that exist in your chart of accounts.  If an invalid account results from your template, it will be flagged on the G/L Detail Journal and will be caught by the current version of the Update Detail to Accounts program.