TRYING TO FETCH TOTAL INVOICE VALUES PLS HELP

Respected Engineers

Pls Help Me................

if single Party Have 10 sales invoce need to be total of that all sales invoice.
means trying to fetch total of EIVALUETOTAL FEILDS OF INVOICE

[Field:SALESYESORNO]

Use: Amount Field
set as : $$Total:$Amount:LedgerEntries:First



[Collection: SALES CHAIN COLL]
Fetch : LedgerName, Amount, LedgerEntries.*
Type : Voucher
Filter : SalesVouchers

[System: Formula]
SalesVouchers : $$IsSales:$VoucherTypeName

 

Code:

[Collection    :     SALES CHAIN COLL]
Type         :     Vouchers    :    VoucherType
Child Of    :    $$VchTypeSales
Belongs To    :    Yes
Fetch        :    *.*, Amount, PartyLedgerName

[Collection    :    SALES CHAIN COLL2]
Source Collection:    SALES CHAIN COLL
Fetch        :    *.*, PartyLedgerName, Amount
By            :    PartyLedgerName    :    $PartyLedgerName
Aggr Compute:    Amount    :    Sum    :    $Amount

Use collection 'SALES CHAIN COLL2' at part level for repeat & at field level for total sales values > Set as : $Amount

Hope your problem is resolved.

 

THANK U RESPECTED EXPERTS
VISHAL JI ..................AMIT JI................<3