Personalized Community is here!
Quickly customize your community to find the content you seek.
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
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 | Architecture Insights
We have a problem where a number of the Inventory general ledger codes don't match with the corresponding Item Category Code value showing on an Inventory Valuation Report. The GL is driven by purchases and consumption so it's proving extremely difficult to reconcile and find where the problem lies. There are no other entries in the GL apart from postings with source code 'INVTPCOST' - so it is not manual journal postings that are causing the issue.
One thing that we have spotted is that, on some entries, when you look into the detail of the RPO consumption and the list of entries that make up that RPO - there are item no's in that list that have values in the 'Cost Posted to G/L' column and values in the 'Item Ledger Entry Quantity Column'. However there are some entries that have a value in the cost posted to G/L column but no value in the Item Ledger Entry Quantity column - and the 'Adjustment' box is ticked. On the assumption that the Inventory Valuation Report is driven by the Item Ledger, then the fact that there is an entry in the GL column but not in the item ledger entry column would cause the inventory to show as out of balance. Below is an example of this - the 2 lines highlighted in green have a cost posted to the GL but no entry in the item ledger column and both have 'Yes' in the Adjustment column.
Does anybody have any experience of this themselves or have any suggestions of how we can tackle this??
Any help would be greatly appreciated!
Lets check a few setups:
On the Inventory Setup, do you show Automatic Cost Posting = TRUE or FALSE?
If am guessing you will say FALSE. If this is correct, you need to run either daily, weekly, and at a minimum, at month-end the routine called Adjust Cost-Item Entries. You can search for this. The pop-up has a Post to G/L flag so set this to TRUE. If you forget, I always teach my customer to run after that completes the Post Inventory Cost to G/L report. This will post the entries to the GL.
Look and follow what I wrote and you will see the entries.
Thanks for your reply
On the Inventory Setup - the box next to Automatic Cost Posting is ticked - I assume this means TRUE is that correct?
Yes, if checked this means TRUE.
Thanks for clarifying - so with this being the case are there any other steps you would recommend to follow as your first reply was if this was set to False, or do the same instructions still apply?
Depending on the transaction line sometimes the Output Entry, like the first row, shows Quantity and Expected Cost. On the 11th row the Expected is reversed because the Actual is reflected and posted. The Quantity did not change from the 1st entry so no quantity entry is need to adjust the original.
As for the 2 highlighted rows, with the Adjustment = YES flagged, I would want to look at the Item Card and its related Cost to determine if the Item has a unit cost of 0.00. Can you check the Item Unit Cost and Value Entries associated with the Item for .01 and 1.04.
I will also offer if you want to do a review over Teams, feel free to reach out and I will send an invite and we can review together.
Business Applications communities