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
In BC18 we used to be able to do back dated inventory calculation and posting. Now we have updated to BC online and it is not possible anymore. This is a huge problem for us for year-end inventory process.
Category: Inventory
Has this seriously not been resolved? This is obsurd if that is the case.
Category: Inventory
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
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.