CSV for Invoice import

OCi System Custom Guide

Version 0.1

This custom function has been created for a specific customer and not suitable for general usa

CSV Format

Requirements

• No column headers
• BP code must exist in system before import
• Item code must exist in system before import
• BP code has to be 9 characters long
• Name and BP will be on 2 lines
• Item descriptions will be on 2 lines
• Each invoice is 6 x 4 cells

Header Format.

Payment Advice №

Issue Date

Name

Amount

GST

Item Code

Sample Format

INV001	30-Jan-23	Kaitlynn	305	22.59	GENERAL
		Xxxxxxxxx (Singaporean(s)(sg))
		2023 / K2 / Maroon Medal / 1
		Test STEAM Programme (Nur to K2) -
INV002	30-Jan-23	Jolynn	305	22.59	GENERAL
		XXXXXXXXX (Singaporean(s)(sg))
		2023 / N / Turquoise Tie / 1
		Test STEAM Programme (Nur to K2) -

System Setup

Required Setup

The tax code will need to be setup if you are using GST

Usage

Button location

Error Messages

Index and length must refer to a location within the string.

This is due to the BP code not meeting the length requirement. 

Input array is longer than the number of columns in this table.

The CSV has additional columns

Invoice contain code that is not in system

Check that the BP code or the item code exist in the system

Invoice already exist

Invoice number is duplicated, check the CSV for . 

System Error! Please check your Setting

Check

• Date is within an open financial year.
• BP has a tax code set in the BP registration module if using GST.
• Item code is active
• BP is active
  

• Related Articles

• 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> ...

• BP import: Import CSV

  Steps to import CSV 1. Setup -> Customer/Vendor -> Business Partner 2. click on import button 3. select the file to import. 4. click open button.

• Understanding Contract, Approved, Close & Import to Invoice

  3.1.1.3 Understanding Contract, Approved, Close & Import to Invoice Location Action Remark  CONTRACT Tick on Contract if you want the system to monitor fulfillment status. Meaning quantities committed in Order versus quantities Delivered.  ...

• Payroll Import: Importing CSV.

  To import the CSV file you'll need to ensure that it is properly formatted and the values are balance. if you encounter errors. Check that Job code is using "" for empty or has a value Check Account code exist in the Chart of Accounts. Values are ...

• 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), ...