XML IMPORT - LAST PRICE UPDATE

Hi,

I am trying to mass edit Stock Items using the XML Method for cost and selling price and mrp

<STANDARDCOSTLIST.LIST>
<DATE>20170401</DATE>
<RATE>557.33/pcs</RATE>
</STANDARDCOSTLIST.LIST>

When i edit using this what happens is if there are items with multiple dates it supercedes and does not add it in the last. I want it to update as the Last Item for the Cost List. Is there some format I can use to ensure that it gets added in the last for every stock item??


Something like this that we used to retrieve the last price in a report

$MRPDetails[Last].MRPRateDetails[Last].MRPRate

I hope my query is clear.

Code:

    <TALLYMESSAGE xmlns:UDF="TallyUDF">
     <STOCKITEM NAME="YOUVAN GOLD PLUS CAPSULE" RESERVEDNAME="">
      <MAILINGNAME.LIST TYPE="String">
       <MAILINGNAME>70048</MAILINGNAME>
      </MAILINGNAME.LIST>
      <OLDAUDITENTRYIDS.LIST TYPE="Number">
       <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>
      </OLDAUDITENTRYIDS.LIST>
      <GUID>bc214ed2-bab1-4282-8f48-94d5842c15f9-00000c58</GUID>
      <PARENT>JUICES &amp; NATURAL BEVERAGES</PARENT>
      <CATEGORY>ZA11 DIVYA MEDICINES 5</CATEGORY>
      <GSTAPPLICABLE>&#4; Applicable</GSTAPPLICABLE>
      <TAXCLASSIFICATIONNAME/>
      <GSTTYPEOFSUPPLY>Goods</GSTTYPEOFSUPPLY>
      <EXCISEAPPLICABILITY>&#4; Applicable</EXCISEAPPLICABILITY>
      <SALESTAXCESSAPPLICABLE/>
      <VATAPPLICABLE>&#4; Applicable</VATAPPLICABLE>
      <COSTINGMETHOD>FIFO</COSTINGMETHOD>
      <VALUATIONMETHOD>Std. Price</VALUATIONMETHOD>
      <BASEUNITS>Box of 10 pcs</BASEUNITS>
      <ADDITIONALUNITS>CTN</ADDITIONALUNITS>
      <EXCISEITEMCLASSIFICATION/>
      <VATBASEUNIT>pcs</VATBASEUNIT>
      <GSTREPUOM>PCS-PIECES</GSTREPUOM>
      <ISCOSTCENTRESON>No</ISCOSTCENTRESON>
      <ISBATCHWISEON>No</ISBATCHWISEON>
      <ISPERISHABLEON>No</ISPERISHABLEON>
      <ISENTRYTAXAPPLICABLE>No</ISENTRYTAXAPPLICABLE>
      <ISCOSTTRACKINGON>No</ISCOSTTRACKINGON>
      <ISUPDATINGTARGETID>No</ISUPDATINGTARGETID>
      <ASORIGINAL>Yes</ASORIGINAL>
      <ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT>
      <IGNOREPHYSICALDIFFERENCE>No</IGNOREPHYSICALDIFFERENCE>
      <IGNORENEGATIVESTOCK>No</IGNORENEGATIVESTOCK>
      <TREATSALESASMANUFACTURED>No</TREATSALESASMANUFACTURED>
      <TREATPURCHASESASCONSUMED>No</TREATPURCHASESASCONSUMED>
      <TREATREJECTSASSCRAP>No</TREATREJECTSASSCRAP>
      <HASMFGDATE>No</HASMFGDATE>
      <ALLOWUSEOFEXPIREDITEMS>No</ALLOWUSEOFEXPIREDITEMS>
      <IGNOREBATCHES>No</IGNOREBATCHES>
      <IGNOREGODOWNS>No</IGNOREGODOWNS>
      <CALCONMRP>No</CALCONMRP>
      <EXCLUDEJRNLFORVALUATION>No</EXCLUDEJRNLFORVALUATION>
      <ISMRPINCLOFTAX>No</ISMRPINCLOFTAX>
      <ISADDLTAXEXEMPT>No</ISADDLTAXEXEMPT>
      <ISSUPPLEMENTRYDUTYON>No</ISSUPPLEMENTRYDUTYON>
      <GVATISEXCISEAPPL>No</GVATISEXCISEAPPL>
      <REORDERASHIGHER>No</REORDERASHIGHER>
      <MINORDERASHIGHER>No</MINORDERASHIGHER>
      <ISEXCISECALCULATEONMRP>No</ISEXCISECALCULATEONMRP>
      <INCLUSIVETAX>No</INCLUSIVETAX>
      <GSTCALCSLABONMRP>No</GSTCALCSLABONMRP>
      <MODIFYMRPRATE>No</MODIFYMRPRATE>
      <ALTERID> 33672</ALTERID>
      <DENOMINATOR> 24</DENOMINATOR>
      <CONVERSION> 1</CONVERSION>
      <BASICRATEOFEXCISE> 12</BASICRATEOFEXCISE>
      <RATEOFVAT>0</RATEOFVAT>
      <VATBASENO> 1</VATBASENO>
      <VATTRAILNO> 1</VATTRAILNO>
      <VATACTUALRATIO> 0.0417</VATACTUALRATIO>
      <SERVICETAXDETAILS.LIST>      </SERVICETAXDETAILS.LIST>
      <VATDETAILS.LIST>      </VATDETAILS.LIST>
      <SALESTAXCESSDETAILS.LIST>      </SALESTAXCESSDETAILS.LIST>
      <GSTDETAILS.LIST>
       <APPLICABLEFROM>20170701</APPLICABLEFROM>
       <CALCULATIONTYPE>On Value</CALCULATIONTYPE>
       <HSNCODE>30049011</HSNCODE>
       <HSNMASTERNAME/>
       <TAXABILITY>Taxable</TAXABILITY>
       <ISREVERSECHARGEAPPLICABLE>No</ISREVERSECHARGEAPPLICABLE>
       <ISNONGSTGOODS>No</ISNONGSTGOODS>
       <GSTINELIGIBLEITC>No</GSTINELIGIBLEITC>
       <INCLUDEEXPFORSLABCALC>No</INCLUDEEXPFORSLABCALC>
       <STATEWISEDETAILS.LIST>
        <STATENAME>&#4; Any</STATENAME>
        <RATEDETAILS.LIST>
         <GSTRATEDUTYHEAD>Central Tax</GSTRATEDUTYHEAD>
         <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
         <GSTRATE> 6</GSTRATE>
        </RATEDETAILS.LIST>
        <RATEDETAILS.LIST>
         <GSTRATEDUTYHEAD>State Tax</GSTRATEDUTYHEAD>
         <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
         <GSTRATE> 6</GSTRATE>
        </RATEDETAILS.LIST>
        <RATEDETAILS.LIST>
         <GSTRATEDUTYHEAD>Integrated Tax</GSTRATEDUTYHEAD>
         <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
         <GSTRATE> 12</GSTRATE>
        </RATEDETAILS.LIST>
        <RATEDETAILS.LIST>
         <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
         <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
        </RATEDETAILS.LIST>
        <RATEDETAILS.LIST>
         <GSTRATEDUTYHEAD>Cess on Qty</GSTRATEDUTYHEAD>
         <GSTRATEVALUATIONTYPE>Based on Quantity</GSTRATEVALUATIONTYPE>
        </RATEDETAILS.LIST>
        <RATEDETAILS.LIST>
         <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
         <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
        </RATEDETAILS.LIST>
        <GSTSLABRATES.LIST>        </GSTSLABRATES.LIST>
       </STATEWISEDETAILS.LIST>
       <TEMPGSTDETAILSLABRATES.LIST>       </TEMPGSTDETAILSLABRATES.LIST>
      </GSTDETAILS.LIST>
      <LANGUAGENAME.LIST>
       <NAME.LIST TYPE="String">
        <NAME>YOUVAN GOLD PLUS CAPSULE</NAME>
       </NAME.LIST>
       <LANGUAGEID> 1033</LANGUAGEID>
      </LANGUAGENAME.LIST>
      <SCHVIDETAILS.LIST>      </SCHVIDETAILS.LIST>
      <EXCISETARIFFDETAILS.LIST>      </EXCISETARIFFDETAILS.LIST>
      <TCSCATEGORYDETAILS.LIST>      </TCSCATEGORYDETAILS.LIST>
      <TDSCATEGORYDETAILS.LIST>      </TDSCATEGORYDETAILS.LIST>
      <EXCLUDEDTAXATIONS.LIST>      </EXCLUDEDTAXATIONS.LIST>
      <OLDAUDITENTRIES.LIST>      </OLDAUDITENTRIES.LIST>
      <ACCOUNTAUDITENTRIES.LIST>      </ACCOUNTAUDITENTRIES.LIST>
      <AUDITENTRIES.LIST>      </AUDITENTRIES.LIST>
      <MRPDETAILS.LIST>
       <FROMDATE>20170401</FROMDATE>
       <MRPRATEDETAILS.LIST>
        <STATENAME>&#4; Any</STATENAME>
        <MRPRATE>750.00/pcs</MRPRATE>
       </MRPRATEDETAILS.LIST>
      </MRPDETAILS.LIST>
      <VATCLASSIFICATIONDETAILS.LIST>      </VATCLASSIFICATIONDETAILS.LIST>
      <COMPONENTLIST.LIST>      </COMPONENTLIST.LIST>
      <ADDITIONALLEDGERS.LIST>      </ADDITIONALLEDGERS.LIST>
      <SALESLIST.LIST>      </SALESLIST.LIST>
      <PURCHASELIST.LIST>      </PURCHASELIST.LIST>
      <FULLPRICELIST.LIST>      </FULLPRICELIST.LIST>
      <BATCHALLOCATIONS.LIST>      </BATCHALLOCATIONS.LIST>
      <TRADEREXCISEDUTIES.LIST>      </TRADEREXCISEDUTIES.LIST>
      <STANDARDCOSTLIST.LIST>
       <DATE>20170401</DATE>
       <RATE>557.33/pcs</RATE>
      </STANDARDCOSTLIST.LIST>
      <STANDARDPRICELIST.LIST>
       <DATE>20170401</DATE>
       <RATE>582.30/pcs</RATE>
      </STANDARDPRICELIST.LIST>
      <EXCISEITEMGODOWN.LIST>      </EXCISEITEMGODOWN.LIST>
      <MULTICOMPONENTLIST.LIST>      </MULTICOMPONENTLIST.LIST>
      <LBTDETAILS.LIST>      </LBTDETAILS.LIST>
      <PRICELEVELLIST.LIST>      </PRICELEVELLIST.LIST>
      <GSTCLASSFNIGSTRATES.LIST>      </GSTCLASSFNIGSTRATES.LIST>
      <EXTARIFFDUTYHEADDETAILS.LIST>      </EXTARIFFDUTYHEADDETAILS.LIST>
      <TEMPGSTITEMSLABRATES.LIST>      </TEMPGSTITEMSLABRATES.LIST>
     </STOCKITEM>
    </TALLYMESSAGE>