Lot and Expiry Control Report [RPT008]

This report is used for companies running SYSPRO’s Lot Traceability module only to indicate what stock is about to expire, going to expire, or has no expiry date set. The operator will be able to make changes to the lot expiration date.

  • Enter a date range in the From Date and To Date field.

  • Select the Refresh icon to load the data grid.

  • Any stock item expiring within the selected date range, including expired stock items, will be displayed in red.

  • If you select “Show only 00/00/0000 Expiry Dates”, the detail grid will display only those items that should have expiry dates in SYSPRO that do not.

  • If you select “Show only expired stock,” the detail grid will display only those expired items. I.e., the expiry date is earlier than the Today’s date.

  • The detail grid can be filtered by Stock code or Lot number.

  • The SysproExpiryDate field is editable. If any dates need to be changed, make the change on the screen and click the “Update” button. This will update the expiry date for the selected lot number and stock code.

  • The detail grid can be exported to Excel and actioned accordingly.

Note:  This Report is very useful for the Quality Control Department to take action on aged stock.

 

SPECIAL FEATURES

  • None

TECHNICAL

  • None

SYSPRO REQUIREMENTS & Business objects used

  • None

REFERENCE

RPT008