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
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
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..
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
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.
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
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,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156