Discount Amount not display / Fetching in invoice column

Discussion in 'Free Source Codes' started by ONKAR, Sep 23, 2019.

    
  1. ONKAR

    ONKAR Active Member


    dear experts I want little help, see this image, discount amount total not coming in column total, I added this but not getting total of this column, see this image and code

    Local: Field: KA Discount Amt: Set as:$$CollAmtTotal:InventoryEntries:$Discount


    POS INVOICE.jpg
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    set as : $$Total:{field name}
     
    ONKAR likes this.


  3. ONKAR

    ONKAR Active Member


    @Amit Kamdar sir I added this

    Local: Field: KA Discount Amt:Set as:$$Total: KA Discount Amt

    i also added this - Local: Field: KA Discount Amt:Set as:$$CollAmtTotal:InventoryEntries:$$Total:KA Discount Amt

    but after loading this tally quit and showing Bad Formula
     


  4. teja varma

    teja varma Active Member


    if it is an attribute of the InventoryEntries(Collection) then use like this:
    Code:
    $$CollAmtTotal:InventoryEntries:$KADiscountAmt
    else

    you have to add this one to the part where InventoryEntries are repeated
    Total :KADiscountAmt

    and in the field where you want to set
    setas :$$Total:KADiscountAmt
     


  5. ONKAR

    ONKAR Active Member


    @teja varma Bhai and @Amit Kamdar sir I have added customized discount tdl in tally, in tally default discount is % basis but I want amount wise so I added a tdl, I think the problem comes from this tdl , see this tdl , cash discount



    [#Line: EI ColumnOne]

    Add: Option: Disc EI ColumnOne: @@IsSales

    [!Line: Disc EI ColumnOne]

    Local: Field: VCH DiscTitle: Set as: "Disc Amt"

    [#Line: VCHBATCH ColumnOne]

    Add: Option: Disc EI ColumnName: @@IsSales

    [!Line: Disc EI ColumnName]

    Local: Field: VCH DiscTitle: Info: "Disc Amt"

    [#Field: MPSDiscountTitle]

    Set as: "Discount Amt"


    [System: Formula]

    CalculatedAmt: ($Rate * $BilledQty) - $BatchDiscount

    NormalAmount: ($BilledQty * $Rate) - $BatchDiscount

    [#Field: VCH Discount]

    Delete: Format

    Add: Format: "Nopercent,NoZero"

    [#Field: VCHBATCH Discount]

    Delete: Format

    Add: Format: "Nopercent,NoZero"

    [#Field: VCH Value]

    Resetval: if (@@NoBaseUnits OR $$IsEmpty:BilledQty) then $$Value else (($Rate * $BilledQty) - $Discount)
     


  6. teja varma

    teja varma Active Member


    then use :
    Code:
    $$CollAmtTotal:InventoryEntries:$KADiscountAmt
     


Share This Page