Consolidated Invoice upload

[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]

Re: Consolidated Invoice upload

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]

Re: Consolidated Invoice upload

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]

Re: Consolidated Invoice upload

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.