search

Fammeo / EasyCloudBooks

MIT License
3 stars 1 forks source link

Tally XML Export for Transaction Page - Required #1003

Open sureshsirvi opened 2 years ago

sureshsirvi commented 2 years ago

We need Excel export for Transaction to import in Tally Software.. Following Fields Required.

For Invoices Voucher

  1. Invoice Date [ Transaction Date ]
  2. Invoice Number [ UniqueId ]
  3. Invoice Amount Before Tax
  4. Invoice Tax Amount
  5. Invoice Total Amount
  6. Notes
  7. Referance Number
  8. Company Name
  9. Default Contact name

For Receipt / Payment and JV Voucher

  1. Date [ Transaction Date ]
  2. Number [ UniqueId ]
  3. Amount
  4. Payment Mode
  5. Notes
  6. Referance Number
  7. Company Name
  8. Default Contact name
sureshsirvi commented 2 years ago

https://documenter.getpostman.com/view/8373681/Szzn7wsi

Xml format

sureshsirvi commented 2 years ago

Looking for high prority.

sureshsirvi commented 2 years ago

Problem:

  1. Most of users using Tally Software for their Firm's accounting. Currently they are required to do mannualy again all transaction into tally which are already recoreded in our ECB.
  2. It is results into duplication of accounting for the ECB users. To do mannual entries into tally from ECB takes to much time also.

Solution:

  1. Tally Accepts XML file as Data Interchange. Hence we can generate XML file for tally using Sample XML provided from Tally. It is idependent sollution and no another software is required to import into tally.Or
  2. In Tally data can be imported using excel file too but it required third party another software to import into tally using excel.
vinpahilwani commented 2 years ago

why we need to create different xml for receipt and invoices @sureshsirvi

sureshsirvi commented 2 years ago

why we need to create different xml for receipt and invoices @sureshsirvi

No need to create separat XML file.. i have sample XML file. will share with mitul sir.. since XML file upload is not supported by github.

mitulpanch commented 2 years ago 
<!-- These XML tags are added to Excel sheet at run-time by UDIMAGIC  -->
<XMLTAGS CELLREFERENCE="A1" FROMROW="4" xmlns:UDF="TallyUDF">
  <!-- Specifies that this (i.e Column as mentioned above) is the key field -->
  <COLUMNNAME.LIST>
    <COLUMNNAME>ID</COLUMNNAME>
    <COLUMNNAME>NAME</COLUMNNAME>
  </COLUMNNAME.LIST>
  <!-- Create VOUCHERTYPE Masters -->
  <MASTER TYPE="VOUCHERTYPE">
    <COMPANYNAME FORMULA="=T#[1]"/>
    <NAME.LIST>
      <NAME COLUMNREFERENCE="C"/>
    </NAME.LIST>
    <PARENT COLUMNREFERENCE="B"/>
    <NUMBERINGMETHOD>Manual</NUMBERINGMETHOD>
    <ISDEEMEDPOSITIVE FORMULA="=If(Or(B#=&quot;Payment&quot;,B#=&quot;Sales&quot;,B#=&quot;Debit Note&quot;,B#=&quot;Journal&quot;,B#=&quot;Sales Order&quot;),&quot;Yes&quot;,&quot;No&quot;)"/>
    <COMMONNARRATION>Yes</COMMONNARRATION>
  </MASTER>
  <!-- Create CURRENCY Master -->
  <MASTER TYPE="CURRENCY">
    <COMPANYNAME FORMULA="=T#[1]"/>
    <ORIGINALNAME COLUMNREFERENCE="U"/>
    <MAILINGNAME FORMULA="=U# &amp; &quot; Curr&quot;"/>
    <DECIMALPLACES> 2</DECIMALPLACES>
  </MASTER>
  <!-- Create Group Master -->
  <MASTER TYPE="GROUP">
    <COMPANYNAME FORMULA="=T#[1]"/>
    <NAME.LIST>
      <NAME FORMULA="=if(len(trim(K#))=0,&quot;New Ledgers&quot;,K#)"/>
    </NAME.LIST>
    <PARENT/>
  </MASTER>
  <!-- Create Ledger Masters -->
  <MASTER TYPE="LEDGER">
    <COMPANYNAME FORMULA="=T#[1]"/>
    <NAME.LIST>
      <NAME COLUMNREFERENCE="H"/>
    </NAME.LIST>
    <PARENT FORMULA="=if(len(trim(K#))=0,&quot;New Ledgers&quot;,K#)"/>
  </MASTER>
  <VOUCHER11>
    <COMPANYNAME FORMULA="=T#[1]"/>
    <GUID FORMULA="=+&quot;udi-EF5Q2H-&quot; &amp; A# &amp; &quot;-&quot; &amp; E# &amp; &quot;-&quot; &amp; C#"/>
    <DATE COLUMNREFERENCE="E"/>
    <EFFECTIVEDATE COLUMNREFERENCE="E"/>
    <VOUCHERTYPENAME COLUMNREFERENCE="C"/>
    <VOUCHERNUMBER COLUMNREFERENCE="D"/>
    <REFERENCE COLUMNREFERENCE="F"/>
    <REFERENCEDATE COLUMNREFERENCE="G"/>
    <NARRATION COLUMNREFERENCE="R"/>
    <ISINVOICE>No</ISINVOICE>
    <ALLLEDGERENTRIES.LIST SCROLL="YES">
      <NARRATION COLUMNREFERENCE="S"/>
      <LEDGERNAME COLUMNREFERENCE="H"/>
      <ISDEEMEDPOSITIVE FORMULA="=IF(UPPER(J#)=&quot;DR&quot;,&quot;Yes&quot;,&quot;No&quot;)"/>
      <AMOUNT CURRENCY="=U#" ROE="=V#" FORMULA="=+Round(I#,2)*IF(UPPER(J#)=&quot;DR&quot;,-1,1)"/>
      <BANKALLOCATIONS.LIST SKIP="=And(len(trim(L#))=0,len(trim(M#))=0,len(trim(N#))=0,len(trim(O#))=0,len(trim(P#))=0,len(trim(Q#))=0)">
        <DATE FORMULA="=E#[1]"/>
        <INSTRUMENTDATE COLUMNREFERENCE="M"/>
        <INSTRUMENTNUMBER COLUMNREFERENCE="L"/>
        <TRANSACTIONTYPE FORMULA="=if(len(trim(N#))=0,&quot;Cheque&quot;,N#)"/>
        <PAYMENTFAVOURING FORMULA="if(len(trim(O#))=0,H#[1],O#)"/>
        <CHEQUECROSSCOMMENT COLUMNREFERENCE="P"/>
        <BANKERSDATE COLUMNREFERENCE="Q"/>
        <STATUS>No</STATUS>
        <AMOUNT CURRENCY="=U#" ROE="=V#" FORMULA="=+Round(I#,2)*IF(UPPER(J#)=&quot;DR&quot;,-1,1)"/>
        <PAYMENTMODE>Transacted</PAYMENTMODE>
        <NAME FORMULA="=+&quot;udi-EF5Q2H-&quot; &amp; A# &amp; &quot;-&quot; &amp; E# &amp; &quot;-&quot; &amp; #"/>
      </BANKALLOCATIONS.LIST>
    </ALLLEDGERENTRIES.LIST>
  </VOUCHER11>
