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 calculate if the expiration date is not provided by vendor.
3.1 Item Card Setup
- Expiration Calculation (e.g. 1Y, 10M etc)
- Expiration Format (new field)
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.