I am getting the above error message
Navision c/front reported the following error
" field number 9 is not defined in the Sales Invoice Header Table"
I am trying to sum and pull up the top 10 items. I have other reports that run similar and have no issues.
Can someone tell me what I need to change? See below for code:
=NL("Rows","Sales Invoice Line","No.","Posting Date","010113..093013","Gen. Prod. Posting Group","TRIM","Link=","Sales Invoice Header","No.","=Document No.","State","MD|VA","-=NL(""Sum"",""Sales Invoice Line"",""Amount"",""No."",nf(,""No.""),""Posting Date"",""010113..093013"")","*","Limit=","10")
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi pierce,
i'm not quite sure, but i think it's because there is no Field, named "No.", in the SalesInvoiceHeader.
The red-coulored Field is related to the "SalesInvoiceHeader", because of the "LINK=", you have set before (green)…..
So every relation after the "LINK=" to SalesHeaderInvoice is directed to that table….
So that's my idea, but i'm not a specialist ;)
Greets
=NL("Rows","Sales Invoice Line","No.","Posting Date","010113..093013","Gen. Prod. Posting Group","TRIM","Link=","Sales Invoice Header","No.","=Document No.","State","MD|VA","-=NL(""Sum"",""Sales Invoice Line"",""Amount"",""No."",nf(,""No.""),""Posting Date"",""010113..093013"")","*","Limit=","10") -
Jet Reports Historic Posts Hi,
I would agree that the problem is probably in that calculated filter field. In this case, it looks like the calculated filter field is a sort by sum. However, there's no reason to ever perform a sort on a linked table since Jet is just checking for the existence of a record in that case anyway. If you want the sort to be applied to the main table (Sales Invoice Line), then you should move the sort by sum filter before the Link=. Otherwise, you should just eliminate it entirely since it won't do anything but make your report slower on a linked table.
Regards,
Hughes
Please sign in to leave a comment.