BeyondERP.Newsletter
Menu

Job page · Inventory management

Update best before dates

A periodic job that updates the best before date of one or many inventory batches.

Business process
Manage inventory quality
Menu item
action:PdsUpdateBestBefore
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 best before date of one or many inventory batches.
What you do hereUse this periodic task to recalculate or set the date by which batches should be used.
Update best before 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 best before dates
Related pagesBest before as of date 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 the best-before date of batches must be recalculated, for example after the Best before period in days of a product changed, or set to a fixed date.
How oftenOn demand, when best-before dates need to change.
Batch settingsUse the Batch tab only for large selections of batches.
What the output showsUpdated best-before dates on the selected batches. A batch is still sellable after this date but may have lost some original properties. A date that looks wrong usually means the batch's manufacturing date or the item's period is wrong.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Batches > Update best before dates.
  2. In Data calculation type, select System to calculate the date from the item's Best before period in days, or Fixed to set the same date for every selected batch.
  3. If you selected Fixed, enter the new date in Best before date.
  4. Select Select and filter the inventory batches to update, for example on item number.
  5. Select OK, then open the batches and check the new best-before dates.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Data calculation typeWhether the date is calculated by the system from the expiration date or set to a fixed date.Microsoft Learn
Best before dateThe new best before date to apply when the Fixed type is used.Microsoft Learn

Test checklist

  1. Selected batches show the new best-before date.
  2. Batches outside the filter are unchanged.

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 best-before date on the selected batches, which reports use to find inventory past its best-before date. Microsoft Learn
Technical architect

5Technical

Menu itemaction:PdsUpdateBestBefore 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:PdsUpdateBestBefore
Everyone

7Sources