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 . 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.
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.