Show ItemName In InventValueReport in AX 2012

(0) Share

Report

Posted on by AXx

hi expert, i have small question, i want to Show new field (item name) in invent value report, for this i do following customization

1 . add new field with name ItemName in InventValueReportTmpLine table .

2. also reference it in InventValueReportDP class in method getInventValueReportTmpLine. i.e

str ItemName;

also note that in this method there is macro used.

#LOCALMACRO.GroupByFields
TransactionId,ItemName
ResourceType,
ResourceGroupId,
ResourceId,

........................

#ENDMACRO

insert_recordset inventValueReportTmpLineTmp
(
#GroupByFields

.........

}

select #GroupByFields

.....

then after it also it reference it in InventValueReportPopulateItem method findReportLine

tmpReportLine.ItemName =_inventTable.itemName();

}

but data are not fetching in newly created field,

please guide me.

Regards.

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!
Hi,

You can try updating the itemName in the InventValueReportDP\getInventValueReportTmpLine method -

InventTable InventTable; //Do this in the declarations part update_recordSet inventValueReportTmpLineTmp setting ItemName = inventTable.itemName() join inventTable where inventTable.itemId == inventValueReportTmpLineTmp.resourceId;

Was this reply helpful? Yes No
AXx 95 on at

Like (0)

Report
Copy link

Link copied!

I have done in this way , it compiles fine , but when i run the report its gives Follwing error

Error executing code: The record buffer is NULL.

Stack trace

(S)\Classes\InventValueReportDP\getInventValueReportTmpLine - line 20

(S)\Classes\DictClass\callObject

(S)\Classes\SRSReportDataTable\getRecord - line 14

(S)\Classes\SrsReportProviderQueryBuilder\addCursorToQueryRun - line 13

(S)\Classes\SrsReportProviderQueryBuilder\getQ

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Were you able to resolve the issue?

Was this reply helpful? Yes No
AXx 95 on at

Like (0)

Report
Copy link

Link copied!

No

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Did you remove the other changes you did and perform an incremental CIL?

Was this reply helpful? Yes No
AXx 95 on at

Like (0)

Report
Copy link

Link copied!

yes But it shows this error when I run report

Error executing code: Wrong type of FIND argument.

Stack trace

(S)\Classes\InventValueReportDP\getInventValueReportTmpLine - line 21

(S)\Classes\DictClass\callObject

(S)\Classes\SRSReportDataTable\getRecord - line 14

(S)\Classes\SrsReportProviderQueryBuilder\addCursorToQueryRun - line 13

(S)\Classes\SrsReportProviderQueryBuilder\getQueryRun - line 26

(S)\Jobs\

.

Was this reply helpful? Yes No
AXx 95 on at

Like (0)

Report
Copy link

Link copied!

Problem Solved:

In InventValueReportPopulateItem Class > FindReportLine > Add this method InventTable::find(tmpReportLine.ResourceId).itemName(). It will retrieve all data but it takes time to display result.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Yes. That's why we were trying to do an update_recordset with a join, so that the performance is better.

Methoid\getInventValueReportTmpLine Line 21 belongs to the macro declaration. Right?

Was this reply helpful? Yes No