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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCODESGeneral Ledger CodesIF
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
MAAOCDTLInvoice Add On Cost DetailMA
MAINVDTLInvoice Line DetailMA
MMDISTAccount DistributionsPO
MMUAVALNo description in the Lawson data dictionaryPO
POAUDITAudit RecordsPO
POCOMPANYCompany System MasterPO
PORECONNo description in the Lawson data dictionaryPO
PURCHORDERPurchase Order MasterPO
RQAUDITRequisition AuditRQ
SUBCKPOINTSubledger Check PointIF
SYSTEMCODESystem CodeIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (56)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
AMASSETAssetAM
AMPOASTDTLPO Asset DetailAM
AMPODFLTSPO DefaultsAM
AMTEMPLATEAsset TemplateAM
APACCRCODEInvoice Accrual CodeAP
APCOMPANYAccounts Payable CompanyAP
APINVOICEAccounts Payable InvoiceAP
APVENGROUPVendor GroupAP
APVENLOCVendor LocationAP
APVENMASTVendor Master RecordAP
BUYERPO Buyer MasterPO
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCPYGRPGeneral Ledger Company GroupIF
GLINTCOGeneral Ledger IntercompanyIF
GLMASTERGeneral Ledger Account MasterIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
ICCATEGORYGL Account CategoryIC
ICCOMPANYInventory Company InformationIC
ICLOCATIONCompany LocationIC
INSTCTRYCDIntrastat Country CodesTX
ITEMLOCItem LocationIC
ITEMMASTItem MasterIC
MAAOCDTLInvoice Add On Cost DetailMA
MACOMPANYMatching CompanyMA
MAINVDTLInvoice Line DetailMA
MAINVMSGInvoice and PO Cost MessageMA
POAOCDTLAdd On Cost DetailPO
POAUDRULESAudit RulesPO
POAUDTYPEAudit TypesPO
POLINELine ItemsPO
POLINESRCPO Line SourcePO
PORECADJLNReceiving Adjustments LinePO
PORECLINEPO Line Item ReceivingsPO
POREVISIONPO RevisionPO
PORLNUFNo description in the Lawson data dictionaryRQ
PORQHUFNo description in the Lawson data dictionaryRQ
PROCLEVMatching Process LevelMA
PURCHORDERPurchase Order MasterPO
REQHEADERRequisition HeaderRQ
REQLINERequisition LineRQ
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

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