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

• 5.0. Sales Invoice

  How to create a Sales Invoice? STEPS: Go to SALES > INVOICE Click NEW Customer Select: EveryDay Customer Pte Ltd S/N enters: 1. ITEM select: SVC001 DESCRIPTION: Collect From: Changi Airport Deliver To: Jurong Island Contact: Mr Ho QTY enter: 5 Check ...

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

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

• Off-Setting Sales Invoice with Credit Note

  Off-Setting Sales Invoice with Credit Note Location Action Remark SALES> RECEIPT  Click SALES activity  Click RECEIPT module  Click NEW  CUSTOMER select EveryDay Customer Pte Ltd  Click IMPORT  Click DOCU OUTSTANDING  Click ADD ALL ROWS You ...