Perpetual Inventory -vs.- POS They cannot coexist

Sorry for the super delayed comments on this. There are some points which needs correction.

Stock update by the inbuilt POS is not immediate .
So yes it is possible to sell more than what is in stock .
It is a serious issue @olamide_shodunke

The ERPNext POS works online, hence very much capable of validating stock availability before submission of stock. Incase stock is not available, POS invoice submission is restricted.

Screenshot 2021-07-13 at 1.14.50 PM

When the POS sync to inventory, it will leave the stocks by:

  • 100 USD valuation rate?
  • 120 USD valuation rate?
    In any of the 2 cases there’s a system contradiction, due the timing of the operations.
    If it leaves the stock by 100, it means I’ll stay with 0 Items in stock with 20 USD in the stock account associated with this item, that I never will be able to correct! @max_morais_dmm

This will be eventually corrected in the Sales Invoice (which is made from POS Invoice) and stock valuation will be updated for the item.

  1. Periodically , the finance department runs reports. To compare the value of the inventory according to the inventory sub-system, versus what is in the General Ledger accounts.
  • If everything is configured properly, and no one has made manual Journal Entries, everything should tie out.
  • Otherwise, if there are discrepancies, Finance reconciles and adjusts. @brian_pond

We very much understand the cost of reposting. This was the very motivation for immutable ledger, but eventually for converted to reposting-via-background-job. @nabinhait @rohit_w perhaps we can give this a fresh though. If you are open for periodic entry, then we can make reposting. This will also be concent of the user on the sales and profitability report based on stock valuation available at the time of posting.