Total in Ledger Billwise Report

Discussion in 'Tally Developer' started by Vashisth, Mar 21, 2019.

    
  1. Vashisth

    Vashisth New Member


    Dear Sir's,
    Kindly help me on below code : how to get total of highlight field with sub total & total.

    [​IMG]
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: PENDINGCHECK]
    Set as: $$AsAmount:50000
    Width: 8
    Type: Number
    Align: Right
    Border: thin right
     


  3. Vashisth

    Vashisth New Member


    Dear Sir, it changes USD RATE field by default with 50000 which i don't required,
    also total and sub total is not coming. as i required sub total & total of USD column field.

    upload_2019-3-21_17-17-11.png
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    refer ---- part : bill subtotal and insert your 2 fields there and calculate totals.
     


  5. Vashisth

    Vashisth New Member


    Sir, not able to sort out..
    can you please help in detailed.
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    add ur 2 fields in part: bill subtotal also

    why and what u cannot understand........... i assume you have made this code yourself??

    Same way u added in previous parts....add it here too.
     


  7. Vashisth

    Vashisth New Member



    [#Line: VCHBILL MainLine]
    Fields : VCHBILLType, OldBillName, SVForceDebit, VCHBILLName, VCHBILLDate, VCHBILLExpiry
    Add: Field: test

    [Field : Test]
    ;Set as: ""
    Use: Number Field
    Storage: myamt

    [System: UDF]
    myamt : Number: 50000


    [#Line: BILLCol1]
    Local : Field : pendingcheck : Set as: "USD"
    Local : Field : pendingcheck : Width: 8
    Local : Field : pendingAMT : Set as: "USD"
    Local : Field : pendingAMT : Width: 10

    [#Line: BILLCol2]
    Local : Field : pendingcheck : Set as: "Rate"
    Local : Field : pendingAMT : Set as: " "

    [#Line: BILLWithDates]
    Right Fields : BillDue, BILLOverdue, PENDINGCHECK,pendingamt
    [Field: PENDINGCHECK]
    Set as: $myamt
    Width: 8
    Type: Number
    Align: Right
    Border: thin right

    [Field: pendingamt]
    Use : AmountField
    Type : Amount
    Set as:(#BillCL/#PENDINGCHECK)
    Width: 10
    Align: Right
    ;Format : "DrCr,NoZero,"


    [#Line: BILL Total]

    Local : Field : pendingamt : Set as :$$Total:pendingamt
    Local : Field : pendingcheck : Set as :$$Total:pendingcheck

    [#Part: BILL Body]
    Lines : BILL Column, BILL Detail
    BottomLines : BILL Total
    Scrolled : Vertical
    Total : BILLCl, BILLInterest, BILLPDC, BILLFinal, BILLOp, BILLForex,pendingamt

    [#Part: BILL SubTotal]
    Local : Line : BILLSubTotal : Replace : Field : Pendingamt : Subpendingamt

    [Field: Subpendingamt]
    Use : pendingamt
    Set as : $$SubTotal:pendingamt
    Style : Normal Italic
    Border : FullThinTop
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    So....is it working???
     


  9. Vashisth

    Vashisth New Member


    Not working sir..:(:(;)
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Maybe you should read once again and very carefully what I instructed......

    I said ADD..... never said replace..... and how can you replace a field when it is not there in the first place :)
     


  11. Vashisth

    Vashisth New Member


    Dear Sir,
    Thanks for your support.. (finally done)....
     

    Attached Files:



  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    very good....same way you can have it ready for group-wise also....... just like LEDBILL Body.....find the Group body and just add your field.
     


Share This Page