• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Reconcile Received not invoiced between IC and AP

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Mary Porter
Veteran Member Send Private Message
Posts: 337
Veteran Member
4/29/2014 7:24 PM
Our Finance department is asking for a report to reconcile the General Ledger PO Receipt Accrual account. The report must compare Inventory Control data for
RNI against AP invoiced items, similar to the PO135, so that the AP dept and Materials dept can work the exceptions and close the open receipts.

Does anyone have anything or know of any Lawson canned reports that would help them accomplish this?
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
4/30/2014 12:08 PM
Basically you're looking for an RNI report for inventory PO lines?
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Dave
New Member Send Private Message
Posts: 1
New Member
4/30/2014 11:18 PM
Hi Jon, that is correct...we are looking for an RNI report for Inventory PO Lines. I've been able to pull some queries that reference the PO# and PO Line# to try and match against A/P, but the query does not capture the IC transactions with the RA (Receipt Adjustments) or the CA (Cost Adjustments). MM280 would be a great report to use, however I noticed that it does not include the PO line #'s and does not show PO # and PO line # for the RA and CA transactions. Any help or advice with our issue would be greatly appreciated.