Submit Stock Transaction is very slow after upgraded to V12

[brian_pond]

@jof2jc

don’t understand the reason why every stock transaction requires to get warehouse-wise balance (the whole Stock Ledger Entry records)

I believe the answer to your “why” question is Perpetual Inventory. More specifically, how the concept of Perpetual Inventory is being modeled in ERPNext.

Here’s a long but interesting thread.
TLDR: Some of us don’t understand why it necessitates summing the entire inventory balance, every time you post a new entry.

Perpetual Inventory -vs.- POS They cannot coexist

Okay, I recently stumbled over my system being set for perpetual inventory and it was really slowing everything down. I unchecked the setting and then started researching exactly what “Perpetual Inventory” was and how it is implemented in accounting systems. This is where I ran into a “disconnect” of sorts. The accounting term “perpetual Inventory” is a practice that immediately records sales and purchasing transactions as they occur in order to allow for better inventory tracking and (suppose…