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.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
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 | Upcoming TechTalks | All TechTalks
Inventory Management>Journals>Item Transactions>Transfer
When i post a transfer from a site/warehouse to another, the financial effect is the same in both debit and credit values of the Ledger Main account/Dimension.
As an example, Posted a transfer for an item (A) "Value=50$"
From Site (Y) => Main account 1201 - BU 01 - Location - 01
to Site (Z) => Main account 1201 - BU 01 - Location - 02
The Effect in trial balance would be like :
Opening Debit Credit Closing
1201 - 01 - 01 500.00 50 50 500.00
1201 - 01 - 02 400.00 50 50 400.00
Which cancels the financial effect made by the transfer I've posted. is there any1 who can help with fixing this issue?!
You'll find this attachment shows 2 journals created by the transfer .. one journal for each line.
Thanks and best regards,
Can you provide some additional details on the issue you see? If you transfer an item from one site to another one and AX generates the postings mentioned above what should be different resp. what is wrong in your opinion?
Due to the Sample Mentioned above..
the trial balance is supposed to be like :
Opening Debit Credit Closing
1201 - 01 - 01 500.00 50 450.00
1201 - 01 - 02 400.00 50 450.00
Sites r linked to dimension : Location
so its supposed to affect the dimension value in either debit or credit but not both of them.
The problem in your example is that you have setup your Inventory inter-unit payable and receivable accounts to your inventory balance accounts. Think of them more like Inter-company accounts. The reason transfers across sites behave this way is due to a possible difference in standard costs, even if there is no actual difference.
Setup your Inventory inter-unit payable and receivable accounts to a separate clearing account, and those two transactions will then net together, and what is left will look very much like you voucher you wanted to see.
From your Screen-print above I can see that you used the same account for the inter-unit receivable and inter-unit payable account. Those accounts are bridging accounts. Can you try Setting up separate accounts for each? The same holds for the inventory issue and inventory receipt accounts. Please use separate ledger accounts for each posting type and I believe your issue will be ok from a finance perspective.
i thought its supposed to affect the Inventory Main Account/Dimension:Location since its moving items from a site to another ..
You are right, but the inter-unit accounts are actually comparable to intercompany Accounts Receivable and intercompany Accounts Payable accounts that are used "in between" as bridging accounts.
So basically you have two postings
(1) Debit: Inter-unit receivable
Credit: Inventory issue
(2) Debit: Inventory receipt
Credit: Inter-unit payable
Because you do not differentiate the inter-unit payables and receivables accounts you get the outcome you showed above.
Probably change your setup in a test environment and check the outcome. I believe your Trial Balance will look better.
You need the bridging accounts to allow for a different standard cost between sites.
In your example, you have a 50 Cr and a 50 Db only because the standard cost is (presumably) the same in both sites. But how would that work if the standard cost in the receiving site were 60? The voucher would not balance, and hence you need a 3rd main account to bridge the gap.
For their own reasons, the developers have simply offset both the issue and receipt transactions to the bridging account directly, where they will net to 0 when the issuing and receiving standard costs are identical but otherwise it will carry the difference between them.
I've changed the Inter-unit Receivable/Payable to some Bridging account. and it worked just fine with me
Thanks very much for helping.
Business Applications communities