ODBC Export Vouchers with required fields

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

    
  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.
     


  2. NSA

    NSA Member


    Thank you Sir,
     


  3. Sudhir83411

    Sudhir83411 New Member


     


  4. Sudhir83411

    Sudhir83411 New Member


    Dear All

    Is there any new procedure to extract voucher by ODBC from Tally Prime?
     


  5. Sudhir83411

    Sudhir83411 New Member


    How can i select particular company name in this qurey
     


  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.
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


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

    Show by way of screenshot with remarks.
     


  8. Gareth

    Gareth New Member


    Following this thread I have been able to generate the following.(.jpg) attached. I have highlighted two columns in red. Wherein I want the primary group of a particular group to be entered and I also want to know whether it is a Dr or a Cr. I have used the following line to try and extract the Parent Group of a ledger " Compute : Parent1 : $$CollectionField:$Parent:1:AllLedgerEntries" but No Luck.

    Here's what the TDL looks like,

    "
    [Collection : All Vouchers]

    Type : Voucher

    Is ODBCTable: Yes

    Fetch : Date, VoucherNumber, Reference, VoucherTypeName, LedgerName, Parent , Narration, PartyLedgerName, Amount

    ;Fetch : DrLed, CrLed

    Compute : Led1 : $$CollectionField:$LedgerName:1:AllLedgerEntries

    Compute : Amt1 : $$CollectionField:$Amount:1:AllLedgerEntries

    Compute : Parent1 : $$CollectionField:$Parent:1:AllLedgerEntries

    Compute : Led2 : $$CollectionField:$LedgerName:2:AllLedgerEntries

    Compute : Amt2 : $$CollectionField:$Amount:2:AllLedgerEntries

    Compute : Led3 : $$CollectionField:$LedgerName:3:AllLedgerEntries

    Compute : Amt3 : $$CollectionField:$Amount:3:AllLedgerEntries

    Compute : Led4 : $$CollectionField:$LedgerName:4:AllLedgerEntries

    Compute : Amt4 : $$CollectionField:$Amount:4:AllLedgerEntries

    Compute : Led5 : $$CollectionField:$LedgerName:5:AllLedgerEntries

    Compute : Amt5 : $$CollectionField:$Amount:5:AllLedgerEntries

    Compute : Led6 : $$CollectionField:$LedgerName:6:AllLedgerEntries

    Compute : Amt6 : $$CollectionField:$Amount:6:AllLedgerEntries

    Compute : Led7 : $$CollectionField:$LedgerName:7:AllLedgerEntries

    Compute : Amt7 : $$CollectionField:$Amount:7:AllLedgerEntries

    Compute : Led8 : $$CollectionField:$LedgerName:8:AllLedgerEntries

    Compute : Amt8 : $$CollectionField:$Amount:8:AllLedgerEntries

    "

    I write the following command in the calculator panel to get the report:

    "
    select $Date, $VoucherTypeName, $VoucherNumber, $Led1,$Parent1, $Amt1, $Led2, $Amt2, $Led3, $Amt3, $Led4, $Amt4, $Led5, $Amt5, $Led6, $Amt6, $Led7, $Amt7, $Led8, $Amt8, $Amount from AllVouchers
    "

    Thanking you in anticipation.
     

    Attached Files:



  9. Himanshu-2002

    Himanshu-2002 Active Member


    Try to do it like this

    $Parent:Ledger:($$CollectionField:$LedgerName:3:AllLedgerEntries)
     


  10. Sai Vineeth

    Sai Vineeth Active Member


    If You want Vouchers in this format-(Every Ledger entry in rows)

    upload_2021-6-17_18-48-42.png


    Instead of using ODBC use XML - https://documenter.getpostman.com/view/13855108/TzeRpAMt#05ddfdc7-e3af-4d09-840a-d71942c8dc21
    This XML is for Sales Vouchers
    Load Xml in Power Query
     


  11. Saro

    Saro New Member


    Hi Experts,
    I want to Export all stock item Entered in invoice, through OBDC Connection, like below, can you to please suggest

    upload_2021-11-24_14-23-21.png
     


Share This Page