Receiving Electronic File Maintenance (EFM) from Do it Best Corp.

Use the following procedure to receive File Maintenance (EFM) from Do it Best Corp. This procedure assumes you have completed all EFM setup.

If you have the Do it Best electronic catalog on your system, it is updated by the EFM process. While the transmission to Do it Best to retrieve EFM is brief, it may take many hours for the system to process the catalog updates. Thus, EFM is typically run when the store is closed in a weekly queue.

Multistore: You must receive EFM data for each store on your system. Be sure to lock in to the store for which you want to receive data before continuing with this procedure. You can check or change the "Lockin Store" by clicking the Store button on the toolbar of the Eagle Browser.

Receiving File Maintenance

This procedure assumes you have already completed telecommunications setup.

1. From the Eagle Browser, enter EFM in the Launch bar and press Enter.

Alternatively, you can click on the Do it Best Telecommunications Menu, and then select Receive File Maintenance (EFM).

2. In the Item File Maintenance window, in the Control Stream field, enter the name of your EFM control stream, or leave the default if your control stream name is HWIEFM.

3. Click . Review the default entries in the fields and make changes if needed.

4. Click and select the vendor code you use for Do it Best from the drop-down list.

5. Click . Select Yes or No to update user codes. If you select Yes, use the bottom portion of the page to enter the letters of the user codes you want to update. You must use only one User Code group but you can update any position in the group. In the example below, all four user codes (D, U, K, and T) are being updated in the Exp Codes A group.

6. Click . Fill in the fields on the screen.

   7. Update Existing Items

      Select Yes or No to update existing items in your inventory. If you select Yes, use the bottom portion of the page to select which fields you want to update.

   8. Options

      Enter the option(s) you want to use when updating Function FIL (Flexible Inventory Load) with EFM data for existing items in your Inventory File.  

      A = Update Function FIL with EFM data even if your primary vendor for the item does not match the code you specified in the Vendor Code field.

      Z = Print items that are not in your Inventory File on the Transmission Report. Note: Option Z can include thousands of items on the report. If you use Option Z, spool the report so you can review it in Spooled Report Maintenance (MSP) before you print it.  

      blank = Do not update Function FIL with EFM data if the primary vendor field items whose vendors do not match.  

   9. Fields to Update

      If the Update Existing Items field is Y, this field is required.

      Enter the option letter(s) for the EFM data fields you want to update in Function FIL (Flexible Inventory Load).     

      A = Update all fields.

      B = Update catalog page.

      C = Update class code.

      D = Update department code.

      E = Update description.  

      F = Update discontinued flag.   

      G = Update fineline.

      H = Update manufacturer part number.

      I = Update manufacturer vendor.

      K = Update purchase unit of measure

      M = Update stocking unit of measure

      N = Update weight.   

      O = Update UPC. If you use this option, you must run Report RAP after running Report RFL.

      Q = Update manufacturer vendor cost

      S = Update order multiple and standard pack          

   10. FIL Posting Flag Default

       Indicate your default value for the "Add/Change Item in IMU" field in Function FIL (Flexible Inventory Load).                  

       Y = Set the Function FIL field to Y for all EFM data.

       N = Set the Function FIL field to N for all EFM data.        

       Enter Y if you add most of the EFM data to your Inventory File. Enter N if you do not add most of the EFM data to your Inventory File. You can override this field on an item-by-item basis in Function FIL.

7. Click . Fill in the fields on the screen.

   • Add New Items

     Select Yes or No to add new items to your inventory. If you select Yes, fill in the other fields below.

   • Use Default Dept for All

     For all new EFM items, indicate if you want to update Function FIL (Flexible Inventory Load) with the department code you specify in the Default Dept field.                            

     Y = Use the department code entered in the Default Dept field for all new items.  

     N = Use the Epicor translation of departments. If the department does not exist in Department Maintenance (MDE), use the code entered in the Default Dept field.

   • Default Dept

     Enter a default department code.

     The system uses this code if:  

     • You enter Y in the Use Default Dept For All field.    

     • You enter N in the Use Default Dept for All field and the department on the item is not in Department Maintenance (MDE).

   • FIL Posting Flag Default

     Indicate your default value for the "Add/Change Item in IMU" field in Function FIL (Flexible Inventory Load).                  

     Y = Set the Function FIL field to Y for all EFM data.

     N = Set the Function FIL field to N for all EFM data.        

     Enter Y if you add most of the EFM data to your Inventory File. Enter N if you do not add most of the EFM data to your Inventory File. You can override this field on an item-by-item basis in Function FIL.

   • In Stores

     If the Add New Items field is Y, this field is required. Enter the stores for which you want to add new items. Enter a list of store numbers, such as 1234, or enter an * (asterisk) to indicate all stores on your system.

     You can override this field on an item-by-item basis in Function FIL (Flexible Inventory Load).

EFM will not run unless you select Yes to Update Existing items or to Add New Items (or both). You cannot answer No to both.

8. (Optional) Click  . If you selected Yes to Add New Items in the previous step, use this page to include or exclude items from certain departments. For example, if you want to exclude items from departments 4, 6, and 8 from being added to your inventory, set the "Include/Exclude Depts" field to E, then enter 4, 6, and 8 in the fields below.

9. Click . Fill in the desired options. Do not use the INFOPLUS options unless you have the INFOPLUS software. If you are not set up to receive the INFOPLUS records on Do it Best's system and you use this option, the records that get transmitted will not process on your system.

10. Click . Fill in the desired options. In the Vendor Code field, be sure to select your vendor code for Do it Best.

11. If you use Order Confirmation, click . Select Option S to save the Order Confirmation file to use for ERP, and select any other desired options on the page.

12. Click . The Date Last Updated field is automatically filled in with the date you last ran EFM. You can optionally select a different date.

13. Click Run to initiate the transmission, or click Queue (F7) to add EFM to an end-of-day queue.

14. Give the transmission a few minutes to process, and then check the transmission results in ASYMSG.

The transmission reports print when the transmission process completes.

Submit Your Comments on This Help Topic

Trademark Information