Unanswered

AssetBalances report – Cannot update AssetBalancesTmp via extension (PreProcess DP)

(2) Share

Report

Posted on by Statics 365

102

Hi,

I’m customizing the AssetBalances report in D365FO.

Goal:

Display a custom field Location (from AssetTable.Location) on the AssetBalances SSRS report
Field added to AssetBalancesTmp and bound correctly in RDLC
Use extension only (no overlayering, no DP duplication)

Constraints:

AssetBalancesDP is standard and cannot be modified
Report is launched via AssetReportsController (menu behavior already redirected to custom report)

What I’ve tried:

CoC on AssetBalancesDP.processReport():

next processReport(); while select forUpdate assetBalancesTmp { assetBalancesTmp.Location = "Duck"; assetBalancesTmp.update(); }

→ No value appears in the report.
DataEventHandler on AssetBalancesTmp (Inserting)

→ Event never fires.
Verified AssetTable.Location has data using SQL.
Verified dataset refresh and RDLC expression are correct.

Observation:

Even hardcoded values set in AssetBalancesTmp after processReport() do not appear.
This suggests the temp data might be snapshot/materialized before extension logic executes.

Questions:

Is AssetBalancesDP designed in a way that prevents modifying AssetBalancesTmp via extensions?
Is duplicating AssetBalancesDP and populating the custom field during insert-time the only supported solution?
Has anyone successfully extended AssetBalances without duplicating the DP?

Any guidance or confirmation would be appreciated.

Categories:

I have the same question (1)

All responses (3)

Answers (0)

Join the conversation

Helpful resources