eSuite – Item Tables – Cost

Information

The eSuite software uses relational tables to store item information. The Cost table contains all cost information, such as vendor, base cost, unit cost, discounts, etc., for the item. The eSuite software uses the Cost table to retrieve information for purchases, inventory and accounting purposes.

The Cost table may contain multiple records for the same item, based on regional and/or vendor differences. This way, a head office can control regional (target) cost differences for items. To find a cost record for the main item, the eSuite software uses a unique key made of four fields: the main item UPC, the target, the format and the vendor ID.

This flexible combination means two things for every item:

• Every UPC can have as many cost records as there are vendors to purchase it from 
• Each vendor can have as many records of varying costs as there are targets (stores/regions)

Display the Cost table

Follow these steps:

The Cost table is available from the following eSuite modules: Care, Batch, Manage, Buy and Sell.

1. In the launcher, click on Items to expand its menu. 
2. Click on Master to open the Items start menu.
   
3. From the Items start window, click on Items.
   
4. Enter the search criteria in the Items wizard.
   
5. Click on Execute.
6. In Items - General List, select a record.
7. Click Edit in the bottom menu to display the options.
   
8. Select Master tables, then Cost master.
   
9. The Cost table is displayed.
   
   
   NOTE: You can also display the Cost table by right-clicking on an item in the grid and selecting Master tables > Cost master or from the Item views menu in the Context tools.

Add a cost record

To add a cost record:

1. Open the Cost table.
2. Click on Add in the toolbar.
   The new Cost table is displayed.
   
3. Enter a value in the Vendor ID field (required).
4. Enter all the other needed information.
5. Click  Save in the toolbar or press Enter on your keyboard to save the changes.
6. The new cost record is displayed.
   
7. Modify as desired and deploy changes when done.