Establishing Levels of Prices Schedules Home | FAQs & Troubleshooting

 

You can establish three levels of price schedules:

• By vendor number

• By vendor number and product line

• By vendor number and item code

Price level by vendor number and item code is applicable for only a specific inventory item purchased from the vendor. Price level by vendor number and product line is applicable for all inventory items within the specified product line. Price level by vendor number (without specifying item code or product line) is applicable for any inventory items purchased from the vendor.

Each time a specific item code is entered in a data entry field, the unit cost is calculated automatically, based on the applicable vendor price level and the quantity entered. The applicable price level is checked in the following order.

1. The price level by vendor number and item code, price level by vendor number and product line, and price level by vendor number are checked first.

2. The last cost on the Item and Vendor file is checked next, if zero cost then;

3. If a vendor price level is not established for the vendor, the valuation method from the Inventory file is used to determine the unit cost.

For more information, see Vendor Price Level Maintenance.