True Value Electronic File Maintenance (EFM)

 

True Value Electronic File Maintenance (EFM) allows you to electronically receive and add inventory changes, new items, and updates to your True Value electronic catalog.

Because the catalog update can take many hours to process, this procedure is typically run when the store is closed.

 

This job aid assumes that you have completed all the set up steps required to receive EFM. For more information, refer to online help. From the Contents tab, open the Vendor-Specific Procedures book, open the True Value book, then open the True Value Telecommunications book.

 

1

Receive EFM data

  1. From the Eagle Browser, click Applications and then click True Value Telecommunications Menu. From the list that displays, click Receive File Maintenance (EFM). The Electronic File Maintenance report window displays.

  1. If you have set up a Default Report Profile for this report, you can simply click Run to use the defaults. Or, you can retrieve a saved report, make any necessary changes, and click Run. Otherwise, continue with the next step.

  2. In the Control Stream box, accept the default of COTEFM, or enter your control stream name for EFM.

  3. Multistore: The control stream should have been set up for store 1 (with store 1's member number in the control stream). You do not need an EFM control stream for each store.

  4. Click the following (in the left pane of the window) and then fill in the fields that display:

  5. Print Setup

  6. Options

  7. User Codes

  8. Existing Items

  9. New Items

  10. Incl/Excl Dept

  11. Price Change

Multistore:  Note the following with regard to the Store field on the Price Change screen:

  • If you price your True Value merchandise the same across all stores, blank out the Store field on this screen. This means that a price change record will be added for every store where the item received exists in inventory. (Note: if the "Keep Prices The Same In All Stores" option in Options Configuration is Y, you MUST blank out the Store field on this screen.

    • If you don't keep prices the same across stores (the "Keep Prices The Same In All Stores" option in Options Configuration is N), this means that a price change record will be added for the store you enter in this field.  Be sure to run EFM for each applicable store.

  1. Click Run.

 

2

Check transmission status

In a few minutes, the call to True Value is complete.

  1. From Network Access, at the Function prompt, type ASYMSG and press <Enter> to display the Async Transmission Log.

  2. You may need to press <Next Item> to view the correct section of the log. Review the log to verify a successful transmission.

  3. Press <End> to exit the screen.

The message MCS Transmission Succeeded, does not necessarily indicate that you successfully downloaded the information you requested. This message merely indicates that your computer and the True Value computer made contact successfully. Look a few lines below this message and you will see either Successful Transmission or Unsuccessful Transmission. If the transmission was successful, the number of files received and the beginning and ending sequence number are also noted.

Check the right-hand column of the log for transmission results:

  • Successful Transmission means you successfully received the information you requested.

  • Unsuccessful Transmission means that you made contact with True Value's computer, but you did not receive the information you requested. This error typically means the sequence number in Function COTUTL is incorrect. Call True Value at 800-828-3658 for the correct sequence number.

  • Transmission Failed means that your computer did not make contact with the True Value computer. Look for an error code. Call the Epicor Advice Line and tell them the error code you received.

 

 

3

Review transmission reports and EFM Viewer

See the transmission reports that print (or spool) after the transmission has completed. Also see the True Value EFM History Viewer to review Changes to F Pack, Closeout Items, Discontinued Items, Item Substitutes, and To Be Discontinued items. You access this viewer by typing EFMHV from the Eagle Browser Launch bar.

 

4

Finalize price changes

Review and finalize price changes received with an EFM transmission like you would any other price changes. From the Item Price Changes (IPC) window, review (change or delete) the changes.

When you are ready to finalize the price changes, run the Price Change Report (RPC) with Option F to finalize and move the price changes to your Inventory file.

 

5

Finalize file maintenance changes

File maintenance records received with an EFM transmission are available for review (change or delete) in the Flexible Inventory Load (FIL) window.

Use the Flex Name COTEFM to review changes to items that already exist in your Inventory file. Use the Flex Name COTNEW to review the new items not yet in your Inventory file.

As you review items, you can make changes to the fields that display in COTEFM or COTNEW. Locate the item in the grid, click the field you want to change, type the new information, and click <Change>.

Use the Flexible Inventory Loading Report (RFL) to print an edit list of the items in COTNEW or COTEFM. When you are ready to finalize the changes, run the RFL report with Options FXY to finalize and move the updates to your Inventory file.