Hi all having problems linking invoices and sales when importing from excel
I have imported both sales and invoices successfully and have linked the sales order with the purchase order number, however when i import the invoices and ask it to link them together it does not do it. Here is an example of one the lines i have imported as an invoice when it does not work.
Invoice Date
|
Invoice Status
|
SalesOrder
|
Item Desc
|
Item Price
|
Currency Code
|
Fees
|
Discount(%)
|
Item Tax
|
Item Tax %
|
Customer Name
|
Invoice Number
|
Invoice VAT Treatment
|
Due Date
|
Template Name
|
Exchange Rate
|
Item Name
|
Quantity
|
Item Type
|
Is Inclusive Tax
|
Item Tax Type
|
Notes
|
Terms & Conditions
|
PayPal
|
Authorize.Net
|
Google Checkout
|
Warehouse Name
|
23/08/2018
|
|
206-03081-30715
|
Test Item 1 |
16.79
|
|
-8.03
|
|
|
|
Fred1
|
|
03/09/2018
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Sales Order matches that in my sales orders number