This topic contains 5 replies, has 0 voices, and was last updated by ms_cherrie 13 years, 3 months ago.

  • Author
    Posts
  • #24431

    ms_cherrie

    Hi, I tried importing invoices with multiple line items but after it got uploaded, NetSuite assigned invoice numbers for each line. So if I have one invoice with 10 lines items on it, NetSuite assigned 10 invoice numbers for each line rather than combining all of it in one invoice.

    Any idea on how to import historical invoices with multiple line items?

    Thanks,
    This is a cached copy. Click here to see the original post.

  • #24432

    Olivier Gagnon NC

    RE: Importing Invoices with Multiple Lines

    Easiest way (though not the only way) is to map an External ID value – i.e. all lines belonging to the same invoice should share the same External ID.

  • #24433

    ms_cherrie

    awesome. it worked. thank you very much

  • #24434

    ms_cherrie

    RE: Importing Invoices with Multiple Lines

    When I tested it, it worked fine. Now what I don't understand is some line items on the invoices did not get imported while the other invoices gets imported in its entirety (all line items). It doesn't make sense

    For Instance:

    Invoice 1 has 10 line items but only 1 got imported

    Invoice 2 has 10 line items and all were imported

    These invoices came from the same and has the same format and external IDs are in similar fashion too.

    Is this a bug?

  • #24435

    Olivier Gagnon NC

    RE: Importing Invoices with Multiple Lines

    Did you get errors?

  • #24436

    ms_cherrie

    RE: Importing Invoices with Multiple Lines

    I didn't get an error, which is weird. But I did find a workaround. I did another upload to update all invoices and added "Orderline" on my mapping. It worked fine after that.

You must be logged in to reply to this topic.