Bug 22132 - [Reports][General Ledger] – Incorrect Unit Cost Calculation for Inventory Item Purchases.
Summary: [Reports][General Ledger] – Incorrect Unit Cost Calculation for Inventory Ite...
Status: CONFIRMED
Alias: None
Product: ML DB 64-bit Win
Classification: Unclassified
Component: Reports - General Ledger (show other bugs)
Version: Version-12
Hardware: Windows Windows - 11
: High Major
Target Milestone: ---
Assignee: SPramod
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-11-03 17:43 IST by G.Shivasai
Modified: 2026-11-03 17:43 IST (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description G.Shivasai 2026-11-03 17:43:18 IST 
The Unit Cost value for purchased inventory items is being incorrectly recalculated in the General Ledger (GL) report, resulting in an overstated total amount.

STEPS:
=> Create Inventory Item & Vendor.
=> Create Item Purchase Transaction.
=> Generate GL Report => Observe the Inventory ac if assigned. If not observe the cash acct. Unit Cost Value of the item is again recalculating on the overall Total.

For Suppose 
5 Qty * 40 Unit cost = 200 but here this 200 Total Cost is again recalculating on the 5 Qty which becoming the value as 1000.

Screenshot:
https://prnt.sc/B48vb2oOVRlH