Finance | Project Operations, Human Resources, ...

How Extend InventSumDateEngine Class for custom fields in Physical on hand inv report

(1) Share

Report

Posted on by Sachin Mittal

i need to extend inventsumdateengine class to add customfields in inventdimphys report , to insert data in InventSumDateTransReport tmp table , which is tmp table for this report and dp class is inventdimphys

can anyone help which method to extends in which class so that i can add logic for custom fields in InventSumDateTransReport table to insert in report

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Martin Dráb 239,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What code you should write, and whether it's possible at all, depends on your specific requirements.

In general, the records are inserted in mergeRecords() table. You can extend neither the insert_recordset statement nor the final insert to inventSumDateTransReport, but you can iterate inventSumDateTransReport records after that and populate your custom fields, if you're able to determine their values. If you need something more, such us extending the insert_recordset statement, you'll need to create an extensibility request.

I'm assuming that the question is about F&O, that's why I moved it from the AX forum and gave you the answer above. If you meant something else in Dynamics AX, please give us more details (and I'll move it back to the AX forum).

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Sachin,

I suggest you make an extension on the table InventSumDateTransReport and add your logic in initFromInventSumDateTrans or initFromInventDim method.

for e.g.

[ExtensionOf(tableStr(InventSumDateTransReport))] final class InventSumDateTransReport_Extension { public void initFromInventSumDateTrans(InventSumDateTrans _inventSumDateTrans, InventDim _inventDim) { next initFromInventSumDateTrans(_inventSumDateTrans, _inventDim); // your code here } }

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Martin Dráb 239,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Aha, there is one more case. My answer covers the scenario when isInventSumDateEngineDenormalizeInventSumDateTransToggleEnabled is false; Mohamed's answer the other case.

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!
Hi @mohamad , I have done this code but its not working , fields are blank in report
[ExtensionOf(tableStr(InventSumDateTransReport))] final class InventSumDateTransReport_Extension { public void initFromInventSumDateTrans(InventSumDateTrans _inventSumDateTrans, InventDim _inventDim) { next initFromInventSumDateTrans(_inventSumDateTrans, _inventDim); // your code here InventTable invent = InventTable::find(this.ItemId); this.PackTypeDesc = ItemPackType::find(invent.ItemPackTypeId).Description; this.PackSizeDesc = PackSizeMaster::find(invent.PackSizeId).Description; ttsbegin; this.insert(); ttscommit; } }

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!

HI @MArtin , in my case i have debugged and found that isInventSumDateEngineDenormalizeInventSumDateTransToggleEnabled is true ;in my case , can you suggest any approach now , to insert data in report custom fields it would be very helpful for me , if not can we say that this report can be customized ???

Was this reply helpful? Yes No
Martin Dráb 239,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Use the debugger to collect more information. First of all, does your code gets called at all? As I mentioned, it depends on configuration.

Also, calling insert() is a bug that would duplicate records. The standard code saves records (otherwise the report would always be empty) and you're doing it once more. The purpose of initFrom methods is initializing field values, not saving.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sachin,

You can't put the insert() instruction in this method.

You must remove it from this method extension to avoid double insertion !

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!

HI @Mohamed
i have removed insert still data is not coming in tmp table

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sachin,

When you say it's not working, did u debug your method and see if it gets called? If yes, then did you check by debugging if the new pack fields you added are being filled or are they empty?

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!

HI @Layan

i mean . yes i have debugged its not hitting this method on running the report

Was this reply helpful? Yes No