ODBC Export Vouchers with required fields

Discussion in 'Tally Integration' started by Sanket Patel, Jul 29, 2019.

Tags:
Page 2 of 2
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The computes formulas give by me and used by you will not work for your purposes. It is given to him, to enable him to transpose data to excel.

    In your case, you have to design and construct your collection in a way, that is required. e.g. Filter on Sales or Purchases.......

    CollectionField will work better and perfectly when you have a strict and consistent method of data entry or a Consistent Table of Data OR from another Collection.

    As per above CollectionField is getting the data for Line # 1 to 8 .........

    and let's say your sales entries are as under:
    entry # 1
    Party A/c DR
    ....to Sales A/c Cr
    ....to CGST 9% A/c Cr
    ....to SGST 9% A/c Cr

    entry # 2
    Party A/c DR
    ....to Sales A/c Cr
    ....to IGST 28% A/c Cr
    ...to R/Off A/c Cr or Dr (as the case maybe)

    As you can see, in above case.....CollectionField will not work for you.......... it will pick data based on the Line number.

    There are many similar type of Reports on this Forum.......go through the same and learn how to collect your relevant data.
     
    Amit Kamdar, Nov 8, 2020
    #26


  2. NSA

    NSA Member


    Thank you Sir,
     
    NSA, Nov 8, 2020
    #27


  3. Sudhir83411

    Sudhir83411 New Member


     
    Sudhir83411, Nov 9, 2020
    #28


  4. Sudhir83411

    Sudhir83411 New Member


    Dear All

    Is there any new procedure to extract voucher by ODBC from Tally Prime?
     
    Sudhir83411, Nov 12, 2020
    #29


  5. Sudhir83411

    Sudhir83411 New Member


    How can i select particular company name in this qurey
     
    Sudhir83411, Dec 9, 2020
    #30


  6. Gareth

    Gareth New Member


    Amit Ji

    I'm relatively new to TDL, and can't figure out how to display the amount next to the ledger name and also display the primary group of the ledger


    [Collection : All Vouchers]

    Type : Voucher

    Fetch : Date, VoucherNumber, Reference, VoucherTypeName, LedgerName, Narration, PartyLedgerName, Amount
    ;Fetch : DrLed, CrLed

    Compute : Led1 : $$CollectionField:$LedgerName:1:AllLedgerEntries
    Compute : Amt1 : $$CollectionField:$Amount:1:AllLedgerEntries
    Compute : Led2 : $$CollectionField:$LedgerName:2:AllLedgerEntries
    Compute : Amt2 : $$CollectionField:$Amount:2:AllLedgerEntries


    Please help.
     
    Gareth, May 11, 2021
    #31


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Explain clearly.....
    In what report you want?
    Which position???

    Show by way of screenshot with remarks.
     
    Amit Kamdar, May 11, 2021
    #32


Page 2 of 2

Share This Page