Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Wrong Mainaccount posting PurchInvoice with procurement category

Posted on by 5

I got the following problem:

I created a purchase order with 1 line procurement categorie A.

Posted PurchaseConfirmation

Change de Procurement categorie for that one line to categorie B

posted second PurchaseConfirmation

Post the Invoice the whole Purchase-order

checking financial-transaction the Main-Account is taken from the very first confirmation which leeds to a fault posting.

everyone had the same experiance?

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Wrong Mainaccount posting PurchInvoice with procurement category

    Hello Roger8157,

    I tested the same behavior in a CU11 machine and noticed that I cannot change the category once the line is saved in the PO.

    I did not even confirm the PO. Just created the PO line with the category and could not change it anymore unless by removing the line.

    Have you implemented a system modification that allows you modifying the category after it is initially selected?

    Can you clarify this with a development colleague and check whether this is the underlying issue of the problem?

    Do you have another demo/test machine that does not have any system modifications implemented to double check and compare that behavior?

    Best regards,

    Ludwig

  • Roger8157 Profile Picture
    Roger8157 5 on at
    RE: Wrong Mainaccount posting PurchInvoice with procurement category

    Hi Ludwig

    Customer use AX2012 R2 CU10

    no what i mean is the following:

    We i run the PurchaseConfirmation AX search the right account from the InventPostingTab and writes that value in tbl AccountDistribution.

    When i change the Categorie on the Purchline and run a second PurchaseConfirmation field Ledgerdimension in AccountDistribution is not set correctly.

    Than when i post the Invoice, AX taking the Mainaccount from Field Ledgerdimension in Tbl AccountDistribution instead of looking in the Inventpostings.

    I know it sound funny. I did a test of creating PO run PurchaseConfirmation; after that i deleted the Inventposting value for that Procurement-Categorie and i tried to post the Purchase-Invoice.

    I would have thought AX will bring up a error saying something like "Account for PorcurementCategories XX not found" but surprinsingly the Posting went trough without any problem; So that why i think AX checks whether is has some entries in AccountDistribution for that specific SourceDocumentLine; and only if there is no entry(which just can be done by deleting those AccountDistributionEntries by hand first) AX will taking the account-Information form the Inventposting setup..

    I got not other AX-System around now to check my thoughts, but i don't see any customisation in that part of process..

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Wrong Mainaccount posting PurchInvoice with procurement category

    Hello Roger8157,

    You mean that when you select e.g. category 510.002, AX is posting on account 510.004.

    Is that right?

    This sounds like a bug.

    I had a look at LCS but could only find some hotfixes for older AX2012 systems. What AX version are you operating?

    Best regards,

    Ludwig

  • Roger8157 Profile Picture
    Roger8157 5 on at
    RE: Wrong Mainaccount posting PurchInvoice with procurement category

    1212.InventPosting.PNG

    Hi Ludwig

    First many help for your help

    Here is a printscreen of our seetings.

    The real point is that it seems like it does not taking the account from there directly, insteed it seems like AX taking the Ledgerdimension form the AccountingDistribution Table....

    So for me it looks like the entries in tbl Accountingdistribution are not updated/created correctly.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Wrong Mainaccount posting PurchInvoice with procurement category

    Hello Roger8157,

    Can you share details of your ledger accounting setup that you can find in inventory-setup-posting-posting-purchase tab for your procurement categories?

    Many thanks and 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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans