Do it Best - Mapping Overrides
Mapping Overrides provide options and preferences for EDI processing. The selections vary by vendor and not all are used with every vendor (options that don't 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 Marker .
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. Then application saves the changes when you choose Process (F12) in the Branch Setup form after making changes or additions from the Mapping Overrides dialog.
Submit PO
There are a number of PO (Purchase Order) formats available with Do it Best Corp. as described in the table below:
Format |
Format Type |
Description |
PO Send v.1.1 (DEFAULT) |
PO Send |
This is the default PO format and includes retail prices for each ordered item (by "retail" we mean "suggested list"). This sends the line number, vendor's item, quantity ordered, UM, retail price, and description along with other data. |
PO Send NORETL |
PO Send |
This is the same as the default PO format, but without retail prices (suggested list). This sends the line number, vendor's item, quantity ordered, UM, and description along with other data. |
IMCS Delete |
PO Send Alt Format |
No longer used. |
INVR Refill Order |
PO Send Alt Format |
This format is a refill order for items that have special dating. |
CF1W Claim Warehouse |
PO Send Alt Format |
An electronic claim for warehouse shipped policy A or B items. |
CF1D Claim Drop Ship |
PO Send Alt Format |
An electronic claim for drop shipped policy A or B items. |
PAR - Personalized Advance Rebate |
PO Send Alt Format |
This format is used for sending a list of rebate items for the PAR Personalized Advanced Rebate program. |
IMCS - Maintenance |
PO Send Alt Format |
No longer used. |
PO (Call For) |
PO Send Alt Format |
This format is used for "call for" orders (type 7 in the member PO header element). |
PO Ship Small Parcel to Store |
PO Send Alt Format |
This format is used for small orders of product that will be shipped independently (via UPS, USPS, FedEx, etc.). EDI processing sends the shipping method, speed, and warehouse using the EDI "reference" assigned to the purchase order (PO) header data. A dialog is presented when a user selects this option from the Process (F12) form's Transmit, EDI tab. The user can select a warehouse, shipping method, and shipping speed (standard, next day, 2nd day). From these selections, the "reference" field is set with the necessary delimited values (the reference is also shown on the EDI tab).
For example, the reference might be "01,Preferred,Standard" for a small parcel PO being shipped from warehouse 01, using the Do it Best preferred shipper, and standard delivery. |
PO Cust Direct Ship |
PO Send Alt Format |
This format is used for orders that will be shipped directly to the customer (via UPS, USPS, FedEx, etc.). EDI processing sends the shipping method, speed, and warehouse from the EDI "reference" assigned to the purchase order (PO) header data. A dialog is presented when a user selects this option from the Process (F12) form's Transmit, EDI tab. The user can select a warehouse, shipping method, and shipping speed (standard, next day, 2nd day). From these selections, the "reference" field is set with the necessary delimited values (the reference is also shown on the EDI tab).
For example, the reference might be "01,Preferred,Standard" for a small parcel PO being shipped from warehouse 01, using the Do it Best preferred shipper, and standard delivery. |
PO Update
There are two (2) options for updating purchase orders with receiving data: Default (POReceive) and POandAPReceive.
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
Two (2) options are provided for price updates: Default and Cost Update. The difference between the two (2) formats is that "Cost Update" only updates costs, not retail pricing. This is typically used when the dealer is using an independent tool to set their prices in place of the vendor's price updates. The "default" option includes both retail pricing and cost updates.
File Maintenance
File Maintenance updates three (3) types of data: catalog, vendor-item, and item. A variety of formats are provided. The legacy (old) formats should no longer be used.
Format |
Description |
FileMaint_NODesc |
Legacy (old) File Maintenance that does not change item descriptions in your inventory data. |
FileMaint_Classic |
Legacy (old) File Maintenance that always brings in "classic" cost (rather than vision cost). |
FileMaint_Classic_ND |
Legacy (old) File Maintenance that always brings in Classic Cost and does not change item description in inventory data. |
FileMaintNEW |
New File Maintenance that updates the cost UM for vendor-items. |
FileMaint_NODescNEW |
New File Maintenance that updates the cost UM for vendor-items, but does not change item descriptions in your inventory data. |
FileMntClassicNEW |
New File Maintenance that updates the cost UM for vendor-items and always brings in "classic" cost (rather than vision cost). |
FileMntClassicNDNEW |
New File Maintenance that updates the cost UM for vendor-items, always brings in "classic" cost (rather than vision cost), and does not change item description in inventory data. |
FileMaint_ND_NEWKW |
New File Maintenance that updates the vendor-item cost UM and doesn't update item descriptions in inventory data. In addition, it sets both the item's Keyword0 value and the manufacturer in the catalog to the Vendor Number instead of name. |
FileMaint_NEWKW |
New File Maintenance that updates the vendor-item cost UM and sets both the item's Keyword0 value and the manufacturer in the catalog to the Vendor Number instead of name. |
FileMntClassNDNEWKW |
New File Maintenance that updates the vendor-item cost UM, always brings in "classic" cost (not vision), and doesn't update item descriptions in inventory data. In addition, it sets both the item's Keyword0 value and the manufacturer in the catalog to the Vendor Number instead of name. |
Send Remit Advice
Not applicable.
Retrieve Invoices
Not applicable.
Direct Ship PO
These overrides match those used for the "Submit PO" options listed earlier.
Sale Flyer Update
Not applicable.
POS Data Capture
Sends retail sales data (based on Point of Sale activity) to Do it Best Corp. There are three (3) selections: Default (POS Data AVG Cost), POS Send Retail Sales (Market Cost), and POS Data Last Recpt. The only distinction between the three (3) choices is the type of cost being sent with the data. Average cost (aka. weighted average) is sent with the default format. The other two (2) options send either the "current market" cost or "last receipt" cost.
Promotional Items
Not applicable.
Warehouse Qty
Not applicable.
Acknowledgment Send
Not applicable.
Acknowledgment Receive
Not applicable.
Catalog Load
No additional options provided.