1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

import sales order report

Discussion in 'Tally Integration' started by hadisunyoto, Jan 9, 2013.

    
Thread Status:
Not open for further replies.
  1. hadisunyoto

    hadisunyoto New Member


    Dear everyone,

    i am trying to export sales order report (outstanding) via xml

    the xml is as follows:

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Sales Orders</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVTODATE>9-1-2013</SVTODATE>
    </STATICVARIABLES>
    </DESC>
    </BODY>
    </ENVELOPE>

    Everything is as expected except that there is no customer or party name. What should be changed in this code to display customer or party name.

    Thank you very much for your help
     
    hadisunyoto, Jan 9, 2013
    #1


  2. A.Marudhachalamurthi

    A.Marudhachalamurthi Member


    Hai,

    Please tell me you are trying to export or import, hence in your xml, Tallyrequest Tag carries the value "EXPORT"

    Thanks & Regards,
    A.Marudhachalamurthi
     
    A.Marudhachalamurthi, Jan 9, 2013
    #2


  3. hadisunyoto

    hadisunyoto New Member


    Hi, thanks for the response. Actually i am trying to export data from Tally

    the result is ok, but no customer name or party name.
    So the question remains: What should be changed in the code above to display customer or party name?

    Thanks
     
    hadisunyoto, Jan 10, 2013
    #3


  4. A.Marudhachalamurthi

    A.Marudhachalamurthi Member


    Hi,
    Do you want to export the sales order book or order outstandings so that i can guide you.
     
    A.Marudhachalamurthi, Jan 10, 2013
    #4


  5. hadisunyoto

    hadisunyoto New Member


    i want to export order outstanding

    the result is similar like this:
    <ENVELOPE>
    <DORDATE>1-Jul-2012</DORDATE>
    <DORNAME>name 1</DORNAME>
    <DORITEM>product 1</DORITEM>
    <DORPNDGQTY>900</DORPNDGQTY>
    <DORRATE>20000</DORRATE>
    <ORDERDICOUNT></ORDERDICOUNT>
    <DORVALUE>18000000</DORVALUE>
    <DORDUEON>1-Mar-2012</DORDUEON>
    <ORDERDUEDAYS>( 314 days)</ORDERDUEDAYS>
    ....
    </ENVELOPE>

    you see that the code in first post can already generate this result, but no party name. That's all i want
     
    hadisunyoto, Jan 10, 2013
    #5


  6. A.Marudhachalamurthi

    A.Marudhachalamurthi Member


    Hai,

    You need to write a separate report so that you are able to get the details of party or customer name. Try to write the tdl code to generate the report.
     
    A.Marudhachalamurthi, Jan 10, 2013
    #6


Thread Status:
Not open for further replies.

Share This Page