Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / accruals error after p...
Microsoft Dynamics AX (Archived)

accruals error after product receipt update

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello Community,

We found an issue in standard process of AX 2012 vendor posting.

The issue : When a receipt slip is corrected and the quantities received changed, the amount corresponding to the changed quantity is reversed from the account (408xxx for french accounting), but the new quantity is not provisioned at the right cost. 

Only the amount of the modified line is deprovisioned, while the system reprovisions the entire receipt slip (and not only the amount of the modified line).

My finance team tells me it's a standard issue, and there should be a MS Hotfix available. But i can't find anything on LCS.

Does someone know if a KB already exists ?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: accruals error after product receipt update

    Thank you for your help Ludwig.

    I'll check if theses match what i'm looking for :)

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: accruals error after product receipt update

    Hello Thomas,

    I found a couple of hotfixes on LCS but cannot really say whether they apply to your version.

    Probably have a look at the following KBs

    KB 4035589Product Receipt cancellation incorrect (released Jul2017)

    KB 3210628The voucher posted to cancel it is incorrect when correcting a product receipt for line pending to invoice (Released Dec2016 with CU13)

    KB 4042228Wrong posting when correcting partially posted product receipt after invoicing (released in Jan 2018)

    Please let a developer have a look at those fixes and whether they apply to your specific system version.

    If there are some doubts whether or not one of the fixes might be suitable, contact your local MS support with your exact version number.

    They should be able to provide you some further assistence then.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: accruals error after product receipt update

    Hi Ludwig,

    The version used is AX 2012 R3.

    Here is a screenshot of what's wrong:

    erreur-provisions.png

    Here, there was a product receipt modification.

    AX should have provided 156€ and not 10761,46€ (which is the sum of all lines).

    What I mean is that we have already analyzed the problem. This is a bug in the AX 2012 R3 standard.

    We cannot correct a complex standard function like this. I looked for a HotFix made by Microsoft and found nothing.
    Maybe one of you knows about the existence of a KB that would fix the bug. Otherwise, I have to open a case with Microsoft.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: accruals error after product receipt update

    Hello Thomas,

    Thank you for this update.

    Can you post a screenshot that illustrates the issue?

    Can you also let us know the AX version that you operate?

    Many thanks

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: accruals error after product receipt update

    Hi Ludwig,

    Here we are using standard cost valuation.

    Please notice that i am not talking about purchase returns. It's only product receipt modification.

    For example, I receive 10 000 € of product. After receipt, i reduce the quantity of one line, for an amount of 1000. It seems that the system reduce the provision for the right amount (1000 €), and then re-post an accrual line of the entire PR amount (9 000€)

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: accruals error after product receipt update

    Hi,

    When you return a purchased item you record an inventory issue transaction.

    Inventory issues are recorded at a running cost price that is modified with the inventory closing/recalculation if you use a current valuation method, such as fifo, lifo, weighted average or alike.

    What inventory valuation principle do you use?

    Is it a current valuation principle or are you using standard costing or moving average costing?

    Best regards,

    Ludwig

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans