Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

accrued purchases report

Posted on by 230

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

  • MATTGUO Profile Picture
    MATTGUO 22,306 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.

  • 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

  • allaboutax Profile Picture
    allaboutax 230 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,

    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 230 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

  • allaboutax Profile Picture
    allaboutax 230 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

  • 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

  • MATTGUO Profile Picture
    MATTGUO 22,306 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?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans