Document Import XML format

Version: 2.0.4

Date: 2023-04-12

XML format documentation

1. Invoice

The follow sections describe the format of the Sales Invoice XML file.

XML	Mandatory	Description
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>	Y	XML Declaration.
<ociac10>	Y	Root Tag. Only 1 per file.
<ocaciv>	Y	Invoice Tag. Allow more than 1 per file. Each tag will represent 1 invoice
<ocacivhead>	Y	Header Tag. Only 1 per Invoice Tag. If there is more than 1, only the first tag will be used.
<sivnum>TEXT(20)</sivnum>	Y	Invoice Number.
<dtivdate>DATE(YYYY-MM-DD)</dtivdate>	N	Invoice Date. If missing Tag/Value, system will use current PC date
<dtivduedate>DATE(YYYY-MM-DD)</dtivduedate>	N	Invoice Due Date. If missing Tag/Value, system will use Invoice Date
<sbpcode>TEXT(20)</sbpcode>	Y	Business Partner Code. *Code must be in system.
<sbplocationcode>TEXT(10)</sbplocationcode>	N	Business Partner Location Code. If missing Tag/Value, system will use Business Partner default Location Code. *Code must be in system.
<sbplocationcode2>TEXT(10)</sbplocationcode2>	N	Business Partner 2nd Location Code. *Code must be in system.
<sbplocationcode3>TEXT(10)</sbplocationcode3>	N	Business Partner 3rd Location Code. *Code must be in system.
<sbplocationcode4>TEXT(10)</sbplocationcode4>	N	Business Partner 4th Location Code. *Code must be in system.
<sivref>TEXT(50)</sivref>	N	Invoice Reference.
<sivsubject>TEXT(100)</sivsubject>	N	Invoice Subject.
<semployeecode>TEXT(20)</semployeecode>	N	Employee Code. *Code must be in system.
<sivremark>TEXT(4000)</sivremark>	N	Invoice Remark.
<sivcomment>TEXT(4000)</sivcomment>	N	Internal Comment.
<scurrencycode>TEXT(3)</scurrencycode>	Y	Currency Code. *Code must be in system.
<nivexchange>DECIMAL(18,6)</nivexchange>	N	Exchange Rate. If missing Tag/Value, system will use default exchange rate of the Currency Code
<sivpayterm>TEXT(4)</sivpayterm>	N	Payment Terms Code. If missing Tag/Value, system will use Business Partner default Payment Terms Code. *Code must be in system.
<sivterms>TEXT(50)</sivterms>	N	Payment Terms Text. If missing Tag/Value, system will use Payment Terms default text.
<isivinclusive>TRUE/FALSE</isivinclusive>	N	Is invoice transaction price inclusive of GST? Not required for non-gst company. If missing Tag/Value, system will set the value to false.
<isivcashsale>TRUE/FALSE</isivcashsale>	N	Is invoice transaction a cash sales? If missing Tag/Value, system will set the value to false.
<nivcashamount>DECIMAL(18,6)</nivcashamount>	*N	Cash Sales Amount. *If < isivcashsale> is TRUE, this value is required.
<sivcashmode>TEXT(10)</sivcashmode>	*N	Cash Mode. If < isivcashsale> is TRUE, this value is required. Code must be in system.
<sdocutitle>TEXT(50)</sdocutitle>	N	Invoice Title. If missing Tag/Value, system will use the default invoice title
<sdocuref1>TEXT(50)</</sdocuref1>	N	Additional Reference Field
<sdocuref2>TEXT(50)</</sdocuref2>	N	Additional Reference Field
<sdocuref3>TEXT(50)</</sdocuref3>	N	Additional Reference Field
<sdocuref4>TEXT(50)</</sdocuref4>	N	Additional Reference Field
<sdocuref5>TEXT(50)</</sdocuref5>	N	Additional Reference Field
<dtpostdate>DATE(YYYY-MM-DD)</dtpostdate>	N	Account Post Date. If missing Tag/Value, system will use Invoice Date
</ocacivhead>	Y	Closing of Header Tag
<ocacivdtl>	Y	Detail Tag. Allow more than 1 per Invoice tag.
<sivdtlsn>TEXT(5)</sivdtlsn>	N	Detail Serial Number.
<sitemcode>TEXT(50)</sitemcode>	Y	Item Code. *Code must be in system.
<sivdtldescription>TEXT(1000)</sivdtldescription>	N	Item Description. If missing Tag/Value, system will use Item default description
<nivdtlqty>DECIMAL(18,6)</nivdtlqty>	Y	Item Quantity. Cannot be 0
<nivdtlprice>DECIMAL(18,6)</nivdtlprice>	Y	Item Unit Price. Cannot be 0
<sivdtluom>TEXT(20)</sivdtluom>	N	Item UOM. If missing Tag/Value, system will use Item default UOM
<nivdtldiscpct>DECIMAL(5,2)</nivdtldiscpct>	N	Discount Percentage
<nivdtldiscamt>DECIMAL(18,6)</nivdtldiscamt>	N	Discount Amount
<staxcode>TEXT(10)</staxcode>	N	Tax Code. Not required for non-gst company. If missing Tag/Value, system will set Business Partner default Tax Code. *Code must be in system.
<nivdtltamt>DECIMAL(18,6)</nivdtltamt>	N	Detail Transaction Amount. If missing Tag/Value, system will calculate the value automatically.
<nivdtltgst>DECIMAL(18,6)</nivdtltgst>	N	Detail Gst Transaction Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nivdtlttotal>DECIMAL(18,6)</nivdtlttotal>	N	Detail Transaction Amount After Gst. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nivdtlaamt>DECIMAL(18,6)</nivdtlaamt>	N	Detail Account Amount. If missing Tag/Value, system will calculate the value automatically.
<nivdtlagst>DECIMAL(18,6)</nivdtlagst>	N	Detail Gst Account Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nivdtllamt>DECIMAL(18,6)</nivdtllamt>	N	Detail Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nivdtllgst>DECIMAL(18,6)</nivdtllgst>	N	Detail Gst Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<swarehousecode>TEXT(10)</swarehousecode>	N	Warehouse Code.*Code must be in system.
<sstocklocation>TEXT(10)</sstocklocation>	*N	Warehouse Location Code. Can only be use if there is Warehouse Code. *Code must be in system.
<sstocklot>TEXT(10)</sstocklot>	N	Stock Lot Number.
<sjobcode>TEXT(20)</sjobcode>	N	Job Code.*Code must be in system.
<sivdtlremark>TEXT(4000)</sivdtlremark>	N	Detail Remark
</ocacivdtl>	Y	Closing of Detail Tag
</ocaciv>	Y	Closing of Invoice Tag
</ociac10>	Y	Closing of Root Tag

