How to get the closing balance expression

[suvechha_b]

Closing Balance  : Opening Balance - Remaining [order_type_desc]

Note : [order_type_desc]  differs for every product and period

so for 1st product : Closing Balance = Opening Balance - (Sales,Purchase,Inventory Adjustment 711,Inventory Adjustment 651,Inventory Adjustment P33,Inventory Adjustment P32,Inventory Adjustment 702)

2nd product : Closing Balance = Opening Balance - (Sales,Purchase,Inventory Adjustment 711,Inventory Adjustment P33,Inventory Adjustment 702)

[order_type_desc]  is dynamic value

Sample attached.

[kaushiknsolanki]

Hi,

See the attached file.

Regards,

Kaushik Solanki

[suvechha_b]

Hi Kaushik,

I want the same output as below

eg ,

         

: