Sales (LCY) Field, Item Table

Contains the sales amount, in LCY, of the item that has been sold.

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 sales.

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

• Global Dimension 1 values

• Global Dimension 2 values

• locations

• dates

• item variants

You can also set a filter in the Drop Shipment Filter field so that the contents of the Sales (LCY) field are calculated on the basis of the items that were shipped 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