Hi there,
I would like like to import Sales Invoices into Business Central using a Configuration Package but I want to use the next available invoice number rather than specifying the number on the import file. The reason is because we want the customer to be able to simply compile the invoice header and lines and import without having to check which number is next in the sequence.
In my Sales Invoice numbering series, I have "Default Nos." selected to automatically choose the next number. I do not have Manual Nos. enabled.
In my import file, the sales invoice number is blank for both the header and the sales line records:
My configuration package is set up with Table 36 and 37 and my Excel source file is based on an export of this.
My problem is that when I import, the Sales Invoice gets created but with no detail lines. In viewing other posts, it seems like you always have to link the header to the lines using the invoice number so I am wondering if it is possible to use the next available invoice number for both header and lines if imported at the same time.
Thanks,
Craig