</XMLTAGS>
vinpahilwani commented 2 years ago

@sureshsirvi can u plz create a video to showcase how user is going to use the xml assuming easycloudbooks provides kind of output you are looking at. to actually understand how user is going to deal with the xml which he gets from easycloudbooks

sureshsirvi commented 2 years ago

@sureshsirvi can u plz create a video to showcase how user is going to use the xml assuming easycloudbooks provides kind of output you are looking at. to actually understand how user is going to deal with the xml which he gets from easycloudbooks

See this video for XML import in tally.

https://www.berrycast.com/conversations/887eaa5c-899f-5d11-a81c-12945a09fffb

to @vinpahilwani

mitulpanch commented 2 years ago

Please @vinpahilwani @sureshsirvi confirm what need to develop so i can move this issue,, if nothing then please say here

sureshsirvi commented 2 years ago

Problem Statement: Currently we need to do mannualy all transaction entry into tally to maintain books of account. We have already avalable records for Invoices, Receipt, Payment and Journals entries. It becomes the duplication of accounting work.

Suggested Solutions

  1. XML Data Interchange: In this case tally supports XML file to import transaction into tally and also supports export of transaction into xml file. We can use this tally facility to import ECB transaction into tally.

  2. ODBC Data Interchange: In this case Tally supports over ODBC port to interchange data. In our case our ECB is cloud base software and runs on browser hence, we need to create one EXE program to talk with tally over the ODBC port. In this sollution we need to provide additional EXE file to user and after installation user need to configure port setting for data interchange.

Conclusion: My suggestion is to go for "XML Data Interchange" facility reason is

  1. Easy to export from ECB
  2. Easy to import into Tally
  3. Less time required to create this facility like 3 days arround [Confirmed @mitulpanch]

Approval Required from @vinpahilwani.

vinpahilwani commented 2 years ago

I authorize this feature but I am not technically sound on this, I request @sureshsirvi @mitulpanch to take care of this feature. I have given my concerns and suggested course of action to sirvi

sureshsirvi commented 2 years ago

Tomorrow i will share XML tag for import of voucher. Comparision of type of voucher in tally with ECB. <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

No | ECB Voucher | Tally Voucher Default -- | -- | -- 1 | Invoice | Sales 2 | Receipt | Receipt 3 | Payment | Payment 4 | Discount | Journal

sureshsirvi commented 2 years ago

Default Ledger for Tally from ECB

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

No | ECB Voucher | Tally Voucher | Default Ledger for Tally | Ledger Group | Effect | Condition -- | -- | -- | -- | -- | -- | -- 1 | Invoice | Sales | Gross Receipt | Indirect Incomes | Credit | - 2 | Receipt | Receipt | Cash | Cash-in-Hand | Debit | #Payment Mode# = "Cash" 3 | Receipt | Receipt | #Payment Mode# | Bank Accounts | Debit | - 4 | Payment | Payment | Cash | Cash-in-Hand | Credit | #Payment Mode# = "Cash" 5 | Payment | Payment | #Payment Mode# | Bank Accounts | Credit | - 6 | Discount | Journal | Discount | Indirect Expenses | Debit | If Amount is Negative - Means Client has given 4000/- against Due Rs 5000/- hence Rs 1000/- is Discount as Debit 7 | Discount | Journal | Discount | Indirect Expenses | Credit | If Amount is Positive - Means Client has given 5000/- against Due Rs 5=4000/- hence Rs 1000/- is Excess amount to Credited

sureshsirvi commented 2 years ago

We need two type of XML export.

  1. Master XML file
  2. Transaction XML file
mitulpanch commented 2 years ago

@sureshsirvi When do you require this? any priority, currently we are working on Custom Field Module, later Custom File is assigned, Please provide timeline so i can allocate

sureshsirvi commented 2 years ago

We need to take this on high priority.. I am ready to provide all required details.

sureshsirvi commented 2 years ago

XML file for voucher for tally import [ Transaction XML file] Master XML file will share you soon.

Image

sureshsirvi commented 2 years ago

XML for Invoice

`

Import Data
All Masters ECB Demo -1 20221008 27995e18-be44-4f78-bcf7-621db83af6e4-00000001 Regular Regular Sales GST Q2 BILL FOR FY 22-23 India GAYTRI ENTERPRISE-NARAYAN SINGH-0940 GAYTRI ENTERPRISE-NARAYAN SINGH-0940 GAYTRI ENTERPRISE-NARAYAN SINGH-0940 GAYTRI ENTERPRISE-NARAYAN SINGH-0940 1 GAYTRI ENTERPRISE-NARAYAN SINGH-0940 Default Accounting Voucher View GAYTRI ENTERPRISE-NARAYAN SINGH-0940 India As Voucher No No No No No No No No 20221008 No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No Yes No No No No No 1 1 192590628519944 -1 GAYTRI ENTERPRISE-NARAYAN SINGH-0940 Yes No No Yes Yes No No -3000.00 -3000.00 1 New Ref No -3000.00 -1 Gross Receipt No No No No No No No 3000.00 3000.00

`

sureshsirvi commented 2 years ago

XML file shared on Slack to @mitulpanch

mitulpanch commented 2 years ago

