Purchases (LCY) Field, Item Table

Contains the total purchase amount, in LCY, of the item that has been purchased.

The program automatically calculates and updates the contents of the field, using the Sales Amount (Actual) field in the Value Entry table for those entries that have been posted as purchases.

You can filter the Purchases (LCY) field so that its contents are calculated only on the basis of one or any combination of the following:

• Global Dimension 1 values

• Global Dimension 2 values

• dates

• locations

• item variants

You can also set a filter in the Drop Shipment Filter field so that the contents of the Purchases (LCY) field are calculated on the basis of the items that were ordered as a drop shipment.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table	Location
Negative Adjmt. (LCY) Field, Item Table	Inventory
Item Table	Inventory
Item Table	Inventory

See Also

Reference

Item Card

Other Resources

How to: Set Up Items
Entering Criteria in Filters