Adding a field to NAV003 Customer Sales and Profitability

I'm trying to add the item number to the sample report mentioned in the subject. I'm able to insert a column next to the item description and add the field by copying the text from the cell that contains the description and just changing it to look for No. instead. When I refresh the report I see the item number and everything seems to be fine until I switch to one of the tabs that contains the "Profit Amount" and those cells are populated with #NAME?. The same thing happens when I try to add the customer number to the Sales Dashboard report so I guess I'm messing up a formula somewhere when I add the column. Below is an example of what I entered in the item number cell.

LinkField([27 Item],[No.])

Any idea how I can add a field without this happening? Any assistance would be greatly appreciated.


Please sign in to leave a comment.