2. Supplier Invoice

The follow sections describe the format of the Supplier Invoice XML file.

XML	Mandatory	Description
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>	Y	XML Declaration.
<ociac10>	Y	Root Tag. Only 1 per file.
<ocacsi>	Y	Invoice Tag. Allow more than 1 per file. Each tag will represent 1 invoice
<ocacsihead>	Y	Header Tag. Only 1 per Invoice Tag. If there is more than 1, only the first tag will be used.
<ssinum>TEXT</ssinum>	Y	Document Running Number Code. *Code must be in system.
<dtsidate>DATE(YYYY-MM-DD)</dtsidate>	N	Invoice Date. If missing Tag/Value, system will use current PC date
<dtsiduedate>DATE(YYYY-MM-DD)</dtsiduedate>	N	Invoice Due Date. If missing Tag/Value, system will use Invoice Date
<sbpcode>TEXT(20)</sbpcode>	Y	Business Partner Code. *Code must be in system.
<sbplocationcode>TEXT(10)</sbplocationcode>	N	Business Partner Location Code. If missing Tag/Value, system will use Business Partner default Location Code. *Code must be in system.
<sbplocationcode2>TEXT(10)</sbplocationcode2>	N	Business Partner 2nd Location Code. *Code must be in system.
<sbplocationcode3>TEXT(10)</sbplocationcode3>	N	Business Partner 3rd Location Code. *Code must be in system.
<sbplocationcode4>TEXT(10)</sbplocationcode4>	N	Business Partner 4th Location Code. *Code must be in system.
<ssiref>TEXT(50)</ssiref>	Y	Supplier Invoice Number. * Duplicate number cannot exist on system
<ssisubject>TEXT(100)</ssisubject>	N	Invoice Subject.
<semployeecode>TEXT(20)</semployeecode>	N	Employee Code. *Code must be in system.
<ssiremark>TEXT(4000)</ssiremark>	N	Invoice Remark.
<ssicomment>TEXT(4000)</ssicomment>	N	Internal Comment.
<scurrencycode>TEXT(3)</scurrencycode>	Y	Currency Code. *Code must be in system.
<nsiexchange>DECIMAL(18,6)</nsiexchange>	N	Exchange Rate. If missing Tag/Value, system will use default exchange rate of the Currency Code
<ssipayterm>TEXT(4)</ssipayterm>	N	Payment Terms Code. If missing Tag/Value, system will use Business Partner default Payment Terms Code. *Code must be in system.
<ssiterms>TEXT(50)</ssiterms>	N	Payment Terms Text. If missing Tag/Value, system will use Payment Terms default text.
<issiinclusive>true/false</issiinclusive>	N	Is invoice transaction price inclusive of GST? Not required for non-gst company. If missing Tag/Value, system will set the value to false.
<sdocutitle>TEXT(50)</sdocutitle>	N	Invoice Title. If missing Tag/Value, system will use the default invoice title
<sdocuref1>TEXT(50)</sdocuref1>	N	Additional Reference Field
<sdocuref2>TEXT(50)</sdocuref2>	N	Additional Reference Field
<sdocuref3>TEXT(50)</sdocuref3>	N	Additional Reference Field
<sdocuref4>TEXT(50)</sdocuref4>	N	Additional Reference Field
<sdocuref5>TEXT(50)</sdocuref5>	N	Additional Reference Field
<dtpostdate>DATE(YYYY-MM-DD)</dtpostdate>	N	Account Post Date. If missing Tag/Value, system will use Invoice Date
</ocacsihead>	Y	Closing of Header Tag
<ocacsidtl>	Y	Detail Tag. Allow more than 1 per Invoice tag.
<ssidtlsn>TEXT(5)</ssidtlsn>	N	Detail Serial Number.
<sitemcode>TEXT(50)</sitemcode>	Y	Item Code. *Code must be in system.
<ssidtldescription>TEXT(1000)</ssidtldescription>	N	Item Description. If missing Tag/Value, system will use Item default description
<nsidtlqty>DECIMAL(18,6)</nsidtlqty>	Y	Item Quantity. Cannot be 0
<nsidtlprice>DECIMAL(18,6)</nsidtlprice>	Y	Item Unit Price. Cannot be 0
<ssidtluom>TEXT(20)</ssidtluom>	N	Item UOM. If missing Tag/Value, system will use Item default UOM
<staxcode>TEXT(10)</staxcode>	N	Tax Code. Not required for non-gst company. If missing Tag/Value, system will set Business Partner default Tax Code. *Code must be in system.
<nsidtltamt>DECIMAL(18,6)</nsidtltamt>	N	Detail Transaction Amount. If missing Tag/Value, system will calculate the value automatically.
<nsidtltgst>DECIMAL(18,6)</nsidtltgst>	N	Detail Gst Transaction Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nsidtlttotal>DECIMAL(18,6)</nsidtlttotal>	N	Detail Transaction Amount After Gst. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nsidtlaamt>DECIMAL(18,6)</nsidtlaamt>	N	Detail Account Amount. If missing Tag/Value, system will calculate the value automatically.
<nsidtlagst>DECIMAL(18,6)</nsidtlagst>	N	Detail Gst Account Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nsidtllamt>DECIMAL(18,6)</nsidtllamt>	N	Detail Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<nsidtllgst>DECIMAL(18,6)</nsidtllgst>	N	Detail Gst Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
<swarehousecode>TEXT(10)</swarehousecode>	N	Warehouse Code.*Code must be in system.
<sstocklocation>TEXT(10)</sstocklocation>	*N	Warehouse Location Code. Can only be use if there is Warehouse Code. *Code must be in system.
<sstocklot>TEXT(10)</sstocklot>	N	Stock Lot Number.
<sjobcode>TEXT(20)</sjobcode>	N	Job Code.*Code must be in system.
<ssidtlremark>TEXT(4000)</ssidtlremark>	N	Detail Remark
</ocacsidtl>	Y	Closing of Detail Tag
</ocacsi>	Y	Closing of Invoice Tag
</ociac10>	Y	Closing of Root Tag

