how get taxable and exempted amount from below collection [Collection: VWPSCollSrc] Type : Vouchers : ledger Child of : $$VchTypesales Belongs to : Yes Fetch : Date,VoucherTypeName,PartyLedgerName,MasterId,Amount, incometax number, voucher number [Collection:VWPSColl] Source Collection : VWPScollSrc Walk : ledger Entries By : VWPSVch : $masterid;;vouchernumber aggr Compute : VWPSGross :Sum:$Amount Fetch: amount,ledgername,MasterId, voucher number, date, vatassessablevalue Fetch : Allledgerentries.*,*.* Keep Source). [System : Formula] TotalSalesWithoutTax:$VWPSGross TotalSalesWithTax :$Amount ExemptedSales : TaxableSales : TaxAmount :$Amount-$VwpsGross
[System : Formula] TotalSalesWithoutTax:$VWPSGross TotalSalesWithTax :$Amount ExemptedSales @TotalSalesWithoutTaxs-@@TaxableSales TaxableSales @TaxAmount/0.05 ;here tax rate 5% TaxAmount :$Amount-$VwpsGross
I have changed "Walk : ledger Entries" to "Walk : Inventory Entries" and getting both value, now i am not getting "party ledger name" and "pan number" any solution please