I would like to combine item ledger entries qty, Cost posted to G/L of value entries data ( Normal entries + Adjusted entries) in a report.
currently, report's shows as two line like how it's in value entries, but I want to club both lines.
Pls, refer below.
I have tried below - But it's not working
On Qty Column in report - =sum(Fields!ItemLedgerEntryQuantity_ValueEntry.Value)
on the Cost posted to G/L column =sum(Fields!Cost_Posted_to_G_L_.Value)