Importing Order Entry Data

You can customize the system to import line item information from an existing data file into an order. Your outside salespeople can then enter an order on a portable device, for example, and import all of the quantity and product information into a sales order when they return to the office.

Before using this feature, the system must be set up to work with your data files. You can use many types of text or spreadsheet data formats, such as comma or tab delimited data files. You define these file formats in User Defined Bid Upload Format Maintenance.

To import order entry data:

  1. Create or open a sales order and display the order's Body tab.

  2. From the Edit Order menu, select Import to display the Order Entry Data Import window.

  3. In the File Format field, press F10 and select the file format for the file you are importing. The names often indicate their purpose or the type of device, such as Handheld.

  4. In the Path Name field, enter the location of the data. For example, C:/SOERF_INP.TXT indicates that the file in question (SOERF_INP.TXT) is located directly on the user's C drive.

  5. Click OK to return to the order's Body tab and populate the order with the customer's line item information.

  6. Continue processing the sales order as usual.

See Also:

Consolidating Sales Orders