Item Planning Review allows you to customize which entry types are considered from item ledger entries when calculating usage.
The default entry types considered are:
- Assembly Consumption
- Assembly Output
- Consumption
- Output
- Negative Adjmt.Sale
- Sale
As a Filter String:
WHERE(Entry Type=FILTER(Assembly Consumption|Assembly Output|Consumption|Output|Negative Adjmt.|Sale))
Change the entry types considered when calculating usage:
- Navigate to Item Planning Review Setup in Business Central.
- Locate the Advanced section and select Show More.
- Select the … button on the Item Ledger Filter
- Add a filter for Entry Type.
- Close the Filter Page and close the Setup
How this works:
If you have any filter on the item ledger entry, it is applied first before setting other filters.
If you have included a filter on the Entry Type field, only that filter is used for the Entry Type when calculating average usage.
If you do not include a filter for Entry Type in your Item Ledger Filter field or if you leave this field blank, the default Entry Type filters are used.
Still need help?
Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.