Display Production order comment lines?

Business Central/NAV Developers Forum
1

Hi,

I’m trying to develop a report to display a daily production order journal.

Production Order

Prod. Order Line <Prod. Order Line>

Capacity Ledger Entry

Prod. Order Comment Line <Prod. Order Comment Line>

Integer DisplayComment

this report request the Posting Date in Capacity Ledger Entry, to show the Output Quantity in that day.

The report works perfectly , but i got a problem when our users request to display production order comment line.

I did the following :

Add 2 global var

CommentLines Text 80 With Dimension 20.

CommentLoop Integer

the following code to catch comments

Prod. Order Comment Line - OnAfterGetRecord()

CommentLoop := CommentLoop +1 ;

CommentLines [CommentLoop] := “Prod. Order Comment Line”.Comment;

and finally in the integer Table :

DisplayComment.SETFILTER(DisplayComment.Number,’%1…%02’,1,CommentLoop);

my problem now is that the reports display all comment !!

how can i fix that problem?

2

Hi Ali

I guess you have not set the relation between Production Order dataitem and ProdOrderCommentLine on property window of ProdOrderCommentLine, to filter to Production Order.“No.”

3

Thanks Jay,

My problem was When user specify the the posting date in Capacity Ledger Entry without mention Production Order No. , the reports group Capacity ledger entry with posting date and Production order No. But it displays all comments of all productions orders even it was not in that date.

Now i fixed the issue by adding date filter in ProdOrderCommentLine. it works perfectly