Product GLs (ICGL_IM09)

The Product G/Ls (ibis_icgl.im09) view allows you to define the GL codes that will be assigned to products in the Products (ici1.im13) table. Every product is assigned a GL Code. A product's GL Code is one of the factors used to determine the GL control accounts updated as a result of posting customer invoices, inventory adjustments or stock receipts.

The GL control accounts for invoice postings are maintained in Company Control Initialization (ibis_cc00/Invoicing/General Ledger), and the GL control accounts for inventory adjustments are maintained in the Inventory Adjustment GL Assignments (ibis_icga.im44) table.

The following list defines every field available in the product G/Ls (icgl) table in alphabetical order:

  • 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 Code - enter a GL code. You can enter a maximum of 2 alpha-numeric characters in this field.

  • GL Code Description - enter a description of the GL code. You can enter a maximum of 30 alpha-numeric characters in this field.

  • 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.

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