Invoice <ENVELOPE><HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER><BODY><IMPORTDATA><REQUESTDESC><REPORTNAME>All Masters</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>ECB Demo</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC><REQUESTDATA><TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER REMOTEID="27995e18-be44-4f78-bcf7-621db83af6e4-00000001" VCHKEY="27995e18-be44-4f78-bcf7-621db83af6e4-0000af29:00000008" VCHTYPE="Sales" ACTION="Create" OBJVIEW="Accounting Voucher View"><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><DATE>20221008</DATE><GUID>27995e18-be44-4f78-bcf7-621db83af6e4-00000001</GUID><GSTREGISTRATIONTYPE>Regular</GSTREGISTRATIONTYPE><VATDEALERTYPE>Regular</VATDEALERTYPE><VOUCHERTYPENAME>Sales</VOUCHERTYPENAME><NARRATION>GST Q2 BILL FOR FY 22-23</NARRATION><COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE><PARTYNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</PARTYNAME><PARTYLEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</PARTYLEDGERNAME><PARTYMAILINGNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</PARTYMAILINGNAME><CONSIGNEEMAILINGNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</CONSIGNEEMAILINGNAME><VOUCHERNUMBER>1</VOUCHERNUMBER><BASICBASEPARTYNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</BASICBASEPARTYNAME><CSTFORMISSUETYPE/><CSTFORMRECVTYPE/><FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE><PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW><BASICBUYERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</BASICBUYERNAME><CONSIGNEECOUNTRYNAME>India</CONSIGNEECOUNTRYNAME><VCHGSTCLASS/><VCHENTRYMODE>As Voucher</VCHENTRYMODE><DIFFACTUALQTY>No</DIFFACTUALQTY><ISMSTFROMSYNC>No</ISMSTFROMSYNC><ISDELETED>No</ISDELETED><ISSECURITYONWHENENTERED>No</ISSECURITYONWHENENTERED><ASORIGINAL>No</ASORIGINAL><AUDITED>No</AUDITED><FORJOBCOSTING>No</FORJOBCOSTING><ISOPTIONAL>No</ISOPTIONAL><EFFECTIVEDATE>20221008</EFFECTIVEDATE><USEFOREXCISE>No</USEFOREXCISE><ISFORJOBWORKIN>No</ISFORJOBWORKIN><ALLOWCONSUMPTION>No</ALLOWCONSUMPTION><USEFORINTEREST>No</USEFORINTEREST><USEFORGAINLOSS>No</USEFORGAINLOSS><USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER><USEFORCOMPOUND>No</USEFORCOMPOUND><USEFORSERVICETAX>No</USEFORSERVICETAX><ISONHOLD>No</ISONHOLD><ISBOENOTAPPLICABLE>No</ISBOENOTAPPLICABLE><ISGSTSECSEVENAPPLICABLE>No</ISGSTSECSEVENAPPLICABLE><ISEXCISEVOUCHER>No</ISEXCISEVOUCHER><EXCISETAXOVERRIDE>No</EXCISETAXOVERRIDE><USEFORTAXUNITTRANSFER>No</USEFORTAXUNITTRANSFER><IGNOREPOSVALIDATION>No</IGNOREPOSVALIDATION><EXCISEOPENING>No</EXCISEOPENING><USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION><ISTDSOVERRIDDEN>No</ISTDSOVERRIDDEN><ISTCSOVERRIDDEN>No</ISTCSOVERRIDDEN><ISTDSTCSCASHVCH>No</ISTDSTCSCASHVCH><INCLUDEADVPYMTVCH>No</INCLUDEADVPYMTVCH><ISSUBWORKSCONTRACT>No</ISSUBWORKSCONTRACT><ISVATOVERRIDDEN>No</ISVATOVERRIDDEN><IGNOREORIGVCHDATE>No</IGNOREORIGVCHDATE><ISVATPAIDATCUSTOMS>No</ISVATPAIDATCUSTOMS><ISDECLAREDTOCUSTOMS>No</ISDECLAREDTOCUSTOMS><ISSERVICETAXOVERRIDDEN>No</ISSERVICETAXOVERRIDDEN><ISISDVOUCHER>No</ISISDVOUCHER><ISEXCISEOVERRIDDEN>No</ISEXCISEOVERRIDDEN><ISEXCISESUPPLYVCH>No</ISEXCISESUPPLYVCH><ISGSTOVERRIDDEN>No</ISGSTOVERRIDDEN><GSTNOTEXPORTED>No</GSTNOTEXPORTED><IGNOREGSTINVALIDATION>No</IGNOREGSTINVALIDATION><ISGSTREFUND>No</ISGSTREFUND><OVRDNEWAYBILLAPPLICABILITY>No</OVRDNEWAYBILLAPPLICABILITY><ISVATPRINCIPALACCOUNT>No</ISVATPRINCIPALACCOUNT><IGNOREEINVVALIDATION>No</IGNOREEINVVALIDATION><IRNJSONEXPORTED>No</IRNJSONEXPORTED><IRNCANCELLED>No</IRNCANCELLED><ISSHIPPINGWITHINSTATE>No</ISSHIPPINGWITHINSTATE><ISOVERSEASTOURISTTRANS>No</ISOVERSEASTOURISTTRANS><ISDESIGNATEDZONEPARTY>No</ISDESIGNATEDZONEPARTY><ISCANCELLED>No</ISCANCELLED><HASCASHFLOW>No</HASCASHFLOW><ISPOSTDATED>No</ISPOSTDATED><USETRACKINGNUMBER>No</USETRACKINGNUMBER><ISINVOICE>No</ISINVOICE><MFGJOURNAL>No</MFGJOURNAL><HASDISCOUNTS>No</HASDISCOUNTS><ASPAYSLIP>No</ASPAYSLIP><ISCOSTCENTRE>No</ISCOSTCENTRE><ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH><ISEXCISEMANUFACTURERON>No</ISEXCISEMANUFACTURERON><ISBLANKCHEQUE>No</ISBLANKCHEQUE><ISVOID>No</ISVOID><ORDERLINESTATUS>No</ORDERLINESTATUS><VATISAGNSTCANCSALES>No</VATISAGNSTCANCSALES><VATISPURCEXEMPTED>No</VATISPURCEXEMPTED><ISVATRESTAXINVOICE>No</ISVATRESTAXINVOICE><VATISASSESABLECALCVCH>No</VATISASSESABLECALCVCH><ISVATDUTYPAID>Yes</ISVATDUTYPAID><ISDELIVERYSAMEASCONSIGNEE>No</ISDELIVERYSAMEASCONSIGNEE><ISDISPATCHSAMEASCONSIGNOR>No</ISDISPATCHSAMEASCONSIGNOR><ISDELETEDVCHRETAINED>No</ISDELETEDVCHRETAINED><CHANGEVCHMODE>No</CHANGEVCHMODE><RESETIRNQRCODE>No</RESETIRNQRCODE><ALTERID> 1</ALTERID><MASTERID> 1</MASTERID><VOUCHERKEY>192590628519944</VOUCHERKEY><EWAYBILLDETAILS.LIST></EWAYBILLDETAILS.LIST><EXCLUDEDTAXATIONS.LIST></EXCLUDEDTAXATIONS.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><SUPPLEMENTARYDUTYHEADDETAILS.LIST></SUPPLEMENTARYDUTYHEADDETAILS.LIST><EWAYBILLERRORLIST.LIST></EWAYBILLERRORLIST.LIST><IRNERRORLIST.LIST></IRNERRORLIST.LIST><INVOICEDELNOTES.LIST></INVOICEDELNOTES.LIST><INVOICEORDERLIST.LIST></INVOICEORDERLIST.LIST><INVOICEINDENTLIST.LIST></INVOICEINDENTLIST.LIST><ATTENDANCEENTRIES.LIST></ATTENDANCEENTRIES.LIST><ORIGINVOICEDETAILS.LIST></ORIGINVOICEDETAILS.LIST><INVOICEEXPORTLIST.LIST></INVOICEEXPORTLIST.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>Yes</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>-3000.00</AMOUNT><VATEXPAMOUNT>-3000.00</VATEXPAMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST><NAME>1</NAME><BILLTYPE>New Ref</BILLTYPE><TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE><AMOUNT>-3000.00</AMOUNT><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><STBILLCATEGORIES.LIST></STBILLCATEGORIES.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>Gross Receipt</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>No</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>3000.00</AMOUNT><VATEXPAMOUNT>3000.00</VATEXPAMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><PAYROLLMODEOFPAYMENT.LIST></PAYROLLMODEOFPAYMENT.LIST><ATTDRECORDS.LIST></ATTDRECORDS.LIST><GSTEWAYCONSIGNORADDRESS.LIST></GSTEWAYCONSIGNORADDRESS.LIST><GSTEWAYCONSIGNEEADDRESS.LIST></GSTEWAYCONSIGNEEADDRESS.LIST><TEMPGSTRATEDETAILS.LIST></TEMPGSTRATEDETAILS.LIST></VOUCHER></TALLYMESSAGE></REQUESTDATA></IMPORTDATA></BODY></ENVELOPE>

mitulpanch commented 2 years ago

