Multiplication of value in voucher

Discussion in 'Tally Developer' started by Sakthi 2018, Jan 22, 2019.

    
  1. Sakthi 2018

    Sakthi 2018 New Member


    Dear experts,
    I want multiplication of value in voucher which is billed qty and my user defined field like freight and other charges. I tried it, but don't multiply the two fields(quantity field, udf). Please guide us.....
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    show code..........
     


  3. Sakthi 2018

    Sakthi 2018 New Member



    Dear Sir,
    I Add two fields in purchase voucher and i want to multiply two fields which is freight amount (from stock item) & billed qty . I tried it, but don't come.
    Please correct my code.


    [#Part: STKI Batch]

    Add : Line : After : STKI SetSTDRate : LEDExpsFrg, LEDExpsCooli

    [Line: LEDExpsFrg]

    Fields : Medium Prompt, LEDExpsFrg

    Local : Field : Medium Prompt : Set as: $$LocaleString:"Freight Charges"

    [Field: LEDExpsFrg]

    Use : Amount Field
    Storage : ItemFreight

    [Line:LEDExpsCooli]

    Fields : Medium Prompt, LEDExpsCooli

    Local : Field : Medium Prompt : Set as: $$LocaleString:"Cooli"

    [Field: LEDExpsCooli]

    Use : Amount Field
    Storage : LEDCooli


    ;;-------------USER DEFINED FIELDS---------------;;

    [System:UDF]

    ItemFreight : Amount : 9006
    LEDCooli : Amount : 9007

    ;;Add Fields in Voucher

    [#Line : EI ColumnOne]
    Option : Global EI ColumnOne : @@IsPurchase

    [!Line: Global EI ColumnOne]

    Add : Fields : At End : SGFreight, SGFreightAmt, SGCli, SGCliAmt

    [Field : SGFreight]
    Use : Short Name field
    Info : "Freight"
    Align : Centre
    Width : 15
    Style : Small bold

    [Field : SGFreightAmt]

    Use : Short Name field
    Info : "Freight Amt"
    Align : Centre
    Width : 15
    Style : Small bold


    [Field : SGCli]
    Use : Short Name Field
    Info : "Cooli"
    Align : Center
    Width : 15
    Style : Small bold

    [Field : SGCliAmt]
    Use : Short Name Field
    Info : "Cooli Amt"
    Align : Center
    Width : 15
    Style : Small bold


    [#Field: VCH ItemTitle]

    Width : @@LongWidth

    [#Line : EI ColumnTwo]
    Option : Global EI ColumnTwo : @@IsPurchase

    [!Line: Global EI ColumnTwo]
    Add : Fields : At End : SGFreight, SGFreightAmt, SGCli, SGCliAmt
    Local : Field : SGFreight : Info : " "
    Local : Field : SGCli : Info : " "
    Local : Field : SGFreightAmt : Info : ""
    Local : Field : SGCliamt : Info : ""




    [#Line : EI InvInfo]
    Option : Global EI InvInfo : @@IsPurchase

    [#Line : CI InvInfo]
    Option : Global EI InvInfo : @@IsPurchase

    [!Line: Global EI InvInfo]
    Add : Fields : At End : SGFreight1, SGFreight2, SGCli1, SGCli2

    [Field : SGFreight1]
    Use : Amount Field
    Set As : $Itemfreight:StockItem:$StockItemName
    Align : Center
    Width : 15
    Skip : YES

    [Field : SGFreight2]
    Use : Amount Field
    Set As : $BilledQty * $ItemFreight
    Align : Center
    Width : 15
    Skip : YES


    [Field : SGCli1]
    Use : Amount Field
    Set As : $LEDCooli:StockItem:$StockItemName
    Align : Center
    Width : 15
    Skip : YES


    [Field : SGCli2]
    Use : Amount Field
    Set As : $BilledQty * $LEDCooli
    Align : Center
    Width : 15
    Skip : YES
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $BilledQty * #SGFreight1

    $BilledQty * #SGCli1
     


  5. Sakthi 2018

    Sakthi 2018 New Member


    Sir,
    Thank you for Reply. But it is not working
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Objectify the UDFs in Object:stockitem.............

    Are you getting this value???? --- $Itemfreight:StockItem:$StockItemName
     


  7. Sakthi 2018

    Sakthi 2018 New Member


    Yes Sir, I got that value. but, it doesn't multiply.
     


  8. Sakthi 2018

    Sakthi 2018 New Member


    I objectifies the UDFs, still it can't multiply....
     


Share This Page