3. Sales Credit Note

The follow sections describe the format of the CN XML file.

XML				Mandatory	Description
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>				Y	XML Declaration.
<ociac10>				Y	Root Tag. Only 1 per file.
	<ocaccn>			Y	Credit Note Tag. Allow more than 1 per file. Each tag will represent 1 Credit note.
		<ocaccnhead>		Y	Header Tag. Only 1 per Invoice Tag. If there is more than 1, only the first tag will be used.
			<scnnum>TEXT(20)</scnnum>	Y	Credit Note Number.
			<dtcndate>DATE(YYYY-MM-DD)</dtcndate>	N	Credit Note Date. If missing Tag/Value, system will use current PC date
			<dtcnduedate>DATE(YYYY-MM-DD)</dtcnduedate>	N	Credit Note Due Date. If missing Tag/Value, system will use Credit Note Date
			<sbpcode>TEXT(20)</sbpcode>	Y	Business Partner Code. *Code must be in system.
			<sbplocationcode>TEXT(10)</sbplocationcode>	N	Business Partner Location Code. If missing Tag/Value, system will use Business Partner default Location Code. *Code must be in system.
			<sbplocationcode2>TEXT(10)</sbplocationcode2>	N	Business Partner 2nd Location Code. *Code must be in system.
			<sbplocationcode3>TEXT(10)</sbplocationcode3>	N	Business Partner 3rd Location Code. *Code must be in system.
			<sbplocationcode4>TEXT(10)</sbplocationcode4>	N	Business Partner 4th Location Code. *Code must be in system.
			<scnref>TEXT(50)</scnref>	N	Credit Note Reference.
			<scnsubject>TEXT(100)</scnsubject>	N	Credit Note Subject.
			<semployeecode>TEXT(20)</semployeecode>	N	Employee Code. *Code must be in system.
			<scnremark>TEXT(4000)</scnremark>	N	Credit Note Remark.
			<scncomment>TEXT(4000)</scncomment>	N	Credit Note Comment.
			<scurrencycode>TEXT(3)</scurrencycode>	Y	Currency Code. *Code must be in system.
			<ncnexchange>DECIMAL(18,6)</ncnexchange>	N	Exchange Rate. If missing Tag/Value, system will use default exchange rate of the Currency Code.
			<scnpayterm>TEXT(4)</scnpayterm>	N	Payment Terms Code. If missing Tag/Value, system will use Business Partner default Payment Terms Code. *Code must be in system.
			<scnterms>TEXT(50)</scnterms>	N	Payment Terms Text. If missing Tag/Value, system will use Payment Terms default text.
			<iscninclusive>TRUE/FALSE</iscninclusive>	N	Is Credit note transaction price inclusive of GST? Not required for non-gst company. If missing Tag/Value, system will set the value to false.
			<iscninventory>TRUE/FALSE</iscninventory>	N	Does Credit note transaction affect inventory? If missing Tag/Value, system will set the value to false.
			<sdocutitle>TEXT(50)</sdocutitle>	N	Credit Note Title. If missing Tag/Value, system will use the default Credit Note title.
			<sdocuref1>TEXT(50)</</sdocuref1>	N	Additional Reference Field.
			<sdocuref2>TEXT(50)</</sdocuref2>	N	Additional Reference Field.
			<sdocuref3>TEXT(50)</</sdocuref3>	N	Additional Reference Field.
			<sdocuref4>TEXT(50)</</sdocuref4>	N	Additional Reference Field.
			<sdocuref5>TEXT(50)</</sdocuref5>	N	Additional Reference Field.
			<dtpostdate>DATE(YYYY-MM-DD)</dtpostdate>	N	Account Post Date. If missing Tag/Value, system will use Invoice Date.
		</ocaccnhead>		Y	Closing of Header Tag
		<ocaccndtl>		Y	Detail Tag. Allow more than 1 per Invoice tag.
			<scndtlsn>TEXT(5)</scndtlsn>	N	Detail Serial Number.
			<sitemcode>TEXT(50)</sitemcode>	Y	Item Code. *Code must be in system.
			<scndtldescription>TEXT(1000)</scndtldescription>	N	Item Description. If missing Tag/Value, system will use Item default description
			<ncndtlqty>DECIMAL(18,6)</ncndtlqty>	Y	Item Quantity. Cannot be 0.
			<ncndtlprice>DECIMAL(18,6)</ncndtlprice>	Y	Item Unit Price. Cannot be 0.
			<scndtluom>TEXT(20)</scndtluom>	N	Item UOM. If missing Tag/Value, system will use Item default UOM.
			<staxcode>TEXT(10)</staxcode>	N	Tax Code. Not required for non-gst company. If missing Tag/Value, system will set Business Partner default Tax Code. *Code must be in system.
			<ncndtltamt>DECIMAL(18,6)</ncndtltamt>	N	Detail Transaction Amount. If missing Tag/Value, system will calculate the value automatically.
			<ncndtltgst>DECIMAL(18,6)</ncndtltgst>	N	Detail Gst Transaction Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ncndtlttotal>DECIMAL(18,6)</ncndtlttotal>	N	Detail Transaction Amount After Gst. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ncndtlaamt>DECIMAL(18,6)</ncndtlaamt>	N	Detail Account Amount. If missing Tag/Value, system will calculate the value automatically.
			<ncndtlagst>DECIMAL(18,6)</ncndtlagst>	N	Detail Gst Account Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ncndtllamt>DECIMAL(18,6)</ncndtllamt>	N	Detail Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ncndtllgst>DECIMAL(18,6)</ncndtllgst>	N	Detail Gst Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<swarehousecode>TEXT(10)</swarehousecode>	N	Warehouse Code.*Code must be in system.
			<sstocklocation>TEXT(10)</sstocklocation>	*N	Warehouse Location Code. Can only be use if there is Warehouse Code. *Code must be in system.
			<sstocklot>TEXT(10)</sstocklot>	N	Stock Lot Number.
			<sjobcode>TEXT(20)</sjobcode>	N	Job Code. *Code must be in system.
			<scndtlremark>TEXT(4000)</scndtlremark>	N	Detail Remark.
		</ocaccndtl>		Y	Closing of Detail Tag
	</ocaccn>			Y	Closing of Invoice Tag