JV <ENVELOPE><HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER><BODY><IMPORTDATA><REQUESTDESC><REPORTNAME>All Masters</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>ECB Demo</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC><REQUESTDATA><TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER REMOTEID="27995e18-be44-4f78-bcf7-621db83af6e4-00000005" VCHKEY="27995e18-be44-4f78-bcf7-621db83af6e4-0000af1b:00000008" VCHTYPE="Journal" ACTION="Create" OBJVIEW="Accounting Voucher View"><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><DATE>20220924</DATE><GUID>27995e18-be44-4f78-bcf7-621db83af6e4-00000005</GUID><VOUCHERTYPENAME>Journal</VOUCHERTYPENAME><NARRATION>Discount</NARRATION><PARTYLEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</PARTYLEDGERNAME><VOUCHERNUMBER>1</VOUCHERNUMBER><CSTFORMISSUETYPE/><CSTFORMRECVTYPE/><FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE><PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW><VCHGSTCLASS/><VCHENTRYMODE>As Voucher</VCHENTRYMODE><DIFFACTUALQTY>No</DIFFACTUALQTY><ISMSTFROMSYNC>No</ISMSTFROMSYNC><ISDELETED>No</ISDELETED><ISSECURITYONWHENENTERED>No</ISSECURITYONWHENENTERED><ASORIGINAL>No</ASORIGINAL><AUDITED>No</AUDITED><FORJOBCOSTING>No</FORJOBCOSTING><ISOPTIONAL>No</ISOPTIONAL><EFFECTIVEDATE>20220924</EFFECTIVEDATE><USEFOREXCISE>No</USEFOREXCISE><ISFORJOBWORKIN>No</ISFORJOBWORKIN><ALLOWCONSUMPTION>No</ALLOWCONSUMPTION><USEFORINTEREST>No</USEFORINTEREST><USEFORGAINLOSS>No</USEFORGAINLOSS><USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER><USEFORCOMPOUND>No</USEFORCOMPOUND><USEFORSERVICETAX>No</USEFORSERVICETAX><ISONHOLD>No</ISONHOLD><ISBOENOTAPPLICABLE>No</ISBOENOTAPPLICABLE><ISGSTSECSEVENAPPLICABLE>No</ISGSTSECSEVENAPPLICABLE><ISEXCISEVOUCHER>No</ISEXCISEVOUCHER><EXCISETAXOVERRIDE>No</EXCISETAXOVERRIDE><USEFORTAXUNITTRANSFER>No</USEFORTAXUNITTRANSFER><IGNOREPOSVALIDATION>No</IGNOREPOSVALIDATION><EXCISEOPENING>No</EXCISEOPENING><USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION><ISTDSOVERRIDDEN>No</ISTDSOVERRIDDEN><ISTCSOVERRIDDEN>No</ISTCSOVERRIDDEN><ISTDSTCSCASHVCH>No</ISTDSTCSCASHVCH><INCLUDEADVPYMTVCH>No</INCLUDEADVPYMTVCH><ISSUBWORKSCONTRACT>No</ISSUBWORKSCONTRACT><ISVATOVERRIDDEN>No</ISVATOVERRIDDEN><IGNOREORIGVCHDATE>No</IGNOREORIGVCHDATE><ISVATPAIDATCUSTOMS>No</ISVATPAIDATCUSTOMS><ISDECLAREDTOCUSTOMS>No</ISDECLAREDTOCUSTOMS><ISSERVICETAXOVERRIDDEN>No</ISSERVICETAXOVERRIDDEN><ISISDVOUCHER>No</ISISDVOUCHER><ISEXCISEOVERRIDDEN>No</ISEXCISEOVERRIDDEN><ISEXCISESUPPLYVCH>No</ISEXCISESUPPLYVCH><ISGSTOVERRIDDEN>No</ISGSTOVERRIDDEN><GSTNOTEXPORTED>No</GSTNOTEXPORTED><IGNOREGSTINVALIDATION>No</IGNOREGSTINVALIDATION><ISGSTREFUND>No</ISGSTREFUND><OVRDNEWAYBILLAPPLICABILITY>No</OVRDNEWAYBILLAPPLICABILITY><ISVATPRINCIPALACCOUNT>No</ISVATPRINCIPALACCOUNT><IGNOREEINVVALIDATION>No</IGNOREEINVVALIDATION><IRNJSONEXPORTED>No</IRNJSONEXPORTED><IRNCANCELLED>No</IRNCANCELLED><ISSHIPPINGWITHINSTATE>No</ISSHIPPINGWITHINSTATE><ISOVERSEASTOURISTTRANS>No</ISOVERSEASTOURISTTRANS><ISDESIGNATEDZONEPARTY>No</ISDESIGNATEDZONEPARTY><ISCANCELLED>No</ISCANCELLED><HASCASHFLOW>No</HASCASHFLOW><ISPOSTDATED>No</ISPOSTDATED><USETRACKINGNUMBER>No</USETRACKINGNUMBER><ISINVOICE>No</ISINVOICE><MFGJOURNAL>No</MFGJOURNAL><HASDISCOUNTS>No</HASDISCOUNTS><ASPAYSLIP>No</ASPAYSLIP><ISCOSTCENTRE>No</ISCOSTCENTRE><ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH><ISEXCISEMANUFACTURERON>No</ISEXCISEMANUFACTURERON><ISBLANKCHEQUE>No</ISBLANKCHEQUE><ISVOID>No</ISVOID><ORDERLINESTATUS>No</ORDERLINESTATUS><VATISAGNSTCANCSALES>No</VATISAGNSTCANCSALES><VATISPURCEXEMPTED>No</VATISPURCEXEMPTED><ISVATRESTAXINVOICE>No</ISVATRESTAXINVOICE><VATISASSESABLECALCVCH>No</VATISASSESABLECALCVCH><ISVATDUTYPAID>Yes</ISVATDUTYPAID><ISDELIVERYSAMEASCONSIGNEE>No</ISDELIVERYSAMEASCONSIGNEE><ISDISPATCHSAMEASCONSIGNOR>No</ISDISPATCHSAMEASCONSIGNOR><ISDELETEDVCHRETAINED>No</ISDELETEDVCHRETAINED><CHANGEVCHMODE>No</CHANGEVCHMODE><RESETIRNQRCODE>No</RESETIRNQRCODE><ALTERID> 7</ALTERID><MASTERID> 5</MASTERID><VOUCHERKEY>192530498977800</VOUCHERKEY><EWAYBILLDETAILS.LIST></EWAYBILLDETAILS.LIST><EXCLUDEDTAXATIONS.LIST></EXCLUDEDTAXATIONS.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><SUPPLEMENTARYDUTYHEADDETAILS.LIST></SUPPLEMENTARYDUTYHEADDETAILS.LIST><EWAYBILLERRORLIST.LIST></EWAYBILLERRORLIST.LIST><IRNERRORLIST.LIST></IRNERRORLIST.LIST><INVOICEDELNOTES.LIST></INVOICEDELNOTES.LIST><INVOICEORDERLIST.LIST></INVOICEORDERLIST.LIST><INVOICEINDENTLIST.LIST></INVOICEINDENTLIST.LIST><ATTENDANCEENTRIES.LIST></ATTENDANCEENTRIES.LIST><ORIGINVOICEDETAILS.LIST></ORIGINVOICEDETAILS.LIST><INVOICEEXPORTLIST.LIST></INVOICEEXPORTLIST.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>Discount</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>No</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>-500.00</AMOUNT><VATEXPAMOUNT>-500.00</VATEXPAMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>Yes</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>500.00</AMOUNT><VATEXPAMOUNT>500.00</VATEXPAMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><PAYROLLMODEOFPAYMENT.LIST></PAYROLLMODEOFPAYMENT.LIST><ATTDRECORDS.LIST></ATTDRECORDS.LIST><GSTEWAYCONSIGNORADDRESS.LIST></GSTEWAYCONSIGNORADDRESS.LIST><GSTEWAYCONSIGNEEADDRESS.LIST></GSTEWAYCONSIGNEEADDRESS.LIST><TEMPGSTRATEDETAILS.LIST></TEMPGSTRATEDETAILS.LIST></VOUCHER></TALLYMESSAGE></REQUESTDATA></IMPORTDATA></BODY></ENVELOPE>

