Incorrect Balance Qty After Transaction

aakvatech · November 11, 2021, 4:40am

Incorrect Balance Qty After Transaction

This is an essential report to run and repost item valuation for transactions that are listed on this report regularly.

One should run this report regularly and create “Repost Item Valuation” doc of type “Transaction” for each of the transactions that are listed having incorrect balance qty after transactions so that to ensure the balances are correct in the Stock Ledger.

This is applicable to v13 beta as well as v13.

Manan_Shah · November 11, 2021, 4:47am

Hi @aakvatech

Can we use the Repost Item Valuation doctype to correct the Actual Qty after Transaction?
I was under the impression that it can only be used to correct the valuation rate.

Also any idea on why the Actual Qty after Transaction is sometimes inconsistent/incorrect leading to wrong values in the Stock Ledger Report?

A lot of users have been experience this lately

aakvatech · November 12, 2021, 4:34am

github.com

aakvatech/CSF_TZ/blob/master/csf_tz/csftz_hooks/items_revaluation.py

import frappe
from frappe import _
from frappe.utils import flt


@frappe.whitelist()
def get_data(filters):
    filters = frappe._dict(filters)
    data = get_stock_ledger_entries(filters)
    itewise_balance_qty = {}

    for row in data:
        key = (row.item_code, row.warehouse)
        itewise_balance_qty.setdefault(key, []).append(row)

    res = validate_data(itewise_balance_qty)
    return res


def validate_data(itewise_balance_qty):

This file has been truncated. show original

We have used this technique to automatically create Repost Item Valuation if there is a discrepancy found in the report.

It’s not an elegant solution but something to get automated and run every 15 minutes just to make sure Stock Ledger Entry is in order.

irfanzck · March 26, 2022, 7:08pm

@aakvatech

Thank you for this information. It really helps and sorted the problem !

Regards

aakvatech · March 27, 2022, 2:12pm

This happens frequently, when you have same warehouse and multiple Delivery Notes (or sales invoice with update stock ticked) submitted simultenously. (either by creating multiple browser tabs and submit concurrently, or multiple users submitting the delivery notes like in counters of supermarket.