Receiving Electronic Invoices (ERP) from Do it Best

Use this field to specify how you want the system to calculate retail prices. (Use the Update Prices options of RRP to specify how you want the system to calculate cost.) The following options are available:  

Blank = Do Not Post Retails. This keeps the prices that are currently in your system. 

1 = Calculate Retails Based on Cost Changes. This recalculates a new retail based on the Desired Gross Profit % from Inventory Maintenance, and the new cost.

2 = Post Only Regular Retails (Exclude Temporary Retails).

3 = Post Regular Retails and Temporary Retails.  Posts IMCS (Inventory Management Control System) retails.

Use this field to specify how the system calculates retail prices. This field is relevant only if you selected Retail Posting option 1.

Note: the system always updates the PO with the invoice cost. You determine whether to update your inventory with the invoice cost when you finalize your receipts (Receiving Report--RRP).

C = Calculate retails or items with a temporary cost (for example, items you order on promotion, whose cost is different from the regular cost). The system calculates retails based on the Desired Gross Profit % (Inventory Maintenance Pricing tab) and the temporary cost.

If you use this option, the system calculates retails for items with a temporary cost. If you do not use this option, the system calculates retails for items with regular cost changes. Items with temporary costs keep their current retail price.

D = Calculate retails for items with decreased cost. The system calculates retails based on the Desired Gross Profit % (Inventory Maintenance Pricing tab) and the new cost.

If you do not use this option, retails will not change when the cost decreases.

A = Ignore Invoice Validation Failure. This option is used when you get the error "invoice has already been reconciled and cannot be processed."

Option A forces the invoice to reconcile/post against the PO even if you have already attempted to reconcile the invoice previously. Be sure that the PO has not already been finalized and your quantities have not been updated before using this option, or else you will risk double-posting the invoice.

I = Suppress Items Added To Inventory Section.  If you enter Y in the Add Items to Inventory field, use this option if you want to suppress the printing of the added items.

K = Suppress Printing of Cost Changes of Less than One Penny. If the difference between the old cost and the new cost is less than one penny, don't print the change in the Price Change Exception section. For example, the old cost is $2.26, and the new cost is $2.255. Since the cost change is less than one penny ($.005), it doesn't print in the Price Change Exception section. The system still changes the cost on the PO, even though the changes don't print in the Price Change Exception section. You can't use option K with option L because they suppress the same items.

L = Suppress Printing of Price Changes of Less than 10%. If the difference between the old price (cost or retail) and the new price is less than 10%, don't print the change in the Price Change Exception section. For example, the old cost is $.41. The new cost is $.37. Since the cost change is less than 10% (7%), it doesn't print in the Price Change Exception section. The system still changes the price on the PO, even though the changes don't print in the Price Change Exception section. Price changes that are greater than 10% print on the report. Asterisks (***) print next to the price of these items. This option reduces the size of the Price Change Exception section. You can't use this option with Option K because they suppress the same items.

N = New Page for Each Exception Type. Each exception section will start on a new page.

P = Suppress Printing of Promotional Price Changes.  The detail of the Promotions Section will not print, but the total number of items in the Promotion Section will print.  Temporary items with no price change will not print in the Price Change Section.

X = Suppress Extra Items Section. Extra Items Section will not print. If you use a blank PO to post to, you may want to use this option. Otherwise, everything on the PO will print as an extra item.

A =  Ignore Invoice Validation Failure. Do not use this option unless told to do so by an Epicor representative. This option is used when you attempt to reconcile an invoice a second time. This option forces the invoice to reconcile even though the system has already marked the invoice as reconciled.

Y = Prompt for EX Filename. Do not use this option unless told to do so by an Epicor representative. This option is used to reconcile a specific invoice that has already been downloaded to your Eagle system. When you use option A and Y together, you will be prompted to enter a pathname of the invoice you wish to reconcile (such as SRTP/EXH0601). Your Epicor representative will give you the pathname to enter.

Multistore: Since you are locked into the correct store, leave the default value in this field.

Enter N in this field, because the transmission has already taken place when you ran EFM.

From the drop-down list, select your vendor code for Do it Best.

Enter the purchase order you want to reconcile. The system uses the PO you enter to match SKU, quantity, cost, and pricing information to the invoice. If you created a PO in the Purchasing and Receiving window and want to append the detail lines of the filled invoice items, enter the PO number of the PO header in this field. The PO you enter must exist in the Purchasing and Receiving window.

Specify whether you want the system to resequence the target purchase order.

Y = Resequence the target PO in invoice/line number order. This option makes it easier to reconcile to the invoice.

N = Keep the items on the PO in their current order.

If you do not resequence the PO now, you can use Function POR (Purchase Order Resequencing) to resequence it later.

Specify whether you want the system to add filled items that are on the invoice but do not match to any items on the PO(s).

Y = Append (add) extra items to the target PO. (note: if you use a blank PO to post to, use this option.)

N = Do not append extra items to the target PO. If you use this option, you must manually add any extra items to the PO in the Purchasing and Receiving window.

A = Append extra items to the target PO even if the vendor of the items doesn’t match the PO’s vendor.

This field determines if the Quantity on Order field in Inventory Maintenance is updated when items are appended to a purchase order.

This field only applies if the Append to Target P.O. field is set to Y.

The following options are available:

Y = The Quantity on Order field in Inventory Maintenance is updated with the appended quantity.

N = The Quantity on Order field in Inventory Maintenance is not updated with the appended quantity.

Use this option if you want ERP to add new items automatically to your inventory file. When you download the electronic invoice file, items downloaded that do not exist in the inventory file but do exist in your Epicor Eagle Catalog for Windows will be added to the inventory file. Once added to the inventory file, the items will be added to the target purchase order. The added items will print in the "Extra Item Added" section of the ERP Exception Report. Exception Report option, "Suppress Items Added To Inventory Section," is available to suppress the printing of the added items.