Expiring Inventory Overview – Fenwick Support

Expiring Inventory Overview provides a matrix style view of expiring inventory by date, with filters to narrow down the search.

Screen_Shot_2022-07-27_at_16.25.32.png

Filters

Row Value	Description
Type	Specifies the type of the relevant expiring inventory.
Item No. Filter	Specifies the Item No. filter.
Item Category Filter	Specifies the Item Category filter.
Invt. Post. Group Filter	Specifies the Inventory Posting Group filter.
Location Filter	Specifies the Location filter.
Date Filter	Specifies the Date filter.
Sales Budget Name	Specifies the sales budget to use when calculating the allocated budget quantity.
Sales Budget Start Date	Specifies the date used when calculating the allocated budget quantity.
Show Value as	Specifies if the item values are shown as quantity or cost amount.
View by	Specifies the period which amounts are displayed.
View as	Specifies how amounts are displayed.
Show Expired Items Only	Specifies if only items with expired inventory are shown.
Show Column Name	Specifies if names of the columns are shown.
Inventory	Actual stock on hand.

Row Value	Description
No.	Specifies the item no.
Description	Specifies the item description.
Inventory	Specifies the current inventory of the item.
Expired Inventory	Specifies the expired inventory up-to the date filter date.
Remaining Columns	Specifies the expiring inventory during that period.