Consolidated Invoice upload

[vsevs Senior Member Find all posts View Profile Close 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 Senior Member Find all posts View Profile Close 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 Senior Member Find all posts View Profile Close 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 Senior Member Find all posts View Profile Close 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.