Document Import XML format

Document Import XML format

Version: 2.0.2
Date: 2022-04-07
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



    • 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 ...
    • 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 ...
    • Adding a subtotal to a document.

      To create a subtotal in a document similar to the following  Step 1. Create a new item group. for Type set it to 'Remark' for Subtotal Level set it to 'Level 1 Reset' there are 9 grouping levels to use. 'Reset' means to reset the count. 'Accumulate' ...