Do It Best: Drop Ship

Efficient inventory management allows clients to spend more time with customers while maintaining clean inventory data. To this end, Paladin can now process Do It Best (DIB) drop ship invoices, also called Direct Ship invoices. Direct Ship invoices are created when a store orders items that are drop shipped from another supplier but invoiced through Do It Best. 

Most parts in the Direct Ship invoice specify a DIB SKU, but some may not. In these cases, a new part is created with the new supplier specified instead of DIB. The manufacturing part number is used for the Paladin part number in these cases.

For Do It Best (DIB) Drop Ship, an additional file will be processed during EDI. This file is the Direct Invoice file DIRINVC_010. Not all stores will get this file from Do It Best: “This will be an optional agreement with the member.” Stores must contact Do It Best for specifics and process to complete the agreement.

Once stores have agreement with DIB, Process drop-ship invoices is enabled for processing the file in Paladin.

To set up this:

1. In Paladin, from the main menu, select File > Setup.
2. Select the Suppliers tab.
3. In the Suppliers pane, check EDI Supplier Services.
4. In the EDI System Choice pane:
   1. Select Do It Best from the EDI System Choice list.
   2. Check Process drop-ship invoices.
   3. Select the store’s correct warehouse from the DIB RSC Code list.
   4. In the DBI API Subscription Key box, enter the key provided by DIB. 

Figure 1: DIB drop-ship settings

4. At the bottom of the Suppliers pane, click More.
5. In the Additional Fields pane, enter the Vendor Number. 

Note: The Direct Invoice specifies a DIB Vendor that the shipment is coming from. When the file is processed, a new Paladin Supplier is created with the Vendor Number field showing the DIB Vendor number. 

Figure 2: Vendor Number

6. Click Save, then click Close.

For the Direct Invoice file DIRINVC_010 file to be downloaded and processed:

1. In Paladin, select the Inventory module.
2. On the bottom ribbon of the module, select F9 EDI.
3. In the EDI Processing window, click Download Files.

Figure 3: EDI Processing

4. When the EDI run is done, press Reporting  The EDI Reporting window opens.
5. Click the magnifying glass to open a report.

Figure 4: EDI Reporting window

In the report, Retail One is the retail price of the part instead of the Price specified in the EDI file. Direct Invoice files do not specify price, regular Invoice files do. If the part does not already exist in Paladin, the Retail price is calculated from Cost (which is specified in the Direct Invoice file) using a default margin specified in Paladin Configuration’s Company tab.

Figure 5: Retail One as retail price