The Calculate Inventory on the Physical Inventory Journal (and new Physical Inventory Order does not allow for a back-dated calculation of quantity on hand. In certain versions, this was alllowed. However, a change was introduced to no longer filter the calculation due to the fact that costing was incorrectly calculated because Item Application during posting was based on existing Item Ledger Entries regardless of posting date. So, even if Calculate Inventory was back-dated from August 31 to June 30, for example, all of the ILE posted since July 1 would still be considered for Item Application and would lead to costing discrepancies because application was not limited to entries posted up to June 30.
The challenge is that not allowing a back-dated calculation doesn't take into account the reality of managing a Physical Inventory process for the accounting and warehouse departments. The process takes time and may not be done immediately at the end of a period. To not be able to backdate the calculation is fundamentally an incorrect conclusion and too limiting.
Comments
Completely agree with Paul Austin-Menear. The lack of this feature is a huge problem when managing 3PL stocks.
Category: Inventory
In practice, it's several days' until a cycle count is completed in our 3PLs. Even with automation in place to transmit a digital report instead of paper, we're still looking at minimum 4-5 days after the close of a month period before we can post an adjustment into BC for the inventory on the close of the period.
Backdating is essential for this purpose, my vote includes the 20 people on our ops teams globally who run into this problem every month.
Category: Inventory
This is a handy feature and having this we can load stock take from the 3rd party stock takes and recalculate stock on hand later.
Category: Inventory
Any updates on this? They have dropped the ball here - we need this
Category: Inventory
I have done his customization for customers many times, it is better to be available for both Physical inventory journals and Physical inventory orders
Category: Inventory
From a purchasing prospective the sales/inventory interface is much to granular (showing every individual sale) compared to our previous Sage system, which gave us yearly & monthly totals at a glance. If we needed to dig deeper that was available as well.
Category: Inventory
Again came across to this, customer has problem because cannot date filter back in time. It is not good that functions that have been in NAV earlier and it has been removed from the BC. This happens to my customer, they have had NAV earlier and have transferred to BC and now they get problems in usage.
Category: Inventory
Hello, team. I totally agree with colleagues. The feature will be in demand and MS Business Central will become more user-friendly.
Category: Inventory
I have talked to two of my colleagues in Abakion who I think nows everything about inventory costing in Business Central. And they totally agree with Thomas and Denise in this matter. Let's get the functionality back in Business Central.
Sune Lohse
UseDynamics.com
Category: Inventory
Disallowing the date filter for Calculate Inventory presumes a perfect world. Assume that we’re old hands and getting ready to close 08/31/20 timely. In this scenario, our prod-ops people would be taking inventory today and uploading their physical count to SharePoint for accounting to retrieve. The way Microsoft is envisioning this, we should enter the second the physical count is uploaded, and MSBC will calculate difference. Until we automate, that difference is our monthly usage. Post-automation, the difference will be shrinkage.
This reasoning fails on two levels:
1) Even if fully automated, there’s no accounting team that will have all PIs entered on the same date as physical count is taken. Even if I had a team of 50 accountants instead of 6, we would not have all invoices from our vendors, nor would we necessarily have all BOLs to enter incoming inventory.
2) Assume that accounting decides to wait until all PIs are entered and ensures that this occurs within 5 business days. During those 5 business days, business does not come to a standstill. Production-warehouse people will be entering BOLs. Posting physical count 5 business days later means that entries will have been made from subsequent accounting period, and those entries cannot be filtered out.
Microsoft’s assumption does a disservice to those of us who are trying to implement MSBC. We consolidate 23 different legal entities, multiple currencies, multiple business types – manufacturing, e-Commerce, software development, services. The complexity of our business model drove us to MSBC. But the way physical inventory journals are handled, Microsoft is assuming that every client enters every document the same day it is received and that prod-operations neither gets ahead of nor lags behind accounting.
Currently, physical inventory journal is designed for perfect world scenario, and that scenario simply does not exist.
Category: Inventory
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.