Stock valuation by period

• Stock site (field STOFCY)

Enter or select a site.

• Product (field ITMREF)

Enter or select a product for Site selected. This is optional.

If you enter a product, the Valuation method field defaults to the method assigned to this product.

If you leave this blank, the query results include all products with selected Valuation method.

• Valuation method (field VLTCOD)

If the Product field is blank, enter or select a valuation method code to include all products in the selected Site assigned to this valuation method.

If you enter a Product, this field defaults to the valuation method assigned to the product. You still have the option to enter a different valuation method if, for example, the selected product changed valuation methods during the period and you want to see values for the prior valuation method.

• Currency (field CUR)

This field displays the site currency and cannot be changed.

• From lot (field LOTF)

Enter a lot number or a range of numbers in the From lot and To lot fields. Only active lots display in the selection list. When running the query, there is a separate record for each lot number in the results grid.

These fields are only available if the Valuation method is Average lot cost (ALC). Otherwise they are greyed out.

• To lot (field LOTT)

• Fiscal year (field FIYNUM)

Enter or select a fiscal year, open or closed. This field defaults to the current year.

• From period (field PERF)

Enter a period or range of periods within the selected fiscal year. Periods can be open or closed.

• To period (field PERT)

• Start date (field DATES)

This field displays the start date for the selected Period.

• End date (field DATEE)

This field displays the end date for the selected Period.

• Period end (field PEREND)

This field displays the selected period end date for all valuation methods.

• Product (field ITMREF)

This field displays the product code based on the selection for all valuation methods.

• Description (field ITMDES)

This field displays the description for the product on the line for all valuation methods.

• Major version (field ECCVALMAJ)

This field only displays if the selected product has an associated Major version record.

• Minor version (field ECCVALMIN)

This field only displays if the selected product has an associated Minor version record.

• Receipt date (field RCPDAT)

This field displays each layer if FIFO or LIFO is the selected valuation method.

• Chronological costs (field CSTCOU)

• Lot (field LOT)

This field displays if LOT AUC is the selected valuation method.

• Sublot (field SLO)

• Beginning std. cost (field STDCSTSTR)

This field only displays if STD or Revised standard is the selected valuation method.

• Ending std. cost (field STDCSTEND)

• Beginning avg. cost (field BEGAVC)

This field only displays if Cumulative AUC or LOT AUC is the selected valuation method.

• Ending average cost (field ENDAVC)

• Beginning base qty. (field BEGBASQTY)

This field displays for all valuation methods.

• Beginning base amt. (field BEGBASAMT)

• Period receipt qty. (field PERRCPQTY)

• Period receipt amt. (field PERRCPAMT)

• Period issue qty. (field PERISSQTY)

• Period issue amt. (field PERISSAMT)

• Value change quantity (field PERVALCHGQ)

This field displays if FIFO, LIFO, or LOT AUC is the selected valuation method.

• Value change amount (field PERVALCHG)

This field displays for all valuation methods.

• Total not absorbed (field PERAMTDEV)

• Ending base quantity (field ENDBASQTY)

• Ending base amount (field ENDBASAMT)

• Val. method change (field VALMTHDCHG)

This field only displays if a valuation method change is detected during the selected period. It is not dependent on the method selected for the query.