BeyondERP.Newsletter
Menu

Job page · Inventory management

Update expiry dates

A periodic job that updates the expiration date of one or more inventory batches.

Business process
Manage inventory quality
Menu item
action:PdsUpdateExpDate
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic job that updates the expiration date of one or more inventory batches.
What you do hereUse this periodic task to recalculate batch expiration dates from the product's shelf life, or to set a fixed date.
Update expiry dates page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage inventory quality
Menu pathInventory management › Periodic tasks › Batches › Update expiry dates
Set up firstReleased products Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen batch expiration dates must change, for example after the Shelf life period in days of the product changed or a batch was found to expire earlier or later.
How oftenOn demand, when expiration dates need to change.
Batch settingsSet up the batch job only when many batches are selected.
What the output showsUpdated expiration dates on the selected batches. Master planning and reservation rules that use shelf life follow the new date, so an unexpected expired batch usually means a wrong manufacturing date or shelf life period.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Batches > Update expiry dates.
  2. In Data calculation type, select System to set the expiration date to the batch's manufacturing date plus the shelf life period in days, or Fixed to enter the date yourself.
  3. If you selected Fixed, enter the new date in Expiration date.
  4. Select Select and filter the batches whose expiration date should change.
  5. Select OK, then open the batches and check the new expiration dates; the batch is unusable after that date.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Data calculation typeWith System, the expiration date is the batch production date plus the shelf life period in days; with Fixed, you enter the date.Microsoft Learn
Expiration dateThe new expiration date to apply when the Fixed type is used.Microsoft Learn

Test checklist

  1. Selected batches show the new expiration date.
  2. Batches outside the filter keep their date.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, by running it again: Run the job again with the correct date or calculation type to overwrite the dates. Microsoft Learn
If you change it laterChanges the expiration date of the selected batches, which affects whether they can still be used, planned and sold. Microsoft Learn
Technical architect

5Technical

Menu itemaction:PdsUpdateExpDate Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itQuality control clerk InventQualityControlClerkShipping clerk InventShippingClerkPurchasing manager TradePurchasingManagerSales manager TradeSalesManagerWarehouse worker WMSWarehouseWorkerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=action:PdsUpdateExpDate
Everyone

7Sources