BeyondERP.Newsletter
Menu

Job page · Cost management

Clean up the costing sheet cache

A periodic task that cleans up the costing sheet cache, which holds costing sheets temporarily to help generate prices.

Business process
Manage data
Menu item
action:CostSheetCachePurgeJob
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 task that cleans up the costing sheet cache, which holds costing sheets temporarily to help generate prices.
What you do hereUse this task to delete records in the costing sheet cache that have reached a specified age in days.
Clean up the costing sheet cache 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 data
Menu pathCost management › Manufacturing accounting › Clean up › Clean up the costing sheet cache
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 costing sheet cache has grown large, for example after many BOM calculations or price calculations.
How oftenOn demand, or on a recurring batch schedule that suits how often you run price calculations.
Batch settingsA recurring batch job outside business hours keeps the cache small without manual work.
What the output showsCosting sheet cache records of the specified age or older are removed. Costing sheets are generated again when needed, so a slower first display afterwards is normal.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Manufacturing accounting > Clean up > Clean up the costing sheet cache.
  2. Know what is deleted: the CostSheetCache table only holds costing sheets temporarily to help generate prices, so no posted data is affected.
  3. Enter the age in days; cache records that have that age or older are deleted.
  4. Run it in the background on a recurrence if the cache grows quickly, then select OK.
  5. Open a costing sheet for an item or production order afterwards to confirm it is built again without errors.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo, but the cache is rebuilt: Deleted cache records can't be restored, but they are temporary data that the system recreates when a costing sheet is needed. Microsoft Learn
If you change it laterDeletes old records from the CostSheetCache table; costing sheets are rebuilt on demand. Microsoft Learn
Technical architect

5Technical

Menu itemaction:CostSheetCachePurgeJob
Roles to set it up and use itTo use itInventory accountant InventCostAccountantGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources