Hello community,
I am trying to create a report with 2 basic information:
1st = NL("Rows","Ship-to Address")
2nd= NL("Rows","Item","No.")
I am putting this information in the same line, so then the report will give me the "Ship-To Address" repetead as for each "Item No.".
The problem is that the report takes too long to run.
Any ideas of a different way to do this?
Thank you in advance
Gonzalo
i think it must be Nf.i advise you to read more about NL and NF .
Hello Gonzalo -
You want to avoid putting more than one NL(Rows) on a single line. Each function tries to make copies of the other... which tries to make copies of the other... which tries to make copies of the other... well, you get the point.
I see that the Ship-To Address table in NAV is related to the Customer table (but not the Item table).
Are you wanting to see every address that each Item has ever been shipped to?
I'm thinking that would probably require a Grouping Report and retrieving data out of the Item, Item Ledger Entry, Customer, and Ship-To Address tables.
