data not assigning in Reports

(0) Share

Report

Posted on by anandb313@gmail.com

200

In NAV tem journal line reports, I have added a code to get unit price of the Item and my report table name is Item journal line.

Item.RESET;

Item.SETRANGE(Item."No.",RecItemJn."Item No.");

IF Item.FINDFirst THEN

"Unit Price" := Item."Unit Price";

But It returns zero value but actually it has data in Item. I have added this code both in Item Journal Line - OnPreDataItem() and Item Journal Line - OnAfterGetRecord()

Any Ideas! Thanks in Advance

*This post is locked for comments

All responses (4)

Answers (1)

anandb313@gmail.com 200 on at

Like (0)

Report

RE: data not assigning in Reports

Thanks for your response Andrey..But it doesn't work
anandb313@gmail.com 200 on at

Like (0)

Report

RE: data not assigning in Reports

Thank You very much Suresh Kulla..Its working!!
Verified answer

Suresh Kulla 43,745 on at

Like (1)

Report

RE: data not assigning in Reports

You need to add the code in the OnAfterGetRecord.

What is RecItemJnl is it a variable then it will not have the Item Journal Line Record, if you are just looking for reporting purpose only then create a variable called UnitPrice (Decimal) then use the following code

CLEAR(UnitPrice);

IF Item.GET("Item Journal Line"."Item No.") THEN

UnitPrice := Item."Unit Price"

If you have want to reflect that value in the journal then you need to assign the unit price to the Unit Price field and use the Modify statement.
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: data not assigning in Reports

You forgot Modify.

Next way:

Item.RESET;

Item.SETRANGE(Item."No.",RecItemJn."Item No.");

IF Item.FINDFirst THEN BEGIN

"Unit Price" := Item."Unit Price";

MODIFY;

END;