Purchase Price Table
Retrieves the direct unit cost from the Last Direct Unit Cost field on the item card, but you may also need to set up some individual purchase prices for items. You do this in the Purchase Prices window, which you find by clicking Related Information, pointing to Purchases, and then clicking Prices on the item card.
In the Purchase Prices window, you can specify the conditions for a special direct unit cost for a specific item when quotes, orders, invoices and credit memos are set up. For example, the conditions can require that you buy a certain quantity or that the invoice is in a particular currency. They can also contain a starting date and an ending date, between which the purchase price is valid, and they can contain a specific unit of measure code. You can also define a combination of the conditions under which the purchase price applies. You can set up several purchase prices for each item, but each must have a different set of conditions.
When you enter an item on an invoice, for example, the program automatically looks in the Purchase Price table to see whether it contains a purchase price for the item. If it does, the program checks whether the starting date has arrived and the ending date has not. If the conditions are met, the program will enter the purchase price in the Direct Unit Cost field on the invoice. If not, the program will check the last direct unit cost on the stockkeeping unit card and use that. If this does not exist, it will use the last direct unit cost on the item card.
List of Fields in the Table
To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.
| Field | Location |
|---|---|
| Unit of Measure Code Field, Purchase Price Table | Purchases and Payables |
| Ending Date Field, Purchase Price Table | Purchases and Payables |
| Starting Date Field, Purchase Price Table | Purchases and Payables |
| Vendor No. Field, Purchase Price Table | Purchases and Payables |
| Minimum Quantity Field, Purchase Price Table | Purchases and Payables |
| Direct Unit Cost Field, Purchase Price Table | Purchases and Payables |
| Variant Code Field, Purchase Price Table | Purchases and Payables |
| Item No. Field, Purchase Price Table | Purchases and Payables |
| Currency Code Field, Purchase Price Table | Purchases and Payables |
See Also
Reference
Other Resources
How to: Define Purchase Prices
Record Purchase Price, Discount, and Payment Agreements