web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / accrued purchases report
Microsoft Dynamics AX (Archived)

accrued purchases report

(0) ShareShare
ReportReport
Posted on by allaboutax 242

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

I have the same question (0)
  • MATTGUO Profile Picture
    MATTGUO 22,344 Moderator on at
    RE: accrued purchases report

    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?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: accrued purchases report

    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

  • allaboutax Profile Picture
    allaboutax 242 on at
    RE: accrued purchases report

    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

  • allaboutax Profile Picture
    allaboutax 242 on at
    RE: accrued purchases report

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: accrued purchases report

    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

  • allaboutax Profile Picture
    allaboutax 242 on at
    RE: accrued purchases report

    the question I have is is should this report show orders that are partially received? Is this a bug?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: accrued purchases report

    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

  • MATTGUO Profile Picture
    MATTGUO 22,344 Moderator on at
    RE: accrued purchases report

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans