BeyondERP.Newsletter
Menu

Report page · Inventory management

Shelf advice as of date

A report that shows batch shelf advice information, run from a dialog where you choose the output destination and the records to include.

Business process
Manage inventory quality
Menu item
output:PdsInventBatchShelfAdviceReport
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 report that shows batch shelf advice information, run from a dialog where you choose the output destination and the records to include.
What you do hereUse this report to review the shelf advice dates of batches in physical inventory.
Shelf advice as of date 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 › Inquiries and reports › Physical inventory reports › Shelf advice as of date
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 you review batch-tracked stock for batches that are due for a shelf advice check.
How oftenOn demand, for example before planning quality checks on stored batches.
What the output showsBatches in physical inventory with their shelf advice dates. A batch without a date usually belongs to a product without a Shelf advice period in days, or has no manufacturing date.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Physical inventory reports > Shelf advice as of date.
  2. Make sure the products have a Shelf advice period in days. A batch's shelf advice date is its manufacturing date plus that period.
  3. Expand Records to include and filter on the items or batches you want to review, for example one item number.
  4. Run the report and look for batches whose shelf advice date has passed or is close, so they can be checked for consumption or resale.
  5. If quality orders are generated when batches approach their shelf advice date, compare the list with the open quality orders.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The shelf advice report only reads batch data; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:PdsInventBatchShelfAdviceReport Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:PdsInventBatchShelfAdviceReport
Everyone

7Sources