Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming 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