Finance | Project Operations, Human Resources, ...

Answered

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)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
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

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

Hi,

Were you able to resolve the issue?

Was this reply helpful? Yes No
AXx 95 on at

Like (0)

Report

No

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

Like (0)

Report

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

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

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

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

Join the conversation

Community site session details

Show ItemName In InventValueReport in AX 2012

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Show ItemName In InventValueReport in AX 2012

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates