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

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

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

Select_Warehouse_Code_Shipping

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

Select_Warehouse_Code_Shipping

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. The "POandAPReceive" automatically creates payable invoices when a purchase order is updated.

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.