mitulpanch commented 2 years ago

Payment <ENVELOPE><HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER><BODY><IMPORTDATA><REQUESTDESC><REPORTNAME>All Masters</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>ECB Demo</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC><REQUESTDATA><TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER REMOTEID="27995e18-be44-4f78-bcf7-621db83af6e4-00000004" VCHKEY="27995e18-be44-4f78-bcf7-621db83af6e4-0000ae80:00000008" VCHTYPE="Payment" ACTION="Create" OBJVIEW="Accounting Voucher View"><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><DATE>20220422</DATE><GUID>27995e18-be44-4f78-bcf7-621db83af6e4-00000004</GUID><VOUCHERTYPENAME>Payment</VOUCHERTYPENAME><NARRATION>GST Late Fees</NARRATION><PARTYLEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</PARTYLEDGERNAME><VOUCHERNUMBER>1</VOUCHERNUMBER><CSTFORMISSUETYPE/><CSTFORMRECVTYPE/><FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE><PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW><VCHGSTCLASS/><DIFFACTUALQTY>No</DIFFACTUALQTY><ISMSTFROMSYNC>No</ISMSTFROMSYNC><ISDELETED>No</ISDELETED><ISSECURITYONWHENENTERED>No</ISSECURITYONWHENENTERED><ASORIGINAL>No</ASORIGINAL><AUDITED>No</AUDITED><FORJOBCOSTING>No</FORJOBCOSTING><ISOPTIONAL>No</ISOPTIONAL><EFFECTIVEDATE>20220422</EFFECTIVEDATE><USEFOREXCISE>No</USEFOREXCISE><ISFORJOBWORKIN>No</ISFORJOBWORKIN><ALLOWCONSUMPTION>No</ALLOWCONSUMPTION><USEFORINTEREST>No</USEFORINTEREST><USEFORGAINLOSS>No</USEFORGAINLOSS><USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER><USEFORCOMPOUND>No</USEFORCOMPOUND><USEFORSERVICETAX>No</USEFORSERVICETAX><ISONHOLD>No</ISONHOLD><ISBOENOTAPPLICABLE>No</ISBOENOTAPPLICABLE><ISGSTSECSEVENAPPLICABLE>No</ISGSTSECSEVENAPPLICABLE><ISEXCISEVOUCHER>No</ISEXCISEVOUCHER><EXCISETAXOVERRIDE>No</EXCISETAXOVERRIDE><USEFORTAXUNITTRANSFER>No</USEFORTAXUNITTRANSFER><IGNOREPOSVALIDATION>No</IGNOREPOSVALIDATION><EXCISEOPENING>No</EXCISEOPENING><USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION><ISTDSOVERRIDDEN>No</ISTDSOVERRIDDEN><ISTCSOVERRIDDEN>No</ISTCSOVERRIDDEN><ISTDSTCSCASHVCH>No</ISTDSTCSCASHVCH><INCLUDEADVPYMTVCH>No</INCLUDEADVPYMTVCH><ISSUBWORKSCONTRACT>No</ISSUBWORKSCONTRACT><ISVATOVERRIDDEN>No</ISVATOVERRIDDEN><IGNOREORIGVCHDATE>No</IGNOREORIGVCHDATE><ISVATPAIDATCUSTOMS>No</ISVATPAIDATCUSTOMS><ISDECLAREDTOCUSTOMS>No</ISDECLAREDTOCUSTOMS><ISSERVICETAXOVERRIDDEN>No</ISSERVICETAXOVERRIDDEN><ISISDVOUCHER>No</ISISDVOUCHER><ISEXCISEOVERRIDDEN>No</ISEXCISEOVERRIDDEN><ISEXCISESUPPLYVCH>No</ISEXCISESUPPLYVCH><ISGSTOVERRIDDEN>No</ISGSTOVERRIDDEN><GSTNOTEXPORTED>No</GSTNOTEXPORTED><IGNOREGSTINVALIDATION>No</IGNOREGSTINVALIDATION><ISGSTREFUND>No</ISGSTREFUND><OVRDNEWAYBILLAPPLICABILITY>No</OVRDNEWAYBILLAPPLICABILITY><ISVATPRINCIPALACCOUNT>No</ISVATPRINCIPALACCOUNT><IGNOREEINVVALIDATION>No</IGNOREEINVVALIDATION><IRNJSONEXPORTED>No</IRNJSONEXPORTED><IRNCANCELLED>No</IRNCANCELLED><ISSHIPPINGWITHINSTATE>No</ISSHIPPINGWITHINSTATE><ISOVERSEASTOURISTTRANS>No</ISOVERSEASTOURISTTRANS><ISDESIGNATEDZONEPARTY>No</ISDESIGNATEDZONEPARTY><ISCANCELLED>No</ISCANCELLED><HASCASHFLOW>Yes</HASCASHFLOW><ISPOSTDATED>No</ISPOSTDATED><USETRACKINGNUMBER>No</USETRACKINGNUMBER><ISINVOICE>No</ISINVOICE><MFGJOURNAL>No</MFGJOURNAL><HASDISCOUNTS>No</HASDISCOUNTS><ASPAYSLIP>No</ASPAYSLIP><ISCOSTCENTRE>No</ISCOSTCENTRE><ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH><ISEXCISEMANUFACTURERON>No</ISEXCISEMANUFACTURERON><ISBLANKCHEQUE>No</ISBLANKCHEQUE><ISVOID>No</ISVOID><ORDERLINESTATUS>No</ORDERLINESTATUS><VATISAGNSTCANCSALES>No</VATISAGNSTCANCSALES><VATISPURCEXEMPTED>No</VATISPURCEXEMPTED><ISVATRESTAXINVOICE>No</ISVATRESTAXINVOICE><VATISASSESABLECALCVCH>No</VATISASSESABLECALCVCH><ISVATDUTYPAID>Yes</ISVATDUTYPAID><ISDELIVERYSAMEASCONSIGNEE>No</ISDELIVERYSAMEASCONSIGNEE><ISDISPATCHSAMEASCONSIGNOR>No</ISDISPATCHSAMEASCONSIGNOR><ISDELETEDVCHRETAINED>No</ISDELETEDVCHRETAINED><CHANGEVCHMODE>No</CHANGEVCHMODE><RESETIRNQRCODE>No</RESETIRNQRCODE><ALTERID> 6</ALTERID><MASTERID> 4</MASTERID><VOUCHERKEY>191864779046920</VOUCHERKEY><EWAYBILLDETAILS.LIST></EWAYBILLDETAILS.LIST><EXCLUDEDTAXATIONS.LIST></EXCLUDEDTAXATIONS.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><SUPPLEMENTARYDUTYHEADDETAILS.LIST></SUPPLEMENTARYDUTYHEADDETAILS.LIST><EWAYBILLERRORLIST.LIST></EWAYBILLERRORLIST.LIST><IRNERRORLIST.LIST></IRNERRORLIST.LIST><INVOICEDELNOTES.LIST></INVOICEDELNOTES.LIST><INVOICEORDERLIST.LIST></INVOICEORDERLIST.LIST><INVOICEINDENTLIST.LIST></INVOICEINDENTLIST.LIST><ATTENDANCEENTRIES.LIST></ATTENDANCEENTRIES.LIST><ORIGINVOICEDETAILS.LIST></ORIGINVOICEDETAILS.LIST><INVOICEEXPORTLIST.LIST></INVOICEEXPORTLIST.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>Yes</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>-250.00</AMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>Cash</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>Yes</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>250.00</AMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><PAYROLLMODEOFPAYMENT.LIST></PAYROLLMODEOFPAYMENT.LIST><ATTDRECORDS.LIST></ATTDRECORDS.LIST><GSTEWAYCONSIGNORADDRESS.LIST></GSTEWAYCONSIGNORADDRESS.LIST><GSTEWAYCONSIGNEEADDRESS.LIST></GSTEWAYCONSIGNEEADDRESS.LIST><TEMPGSTRATEDETAILS.LIST></TEMPGSTRATEDETAILS.LIST></VOUCHER></TALLYMESSAGE></REQUESTDATA></IMPORTDATA></BODY></ENVELOPE>

