Additional transactions for materials

If the item is a material to be issued on receipt, any change in the item cost is accounted for by writing entries to both the MATRECTRANS and MATUSETRANS tables. The accounts default as if inserting a purchase requisition line. If the materials are charged to a work order, the actual materials cost is also updated.

Example

You approve an invoice for 20 bearings at CAD3.30 each. The base currency is US dollars, and the exchange rate is currently CAD5.00 per USD1.00. At the point of receipt, the item price is only CAD3.00, and the exchange rate is CAD6.00 per USD1.00.

At receipt, the bearings are CAD3.00 = USD0.50 each.

At invoice approval, the bearings are CAD3.30 = USD0.66 each.

The following record, ISSUETYPE = INVOICE, is written to both the MATRECTRANS and MATUSETRANS tables.

Table 1. Source of GL account for MATRECTRANS and MATUSETRANS
GL account source Debit Credit GL account source
Debit account established upon insertion of invoice line = PO line debit Account ($0.66-$0.50) x 20 = $3.20 ($0.66-$0.50) x 20 = $3.20 PO line credit account = Company RBNI account

If Issue on Receipt? = Y

MATUSETRANS.GLDEBITACCT Defaults to INVOICECOST.GLDEBITACCT Defaults to POLINE.GLDEBITACCT

MATUSETRANS.GLCREDITACCT Defaults to INVOICECOST.GLCREDITACCT⇐ POLINE.GLCREDITACCT

For Service

SERVRECTRANS.GLDEBITACCT Defaults to INVOICECOST.GLDEBITACCT Defaults to POLINE.GLDEBITACCT

SERVRECTRANS.GLCREDITACCT Defaults to INVOICECOST.GLCREDITACCT Defaults to POLINE.GLCREDITACCT