Import Sales Invoice

Discussion in 'Tally Developer' started by bytelogik, Sep 6, 2012.

    
  1. bytelogik

    bytelogik New Member


    Dear Friends,

    I have wrote a TDL to import Sales Voucher from excel file which is attached to this post.
    I am stuck with importing Sales "Invoice". A sample excel file is attached.

    1) The problem is how to import sales items along with their quantity, rate and amount.
    I have no clue on how to proceed with this.
    It would be very helpful to me as well as other who are trying to import sales/purchase invoice.

    2) Is it possible to embed XML objects right into the code ?
    I have exported a sales invoice as XML, and imported the same using Import of Data --> Import of Vouchers in the tally. The xml file is imported OK.
    Now is the following possible ?
    Pseudocode for TDL:
    a) Import excel file containing multiple sales invoices
    b) Get record data for the sales invoice
    c) Create XML objects in the code
    d) Pass the XML objects to "Tally's Import Of Voucher" function (where is it???)

    3) Is it possible to call "Tally's Import Of Voucher" function by passing a XML file name ?

    Thanks in advance.
     

    Attached Files:




  2. In Your File You Written Write Some point which is missing is :
    Set value : Persisted View : $$Sysname:"InvVchView"

    For Inventory Entries
    For Qty Use as $$tgtObject:($$AsQty:(Variable Name(Number))
    for Rate USE $$tgtObject:($$asRate:(Variable Name))
     


  3. bytelogik

    bytelogik New Member


    Thanks Tushar.

    I was a bit frustated, there should have been an small example in TDL manual to import sales/purchase voucher from excel.
    Anyways, there is a small example in the TDL manual to create sales voucher. I will use that.
     


  4. laxman

    laxman Member


    if possible import accounts only with multy column for example date,party name,sale 5%,sale 13% , vat 5% ,vat 13%,packing charge,round off .
     


Share This Page