Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks
Please, i'm facing a strange issue. For a particual Vendor, when I create an invoice (related the a receipt), I saw that the final operation in GL is passing in a wrong charge mainAccount.
On receipt, the mainAccount is 6666700 (with amount X > 0)
in the Invoice, the operation related to 6666700 is canceled (with amount -X ( <0)). All is good till now
But the invoice is generating the final entry with amount X >0 in an other mainAcount which is 6666800 (instead of 6666700 ).
When I try to reproduce the same case, I fail !
I saw also that for this specific vendor, sometime, even in my items (which are not managed on inventory for information) in PurchLine are having "VEND1" as financial dimension (for partner), but when i make the receipt (before talking about invoice), I see that the GL entry for the charge mainAccount contains an other financial dimension ('VEND2' for example) but the GL entry for the vendor is correct (has the good financial dimension). For this issue, I tried also to reproduce the case but ... !
Is these problems can be related to the user who make the receipt and the invoice ? What can be the others sources of my problem ?
Thanks in advance.
What is the exact meaning of the accounts you mentioned? Are they the vendor balance account, inventory account or another one?
Could you please show some more information about the details with screenshots?
Do you check the posting profile in vendor master?
The accounts that are used for posting purchase order related transactions are defined in the inventory posting matrix that you can find in the inventory module under 'inventory-setup-posting-posting'. Unless something makes a change/modification to this configuration the accounts used should always be identical.
Do you know if changes have been made to the inventory posting matrix?
Have you tried replicating this issue in a different demo/test environment?
The accounts mentionned are setuped here :
Item groups >> Purchase order (Purchase expenditure, un-invoiced, Purchase expenditure for product, Charge and Purchase expenditure for expense).
For the item (with no inventory), it's setuped with the same value (as =6666700 ) for Purchase expenditure, un-invoiced, Purchase expenditure for product, Charge and Purchase expenditure for expense. So i don't know why sometime when making receipt, instead of having 6666700 I get 6666800 which is setuped for other items !
For 'inventory-setup-posting-posting' all is right, my Item Group (for the item used) is mapped to the right account 6666700.
Hi MATTGUO, can you show the path to check your question : "Do you check the posting profile in vendor master?" ?
Followin your path I find that all is configured well and by the way, your mentioned path gives the same thing as following : Inventory Management>>Setup>>Posting>>Posting (as mentioned by Ludwig).
So I have a question : Can we have somewhere a setup where we can setup posting profile by user ? Because if this is the case, so may be when this issue happen for an User X (may be X can not access to this posting profile and AX try to execute an other posting profile allowed for this User and that's why this issue happen !)
AX doesnot have the feature you mentioned.
If you can't reproduce this error, It cannot rule out that someone has modified the posting profile before.
OK, let's suppose that posting profile was modified before, but what about financial dimenions which are not the same between the GL entry and my PurchLine ?
Normally, if my PurchLine has VEND1 as Partner financial dimension so when making the receipt I must have the same financial dimension in GL, but it' not the case for many Purch Orders !
I'm progressing on my analysis :)
So I remarked that when the issue related to financial dimension happened when making the receipt so the problem related to the Account happen also when making the invoice !
So the origine of my problem is based on financial dimension generated in receipt step which are not good (for the vendor balance the financial dimension is the right one, but for the charge, the financial dimension is not !)
Do you have any idea where can I check ?
Can you share an example that illustrates the issue?
Is it possible that somebody played around with the inventory posting matrix and made some changes after for example a packing slip was posted?
Do you see the same issue if you create new POs ?
As i explained in my last post, we have to check why the product receipt vouchers are generated with 2 differents financial dimensions instead of one !
So let's forget the invoice issue and focus product receipt financial dimensions issue. Here as you know, no one can modify anything, because if the PO lines are containing the same financial dimensions so the vouchers generated must be generated at the same way (it means with the same financial dimensions so the vouchers are the PO Lines).
Please refer to my 2 attached files to have and idea for what is happening in my case !
The financial dimension generating the issue is PARTxxxx (in this case we have vouchers generated with PARTxxx = IDxxxx and PARTxxx = ADxxxx, but it must only IDxxx), so why the entry in my account 612638xxx is generated with a wrong financial dimension PARTxxx = ADxxxx ?
Usually, the charge will use the dimensions from the header or the line where the charge has been applied. Is this a line or header level charge? Can you also check if there is a fixed dimension value set on the main account which can override the one used on the order?
There is no fixed dimension value set on this main account.
We don't set dimensions on headers, so all is set on lines (line by line).
Very strange this issue !
If it is not a fixed findim setup or a main account allocation rule then I would assume that this is either caused by a modification or a system bug.
Have you already searched LCS for available hotfixes?
If you can't find anything on LCS I would ask you to get into contact with a colleague from development who can debug this behavior.
Would be great if you could keep us informed here.
Many thanks and best regards
Business Applications communities