EDI Mapping Overrides for ACE Hardware Corporation

Mapping Overrides for ACE Hardware

Mapping Overrides provide options and preferences for EDI processing. The selections vary by vendor and not all are used with every vendor (options that do not apply are disabled and show the text "<Default>" in light gray text color). Override settings are accessed from the Branch Setup maintenance form's EDI tab via a context menu Menu_Marker_Icon. Overrides, as well as other EDI settings, are branch (location) specific. If you have more than one location, changes would need to be made for each branch location. Changes are only saved if the user chooses Process (F12) from the Branch Setup form after making changes or additions.

Main Menu > Maintenance > Database > Branches, EDI, Overrides (Context Menu)

Submit PO

The only option provided is POSendWeb. This format is used for sending order data to ACE Hardware Corporation.

PO Update

The two (2) options provided are InvoicePOMatch and EDIINVOICESIMPLE. The first option, InvoicePOMatch, should be used in most cases. This matches a PO (purchase order) identifier in the data with a purchase order document allowing multiple PO documents to be updated by a single data file. The InvoicePOMatch also includes ACE bulletin numbers. The second option, EDIINVOICESIMPLE, does not match on purchase order documents and does not include the bulletin information.

PO Update Sort Order

This override is available for all EDI features. Choices include the following: None, ItemNumber, and Tote. Your selection determines whether purchase order details are to be re-ordered based on either the item number or tote when updated by EDI processing with receiving quantities and costs. In addition, the PO Update Sort Order selection is used by the Tags & Labels feature when copying a Purchase Order (using the Import (F2) function). If the override for sorting is set to anything other than None, the application retains the sort order of the purchase order's item details.

  • None
    Use the None selection to preserve the original order that the purchase order details were entered in . In this case, the details are not re-ordered by EDI processing.

  • ItemNumber
    Use the ItemNumber selection to sort the purchase order details by the application's item numbers (not the vendor-item SKU).

  • Tote
    Use the Tote selection to refer to the reusable shipping container with loose, incoming shipping merchandise from the vendor. It could also possibly refer to a pallet or other type of container. Use this only if the vendor provides reference to a "tote" in their PO Update data; the application can use this information to update the purchase order data (details).

The sorting preference is available to all EDI features; however, the option was specifically added for Do it Best® members. EDI with Do it Best Corp. does update and use the "EDI Tote" value for purchase order details. Other EDI providers may or may not provide this information with their data.

Price Updates

The overrides for Price Updates determine how "hot sheets" data is used to update your catalog, items, and pricing. The following options are provided: HS_FileMaint, Hotsheets_VP, HS_FileMaintNoDesc, HS_FileMaintCostOnly, and HS_FileMntCostOnlyND. Please see the table below for additional details:

Document Format

Description

HS_FileMaint

Price changes with Catalog and Item Maintenance. This updates catalog data as well as the following item (inventory) fields: description, UPC, discontinued flag, department, class, and fineline. Price changes include both sales and dynamic promotions (types 6 and 7). This also updates instant savings and promotional items in your inventory. ACE Rewards card information is also updated.

Hotsheets_VP

Variable Price hot sheets. This format is used for price updates and sale pricing only. No file maintenance is done and no ACE Rewards data is updated. A flag in the hot sheet data determines which of several ACE prices are used.

HS_FileMaintNoDesc

This is identical to the HS_FileMaint type except that inventory item descriptions are not updated (only catalog descriptions are).

HS_FileMaintCostOnly

This is identical to the HS_FileMaint type except that price changes only include cost. This assumes that the customer is basing their pricing off of cost or is using a third party tool such as Margin Master™, a product of RetailerSoft™ (http://www.retailersoft.com), to manipulate their pricing.

HS_FileMntCostOnlyND

This is identical to the previous type, HS_FileMaintCostOnly, except that inventory item descriptions are not updated (only catalog descriptions are).

File Maintenance

Not applicable (see Price Updates).

Send Remit Advice

Not applicable.

Retrieve Invoices

Not applicable.

Direct Ship PO

The only option provided is POSendWeb. This format is used for sending "direct ship" purchase order data to ACE Hardware Corporation.

Sale Flyer Update

POS Data Capture

No additional options provided.

Promotional Items

Not applicable. See the ACE Rewards documentation for additional information about ACE promotions.

Warehouse Qty

Not applicable.

Acknowledgment Send

Not applicable.

Acknowledgment Receive

Not applicable.

Catalog Load

No additional options provided.