Skip to main content

Import orders into EMERGE using grouping numbers

Import sales orders and purchase orders from Excel Files into EMERGE

Written by Gigi Nguyen

Overview

If your sales orders and purchase orders are created from imported documents, you can use grouping numbers to prevent duplicate order numbers in EMERGE.

How to use grouping numbers

  1. Download the import template.
    ​

  2. In the PO Grouping Number column, enter a number on each item row. Use the same number for all rows that belong to the same order.
    ​

  3. Leave the PO Number column blank.
    ​

  4. Upload the file to import your orders.
    ​

Tips:

  1. Click "Click for Explanation" in the column name to see a short description of the field.

  2. Grouping number rules

    • The number must be a whole number > 0

    • The numbers do not need to be in order. For example, 1, 4, and 99 are all valid.

How grouping numbers work

A grouping number tells EMERGE which item rows in your import file belong to the same order.

  • Rows with the same grouping number are combined into one order.

  • It is only used to group rows, not as the final order number.

EMERGE will then assign the actual order number automatically, in the same running sequence as manually created orders.

Did this answer your question?