Electronic Transmissions - Orders and Order Guides

The Electronic Transmissions screen allows you to configure website or FTP information for a distributor and setup templates for order guides, orders, invoices, and journal entries.

Once a template for electronic ordering has been configured, you can assign the template to a vendor in the "Electronic Distributor" fields of the Vendors' definition. Then, electronic orders for the vendor can be transmitted from the Orders screen.

Once a template for order guides has been configured, vendor order-guides can be imported from the Import Order Guides screen.

Note: Stock templates for many major distributors are available for download from the Compeat website. To use these templates, simply download them from the Downloads page of the Client Login area, and then import them through this screen. Once imported, enter a local directory and save the screen. The templates will then be available for future use.

baby_down.jpg Click to view/hide picture.

Distributor Information

Order Guides Tab

This tab allows you to set up specifications for importing order guides.

Import File Specifications

The Import and Export buttons can be used to export the current configuration to an xml file or import an existing configuration from an xml file. Templates can be downloaded from the Client Login area of the Compeat website.

image19.gif

image20.gif

image22.gif

Fields

The Fields section contains a data grid that is used to map fields from the order guide to fields within Compeat. Click the plus symbol in the grid toolbar to open a list of hard-coded Compeat fields.

Field_Chooser.png

Select the fields that you wish to map to and then click OK.

Note: The list of available fields may not exactly match those in a data file. For example, a "Item ID" in the data field may need to be mapped to the "Item Code" in Compeat.

Description grid options:

Note: If the vendor accepts orders for split cases, chances are the order guide file will indicate whether the price represents cases or eaches.  Most vendors include this indication in one of two ways:

1.  Separate columns for Case and Each prices.  If this is what the vendor uses, you will need add ‘Price’ and ‘Split Price’ fields to the template.  If the price appears in the ‘Split Price’ column of the order guide, and ‘Match on Split Case’ is selected, Compeat will only find an exact match in the restaurant inventory if the item code in the order guide matches one that is assigned to the purchase unit that is marked as the split qty in a restaurant inventory item.

2. One price column and a split case indicator with true/false values.  If this is what the vendor uses, you will need to add ‘Split Case’ and ‘Price’ fields to the template.  You will also need to enter the true and false values for the ‘Split Case’ column.  Many vendors use something like ‘EA’ for a true split value, and ‘CS’ for a false split value, but it can vary from vendor to vendor. If the price in the order guide is for a split case, the ‘Split Case’ column will contain the true value.  If it is not flagged as the split, it will contain the false value.  All prices will appear in the ‘Price’ column.  If the value in the ‘Split Case’ column of the order guide is true, and ‘Match on Split Case’ is selected, Compeat will only find an exact match in the restaurant inventory if the item code in the order guide matches one that is assigned to the purchase unit that is marked as the split qty in a restaurant inventory item.

 

Formatting Rules

You can apply functions to transform the data as it is imported. To create rules for a field, select the field and click on Edit Formatting Rules. These rules include functions for concatenating, removing spaces, converting case, basic math functions, and more. A brief description each function will display at the bottom of the dialog when you click on the function in the "Available Rules" list.

Rule_Builder.png

 

The more common uses for formatting rules are for defining the date format in the file, or replacing a value with another value.

Order Export Tab

This tab allows you to configure Compeat for exporting orders. Your vendor should provide you with the specifications needed to complete this form.

Export File Specifications

The Import and Export buttons can be used to export the current configuration to an xml file or import an existing configuration from an xml file.

Fields (Order Header Fields and Order Detail Fields)

Create a field list and specify properties for the order header in this section. Your vendor should provide you with the specifications needed to complete this form.

Description grid options:

Note: For other file types, fields are exported in the order they appear in the list.

Note: If the vendor accepts orders for split cases, chances are they are expecting the order file to indicate whether the quantity being ordered represents cases or eaches.  Most vendors expect this indication in one of two ways:

1.  Separate columns for Case and Each quantities.  If this is what the vendor uses, you will need add ‘Case Qty’ and ‘Each Qty’ fields to the template.  If the purchase unit that is selected on the order is flagged as the split quantity in the restaurant inventory item, the quantity will appear in the ‘Each Qty’ column in the order file.  If it is not flagged as the split, it will appear in the ‘Case Qty’ column.

2.  One quantity column and a split case indicator with true/false values.  If this is what the vendor uses, you will need to add ‘Split Qty’ and ‘Qty’ fields to the template.  You will also need to enter the true and false values for the ‘Split Qty’ column.  Many vendors use something like ‘EA’ for a true split value, and ‘CS’ for a false split value, but it can vary from vendor to vendor. If the purchase unit that is selected on the order is flagged as the split quantity in the restaurant inventory item, the ‘Split Qty’ column will contain the true value.  If it is not flagged as the split, it will contain the false value.  All quantities will appear in the ‘Qty’ column.

Note:  For catch-weight items, most vendors will assume that any quantity in the order file for catch-weight items is for cases.