CSV Bulk Invoice Import

CSV Bulk Invoice Import is the form for automated uploading and processing of the list of sales documents from CSV file. It is possible to select the document type and the operation type before starting the process.
CSV Bulk Invoice Import is available by going to Sales -> New Operation and selecting CSV Bulk Invoice Import
Each of the processed documents can be either saved as draft or posted or send by email.
Import runs in the background mode so it's not required to wait while the process will be completed by staying on the same page.
Required fields (columns):
1) InvoiceDate - document date, if it is left blank the current date will be used;
2) ClientName - client name, if client is not found it will be created;
3) ItemName1 - existed product/service name or item description;
4) ItemPrice1 - price, if it is left blank the price from the price list will be used (for existed product or service);
All other fields (columns) are optional.
The columns order does not matter but the headers are important and should be  the same as in the template.
The required columns are marked with asterisk in the template but this symbol is not required.
The fields to add a line item (N - increment number):
ItemNameN - existed product/service name or item description; 
ItemCodeN - existed product/service code, if item name is left blank then the item will be looked up by the given code;
ItemDescriptionN - line item description;
ItemQtyN - quantity, if it is left blank then the value 1 will be used;
ItemPriceN - price, if it is left blank the price from the price list will be used (for existed product or service); 
ItemDiscountN - line discount in %; 
ItemAccountCodeN - account code, if it is left blank the default code will be used; 
ItemTaxKeyN - tax key name or ID, if it is left blank the default tax key will be used;  
Up to 25 line items are supported for a document row:
ItemName1, ItemName2, ItemName3, ... ItemName25
At least 2 columns should be added for every additinal line item:
ItemNameN and ItemPriceN (N - increment number)
InvoiceNumber - document number, if it is left blank the auto generated number will be used;
The fields to create a new client:
ClientName - client name;  
IsCompany - client type, the value should be 1 or true to set the type to Corporate;
ClientRegNumber - registration number;
ClientVatNumber - VAT number; 
ClientAddress - address (street, city); 
ClientZip - zip code
ClientCountry - 2-Letter country code;
ClientEmail - email address;
The existed shipping address will be looked up by the following fields:
ShippingTo and ShippingAddress
The fields to create a new shipping adress:
ShippingTo - recipient name;
ShippingAddress - address (street, city);
ShippingZip - zip code
ShippingCountry - 2-Letter country code;
ShipperName - shipper name;
The fields to add a shipping charge:
ShippingCharge - shipping charge;
ShippingChargeAccountCode - account code, if it is left blank the default code will be used;
ShippingChargeTaxKey - tax key name or ID, if it is left blank the default tax key will be used; 
PaymentMethod - payment method, can contain one of the following values:
0 - Not Defined
1 - Bank
2 - Cash
3 - Card
4 - Prepayment
5 - Offsetting
6 - Factoring
If it is left blank the default value will be used;
The fields to add a billing period:
PeriodFrom - start date;
PeriodTill - end date; 
If both fields are missed or left blank the period will not be set
Comment - comment; 
The fields to add a new payment to the posted document (N - increment number):
MoneyAccountNameN - money account name, the currency of the account should be the same as in the document;
PaymentAmountN - payment amount;
Up to 3 payment types are supported for a document row:
MoneyAccountName1, MoneyAccountName2,MoneyAccountName3

Still need help? Contact Us Contact Us