DotNetInvoice Forums

DotNetInvoice Invoicing Script Discussion Forum
Welcome to DotNetInvoice Forums Sign in | Join | Help
in Search

Import Invoices Problem

Last post 11-30-2009, 2:09 PM by erdesign. 2 replies.
Sort Posts: Previous Next
  •  11-27-2009, 9:29 AM 555

    Import Invoices Problem

    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.

  •  11-30-2009, 10:43 AM 557 in reply to 555

    Re: Import Invoices Problem

    John,

    Could you please email us a copy of your import CSV file at support@dotnetinvoice.com?  We'll let you know what needs to change in your file for now and see if there is anything we can change in the next version to make the error more informative.

    Our QB integration is moving along.  We've tested moving data back and forth between QB and DotNetInvoice.  We are now making sure all fields are moving correctly and hoping to have a Beta available soon.


    ---
    Jeremy
    DotNetInvoice Support
  •  11-30-2009, 2:09 PM 558 in reply to 557

    Re: Import Invoices Problem

    I just emailed you at support@dotnetinvoice.com, please advise.
View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems