Hello,
I have multiple franchises, and all of them have already made some transactions. The stock data is not correct, and some items have negative stock. Now, I want to make the stock accurate for all warehouses and all items without deleting existing transactions. How can I do this? The franchises’ sites have perpetual inventory enabled.
Make sure the solution doesn’t affect current transactions or any accounting perspective.
can we create any type of script or somthing to mange this.
“I want to commit fraud by forcing an arbitrary, unconfirmed physical inventory to match what’s on my balance sheet, which for some reason I believe to be correct.” Both sets of records are wrong. You have to do a physical inventory and move that into ERPNext with a Stock Reconciliation, then your balance sheet will be right and it will disagree with what was there before. One impacts the other - “Perpetual Inventory”, which is a core feature of ERPNext.
It will destroy profit and Loss for the period by accumulating big balances as stock adjustment expenses ultimately will lead towards Balance Sheet with abnormal figures as well.
You can create a back-dated opening stock entry.
That would correct the stock from that day on wards, and remove all negative figures.
This probably what @ahsantareen probably wants, but didn’t communicate that clearly. You can use a Stock Reconciliation for this but I prefer a workflow with slightly more control for backdated opening inventories:
The main issue is that transactions were done without creating a Material Receipt, which is why the quantity has gone negative. As a result, the Profit and Loss Statement is not accurate. Now, I simply want to correct the stock and ensure the Profit and Loss Statement report reflects the correct values.