PO278 – RNI Aging Report
- System
- Purchase Order (PO)
- Type
- Batch program
- Updates
- 31 tables
- References
- 68 tables
PO278 (RNI Aging Report) is a Lawson Purchase Order batch program. It updates ADDRDATA, APAPPROVAL, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV, APVENADDR and 23 more and references APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND and 60 more.
About PO278
This report is reporting off the General Ledger transactions posted when the Received, Not Invoiced Report (PO135) is run in Update mode for a period close. There are three reports that display Summary, PO Detail,PO-Invoice detail for all purchase order lines with receipts and no invoices at the time PO135 was run. Buyers, receiving staff, or Accounts Payable staff can run this report throughout the month to track receipts that are not invoiced. This allows for visibility to reduce the PO Accrual amount so it does not continue to grow each period. When PO135 is run in Update mode at the beginning of the next period, only transactions that are still in a received not invoiced state arereported. PO135 must be run in Update mode for period end. Invoice Match processing will not print details against any receipts because the system does not create details. Only Detail Match processing will print invoice details on thisreport. Invoice Match amounts are included in the RNI balance totals.
Updated files (31)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLTRANS | General Ledger Transactions | GL |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POMATCHOBJ | Cost Change Information | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (68)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYMENT | Invoice Payment | AP |
| APPROCGRP | Process Group | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| BUYER | PO Buyer Master | PO |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLNAMES | General Ledger Names | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| ICCOMPANY | Inventory Company Information | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| ITEMMAST | Item Master | IC |
| MACOMPANY | Matching Company | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAINVHAND | Invoice Handling Code | MA |
| MAINVMSG | Invoice and PO Cost Message | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHRULE | Matching Rules | MA |
| MMDIST | Account Distributions | PO |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| POAOCDTL | Add On Cost Detail | PO |
| POCOMPANY | Company System Master | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POLINE | Line Items | PO |
| POLINESRC | PO Line Source | PO |
| POMATCHOBJ | Cost Change Information | PO |
| PORECEIVE | PO Receivers | PO |
| PORECLINE | PO Line Item Receivings | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVENDLOC | Vendor Location Master | PO |
| PROCUREGRP | Procurement Group | PO |
| PURCHORDER | Purchase Order Master | PO |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, ICBL, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU