I am writing an application which interacts with Sage50 2016. I have full access to both the .NET and COM APIs.

My current task is to import purchases (PurchaseInvoice in the .NET API, PurchaseJournal in the COM API). Since the .NET API seems to be read-only for purchases, I'm using the Import function in the COM API, using the XML format:

Import imp = app.CreateImporter(PeachwIEObj.peachwIEObjPurchaseJournal);
imp.SetFileType(PeachwIEFileType.peachwIEFileTypeXML);
imp.SetFilename(fileName);
string[] guids = null;
imp.ImportAndReturnGUIDs(out guids);


It works fine for a regular purchase invoice import. However in some circumstances I really need to be able to add line items to an existing purchase invoice. I've tried different combinations of XML with the importer, but so far it's looking like it is impossible to use the importer to add line items to an existing purchase invoice.

At this point it seems that my only alternatives would be to delete the existing invoice and reimport the whole thing (not something I'd really want to do), or to create a separate invoice for the new line items, with a slightly different invoice number (also not preferable).

Is this correct? Or does anyone know of a way to add line items?

Thanks in advance,
David