Dear all, I am very much new to this forum and this is my first post.
I am having a Exceltotally program (Tally is an accounting program)
Excel sheet is attached herewith.
In A1 there is comment:
<COLUMNNAME.LIST>
<COLUMNNAME>ID</COLUMNNAME>
</COLUMNNAME.LIST>
<MASTER TYPE="LEDGER" SINGLERECORD="No">
<NAME.LIST>
<NAME>sbi aakrutee</NAME>
</NAME.LIST>
<PARENT>Bank Accounts</PARENT>
</MASTER>
<VOUCHER>
<GUID FORMULA="=+"ss-" & IF(AND(MONTH(B#)>=4,MONTH(B#)<=12),YEAR(B#) & "nn" & YEAR(B#)+1,YEAR(B#)-1 & "-" &YEAR(B#)) & "-" & IF(LEN(A#)>=18,"",REPT("0",18-LEN(A#))) & RIGHT(A#,18)"/>
<DATE COLUMNREFERENCE="B"/>
<EFFECTIVEDATE COLUMNREFERENCE="B"/>
<VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
<REFERENCE COLUMNREFERENCE="A"/>
<NARRATION COLUMNREFERENCE="H"/>
<VOUCHERNUMBER COLUMNREFERENCE="A"/>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME COLUMNREFERENCE="C"/>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<AMOUNT FORMULA="=+Round(G#,2)*1"/>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>sbi aakrutee</LEDGERNAME>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<AMOUNT FORMULA="=+Round(G#,2)*-1"/></ALLLEDGERENTRIES.LIST>
</VOUCHER>
In Cell C1 comment is as under:
<COLUMNNAME.LIST>
<COLUMNNAME>LEDGERNAME</COLUMNNAME>
</COLUMNNAME.LIST>
<MASTER TYPE="LEDGER">
<NAME.LIST>
<NAME COLUMNREFERENCE="C"/>
</NAME.LIST>
<PARENT>SUNDRY DEBTORS</PARENT>
<ISBILLWISEON>No</ISBILLWISEON>
<ISCOSTCENTRESON>No</ISCOSTCENTRESON>
</MASTER>
This excel sheet gives me a less than perfect result. It allows me to have one entry only under PARTICULARS. Screenshot is attached
I want to have under PARTICULARS (in Tally program)
Valuation fees 1500
Service tax 225
TDS Receivable AY1718 -150
So, total should be 1500+225-150 = 1575
Presently, with the above code, I can only enter
Valuation fee = 1500/-
How and what are the changes to make to get my result achieved.
I am very much new to xml and so, I required help from you buddies