Technical and Installation Discussions

[hyanaga]

We are in test mode of upgrading a client from v4.3 to v4.5.  We have VI jobs in v4.3 to import AR customers, SO Invoices, and AR Cash Receipts.  The Customers and Cash Receipts are importing fine, with only one adjustment necessary.  But when we tried to import SO Invoices, we get the error "L record AddLine() failed.  Missing or invalid header."   None of the invoices will import.

The source file is the same for all 3 of these import types.  The header and detail are on the same line. 

I just figured out the issue while I was typing this, so I'll share in case anyone else runs into it.  On the Record tab, there is now a Header Record that needs to be added, and it should be above any of the Line record definitions (like RegularItem).  Once I added that, it worked.

[hyanaga]

I spoke too soon.  Now the header files are fine, but it's not recognizing the lines, so when I try to import, it says each header has no lines and won't be imported. 

I have a RegularItem defined on the Records tab, but it's the same definition as the Header record, because they are both the same kind of line (first character of second field = "S").  I also have some Skip Records defined.  I'm going to play around with the order of these record definitions, but if anyone has other ideas, I'd love to hear them.

Hollie

[hyanaga · Accepted solution]

I removed the header and regular item records on the Records tab and now it is importing correctly.