</ociac10>				Y	Closing of Root Tag

4. Sales Debit Note

XML				Mandatory	Description
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>				Y	XML Declaration.
<ociac10>				Y	Root Tag. Only 1 per file.
	<ocacdn>			Y	Debit Note Tag. Allow more than 1 per file. Each tag will represent 1 debit note.
		<ocacdnhead>		Y	Header Tag. Only 1 per Invoice Tag. If there is more than 1, only the first tag will be used.
			<sdnnum>TEXT(20)</sdnnum>	Y	Debit Note Number.
			<dtdndate>DATE(YYYY-MM-DD)</dtdndate>	N	Debit Note Date. If missing Tag/Value, system will use current PC date
			<dtdnduedate>DATE(YYYY-MM-DD)</dtdnduedate>	N	Debit Note Due Date. If missing Tag/Value, system will use Debit Note Date
			<sbpcode>TEXT(20)</sbpcode>	Y	Business Partner Code. *Code must be in system.
			<sbplocationcode>TEXT(10)</sbplocationcode>	N	Business Partner Location Code. If missing Tag/Value, system will use Business Partner default Location Code. *Code must be in system.
			<sbplocationcode2>TEXT(10)</sbplocationcode2>	N	Business Partner 2nd Location Code. *Code must be in system.
			<sbplocationcode3>TEXT(10)</sbplocationcode3>	N	Business Partner 3rd Location Code. *Code must be in system.
			<sbplocationcode4>TEXT(10)</sbplocationcode4>	N	Business Partner 4th Location Code. *Code must be in system.
			<sdnref>TEXT(50)</sdnref>	N	Debit Note Reference.
			<sdnsubject>TEXT(100)</sdnsubject>	N	Debit Note Subject.
			<semployeecode>TEXT(20)</semployeecode>	N	Employee Code. *Code must be in system.
			<sdnremark>TEXT(4000)</sdnremark>	N	Debit Note Remark.
			<sdncomment>TEXT(4000)</sdncomment>	N	Debit Note Comment.
			<scurrencycode>TEXT(3)</scurrencycode>	Y	Currency Code. *Code must be in system.
			<ncnexchange>DECIMAL(18,6)</ncnexchange>	N	Exchange Rate. If missing Tag/Value, system will use default exchange rate of the Currency Code.
			<sdnpayterm>TEXT(4)</sdnpayterm>	N	Payment Terms Code. If missing Tag/Value, system will use Business Partner default Payment Terms Code. *Code must be in system.
			<sdnterms>TEXT(50)</sdnterms>	N	Payment Terms Text. If missing Tag/Value, system will use Payment Terms default text.
			<isdninclusive>TRUE/FALSE</isdninclusive>	N	Is debit note transaction price inclusive of GST? Not required for non-gst company. If missing Tag/Value, system will set the value to false.
			<isdninventory>TRUE/FALSE</isdninventory>	N	Does debit note transaction affect inventory? If missing Tag/Value, system will set the value to false.
			<sdocutitle>TEXT(50)</sdocutitle>	N	Debit Note Title. If missing Tag/Value, system will use the default Debit Note title.
			<sdocuref1>TEXT(50)</</sdocuref1>	N	Additional Reference Field.
			<sdocuref2>TEXT(50)</</sdocuref2>	N	Additional Reference Field.
			<sdocuref3>TEXT(50)</</sdocuref3>	N	Additional Reference Field.
			<sdocuref4>TEXT(50)</</sdocuref4>	N	Additional Reference Field.
			<sdocuref5>TEXT(50)</</sdocuref5>	N	Additional Reference Field.
			<dtpostdate>DATE(YYYY-MM-DD)</dtpostdate>	N	Account Post Date. If missing Tag/Value, system will use Invoice Date.
		</ocacdnhead>		Y	Closing of Header Tag
		<ocacdndtl>		Y	Detail Tag. Allow more than 1 per Invoice tag.
			<sdndtlsn>TEXT(5)</sdndtlsn>	N	Detail Serial Number.
			<sitemcode>TEXT(50)</sitemcode>	Y	Item Code. *Code must be in system.
			<sdndtldescription>TEXT(1000)</sdndtldescription>	N	Item Description. If missing Tag/Value, system will use Item default description
			<ndndtlqty>DECIMAL(18,6)</ndndtlqty>	Y	Item Quantity. Cannot be 0.
			<ndndtlprice>DECIMAL(18,6)</ndndtlprice>	Y	Item Unit Price. Cannot be 0.
			<sdndtluom>TEXT(20)</sdndtluom>	N	Item UOM. If missing Tag/Value, system will use Item default UOM.
			<staxcode>TEXT(10)</staxcode>	N	Tax Code. Not required for non-gst company. If missing Tag/Value, system will set Business Partner default Tax Code. *Code must be in system.
			<ndndtltamt>DECIMAL(18,6)</ndndtltamt>	N	Detail Transaction Amount. If missing Tag/Value, system will calculate the value automatically.
			<ndndtltgst>DECIMAL(18,6)</ndndtltgst>	N	Detail Gst Transaction Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ndndtlttotal>DECIMAL(18,6)</ndndtlttotal>	N	Detail Transaction Amount After Gst. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ndndtlaamt>DECIMAL(18,6)</ndndtlaamt>	N	Detail Account Amount. If missing Tag/Value, system will calculate the value automatically.
			<ndndtlagst>DECIMAL(18,6)</ndndtlagst>	N	Detail Gst Account Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ndndtllamt>DECIMAL(18,6)</ndndtllamt>	N	Detail Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<ndndtllgst>DECIMAL(18,6)</ndndtllgst>	N	Detail Gst Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically.
			<swarehousecode>TEXT(10)</swarehousecode>	N	Warehouse Code.*Code must be in system.
			<sstocklocation>TEXT(10)</sstocklocation>	*N	Warehouse Location Code. Can only be use if there is Warehouse Code. *Code must be in system.
			<sstocklot>TEXT(10)</sstocklot>	N	Stock Lot Number.
			<sjobcode>TEXT(20)</sjobcode>	N	Job Code. *Code must be in system.
			<sdndtlremark>TEXT(4000)</sdndtlremark>	N	Detail Remark.
		</ocacdndtl>		Y	Closing of Detail Tag
	</ocacdn>			Y	Closing of Invoice Tag
