Any Change in Immutable Ledger

gsbaig · January 3, 2021, 6:30am

Dear All, any update on changes in immutable ledger or not

Mohammed_Redha · January 3, 2021, 6:40am

@gsbaig
It has been merged in prerelease V13:

Allow back-dated stock transactions and repost item costing via background job

github.com/frappe/erpnext

Repost item valuation

frappe:develop ← nabinhait:repost-item-costing

opened 07:08AM - 30 Nov 20 UTC

nabinhait

+2350 -1048

**The Problem:** We maintain the stock item's valuation rate for each warehouse… separately and we need it for each transaction for maintaining the FIFO queue. We also need stock qty for any specific date for reporting purposes. Hence we store both qty and valuation rate in Stock Ledger Entry record. When we receive or deliver an item, we simply add/deduct qty in current SLE with previous stock qty and calculate the valuation rate based on current qty and rate. But when we submit or cancel a back-dated stock transaction, we need to repost all future SLE's for linked items to recalculate qty and valuation rate after each future stock transactions. All these were happening in version 12. But there were some problems. 1. When there are a lot of records for an item, submitting or canceling a back-dated transaction for that item takes a lot of time to repost future SLE and lead to a Time Out error. 2. There are kinds of stock transactions where an item's incoming rate depends on other items/warehouse/transaction. In those cases, while reposting happens for dependant items, the system should repost SLE for the target item with an updated incoming rate. This does not happen and it leads to incorrect valuation rate and accounting entries for the target item. Here are some examples: 1. Inter-warehouse stock transfer: The valuation rate in the target warehouse depends on the source warehouse. 2. Manufacture / Repack Entry: The valuation rate of finished goods depends on raw materials. 3. Sales Return: The valuation rate of a returned item depends on the item's outgoing rate in the original Delivery transaction. 4. Purchase Return: The valuation rate of a returned item depends on the item's outgoing rate in the original Receipt transaction. 5. Subcontracting: The valuation rate of finished goods depends on the supplied raw materials. **The Solution:** 1. Handle reposting via background jobs. Introduced a new document called "Repost Item Valuation" which is created on submission/cancellation of every stock transaction. And it handles reposting via background jobs. If any background jobs fail it shows the status and records an error log. You can restart the reposting after taking an action to resolve those errors. Reposting can also be done manually for any voucher or item. 2. Repost all related items and warehouse. 3. Enforced incoming rate for target warehouse based on source warehouse 4. In Stock Entry added "Is Finished Item" and "Is Scrap Item" checkbox, it will be auto-checked in case of manufacturing. 5. Organised form fields 6. Introduced a field "Role Allowed to Create/Edit Back-Dated Stock Transactions" in Stock Settings. If any customer wants to restrict back-dated transactions to a specific role they can do it.

becht_robert · February 18, 2022, 11:52pm

We have removed immutable ledger feature completely. The back-dated transactions are allowed, and reposting is handled in the backend.

Info from Frappe feb 22

mujeerhashmi · February 19, 2022, 3:51am

There is a checkbox in accounting settings which can be selected to allow deleting stock and general ledger entries on deletion of transactions.