Excel إلى ملف XML لأوامر البيع في Tally

<ENVELOPE>
 <HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER>
 <BODY>
  <IMPORTDATA>
   <REQUESTDESC>
    <REPORTNAME>Vouchers</REPORTNAME>
    <STATICVARIABLES><SVCURRENTCOMPANY>Your Company</SVCURRENTCOMPANY></STATICVARIABLES>
   </REQUESTDESC>
   <REQUESTDATA>
    <TALLYMESSAGE xmlns:UDF="TallyUDF">
     <VOUCHER VCHTYPE="Sales Order" ACTION="Create" OBJVIEW="Invoice Voucher View">
      <DATE>20261021</DATE>
      <VOUCHERTYPENAME>Sales Order</VOUCHERTYPENAME>
      <REFERENCE>SO-101</REFERENCE>
      <PARTYLEDGERNAME>Mehta Electric Stores</PARTYLEDGERNAME>
      <PARTYNAME>Mehta Electric Stores</PARTYNAME>
      <PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>
      <ISINVOICE>Yes</ISINVOICE>
      <LEDGERENTRIES.LIST>
       <LEDGERNAME>Mehta Electric Stores</LEDGERNAME>
       <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
       <ISPARTYLEDGER>Yes</ISPARTYLEDGER>
       <AMOUNT>-44953.28</AMOUNT>
      </LEDGERENTRIES.LIST>
      <LEDGERENTRIES.LIST>
       <LEDGERNAME>IGST</LEDGERNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <AMOUNT>6857.28</AMOUNT>
      </LEDGERENTRIES.LIST>
      <ALLINVENTORYENTRIES.LIST>
       <STOCKITEMNAME>Wire 1.5 sqmm Red FR 90m</STOCKITEMNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <RATE>1540.00/Coil</RATE>
       <AMOUNT>30800.00</AMOUNT>
       <ACTUALQTY> 20 Coil</ACTUALQTY>
       <BILLEDQTY> 20 Coil</BILLEDQTY>
       <BATCHALLOCATIONS.LIST>
        <GODOWNNAME>Main Location</GODOWNNAME>
        <BATCHNAME>Primary Batch</BATCHNAME>
        <ORDERNO>SO-101</ORDERNO>
        <AMOUNT>30800.00</AMOUNT>
        <ACTUALQTY> 20 Coil</ACTUALQTY>
        <BILLEDQTY> 20 Coil</BILLEDQTY>
        <ORDERDUEDATE P="24-Oct-2026">24-Oct-2026</ORDERDUEDATE>
       </BATCHALLOCATIONS.LIST>
       <ACCOUNTINGALLOCATIONS.LIST>
        <LEDGERNAME>Sales</LEDGERNAME>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT>30800.00</AMOUNT>
       </ACCOUNTINGALLOCATIONS.LIST>
      </ALLINVENTORYENTRIES.LIST>
      <ALLINVENTORYENTRIES.LIST>
       <STOCKITEMNAME>MCB 16A SP C Curve</STOCKITEMNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <RATE>160.00/Nos</RATE>
       <DISCOUNT>5</DISCOUNT>
       <AMOUNT>7296.00</AMOUNT>
       <ACTUALQTY> 48 Nos</ACTUALQTY>
       <BILLEDQTY> 48 Nos</BILLEDQTY>
       <BATCHALLOCATIONS.LIST>
        <GODOWNNAME>Main Location</GODOWNNAME>
        <BATCHNAME>Primary Batch</BATCHNAME>
        <ORDERNO>SO-101</ORDERNO>
        <AMOUNT>7296.00</AMOUNT>
        <ACTUALQTY> 48 Nos</ACTUALQTY>
        <BILLEDQTY> 48 Nos</BILLEDQTY>
        <ORDERDUEDATE P="24-Oct-2026">24-Oct-2026</ORDERDUEDATE>
       </BATCHALLOCATIONS.LIST>
       <ACCOUNTINGALLOCATIONS.LIST>
        <LEDGERNAME>Sales</LEDGERNAME>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT>7296.00</AMOUNT>
       </ACCOUNTINGALLOCATIONS.LIST>
      </ALLINVENTORYENTRIES.LIST>
     </VOUCHER>
     <VOUCHER VCHTYPE="Sales Order" ACTION="Create" OBJVIEW="Invoice Voucher View">
      <DATE>20261021</DATE>
      <VOUCHERTYPENAME>Sales Order</VOUCHERTYPENAME>
      <REFERENCE>SO-102</REFERENCE>
      <PARTYLEDGERNAME>Kumar Hardware</PARTYLEDGERNAME>
      <PARTYNAME>Kumar Hardware</PARTYNAME>
      <PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>
      <ISINVOICE>Yes</ISINVOICE>
      <LEDGERENTRIES.LIST>
       <LEDGERNAME>Kumar Hardware</LEDGERNAME>
       <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
       <ISPARTYLEDGER>Yes</ISPARTYLEDGER>
       <AMOUNT>-13888.00</AMOUNT>
      </LEDGERENTRIES.LIST>
      <LEDGERENTRIES.LIST>
       <LEDGERNAME>IGST</LEDGERNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <AMOUNT>1488.00</AMOUNT>
      </LEDGERENTRIES.LIST>
      <ALLINVENTORYENTRIES.LIST>
       <STOCKITEMNAME>LED Bulb 9W Cool White</STOCKITEMNAME>
       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
       <RATE>62.00/Nos</RATE>
       <AMOUNT>12400.00</AMOUNT>
       <ACTUALQTY> 200 Nos</ACTUALQTY>
       <BILLEDQTY> 200 Nos</BILLEDQTY>
       <BATCHALLOCATIONS.LIST>
        <GODOWNNAME>Main Location</GODOWNNAME>
        <BATCHNAME>Primary Batch</BATCHNAME>
        <ORDERNO>SO-102</ORDERNO>
        <AMOUNT>12400.00</AMOUNT>
        <ACTUALQTY> 200 Nos</ACTUALQTY>
        <BILLEDQTY> 200 Nos</BILLEDQTY>
        <ORDERDUEDATE P="21-Oct-2026">21-Oct-2026</ORDERDUEDATE>
       </BATCHALLOCATIONS.LIST>
       <ACCOUNTINGALLOCATIONS.LIST>
        <LEDGERNAME>Sales</LEDGERNAME>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT>12400.00</AMOUNT>
       </ACCOUNTINGALLOCATIONS.LIST>
      </ALLINVENTORYENTRIES.LIST>
     </VOUCHER>
    </TALLYMESSAGE>
   </REQUESTDATA>
  </IMPORTDATA>
 </BODY>
</ENVELOPE>