XML Import : Import File Sample

XML Import : Import File Sample

The following information must be provided in the XML tags before importing into the system:

1. Invoice number
2. Business Partner code 
3. Currency code 
4. Item code 
5. Item Quantity 
6. Item Price 

For tags that are not mandatory, you may leave them blank if they are not needed. However, please do not remove the tags.
For tag that is non -mandotory , you may leave it as blank if you are no needed and do not delete it.

Example of an empty (non-mandatory) tag:
<sjobcode></sjobcode>

Example of a tag with value/information:
<sbpcode>0004</sbpcode>

Please ensure that all codes (e.g., Business Partner Code, Item Code) already exist in the system before performing the XML import. This helps to avoid error messages during the import process.

Sample to import XML for 1 Business Partner and 3 Item in a single Invoice   




    • Related Articles

    • Description XML format

      Version: 2.0.2 Date: 2022-04-07 XML format documentation Please note XML 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 ...
    • XML Import : Import Guide

      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 ...
    • 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. ...
    • Payroll Import: CSV file format

      The file format for import is using a Comma Separated Values format (CSV). the file format has no headers. Format: Account Code, Description, Debit Amount(transaction), Credit Amount(transaction), Debit Amount (Accounting), Credit Amount(Accounting), ...
    • Attach File

      How can I use Document Attachment? - Attach, View, Download & Delete Attaching of documents or pictures can be found in all modules. STEPS: Click PURCHASE activity Click PAYMENT module Select any document Click EDIT Click PROPERTIES tab Attachment ...