Setup formula in Item Card for allow system auto to calculate if the expiration date in m-In when WH Receipt.
Table of Contents
Item Card Setup
New fields added in Item Card - Tracking tab
1) Expiration Calculation
Enter the Date Formula (e.g. 1Y, 36M etc) 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.
