How to Upload Freight Invoices for Multiple Orders

  • Updated

This approach works well to allocate freight costs incurred per order.

  1. Click on Enter Supplier Invoice

    In the main navigation menu, select the **A/P module** and click on "**Enter Supplier Invoice**".

  2. Select "Multiple Orders"

    Select "**there are multiple orders for this invoice**".

  3. Click on Vendor

    Select the appropriate vendor for this invoice, such as **UPS Shipping**.

  4. Click on "+ Add Data"

    Enter the invoice information as usual, such as **invoice number**, **invoice date**, and **due date**. Then, click on "**+ Add Data**".

  5. Copy/Paste Data

    Scrub your shipping invoice to match the Aturian format, i.e., **Order#**, **Description**, **Item Type**, **Unit Cost**, **Qty**, **Freight Cost**, **GL**, **GL comment**.

💡 Tip!

**GL comment** field is not necessary; however, it is recommended to complete other fields. Aturian will adjust freight GL account automatically to correspond with the order. Enter "**0**" for **Unit Cost** and "**1**" for **QTY**.

  1. Click on Submit

    Once data is pasted, click **submit**.

  2. Click on Submit

    Aturian will update GL accounts if needed. Click **submit** again.

  3. Verify Net Total

    Verify **net total** matches the vendor invoice.

  4. Attach Vendor Invoice

    Attach **vendor invoice** and **save the invoice**.

  5. Vendor Consolidated Invoice

    Notice the shipping invoice was **consolidated** with subsidiary "**invoices**" differentiated with a "**- #**" for each order.

  6. Consolidated Invoice

    The consolidated invoice will display as "**open**" while the subsidiary invoices will display as "**closed**".

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request