mitulpanch commented 2 years ago

Receipt <ENVELOPE><HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER><BODY><IMPORTDATA><REQUESTDESC><REPORTNAME>All Masters</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>ECB Demo</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC><REQUESTDATA><TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER REMOTEID="27995e18-be44-4f78-bcf7-621db83af6e4-00000003" VCHKEY="27995e18-be44-4f78-bcf7-621db83af6e4-0000ae6b:00000008" VCHTYPE="Receipt" ACTION="Create" OBJVIEW="Accounting Voucher View"><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><DATE>20220401</DATE><GUID>27995e18-be44-4f78-bcf7-621db83af6e4-00000003</GUID><VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME><NARRATION>Fees Received for Q4</NARRATION><PARTYLEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</PARTYLEDGERNAME><VOUCHERNUMBER>1</VOUCHERNUMBER><CSTFORMISSUETYPE/><CSTFORMRECVTYPE/><FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE><PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW><VCHGSTCLASS/><DIFFACTUALQTY>No</DIFFACTUALQTY><ISMSTFROMSYNC>No</ISMSTFROMSYNC><ISDELETED>No</ISDELETED><ISSECURITYONWHENENTERED>No</ISSECURITYONWHENENTERED><ASORIGINAL>No</ASORIGINAL><AUDITED>No</AUDITED><FORJOBCOSTING>No</FORJOBCOSTING><ISOPTIONAL>No</ISOPTIONAL><EFFECTIVEDATE>20220401</EFFECTIVEDATE><USEFOREXCISE>No</USEFOREXCISE><ISFORJOBWORKIN>No</ISFORJOBWORKIN><ALLOWCONSUMPTION>No</ALLOWCONSUMPTION><USEFORINTEREST>No</USEFORINTEREST><USEFORGAINLOSS>No</USEFORGAINLOSS><USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER><USEFORCOMPOUND>No</USEFORCOMPOUND><USEFORSERVICETAX>No</USEFORSERVICETAX><ISONHOLD>No</ISONHOLD><ISBOENOTAPPLICABLE>No</ISBOENOTAPPLICABLE><ISGSTSECSEVENAPPLICABLE>No</ISGSTSECSEVENAPPLICABLE><ISEXCISEVOUCHER>No</ISEXCISEVOUCHER><EXCISETAXOVERRIDE>No</EXCISETAXOVERRIDE><USEFORTAXUNITTRANSFER>No</USEFORTAXUNITTRANSFER><IGNOREPOSVALIDATION>No</IGNOREPOSVALIDATION><EXCISEOPENING>No</EXCISEOPENING><USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION><ISTDSOVERRIDDEN>No</ISTDSOVERRIDDEN><ISTCSOVERRIDDEN>No</ISTCSOVERRIDDEN><ISTDSTCSCASHVCH>No</ISTDSTCSCASHVCH><INCLUDEADVPYMTVCH>No</INCLUDEADVPYMTVCH><ISSUBWORKSCONTRACT>No</ISSUBWORKSCONTRACT><ISVATOVERRIDDEN>No</ISVATOVERRIDDEN><IGNOREORIGVCHDATE>No</IGNOREORIGVCHDATE><ISVATPAIDATCUSTOMS>No</ISVATPAIDATCUSTOMS><ISDECLAREDTOCUSTOMS>No</ISDECLAREDTOCUSTOMS><ISSERVICETAXOVERRIDDEN>No</ISSERVICETAXOVERRIDDEN><ISISDVOUCHER>No</ISISDVOUCHER><ISEXCISEOVERRIDDEN>No</ISEXCISEOVERRIDDEN><ISEXCISESUPPLYVCH>No</ISEXCISESUPPLYVCH><ISGSTOVERRIDDEN>No</ISGSTOVERRIDDEN><GSTNOTEXPORTED>No</GSTNOTEXPORTED><IGNOREGSTINVALIDATION>No</IGNOREGSTINVALIDATION><ISGSTREFUND>No</ISGSTREFUND><OVRDNEWAYBILLAPPLICABILITY>No</OVRDNEWAYBILLAPPLICABILITY><ISVATPRINCIPALACCOUNT>No</ISVATPRINCIPALACCOUNT><IGNOREEINVVALIDATION>No</IGNOREEINVVALIDATION><IRNJSONEXPORTED>No</IRNJSONEXPORTED><IRNCANCELLED>No</IRNCANCELLED><ISSHIPPINGWITHINSTATE>No</ISSHIPPINGWITHINSTATE><ISOVERSEASTOURISTTRANS>No</ISOVERSEASTOURISTTRANS><ISDESIGNATEDZONEPARTY>No</ISDESIGNATEDZONEPARTY><ISCANCELLED>No</ISCANCELLED><HASCASHFLOW>Yes</HASCASHFLOW><ISPOSTDATED>No</ISPOSTDATED><USETRACKINGNUMBER>No</USETRACKINGNUMBER><ISINVOICE>No</ISINVOICE><MFGJOURNAL>No</MFGJOURNAL><HASDISCOUNTS>No</HASDISCOUNTS><ASPAYSLIP>No</ASPAYSLIP><ISCOSTCENTRE>No</ISCOSTCENTRE><ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH><ISEXCISEMANUFACTURERON>No</ISEXCISEMANUFACTURERON><ISBLANKCHEQUE>No</ISBLANKCHEQUE><ISVOID>No</ISVOID><ORDERLINESTATUS>No</ORDERLINESTATUS><VATISAGNSTCANCSALES>No</VATISAGNSTCANCSALES><VATISPURCEXEMPTED>No</VATISPURCEXEMPTED><ISVATRESTAXINVOICE>No</ISVATRESTAXINVOICE><VATISASSESABLECALCVCH>No</VATISASSESABLECALCVCH><ISVATDUTYPAID>Yes</ISVATDUTYPAID><ISDELIVERYSAMEASCONSIGNEE>No</ISDELIVERYSAMEASCONSIGNEE><ISDISPATCHSAMEASCONSIGNOR>No</ISDISPATCHSAMEASCONSIGNOR><ISDELETEDVCHRETAINED>No</ISDELETEDVCHRETAINED><CHANGEVCHMODE>No</CHANGEVCHMODE><RESETIRNQRCODE>No</RESETIRNQRCODE><ALTERID> 5</ALTERID><MASTERID> 3</MASTERID><VOUCHERKEY>191774584733704</VOUCHERKEY><EWAYBILLDETAILS.LIST></EWAYBILLDETAILS.LIST><EXCLUDEDTAXATIONS.LIST></EXCLUDEDTAXATIONS.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><SUPPLEMENTARYDUTYHEADDETAILS.LIST></SUPPLEMENTARYDUTYHEADDETAILS.LIST><EWAYBILLERRORLIST.LIST></EWAYBILLERRORLIST.LIST><IRNERRORLIST.LIST></IRNERRORLIST.LIST><INVOICEDELNOTES.LIST></INVOICEDELNOTES.LIST><INVOICEORDERLIST.LIST></INVOICEORDERLIST.LIST><INVOICEINDENTLIST.LIST></INVOICEINDENTLIST.LIST><ATTENDANCEENTRIES.LIST></ATTENDANCEENTRIES.LIST><ORIGINVOICEDETAILS.LIST></ORIGINVOICEDETAILS.LIST><INVOICEEXPORTLIST.LIST></INVOICEEXPORTLIST.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>GAYTRI ENTERPRISE-NARAYAN SINGH-0940</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>Yes</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>10000.00</AMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><ALLLEDGERENTRIES.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><LEDGERNAME>Cash</LEDGERNAME><GSTCLASS/><ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE><LEDGERFROMITEM>No</LEDGERFROMITEM><REMOVEZEROENTRIES>No</REMOVEZEROENTRIES><ISPARTYLEDGER>Yes</ISPARTYLEDGER><ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE><ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED><ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED><AMOUNT>-10000.00</AMOUNT><SERVICETAXDETAILS.LIST></SERVICETAXDETAILS.LIST><BANKALLOCATIONS.LIST></BANKALLOCATIONS.LIST><BILLALLOCATIONS.LIST></BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST></INTERESTCOLLECTION.LIST><OLDAUDITENTRIES.LIST></OLDAUDITENTRIES.LIST><ACCOUNTAUDITENTRIES.LIST></ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST></AUDITENTRIES.LIST><INPUTCRALLOCS.LIST></INPUTCRALLOCS.LIST><DUTYHEADDETAILS.LIST></DUTYHEADDETAILS.LIST><EXCISEDUTYHEADDETAILS.LIST></EXCISEDUTYHEADDETAILS.LIST><RATEDETAILS.LIST></RATEDETAILS.LIST><SUMMARYALLOCS.LIST></SUMMARYALLOCS.LIST><STPYMTDETAILS.LIST></STPYMTDETAILS.LIST><EXCISEPAYMENTALLOCATIONS.LIST></EXCISEPAYMENTALLOCATIONS.LIST><TAXBILLALLOCATIONS.LIST></TAXBILLALLOCATIONS.LIST><TAXOBJECTALLOCATIONS.LIST></TAXOBJECTALLOCATIONS.LIST><TDSEXPENSEALLOCATIONS.LIST></TDSEXPENSEALLOCATIONS.LIST><VATSTATUTORYDETAILS.LIST></VATSTATUTORYDETAILS.LIST><COSTTRACKALLOCATIONS.LIST></COSTTRACKALLOCATIONS.LIST><REFVOUCHERDETAILS.LIST></REFVOUCHERDETAILS.LIST><INVOICEWISEDETAILS.LIST></INVOICEWISEDETAILS.LIST><VATITCDETAILS.LIST></VATITCDETAILS.LIST><ADVANCETAXDETAILS.LIST></ADVANCETAXDETAILS.LIST></ALLLEDGERENTRIES.LIST><PAYROLLMODEOFPAYMENT.LIST></PAYROLLMODEOFPAYMENT.LIST><ATTDRECORDS.LIST></ATTDRECORDS.LIST><GSTEWAYCONSIGNORADDRESS.LIST></GSTEWAYCONSIGNORADDRESS.LIST><GSTEWAYCONSIGNEEADDRESS.LIST></GSTEWAYCONSIGNEEADDRESS.LIST><TEMPGSTRATEDETAILS.LIST></TEMPGSTRATEDETAILS.LIST></VOUCHER></TALLYMESSAGE></REQUESTDATA></IMPORTDATA></BODY></ENVELOPE>

