2) Expiration Date Format
- add field in Item Card and WH Receipt Line
- value in WH Receipt Line default from Item Card
- field property - Option
- Option including Exact Date / Beginning Of Month / End of Month
3) Auto Setup formula in Item Card for allow system auto to calculate if the expiration date is not provided by vendorin m-In when WH Receipt.
3.1 Table of Contents
Item Card Setup
New fields added in Item Card - Tracking tab
1) Expiration Calculation
Enter the Date Formula (e.g. 1Y, 10M 36M etc)
- Expiration Format (new field)
for calculate the expiration date base on the Manufacturing Date
2) Expiration Format
Option including Exact Date / Beginning of Month / End of Month.
- calculate the expiry date specific product line
- calculate the expiry date (e.g. 01/MM/YYYY 月頭 or 30/MM/YYYY 月尾) on specific product line
- Exact Date = system calculate the Expiration Date according to the Manufacturing Date+Expiration Calculation formula.
- Beginning of Month = system calculate the Expiration Date then convert to the 1st day of the month (e.g. result = Jun 12, 2020 => Jun 01, 2020).
- End of Month = Same logic with the option Beginning of Month but the Expiration Date to be the last date of the month.
4) Validation
System check if the expiry date is earlier then the existing inventory then prompt message for alert user.