[vsevs]

Hi,
Can anybody help me in this. I need to know what are the tables for which we need to upload the data incase of consolidated invoice (invoice for multiple shipments).

Thanks.

[james_foran]

There is an Invoice XML which I would advise you use.

Otherwise, it is just the INVOICE, INVOICE_LINEITEM, INVOICE_REFNUM and INVOICE_STATUS tables that you need to focus on.

Make sure up upload a PARENT INVOICE record first. THis is just like any other, except it has a consolidation type of PARENT.

Then within the same CSV file, you can upload the CHILD invoices. They will have a consolidation type of CHILD, and a PARENT_INVOICE_GID of the PARENT invoice.

Hope this helps.

[vsevs]

Hi,
Can you please let me know the invoice XML file name to use to upload the consolidated invoice.
It would be of great help if you can give me a sample.

Best Regards,
Venkat.

[vsevs]

Hi,
Can anyone suggest me what is the best way to create consolidated invoice when we have a excel file or flat text file of invoices. It would be of great help if someone can help me with the procedure to do this.

Thanks.