Component Price Table¶

There is a more sophisticated way of picking up prices.
We hold a new table in the system (Pricing > Component Price Table) that holds the following fields:

The table contains a Stock Item, ‘Customer’ or ‘Price Type’, ‘Quantity’ and ‘Price’ to the table ‘Stock Price’.

Order Processing > Order > Component Detail Entry

When you selected a component here, the price was not being found properly.
It now looks in Stock Setup > Stock Items > Selling Price, and then looks in Pricing > Component Price Table to see if there are any prices there.
When you are doing a lookup here to add a new record, the stock code lookup is now working properly – previously stock items were missing.
Administration > Users >* Permissions*

The option 'Component Price Table' was missing from permissions – it is now there.

Component Discount % by Category

It is now possible to calculate component discount % by category when entering a component detail line.
There is also a start date and end date for when these discounts apply.

We have created a new discount table by category code for component sales. The table contains id, category code id, discount %, start date and end date.
This table will be accessed in Component Detail Entry and will use the discount %, if found, for the category code that is held against the stock item that has been selected.
The new form for this is in Pricing below ‘Component Price Table’.