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.
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 INVOICECOST.GLDEBITACCT
POLINE.GLDEBITACCT
MATUSETRANS.GLCREDITACCT INVOICECOST.GLCREDITACCT⇐
POLINE.GLCREDITACCT
For Service
SERVRECTRANS.GLDEBITACCT INVOICECOST.GLDEBITACCT
POLINE.GLDEBITACCT
SERVRECTRANS.GLCREDITACCT INVOICECOST.GLCREDITACCT
POLINE.GLCREDITACCT