PO135 – Received, Not Invoiced Report
- System
- Purchase Order (PO)
- Type
- Batch program
- Updates
- 28 tables
- References
- 56 tables
PO135 (Received, Not Invoiced Report) is a Lawson Purchase Order batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, CKPOINT, FBDETAIL, FBFUNDAMT, FBTRANS, FBYETR and 20 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, AMASSET, AMPOASTDTL and 48 more.
About PO135
Run Received, Not Invoiced Report (PO135) to update the General Ledger (GL) interface file with non-inventory transactions from purchase orderreceipts and adjustments. NOTE To capture the audit trail of receipts and adjustments for non-inventory tracked items, run PO135 (Received, Not Invoiced Report) in report mode for a month prior to running it in update mode. **Processing Effect This program is an as-of or estimate program. The program records your liability for the period. That is, it passes to the GL interface file those transactions for nonstock X (special order) type items for which the received quantity is greater than the approved quantity. Throughout the period, you can run PO135 in report mode to monitor those purchase order lines for which the received quantity is greater than the approved quantity. However, at the end of the period, run the program in update mode only once to post thetransactions. The PO135 (Received, Not Invoiced Report) prints in process level order. You can enter the process level on the purchase order in the Terms form tab of PO20.2 (PO Header Options). The report lists inventory-tracked transactions but does not post them. See IC130 (GL Transaction Interface) to post inventory item transactions. PO135 creates auto reversal transactions. The Auto Reversal Cycle which follows explains how auto reversals are handled. The cycle continues until the received quantity is no longer greater than the approved quantity. Auto Reversal Cycle: The next time GL199 (Period Closing) runs, the program creates a reversal. The reversal is posted in GL190 (Journal Posting). The next time PO135 runs in update mode, two types of purchase order lines reappear: Nonstock and X-tracked item types for which the receivedquantity is greater than the approved quantity. The two types reappear so they can be posted to the end of period. For each nonstock or X type item, PO135 creates a debit for the expense account and creates a credit for the Received Not Invoiced (RNI) account. The expense account can default, or you can override it at the purchase order line. During the following period, several steps occur: - The General Ledger reverses the transaction. - AP175 (Invoice Distribution Closing) sends the expense account to the General Ledger and sends a credit to the accrual account. (When AP175 runs in update mode, it expenses service type items.)
Updated files (28)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCODES | General Ledger Codes | IF |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| POAUDIT | Audit Records | PO |
| POCOMPANY | Company System Master | PO |
| PORECON | No description in the Lawson data dictionary | PO |
| PURCHORDER | Purchase Order Master | PO |
| RQAUDIT | Requisition Audit | RQ |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (56)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| AMASSET | Asset | AM |
| AMPOASTDTL | PO Asset Detail | AM |
| AMPODFLTS | PO Defaults | AM |
| AMTEMPLATE | Asset Template | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| BUYER | PO Buyer Master | PO |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| ICCATEGORY | GL Account Category | IC |
| ICCOMPANY | Inventory Company Information | IC |
| ICLOCATION | Company Location | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| ITEMLOC | Item Location | IC |
| ITEMMAST | Item Master | IC |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MACOMPANY | Matching Company | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAINVMSG | Invoice and PO Cost Message | MA |
| POAOCDTL | Add On Cost Detail | PO |
| POAUDRULES | Audit Rules | PO |
| POAUDTYPE | Audit Types | PO |
| POLINE | Line Items | PO |
| POLINESRC | PO Line Source | PO |
| PORECADJLN | Receiving Adjustments Line | PO |
| PORECLINE | PO Line Item Receivings | PO |
| POREVISION | PO Revision | PO |
| PORLNUF | No description in the Lawson data dictionary | RQ |
| PORQHUF | No description in the Lawson data dictionary | RQ |
| PROCLEV | Matching Process Level | MA |
| PURCHORDER | Purchase Order Master | PO |
| REQHEADER | Requisition Header | RQ |
| REQLINE | Requisition Line | RQ |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (27)
ACAC, ACTA, API3, API4, GLCC, ICI1, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, POIF, POIG, POIL, POIM, SLFD, SLSB, SLSE, SLSS, SLSU