Support required for Voucher Type wise Bills Receivables Report

Discussion in 'Tally & TDL Learning HUB' started by Ch Suresh, Oct 31, 2022.

    
  1. Ch Suresh

    Ch Suresh Member


    Dear Experts,
    I am trying to filter voucher type in the bills receivables report, but unable to fetch the Vouchertype name in that report, please guide me


    My code is:

    [#Line: BILLCol1]
    Local:Field:BillType:Info:"VCH TYPE"

    [#Line: BILLCol2]
    Local:Field:BillType:Info:""

    [#Field: BILLFixed]
    Add:Field:Before:BILLDate:BillType

    [Field:BillType]
    Use : ShortNameField
    Set as : $BillType;CurLangVoucherTypeName
    Width : @@NumberWidth + 1

    [#Collection: Company Receivables]
    ; Walk:Ledger Entries
    ; Walk:Inventory Entries
    Compute:Billtype:$Name:VoucherType:$VoucherTypeName

    upload_2022-10-31_12-30-35.png
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Bills Receivable and Bills Payable has collection of BILLS .... hence there is no direct co-relation with Entries in order for you to extract the Vchtype.

    You will need to make a FUNCTION to extract the VchType from the bill name and display it in your field.
     


  3. balajimg

    balajimg Active Member


    just for the understanding, check this

    [#Collection: Company Receivables]
    Compute : Billtype : $LedgerEntries[1].VoucherTypeName
     


  4. Ch Suresh

    Ch Suresh Member


    Thank you for your quick response, i will go through your suggitions

    Thank you
     


  5. Mac

    Mac Member



    nice one sir ji , What about the Filter of specific sales voucher type ?
     


  6. balajimg

    balajimg Active Member


    add your filter to the collection
     


  7. Mac

    Mac Member


    I WRITE THIS LIKE BELOW BUT NOT WORKING -"SAL IS SALES VOUCHER TYPE" -Kindly suggest


    [#Collection: Company Receivables]
    Compute : Billtype : $LedgerEntries[1].VoucherTypeName
    ;Filter:JJJ

    [System:Formula]
    JJJ :$VoucherTypeName CONTAINS "SAL"
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    JJJ :$VoucherTypeName = "SAL"
     


  9. Mac

    Mac Member


    TRIED BUT STILL NOT WORKING SIR
     


  10. Himanshu-2002

    Himanshu-2002 Active Member


    In your field do it like this

    [Field: MyVchTypeField]
    Set as:$LedgerEntries[1, @@IsSalVchType].VoucherTypeName

    [System:Formulas]
    IsSaleVchType:$VoucherTypeName contains "SAL"
     


  11. Mac

    Mac Member



    HIMANSHUBHAI its working replace of "Vchtype field" perfectly , but not filtering data of "SAL" vouchertype
     


  12. Himanshu-2002

    Himanshu-2002 Active Member


    Great, Yes You need to replace the field name as per your report. It won't filter the other fields directly But you can use the same approach to fetch other things as well

    Example:How to fetch Invoice Amount of Voucher Type containing "SAL"

    [Field: MyInvAmtField]
    Set as:$LedgerEntries[1, @@IsSalVchType].Amount

    [System:Formulas]
    IsSaleVchType:$VoucherTypeName contains "SAL"

    Note: No need to define system formulas again and again
     


  13. Mac

    Mac Member



    Thanks , Himanshubhai

    But My Concern is Show only "SAL" Voucher type Invoices.
     


  14. Himanshu-2002

    Himanshu-2002 Active Member


    Do like this in your collection

    [Collection:MyBillsCollection]
    Type:Bills
    Filter:IsSaleVchTypeBill

    [System:Formulas]
    IsSaleVchTypeBill:NOT $$IsEmpty:$LedgerEntries[1, @@IsSaleVchType].MasterID
    IsSaleVchType:$VoucherTypeName contains "SAL"
     


  15. Mac

    Mac Member


    Still not working sir ji
     


Share This Page