Stock ledger Entry Messed-up

ERPNext
1

Hello,

Using v7.0.27 all stock ledger entries from sales invoices are double posted…plus and minus…hence stock ledger data and other reports is messy…
What may cause this?

Tks

2

Please check if you have entered “Customer Warehouse (Optional)” field in Sales Invoice Item table.

3

No it’s hidden…what causes this? All stock reports getting messy… all stock ledger entries are double.
Please help…

4

That is one thing I can imagine which can lead to such scenario. May be customer warehouse is setting automatically based on user permissions. Please remove it from hidden and check if it is causing the issue. Also check “Ignore User Permissions” is check for that field from Customize Form.

5

@nabinhait I have user permission setting for warehouse, but not customer warehouse.
how to fix the data? is this a ‘serious’ bug? what is customer warehouse used for?

6

Hello,

Customer Warehouse field is also a link field, linked to Warehouse master. It’s possible that Warehouse set in your User Permission is being auto-set in the Customer Warehouse field.

There are instances where affect of Delivery Note is Material Transfer. In such a case, you can select Customer Warehouse in the Delivery Note Item table. On submission of Delivery Note, stock will be deducted from your Companies Warehouse, and added into Customer’s Warehouse.

As suggested by Nabin, please check Ignore User Permission for the Customer Warehouse field, so that value in this field will not be updated based on User Permissions. Steps:

  1. Search > Customize Form
  2. Doctype = Delivery Note Item
  3. For “Customer Warehouse” field, check “Ignore User Permission”.
  4. Update Customize Form.

For correcting existing transactions, please Cancel and Amend them. While amending, ensure that no value in updated in the Customer Warehouse field.

7

@umair @nabinhait I had set ignore User Permission before…but why customer warehouse is still set automatically?

Will we get a patch to fix the data?

8

I have used version v12.7.0 (version-12).
I have two companies in single entity. all stock ledger entries from sales invoices are double posted…plus and minus…hence stock ledger data and other reports is messy… anyone help me to resolve this.
Stock ledger double issue occur only one company. Other company there is no issue.