Inventory Adjustment G/L Assignment (IM44)

The Inventory Adjustment G/L Assignment (ibis_icga.im44) view is used to maintain a GL relating table for inventory adjustments that stores the GL Control accounts affected as a result of posting inventory adjustments through Enter Inventory Adjustments (IC50) and Transfer Physical to Book (PI19). For each combination of Warehouse/Product GL Code/Inventory Adjustment Code, an applicable Inventory Control account and the offsetting Adjustment account (if applicable) are identified. For example:

    Whse Code       GL Code       Adj. Code       Offset GL Account       Inventory GL Account
    01       00       C       01-5100       01-1100

If a cost adjustment (code 'C') is made to reduce a Product's average cost (in Warehouse 01, for a Product with a GL Code of '00'), then the resulting GL posting generated is:

    Debit      01-5100      Cost of Goods Sold Adjustment Account
    Credit      01-1100      Inventory Account

If there is NO entry in the Adjustment GL relating table for a Warehouse/Product GL Code/Inventory Adjustment Code combination, then the program will generate the posting to 'dummy' GL accounts. For more information on GL postings to fictitious GL accounts, see Decoding 'XYZ' GL Accounts.

If there is an entry in the GL relating table for a Warehouse/Product GL Code/Inventory Adjustment Code combination BUT the GL control accounts are not specified, then this means that no interfacing records will be generated to the General Ledger. It is not mandatory that all adjustment codes generate GL postings.

The following list defines every field available in the inventory adjustment G/L assignment (icga) table in alphabetical order:

  • Branch - enter or select from the look up a sales office/warehouse code. The warehouse code is part of the key used by the system to determine the GL control accounts that are affected as a by-product of posting inventory adjustments. This field is validated against the Sales Office/Warehouse Numbers (ibis_sab.CC96) table.

  • Company - the company field is available when you create a new record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the creation process only. Once the record is created, the company to which the record is associated displays in the General section (at the top of the view).

  • Created On - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created By - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • GL Adjustment Account Code - when adjustments affecting inventory quantity or cost are posted through Inventory Adjustment Entry (ibis_ic50) (using the GL accounts from IM44), the value of that transaction may be posted to the general ledger. For the value that is posted to the inventory control account, the offsetting side of the entry is posted to the GL account that is entered in this field.

    • This field is unavailable (grayed out) if the Inventory Adjustment Code is set to 'T' (stock transfer).

    • This field mandatory if you enter a GL Inventory Account and the Inventory Adjustment Code is anything other than a 'T'.

      Note: If no interfacing records are to be posted to the General Ledger for this Warehouse/Product GL Code/Inventory Adjustment Code combination, then leave this field blank.

  • GL Inventory Account Code - when adjustments affecting inventory quantity or cost are posted by IC50, the value of that transaction may be posted to the General Ledger. Enter the GL account code for the inventory control account in this field. The offsetting side of the entry is posted to the GL account entered in the 'GL Adjustment Account' field.

    • Note: If no interfacing records are to be posted to the General Ledger for this Warehouse/Product GL Code/Inventory Adjustment Code combination, then leave this field blank.

  • Inventory Adjustment Reason Code - enter or select from the query the inventory adjustment code you want to work with. The inventory adjustment code is part of the key used by the system to determine the GL control accounts that are affected as a by-product of posting inventory adjustments. This field is validated against the Inventory Adjustment Codes (ibis_ica.im09) table.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

  • Product GL Code - enter or select from the look up the GL code you want to work with. The product GL code is part of the key used by the system to determine the GL control accounts that are affected as a by-product of posting inventory adjustments. GL Codes are defined in the Product G/Ls (ibis_sab.cc96) table and are assigned to each Product in the Products (ibis.ici1_im13) view.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.