Dynamics Community Forum Thread Details

Stock Closure Never Performed by Customer

I have just found out that one customer has never done a stock recalculation and close. They are using standard cost and track cost down to batch level. They have been on D365 FSCM for four years now. They had raised a question regarding ledger postings when updating the standard cost of the item, even though the stock has long since left the building. I had advised them that is because their production orders are only at reported as finished in the example they had provided. They have unfortunately many production orders that have never been ended and many purchase orders without posted invoice, so they are not financially updated. They are in the process of cleaning this up and closing out as many transactions as possible. I would then advise them to recalculate and close inventory, but the transactions go back four years. What is the best way for them to go about rectifying the situation? Should they for example recalculate and close month by month, dating back to 2019, or should they close year by year, or should they be doing a stock recalculation and close at the end of the month, and then go through the routine going forward?

Hi,

To rectify the situation where a customer has never performed a stock recalculation and close, and considering that the transactions go back four years, there are several steps they can take:

Clean Up Unfinished Transactions:

Complete and end any open production orders that have never been finished. Also, address any outstanding purchase orders without posted invoices. This ensures that financials are updated accurately.

Historical Recalculation and Closure:

Given the extensive history, it might be practical to perform a stock recalculation and close on a periodic basis, such as month by month or year by year, starting from the earliest transactions. This helps in systematically addressing the historical data.

Gradual Approach:

Considering the volume of transactions, a phased or gradual approach might be beneficial. They could start with the oldest transactions and work their way forward, addressing a manageable chunk of data at a time.

Review and Adjust Standard Costs:

Before the recalculation, review and adjust standard costs as necessary. This ensures that the recalculated values align with the current cost structure.

Periodic Closing Going Forward:

Going forward, it's advisable to perform regular stock recalculation and closure at the end of each month. This helps maintain accurate and up-to-date financial records.

Best regards,

Kevin

Quick Links

Leaderboard