Import Open Sales Order

If you want to import open sales orders into Versaccounts, you can use the csv file open_sales_orders.csv.

The file has the following columns. For order with multiple lines, repeat Internal Ref,Order Date,Customer PO Number columns for each line.
Internal Ref: Optional. A internal reference number for the sales order. Use the same internal ref for orders that have multiple rows.
Order Date: The date of the sales order.
Customer PO Number: Name of the PO if applicable.
Ship From: Facility Code: The facility (warehouse) that the order is to be fulfill from. Use WHS(default facility) if you only have one facility.
Bill To: customer company name: Name of the company if it is a company.
Bill To: customer given name: Name of the person or primary contact
Bill To: customer surname: Name of the person or primary contact
Ship To: customer company name: Optional. Name of the company that the order is to be shipped to
Ship To: customer given name: Name on the ship to address
Ship To: customer surname: Name on the ship to address
Ship To: address_line_1 : Address of the ship to address
Ship To: address_line_2: Address of the ship to address
Payment Terms Discount: If the order has terms and a discount is given for early payment, put the discount % here. Put 0 otherwise.
Payment Terms Discount Days: If the order has terms and a discount is given for early payment, put the # of days before a discount is provided. Put 0 otherwise.
Payment Terms Net: The # of the days before this invoice is overdue(if the order is turned into an invoice)
Message: A note about the order. Optional.
Product Name: Name (part number) of the product on the sales order. Product must already exist.
Quantity:  The quantity to order.
Measurement Unit: The unit the product is in. Measurement Units must already exist in the system.
Price Per Unit : Price of the product.
Currency Code: Currency the order is in. Use the 3 digit ISO 4217 currency code. USD for example.
Estimated Delivery Date: Expected Delivery date of the sales order.