i have some doubts in My collection can any one tell how to clear that doubt. i have written one collection like this,in my sales voucher it contains sales ledger,duties & Tax Ledgers and Inventory as well. by using one collection i have to get all the data is this possible.please reply as soon as possible. [Collection : SalesVchTypeColl] Type : Vouchers:VoucherType Child Of : $$VchTypeSales Belongs To : Yes Fetch : Date,VoucherNumber,VoucherType [Collection : SalesInvColl] Source Collection : SalesVchTypeColl Walk : AllInventory Entries, AccountingAllocations Fetch : PartyLedgerName,StockItemName,LedgerName,VoucherNumber,BilledQty,Rate,Amount,Date,Reference,Narration Compute : PartyName :$PartyLedgerName By : VchrNum :$VoucherNumber By : StkItmName :$StockItemName Compute : AccLedgr :$LedgerName Aggr Compute : StkQty :Sum:$BilledQty Aggr Compute : StkRate :Sum:$Rate Aggr Compute : StkAmnt :Sum:$Amount Compute : StkUom :$$LocaleString:$Rate Compute : SalsNartion :$Narration
Inventory Details i.e StockItemName , Rate,Qty,Amount,Sales Ledger used for Stock Item and Duties & Tax Ledgers used in SalesVoucher
[Collection : SalesInvColl] Source Collection : SalesVchTypeColl Walk : AllInventory Entries, AccountingAllocations ;;Fetch : PartyLedgerName,StockItemName,LedgerName,VoucherNumber,BilledQty,Rate,Amount,Date,Reference,Narration By : VchrNum :$VoucherNumber By : StkItmName :$StockItemName Compute : PartyName : $$Owner:$$Owner:$PartyLedgerName Compute : AccLedgr :$LedgerName Aggr Compute : StkQty :Sum:$$owner:$BilledQty Aggr Compute : StkRate :Sum:$$Owner:$Rate Aggr Compute : StkAmnt :Sum:$$Owner:$Amount Compute : StkUom :$$LocaleString:$BaseUnits:StockItem:$$Owner:$StockItemName Compute : SalsNartion :$$Owner:$$Owner:$Narration
In This collection we won't get the Tax Ledgers (Duties & Taxes). i need tax ledgers also in the report sir how can i get that one
Also.... Walk : All Ledger Entries By : LedName : $LedgerName then conditionally ...Aggr Compute if ledger belongs to Duties.............