sureshsirvi commented 2 years ago

Ledger Creation XML Tag `

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE
                xmlns:UDF="TallyUDF">
                <LEDGER Action="Create">
                    <NAME>Test321 Debtors</NAME>
                    <PARENT>Sundry Debtors</PARENT>
                    <ADDRESS>Address</ADDRESS>
                    <COUNTRYOFRESIDENCE>Country</COUNTRYOFRESIDENCE>
                    <LEDSTATENAME>State</LEDSTATENAME>
                    <LEDGERMOBILE>Mobile</LEDGERMOBILE>
                    <PARTYGSTIN>GSTIN</PARTYGSTIN>
                </LEDGER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 2 years ago

Create "Receipt" Voucher

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER ACTION="Create" VCHTYPE=" Receipt ">
                    <VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER></VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Cash Received</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>300</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Cash</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-300</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 2 years ago

Create "Payment" Voucher

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER ACTION="Create" VCHTYPE=" Payment ">
                    <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER></VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Cash Paid</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-600</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Cash</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>600</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 2 years ago

Journal Entry for Discount - When Amount Received less then Invoice Amount i.e. Expenses

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER ACTION="Create" VCHTYPE=" Journal ">
                    <VOUCHERTYPENAME>Journal</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER></VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Discount</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Discount</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-300</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>300</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 2 years ago

Journal Entry for Discount on Excess amount received - When Amount Received greater then Invoice Amount i.e. Income

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER ACTION="Create" VCHTYPE=" Journal ">
                    <VOUCHERTYPENAME>Journal</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER></VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Excess Received</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
                        <AMOUNT>-400</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Discount</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
                        <AMOUNT>400</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 2 years ago

Invoice XML Tags

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER ACTION="Create" VCHTYPE=" Sales ">
                    <VOUCHERTYPENAME>Sales</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER>B1234</VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Notes</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-600</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Gross Receipt</LEDGERNAME>
                        <REMOVEZEROENTRIES>NO</REMOVEZEROENTRIES>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>600</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 2 years ago

Voucher Altration

Image

mitulpanch commented 2 years ago

TAGNAME TAGVALUE se unique hota he i guess

sureshsirvi commented 2 years ago

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
Payment 20220401 s_aS-1201251 2 Test321 Cash Paid 20220401 Test321 YES -600 Cash NO 600 `
sureshsirvi commented 2 years ago

