I am doing a report and i found that i am having problem when using NF(),
I am pointing my NL to a service invoice line table.
=NL("Rows","Service Invoice Line",.:Company=","RCB")
But when i am using NF(B2,"Document No."), it not showing me the document no. but is other column, which is Line No. And i found that if i use NF(B2,"Document Type"), it wil give me document number.
Anyone facing that issue before?
Date
Votes
4 comments
-
Harry Lewis Hello -
Since (in standard NAV) "Document No." is field number 3 in the Service Invoice Line table, and "Line No." is field number 4 what do the following functions return?
=NF(B2,"3")
=NF(B2,"4")
Also, I do not see a "Document Type" field in that table. Has the table been customized?
If you continue to have issues, I would recommend submitting a support request.
-
LAU JUEN LIANG Hi Harry,
I tried to use the field no. It return with the correct data. The only problem is if i am using "field name", it will show me different field data.
It only happened on this table. I have no issue when i am using Item table.
-
Harry Lewis Hello -
What I suspect is happening is that Jet is configured to use NAV's field captions...
... and that something has happened to NAV's caption list.
If you look at the captions defined for the language NAV and Jet are using...
do you see any problems?
If this doesn't help you resolve the issue, I would definitely submit a request to Jet Tech Support.
-
LAU JUEN LIANG Hi,
I had checked my User Interface language for JetReport DataSource is ENU and in my field properties all of my captionML is ENU for example ENU=Document No. etc...
Please sign in to leave a comment.