General ledger (GL) object

The MXGLTXN object structure allows for outbound synchronization of GL transactions. This interface allows for the posting of site-level transactions to an external general ledger application for accounting reconciliation.

Purpose

This interface uses a nonpersistent MBO with data from the following subrecords:

  • SERVRECTRANS
  • MATRECTRANS
  • INVTRANS
  • INVOICETRANS
  • MATUSETRANS
  • LABTRANS
  • TOOLSTRANS

The event filter class, GLEventFilter, is used to set the events to the applicable persistent objects listed.

The SOURECEMBO field identifies the database table in which the transaction originated. Its value is derived from the GLSOURCEMBO synonym domain.

Outbound integration processing

The following table shows the predefined values used in outbound integration processing.

Table 1. General ledger object predefined components for outbound integration processing
Predefined integration components Value Description
Object structure definition class functionality MoutGLProcess - Service receipts
Service receipts include the following entries:
  • Accounting entries for non-distributed service receipts created by the receiving application for services ordered on purchase orders (ISSUETYPE = RECEIPT, COSTINFO=1)
  • Accounting entries for distributed service receipts created by the receiving application for services ordered on purchase orders (ISSUETYPE = POCOST)
  • Accounting entries for purchase order services with Receipt Required = N that are directly invoiced instead of being received (ISSUETYPE = INVOICE)
  • Accounting entries for services that are not against purchase orders and are invoiced directly (ISSUETYPE = INVOICE)
  • Invoice variance transactions recorded against service receipts (ISSUETYPE = INVOICE)

Service receipts (SERVRECTRANS) processing:

  • Sets SOURCEMBO to SERVRECTRANS and ISSUETYPE to the value listed.
  • INVOICE type transactions: sends out on insert.
  • POCOST and RECEIPT type transactions: if Inspection Required = N for the corresponding POLINE, sends out on insert. If inspection required = Y, sends out when status is changed to COMP.
  MoutGLProcess - Material receipts
Material receipts include the following:
  • Accounting entries for non-distributed material receipts created by the receiving application for items/ tools ordered on purchase orders (ISSUETYPE = RECEIPT, COSTINFO = 1)
  • Accounting entries for distributed material receipts created by the receiving application for items/ tools ordered on purchase orders (ISSUETYPE = POCOST)
  • Accounting entries for Item transfers between storerooms (ISSUETYPE = TRANSFER and PONUM=NULL)
  • Accounting entries for receipt inspection transfers of items between the receipt inspection storeroom and the purchase order line storeroom (ISSUETYPE = TRANSFER and RECEIPTREF!=NULL and PONUM!=NULL)
  • Accounting entries for receipts against internal purchase orders (ISSUETYPE = TRANSFER and RECEIPTREF=NULL and PONUM!=NULL)
  • Accounting entries for receipt inspection goods return of items and materials (ISSUETYPE = RETURN)
  • Accounting entries for return to vendor from a storeroom or direct issue purchase order lines (ISSUETYPE = RETURN)
  • Invoice variance transactions recorded against material receipts (ISSUETYPE = INVOICE)
  • Accounting transaction for increasing the kit item's INVENTORY control account value when kits are made (ISSUETYPE = KITMAKE). transactions for increasing the INVENTORY control account for each constituent item of a kit when a kit is disassembled (ISSUETYPE = KITBREAK)

Material receipts (MATRECTRANS) processing:

  • Sets SOURCEMBO to MATRECTRANS and ISSUETYPE to value listed.
  • Sends out INVOICE, RECEIPT, TRANSFER, RETURN, KITMAKE and KITBREAK type transactions on insert.
  • For POCOST type transactions on insert if status is COMP (that is, on insert if Inspection Required = N, and when status changed to COMP if Inspection Required = Y).
  MoutGLProcess - Inventory adjustment transactions
Inventory adjustment transactions include the following:
  • Inventory current balance adjustments (ITTYPE = CURBALADJ)
  • Inventory standard/ average cost adjustments (ITTYPE = STDCOSTADJ/ AVGCOSTADJ)
  • Cost difference when a kit is disassembled and there is a difference between the value of the kit and the sum of the kit component values (ITTTYPE = KITCOSTVAR)
  • Physical count reconciliation (ITTYPE = RECBALADJ)
  • Capitalized cost adjustment (ITTYPE = CAPCSTADJ)
  • Standard cost receipt adjustment (ITTYPE = STDRECADJ)

Inventory adjustment (INVTRANS) processing:

  • Sets SOURCEMBO to INVTRANS and ITTYPE to value listed.
  • Does not send out transactions with ITTTYPE = INSERTITEM, CREATEASSET and PCOUNTADJ, as they are considered audit records rather than accounting transactions.
  • Sends out all other transactions on insert.
  MoutGLProcess - Invoice transactions
Invoice transactions include the following transactions created by invoice approval:
  • Invoice TOTAL transaction (amount payable to invoice vendor, TRANSTYPE = TOTAL)
  • Invoice line tax transactions (tax accounting for each TAX code for an invoice line, TRANSTYPE = TAX1:TAX5)
  • Invoice currency variance transaction (TRANSTYPE = CURVAR)
  • Invoice price variance transactions (TRANSTYPE = INVCEVAR)

Invoice transaction (INVTRANS) processing:

  • Sets SOURCEMBO to INVOICETRANS and TRANSTYPE to the value listed.
  • Sends out all transactions when they are created.
  MoutGLProcess - Material issue and return transactions
Material issue and return transactions include the following:
  • Accounting entries for items issued from a storeroom in the system (ISSUETYPE = ISSUE)
  • Accounting entries for items returned to a storeroom (ISSUETYPE = RETURN)

Material issue and return (MATUSETRANS) processing:

  • Sets SOURCEMBO to MATUSETRANS and ISSUETYPE to value listed.
  • Does not send out direct issue transactions that are created by PO receiving/ invoice variances in MATUSETRANS, as they are accounted for in MATRECTRANS. Identifies such transactions by their PONUM, so all MATUSETRANS transactions that have a PO reference are not sent out by this interface.
  • Sends out all other transaction at time of creation.
  MoutGLProcess - Labor transactions

Labor Transaction (LABRTRANS) processing:

  • Sets SOURCEMBO to LABTRANS.
  • If approval not required, send out labor actuals against work orders on insert.
  • If approval required, sends out transaction after it is approved (when GENAPPSERVRECEIPT is Y).
  MoutGLProcess - Tool transactions

Tool Transaction (TOOLTRANS) processing:

  • Sets SOURCEMBO to TOOLTRANS.
  • Sends out usage of tools on work orders on creation of TOOLTRANS
Publish channel MXGLTXNInterface  
Processing rules SKIPGL Skips the sending of the general ledger transaction based on the value in SOURCEMBO existing in the GLSOURCE control.
Integration controls GLSOURCE  

Inbound integration processing

The following table shows the preconfigured values used in inbound integration processing.

Table 2. General ledger object predefined components for inbound integration processing
Predefined integration components Value and description
Object structure processing class functionality None
Publish channel None
Processing rules None
Integration controls None