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
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
One of my clients is using manual Inventory cost adjustment and we would like to enable now the Automatic cost posting and Expected cost posting. So we thought of clear the old entries first to adjust the cost to GL. so we manually ran the batch job without item # filter and it posted Inventory cost to GL for certain inventories and skipped few hundreds.
When we manually chose those skipped ones in a batch job using preview instead of posting it shows entries, but we don't want to adjust them in historical transaction date, as P/L books are closed and we would like to adjust in Current month(June 2020) to absorb the cost.
Any suggestion to post those entries in current month.
we are currently using NAV2009 SP1.
for 1st set of entries, we followed the following steps
entries are also got adjusted to 01st June 2020.
when we follow the above method using posting date filter for the missed ones doesn't give any entries, but when we take out that posting date filter and it gives entries in the preview. so basically it is trying to adjust in historical date.
thanks & regards
Set the Allow Posting from to 1st June 2020 in General Ledger Setup
when i set that, it says Posting date is not within your range error msg.
Set the same Allowed Posting From on your User Setup (user which running the adjust cost process)
Yes, in both places GL Setup and User setup the Allow posting from field set to 01st june 2020. But the posting date is not within your range error occurs.
Thank you for posting on the Microsoft Dynamics NAV and Business Central Forum.
The key challenge here is that if Value Entries in Table 5802 have a Posting Date with a past date but the entry was not ever posted to the G/L Entries, then it can lead to challenges if the periods of these unposted Value Entries are closed and Value Entries are historical in nature and originally missed for posting.
SInce Version 5.00 released for Microsoft Dynamics NAV and all subsequent versions, the rule is to always balance the Inventory Subsisdiary Ledger value in the Value Entries to the General Ledger Entries by Posting Date. Thus, the system doesn't include an option to post the Value Entry on a different Posting Date from the G/L Entries Posting Date. The system always requires a matching date. This is what is reqiured with the Post Inventory Cost to G/L process. Table 5811 stores the Value Entries from Table 5802 to be posted with a matching posting date to the Value Entry. Once posted, the record moves to Table 5823 for a linking of the posted Value Entry Numbers to the linked G/L Entries No. This is managed so that there is a Posting Date match so Inventory Value always balances to the G/L Entries and Chart of Account balance by date.
Based on what you have provided, there may have to be some manual posting of inventory value to the G/L to bring the balance total into a correct total as of 6/1/2020. If the prior period Value Entries cannot be posted because the company has closed the period and doesn't want to reopen the period, then this would be required. Once balance on June 1, then they would enable the posting options in Inventory Setup going forward for Expected Cost Postng and Automatic Cost Posting to make sure that the Value Entries are automatically posted to prevent the issue from occurring in the future.
In my opinion, the company will need to track the total of these entries that cannot be posted back to the original Value Entries Posting Date becuase the value will generate an out-of-balance situation until the updated posting can be completed. I am anticipating that there is currently a difference between the Inventory Valuation and the G/L Balance in Inventory because not all of the Cost Amount (Actual) and Cost Amount (Expected) value had been previously posted for all of the Value Entries.
Some guidance available for this area can be found at the following: docs.microsoft.com/.../design-details-inventory-posting
The current situation will definitely entail some processing steps outside of standard inventory posting processes.
I hope this helps move you forward in the corrective steps.
Thank you Tom for your valuable time to explain in detail.
I shall communicate back to my client on manual adjustments.
but i have couple of question,
1.) how to adjust the cost to Sub-ledger by passing GL Journal? i also need to adjust inventory by passing negative adjustment correct and it has to effect the value entries?
2.) If i adjust manually how would i get a check mark in Item card --> Cost posted to G/L? or does it has to wait until next transactions?
Business Applications communities