1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Create new sales order using xml request to Tally erp9

Discussion in 'Tally Integration' started by Shaheer, Jul 3, 2014.

    
  1. Shaheer

    Shaheer New Member


    Dear all,
    I have to insert a new sales order to the tally using xml request.
    Please help me

    Thanks.
     
    Shaheer, Jul 3, 2014
    #1
    zakirhossain likes this.


  2. Shaheer

    Shaheer New Member


    Dear all,
    Following is the xml request to create a new sales order. This will insert only one item.
    How to insert multiple item? Please help me

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Import Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <IMPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>All Masters</REPORTNAME>
    <STATICVARIABLES>
    <SVCURRENTCOMPANY>XYZ</SVCURRENTCOMPANY>
    </STATICVARIABLES>
    </REQUESTDESC>
    <REQUESTDATA>
    <TALLYMESSAGE xmlns:UDF="TallyUDF">
    <VOUCHER VCHTYPE="Sales Order" ACTION="Create">
    <DATE>20140401</DATE>
    <PARTYNAME>CASH</PARTYNAME>
    <VOUCHERTYPENAME>Sales Order</VOUCHERTYPENAME>
    <VOUCHERNUMBER>8</VOUCHERNUMBER>
    <REFERENCE>8</REFERENCE>
    <PARTYLEDGERNAME>CASH</PARTYLEDGERNAME>
    <BASICBASEPARTYNAME>CASH</BASICBASEPARTYNAME>
    <FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE>
    <PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>
    <BASICBUYERNAME>CASH</BASICBUYERNAME>
    <LEDGERENTRIES.LIST>
    <LEDGERNAME>CASH</LEDGERNAME>
    <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
    <LEDGERFROMITEM>No</LEDGERFROMITEM>
    <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
    <ISPARTYLEDGER>Yes</ISPARTYLEDGER>
    <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>
    <AMOUNT>-1000.00</AMOUNT>
    </LEDGERENTRIES.LIST>
    <ALLINVENTORYENTRIES.LIST>
    <STOCKITEMNAME>MY ITEM1</STOCKITEMNAME>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
    <ISAUTONEGATE>No</ISAUTONEGATE>
    <ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>
    <ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>
    <ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>
    <ISPRIMARYITEM>No</ISPRIMARYITEM>
    <ISSCRAP>No</ISSCRAP>
    <RATE>100.00/Nos</RATE>
    <AMOUNT>1000.00</AMOUNT>
    <ACTUALQTY> 10 Nos</ACTUALQTY>
    <BILLEDQTY> 10 Nos</BILLEDQTY>
    <BATCHALLOCATIONS.LIST>
    <MFDON>20140401</MFDON>
    <GODOWNNAME>Main Location</GODOWNNAME>
    <BATCHNAME>Primary Batch</BATCHNAME>
    <DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME>
    <INDENTNO/>
    <ORDERNO>-1</ORDERNO>
    <DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>
    <AMOUNT>1000.00</AMOUNT>
    <ACTUALQTY> 10 Nos</ACTUALQTY>
    <BILLEDQTY> 10 Nos</BILLEDQTY>
    <ORDERDUEDATE>2 Days</ORDERDUEDATE>
    </BATCHALLOCATIONS.LIST>
    <ACCOUNTINGALLOCATIONS.LIST>
    <LEDGERNAME>SALE OF SPARES @4%</LEDGERNAME>
    <GSTCLASS/>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <LEDGERFROMITEM>No</LEDGERFROMITEM>
    <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
    <ISPARTYLEDGER>No</ISPARTYLEDGER>
    <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
    <AMOUNT>1000.00</AMOUNT>
    </ACCOUNTINGALLOCATIONS.LIST>
    </ALLINVENTORYENTRIES.LIST>
    </VOUCHER>
    </TALLYMESSAGE>
    </REQUESTDATA>
    </IMPORTDATA>
    </BODY>
    </ENVELOPE>
     
    Shaheer, Jul 4, 2014
    #2


  3. sivam

    sivam Active Member



    Surely it insert only one item. Because u use only one ALLINVENTORYENTRIES.LIST. U repeat it based on ur No. of Items. like following...

    <TALLYMESSAGE xmlns:UDF="TallyUDF">
    <VOUCHER VCHTYPE="Sales Order" ACTION="Create">
    <DATE>20140401</DATE>
    <PARTYNAME>CASH</PARTYNAME>
    <VOUCHERTYPENAME>Sales Order</VOUCHERTYPENAME>
    <VOUCHERNUMBER>8</VOUCHERNUMBER>
    <REFERENCE>8</REFERENCE>
    <PARTYLEDGERNAME>CASH</PARTYLEDGERNAME>
    <BASICBASEPARTYNAME>CASH</BASICBASEPARTYNAME>
    <FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE>
    <PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>
    <BASICBUYERNAME>CASH</BASICBUYERNAME>
    <LEDGERENTRIES.LIST>
    <LEDGERNAME>CASH</LEDGERNAME>
    <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
    <LEDGERFROMITEM>No</LEDGERFROMITEM>
    <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
    <ISPARTYLEDGER>Yes</ISPARTYLEDGER>
    <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>
    <AMOUNT>-1000.00</AMOUNT>
    </LEDGERENTRIES.LIST>

    <ALLINVENTORYENTRIES.LIST>
    <STOCKITEMNAME>MY ITEM1</STOCKITEMNAME>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
    <ISAUTONEGATE>No</ISAUTONEGATE>
    <ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>
    <ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>
    <ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>
    <ISPRIMARYITEM>No</ISPRIMARYITEM>
    <ISSCRAP>No</ISSCRAP>
    <RATE>100.00/Nos</RATE>
    <AMOUNT>1000.00</AMOUNT>
    <ACTUALQTY> 10 Nos</ACTUALQTY>
    <BILLEDQTY> 10 Nos</BILLEDQTY>
    <BATCHALLOCATIONS.LIST>
    <MFDON>20140401</MFDON>
    <GODOWNNAME>Main Location</GODOWNNAME>
    <BATCHNAME>Primary Batch</BATCHNAME>
    <DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME>
    <INDENTNO/>
    <ORDERNO>-1</ORDERNO>
    <DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>
    <AMOUNT>1000.00</AMOUNT>
    <ACTUALQTY> 10 Nos</ACTUALQTY>
    <BILLEDQTY> 10 Nos</BILLEDQTY>
    <ORDERDUEDATE>2 Days</ORDERDUEDATE>
    </BATCHALLOCATIONS.LIST>
    <ACCOUNTINGALLOCATIONS.LIST>
    <LEDGERNAME>SALE OF SPARES @4%</LEDGERNAME>
    <GSTCLASS/>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <LEDGERFROMITEM>No</LEDGERFROMITEM>
    <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
    <ISPARTYLEDGER>No</ISPARTYLEDGER>
    <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
    <AMOUNT>1000.00</AMOUNT>
    </ACCOUNTINGALLOCATIONS.LIST>

    </ALLINVENTORYENTRIES.LIST>
    <ALLINVENTORYENTRIES.LIST>
    <STOCKITEMNAME>MY ITEM2</STOCKITEMNAME>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
    <ISAUTONEGATE>No</ISAUTONEGATE>
    <ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>
    <ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>
    <ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>
    <ISPRIMARYITEM>No</ISPRIMARYITEM>
    <ISSCRAP>No</ISSCRAP>
    <RATE>100.00/Nos</RATE>
    <AMOUNT>1000.00</AMOUNT>
    <ACTUALQTY> 10 Nos</ACTUALQTY>
    <BILLEDQTY> 10 Nos</BILLEDQTY>
    <BATCHALLOCATIONS.LIST>
    <MFDON>20140401</MFDON>
    <GODOWNNAME>Main Location</GODOWNNAME>
    <BATCHNAME>Primary Batch</BATCHNAME>
    <DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME>
    <INDENTNO/>
    <ORDERNO>-1</ORDERNO>
    <DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>
    <AMOUNT>1000.00</AMOUNT>
    <ACTUALQTY> 10 Nos</ACTUALQTY>
    <BILLEDQTY> 10 Nos</BILLEDQTY>
    <ORDERDUEDATE>2 Days</ORDERDUEDATE>
    </BATCHALLOCATIONS.LIST>
    <ACCOUNTINGALLOCATIONS.LIST>
    <LEDGERNAME>SALE OF SPARES @4%</LEDGERNAME>
    <GSTCLASS/>
    <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
    <LEDGERFROMITEM>No</LEDGERFROMITEM>
    <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
    <ISPARTYLEDGER>No</ISPARTYLEDGER>
    <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
    <AMOUNT>1000.00</AMOUNT>
    </ACCOUNTINGALLOCATIONS.LIST>
    </ALLINVENTORYENTRIES.LIST>

    </VOUCHER>
    </TALLYMESSAGE>
     
    sivam, Jul 25, 2014
    #3


Share This Page