</ociac10>				Y	Closing of Root Tag

Related Articles
XML Import : Import document
Steps. 1. Open Invoice module 2. Click on Import. 3. select the xml file. 4. click 'open' 5.status message will indicate success or failure of the import. Notes the document listing may not refresh automatically, if that happens click on 'clear' or ...
Upload my customized document layout.
Customized document layout will come in a dot XML extension file. Step 1 Click Maintenance -> Updates -> Document Settings Import Step 2 Select the location where the layout is. then click on 'Get Document' a list of the customized layouts will ...
Document Details Import
Document Details Import allows you to import an Excel file as the details for a document. the custom function allows you choose an the area where the details are and provides a mapping function for the columns. 1. prepare the document header. select ...
XML Import: Missing Information
Missing Information system side. this indicates that there is missing information on the system side. you'll need to create the missing information before being able to import the xml. the missing information is commonly from the following area 1. ...
Changing to different Printout Format
Changing to different Printout Format Location Action Remark SALES> QUOTATION  Click on LAYOUT Document Properties Dialogue box will appear  Un-Tick all the DEFAULT boxes Un-Tick the Default box release the pre-set layout format you have set in ...

Document Import XML format

Document Import XML format

Related Articles

XML Import : Import document

Upload my customized document layout.

Document Details Import

XML Import: Missing Information

Changing to different Printout Format