<VOUCHER DATE="01-Apr-2022" Action="Alter" TAGNAME="REFERENCE" TAGVALUE="s_aS-1201251" VCHTYPE = "Payment"> this is for alter

with <REFERENCE>s_aS-1201251</REFERENCE>

mitulpanch commented 2 years ago

At first above thing look fine, but date combination is little problem as discussed over phone with @sureshsirvi so We are planning to take this as GUID option on import

Guid works correctly as intended to alter, just 1 more confirmation required for GUID format Tally supports

sureshsirvi commented 2 years ago

Remote id is Uniq ID and it has no fixed length.. we can use it to Alter Voucher

<VOUCHER REMOTEID="P-123456789" ACTION="Create" VCHTYPE=" Payment ">

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER REMOTEID="P-123456789" ACTION="Create" VCHTYPE=" Payment ">
                    <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER></VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Cash Paid</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-1800</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Cash</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>1800</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

mitulpanch commented 2 years ago

API Ready

mitulpanch commented 2 years ago

Available on Admin companies for Testing still waiting for any changes

sureshsirvi commented 2 years ago

Testing Error

Error from Tally during Ledger Import

****Importing Data from 'F:\ecb Testing\LedgerImport-1.xml' on 29-Oct-22 at 21:51:28

Importing Data to company: 'Testing'

ERROR: Ledger: REMOTEID:-63lqqd9jUqG8fBkLOOHAw Group 'Sundry Deptors' does not exist!

Import Summary Created : 0 Altered : 0 Deleted : 0 Combined: 0 Ignored : 0 Errors : 1 ----------------------------------------------****

Error Reason is spelling mistake "Group 'Sundry Deptors' does not exist!" we need to correct spelling of "Sundry Debtors"...

sureshsirvi commented 2 years ago

Error in Transaction File:

Importing Data from 'F:\ecb Testing\transactions-2.xml' on 29-Oct-22 at 21:58:16

Importing Data to company: 'Testing'

ERROR: Voucher: ID:, Voucher Type: Sales, Source Voucher Number: , Voucher Number: 1, Date: 2-Apr-22 Ledger 'Default Bank' does not exist!

Import Summary Created : 0 Altered : 0 Deleted : 0 Combined: 0 Ignored : 0 Errors : 1

We need to create default ledger using Ledger XML file.. see here for default ledgers

https://github.com/Fammeo/EasyCloudBooks/issues/1003#issuecomment-1283371230

sureshsirvi commented 1 year ago

Error Correction Required: Corrected tags..

Receipt

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER REMOTEID="vh76tqFsBUeragmSuHQqNA" ACTION="Create" VCHTYPE="Receipt">
                    <VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
                    <DATE>20220421</DATE>
                    <EFFECTIVEDATE>20220421</EFFECTIVEDATE>
                    <PARTYLEDGERNAME>MAMTA ELECTRIC AND HARDWARE- MOHAN LAL</PARTYLEDGERNAME>
                    <NARRATION>GST Tax March 2022</NARRATION>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>MAMTA ELECTRIC AND HARDWARE- MOHAN LAL</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>100.00</AMOUNT>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>PNB 0032</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-100.00</AMOUNT>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 1 year ago

Error Correction Required: Corrected tags..

Payment

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
                <VOUCHER REMOTEID="D2aKeXDtTEymuUbRoIPkFw" ACTION="Create" VCHTYPE="Payment">
                    <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
                    <DATE>20220420</DATE>
                    <EFFECTIVEDATE>20220420</EFFECTIVEDATE>
                    <PARTYLEDGERNAME>KANAIYA TRADERS - BHARTKUMAR</PARTYLEDGERNAME>
                    <NARRATION>GST RCM Mar 2022</NARRATION>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>KANAIYA TRADERS - BHARTKUMAR</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-154.00</AMOUNT>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>PNB 0032</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>154.00</AMOUNT>
                        <LEDGERFROMITEM>NO</LEDGERFROMITEM>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

mitulpanch commented 1 year ago

Konse tag me error he sir?

sureshsirvi commented 1 year ago

We need following Default Ledgers

  1. "Gross Receipt" Group "Indirect Incomes" - for Invoice Voucher
  2. "Output CGST" Group "Duties & Taxes" - for Invoice Voucher
  3. "Output SGST" Group "Duties & Taxes" - for Invoice Voucher
  4. "Output IGST" Group "Duties & Taxes" - for Invoice Voucher
  5. "Cash and Bank" Group "Cash-in-Hand" - for Receipt & Payment Voucher for Blank Payment Mode.
  6. "Discount" Group "Indirect Expenses" - for Discount Voucher
sureshsirvi commented 1 year ago

Sales Invoice TAG with CGST and SGST and IGST Ledger

`

Import Data 
<BODY>
    <IMPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>All Masters</REPORTNAME>
        </REQUESTDESC>
        <REQUESTDATA>
            <TALLYMESSAGE xmlns:UDF="TallyUDF">
        <VOUCHER REMOTEID="D2aKeXDtTEymuUbRoIPkFw" ACTION="Create" VCHTYPE="Sales">
                    <VOUCHERTYPENAME>Sales</VOUCHERTYPENAME>
                    <DATE>20220401</DATE>
                    <VOUCHERNUMBER>B1234</VOUCHERNUMBER>
                    <PARTYLEDGERNAME>Test321</PARTYLEDGERNAME>
                    <NARRATION>Notes</NARRATION>
                    <EFFECTIVEDATE>20220401</EFFECTIVEDATE>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Test321</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>YES</ISDEEMEDPOSITIVE>
                        <AMOUNT>-600</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Gross Receipt</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>400</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Output CGST</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>100</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                    <ALLLEDGERENTRIES.LIST>
                        <LEDGERNAME>Output SGST</LEDGERNAME>
                        <ISDEEMEDPOSITIVE>NO</ISDEEMEDPOSITIVE>
                        <AMOUNT>100</AMOUNT>
                    </ALLLEDGERENTRIES.LIST>
                </VOUCHER>
            </TALLYMESSAGE>
        </REQUESTDATA>
    </IMPORTDATA>
</BODY>

`

sureshsirvi commented 1 year ago

Payment - Bank Leadger - Positive Value anan chahiye Sales - Tax mcomponent chahiye - Positive ayega Bank ke jagaj - Gross Receipt Gross Receipt Leadger - Positive Value anan chahiye Receipt Bank - Negetive value ayega Default Bank - ke jagah - Cash and Bank chahiye

mitulpanch commented 1 year ago

All live, available for testing @sureshsirvi

mitulpanch commented 1 year ago

REFERENCE Tag added on request from @sureshsirvi RefNo on transaction will be added to tag value

Avinash-ecb commented 1 year ago

After discuss with @mitulpanch sir over this is remaining to confirm from @sureshsirvi sir side

sureshsirvi commented 1 year ago

Menu name need to Change "Tally XML Export" and Tally icon to be placed..