Announcements
1,090
Hi All,
We have just transacted "Purchase Order Receipt" in GP; however
the items Quantity & Amount$ are not shown in inventory report. ( Inventory History Report).
Would you please advise if there is any additional "Steps" after "PO Receipt" needed to be performed, in order to successfully posted the "received items" Qty & Amoutns in the book & inventory report.
Thank you
*This post is locked for comments
There are no further steps required after posting from the "Receiving Transaction Entry Window". Though, the Journal Entry would or would not be posted automatically depending on your posting setup.
Could you please check the "Inventory Transactions" smart list for the posted receiving transaction and ensure whether the document is showing or not. Please include the "Document Status" from the Add Columns button in order to check the status of the transaction (Posted or Unposted)
If not, would you check the Batch Recovery window (Dynamics GP > Tools > Routines > Batch Recovery), it is possible that the batch hangs during posting.
You could run the following scrip on SQL Management Studio in order to check the inventory tables;
Inventory Unposted Transaction:
USE #DBName
SELECT * FROM IV10000 WHERE BACHNUMB = '#BachNumber' AND IVDOCNBR = '#DocumentNumber'
SELECT * FROM IV10001 WHERE IVDOCNBR IN
(SELECT DISTINCT IVDOCNBR FROM IV10000 WHERE BACHNUMB = '#BachNumber' AND IVDOCNBR = '#DocumentNumber')
Inventory Posted Transaction:
USE #DBName
SELECT * FROM IV30300 WHERE DOCNUMBR = '#DocumentNumber'
SELECT * FROM IV10200 WHERE RCPTNMBR = '#DocumentNumber'
SELECT * FROM SEE30303 WHERE DOCNUMBR = '#DocumentNumber'
Purchasing Unposted Transaction
SELECT * FROM POP10300 WHERE POPRCTNM = '#DocumentNumber'
Purchasing Posted Transaction
SELECT * FROM POP30300 WHERE POPRCTNM = '#DocumentNumber'
Your feedback is highly appreciated
No additional steps required. As soon as the receipt is POSTED, inventory is updated. Has the receipt been posted? Check Inventory Transaction Inquiry and see if you can find the transaction there. Maybe there's an issue with the report you're running.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
