Announcement

Collapse
No announcement yet.

Consolidated Invoice upload

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Consolidated Invoice upload

    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.

  • #2
    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.
    James Foran
    Toll Global Information Services
    http://www.tollgroup.com

    Comment


    • #3
      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.

      Comment


      • #4
        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.

        Comment

        Working...
        X