hello…
i found some bug at Gross Profit Report when my Sales Invoice have returned with UOM Conversion.
example :
i create sales invoice with item
Beras
qty : 3
UOM : Ton
Stock UOM Kg, UOM Conversion 1000
Stock Qty : 3000 Kg
and then i make sales return,
Beras
qty : -1
UOM : Ton
Stock UOM kg, UOM Conversion 1000
Stock Qty : -1000 Kg
when i see at Gross Profit Report, the report show my Qty : 2999
after i check the code at Gross Profit, i found this query
gross_profit.py line 189
returned_invoices = frappe.db.sql(“”"
select
si.name, si_item.item_code, si_item.qty, si_item.base_amount, si.return_against
from
tabSales Invoice
si,tabSales Invoice Item
si_item
where
si.name = si_item.parent
and si.docstatus = 1
and si.is_return = 1
“”", as_dict=1)
i change the query from si_item.qty to si_item.stock_qty as qty and si.base_amount to si_item.base_net_amount as base_amount
and it fixed.
i found this bug at ERPNEXT ver 10 and 11.0.3-beta.32 () (staging)