Hello,
We are trying to get started by importing our invoices into DNI but I am getting the following error every single time, no matter what I try:
-- Starting Invoice Import --
Error: Invoice ID 1 - Object cannot be cast from DBNull to other types.
-- End Invoice Import --
-- Start Invoice Detail Item Import --
Error: Failed to add invoice detail as invoice not found - Invoice ID 1 - Description - descr
-- End Invoice Detail Item Import --
DATA NOT IMPORTED - PLEASE CORRECT ERRORS AND TRY AGAIN
End importing invoices......
Below is a table depicting the structure I am trying to upload via CSV (i did not see a place to attach the actual CSV file in this post) :
| InvoiceId |
InvoiceDate |
Description |
Quantity |
Amount |
Taxable |
Comments |
Due |
ClientId |
Status |
Tax Rate (%) |
Tax 2 Rate (%) |
RecurringID |
| 1333 |
11/24/2009 |
descr |
1 |
5 |
0 |
none |
11/24/2009 |
2 |
2 |
|
|
|
Please let me know what I am doing wrong as I am just trying to get one invoice successfully imported from you sample csv import format.
Many thanks,
*PS - Any word on when the QB integration module is coming out?
John.