is the accrued purchases report supposed to include PO's that have partial deliveries when I run report it does not look like its including these PO's does anyone know if there is a hotfix for this or is it working correctly?
*This post is locked for comments
Hi allaboutax,
For standard feature, the report contains the PO which partially received but not invoiced.
If it isnot the case, please check the Cutoff date is the correct range, and you can search same issue for hotfixes in LCS.
Hi allaboutax,
I found a hotfix on LCS that seems to fix
Can you check the following one:
KB 2924280Partial invoicing of product receipt displays incorrect values in the accrued purchase report
Best regards,
Ludwig
the question I have is is should this report show orders that are partially received? Is this a bug?
Hi allaboutax,
If you have the information in GL then you don't need the report in my opinion. You can have a developer looking into the partly shipped issue and get the report fixed but if you have the data in GL anyway I would use them rather than trying to reconcile a report that does not do what you want/you are looking for.
Best regards
Ludwig
I have not but this is what I did
We run a report in Procurement and Sourcing > Reports > Status > Accrued Purchases. I ran this report through today, with the box for Purchase order receipts with GL postings box checked.
2. This report should include every purchase order line that has been received against, but not invoiced for.
3. We have two general ledger accounts set up for unvouchered accounts payable. 210020 is for bill of material (inventoried) items and 210021 for expensed (non-inventory) items.
4. The total of those two g/l accounts should equal the total on the Accrued Purchase report. In the attached example they do not and rarely do they. At month end, I have been looking at all the transactions for the month in each g/l account to see what is missing from the report. It has been time consuming but able to be done.
5. The items missing from the report, in my analysis, seem to be purchase order lines received that have a deliver remainder amount on the line (not received in full).
6. One such item is on PO-025134. vendor, po line 130 has several receipts for the product received, yet has a deliver remainder amount. The quantity ordered is for the year so the deliver remainder amount is legitimate
We run a report in Procurement and Sourcing > Reports > Status > Accrued Purchases. I ran this report through today, with the box for Purchase order receipts with GL postings box checked.
2. This report should include every purchase order line that has been received against, but not invoiced for.
3. We have two general ledger accounts set up for unvouchered accounts payable. 210020 is for bill of material (inventoried) items and 210021 for expensed (non-inventory) items.
4. The total of those two g/l accounts should equal the total on the Accrued Purchase report. In the attached example they do not and rarely do they. At month end, I have been looking at all the transactions for the month in each g/l account to see what is missing from the report. It has been time consuming but able to be done.
5. The items missing from the report, in my analysis, seem to be purchase order lines received that have a deliver remainder amount on the line (not received in full).
6. One such item is on PO-025134. Airgas is the vendor, po line 130 has several receipts for the product received, yet has a deliver remainder amount. The quantity ordered is for the year so the deliver remainder amount is legitimate
Hi allaboutax,
If you use separate ledger accounts for packing slip/purchase receipt postings and include the PO and vendor in the auto posting texts then you don't need the accrued purchases report because you can retrieve all the information directly from your GL vouchers.
Have you checked if you can do that and checked those vouchers already?
Best regards
Ludwig
Hi allaboutax,
Do you select Purchase order receipts with GL postings in the filter form?
docs.microsoft.com/.../can-usa-accrued-purchases-report-vendaccruedpurchases-na
Are partial deliveries invoiced?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156