Total of Discount Coloumn - Solved

Hi,
For a report I am trying to fetch Invoice Taxable Amount and Total Discount Amount in the Invoice. Now when I am using the Default Collection for SalesDataExport I am able to get the Total Taxable amount flawlessly but I am unable to get the total of Discount Value using the same parameters and method.

Unable to understand why.. Can Seniors Guide ??

( Discount Value is Already being computed in the collection as
Aggr Compute : ActualQty : Sum : $ActualQty
Aggr Compute : BilledQty : Sum : $BilledQty
Aggr Compute : Amount : Sum : $Amount
Aggr Compute : DiscountValue : Sum : ($BilledQty * $Rate) * $Discount / 100 )

Code:

    [Field: PQRPartyDiscountAmount]
    Use : Amount Forex Field
    Set as : $DiscountV
    Border : Thin Left
    Width : 10% Screen
    Align : Right
    Format : "No Zero,Symbol," + ##ShowForex
  
    [Field: PQRPartyTaxableAmount]
    Use : Amount Forex Field
    Set as : $Taxamount
    Border : Thin Left
    Width : 10% Screen
    Align : Right
    Format : "No Zero,Symbol," + ##ShowForex




[Collection: PQRSalesManVouchersColl]
    Use    : SalesDataSrcCollSrc
    Type : Voucher
    Fetch : Date,VoucherNumber,VoucherTypeName,LedgerName,PartyLedgerName,Manledger,AreaLedger,Amount,DiscountValue,LedgerEntries.*
    Filter : PQRSaleManVouchers
    Filter : SalesManFilter, AreaFilter
    Fetch    : Manledger:Ledger:$Ledgername
    Fetch    : Arealedger:Ledger:$Ledgername
    Compute: TaxAmount : $$CollAmtTotal:InventoryEntries:$AMount
    Compute : DiscountV : $$CollAmtTotal:InventoryEntries:$DiscountValue

 

Tried that Not working.. Tried the below method that also not working..

Code:

    [Field: PQRPartyTaxableAmount]
    Use : Amount Forex Field
    Set as : $DiscountV
    Border : Thin Left
    Width : 10% Screen
    Align : Right
    Format : "No Zero,Symbol," + ##ShowForex
   
    [Field: PQRPartyAmount]
    Use : Amount Forex Field
    Set as : $Amount
    Border : Thin Left
    Width : 10% Screen
    Align : Right
    Format : "No Zero,Symbol," + ##ShowForex
  


[Collection: PQRSalesManVouchersColl]
    Use    : SalesDataSrcCollSrc
    Type : Voucher
    Fetch : Date,VoucherNumber,VoucherTypeName,LedgerName,PartyLedgerName,Manledger,AreaLedger,Amount,DiscountValue,LedgerEntries.*,InventoryEntries.*
    Filter : PQRSaleManVouchers
    Filter : SalesManFilter, AreaFilter
    Fetch    : Manledger:Ledger:$Ledgername
    Fetch    : Arealedger:Ledger:$Ledgername
    Compute: TaxAmount : $$CollAmtTotal:InventoryEntries:$AMount
    Compute : DiscountV : $$CollAmtTotal:InventoryEntries:$DiscountValue
    Aggr Compute : ActualQty : Sum : $ActualQty
    Aggr Compute : BilledQty : Sum : $BilledQty
    Aggr Compute : Amount : Sum : $Amount
    Aggr Compute : DiscountValue : Sum : ($BilledQty * $Rate) * $Discount / 100

 

Didnt Work Then Also..

Lets leave the This code separetely. What would be the best way to get the total of the discount value per invoice..

Code:

    [Collection: PQRSalesManVouchersColl]
    Use    : SalesDataSrcCollSrc
    Type : Voucher
    Fetch : Date,VoucherNumber,VoucherTypeName,LedgerName,PartyLedgerName,Manledger,AreaLedger,Amount,DiscountValue,LedgerEntries.*,InventoryEntries.*
    Filter : PQRSaleManVouchers
    Filter : SalesManFilter, AreaFilter
    Fetch    : Manledger:Ledger:$Ledgername
    Fetch    : Arealedger:Ledger:$Ledgername
    Compute             : Rate              : $Rate
    Compute             : Discount          : $Discount
    Aggr Compute : ActualQty : Sum : $ActualQty
    Aggr Compute : BilledQty : Sum : $BilledQty
    Aggr Compute : Amount : Sum : $Amount
    Aggr Compute : DiscountValue : Sum : ($BilledQty * $Rate) * $Discount / 100
    Compute: TaxAmount : $$CollAmtTotal:InventoryEntries:$AMount
    Compute : DiscountV : $$CollAmtTotal:InventoryEntries:$DiscountValue

 

Mr. Mehta,

you are trying to compute discount value in voucher level, where as the discount is associated in sub collection called Inventory Entries.

So, try to use $$CollectionAmtTotal:InventoryEntries:$YourdiscValue

 

You mean like this

Compute : DiscountV : $$CollAmtTotal:InventoryEntries:$DiscountValue

 

Tally doesn't have $DiscountValue by default

so,
[#Object : InventoryEntry]
DiscountValue : ($BilledQty * $Rate) * $Discount / 100

then in your collection,

Compute : DiscountV : $$CollAmtTotal:InventoryEntries:$DiscountValue

Hope this clears your doubt.

 

Thanks .. What you suggested was not only educational .. It gave an important way to do things that if something is calculated in default collections and if you plan to use you need to objectify it. makes me look at things in a different way. Thanks @Amit Kamdar and @balajimg for guiding and solving this thread.

Hope both of you can help me solve this thread also
http://tdlexpert.com/index.php?threads/collection-name-needed-stock-vouchers.11570/#post-47815

7th TDL Completed thanks to this wonderful team and forum. Making my work very efficient.