I have a Sales report using the Sales Invoice Header & Sales Invoice Line with a link to G/L Account No..
I only want to see the G/L accounts between 41000 & 43000, so I have used a filter as below
My problem is it still brings up blank G/L account fields.
How can I filter these out please?
Thanks
Rodney
You'll want to use this as your filter: 41000..43000
or, if you want an exclusive range: 41001..42999
Thanks Harry, I tried that but with both I am still picking up blank lines
It is where an invoice has been entered direct to a GL code eg freight (not using an item) so the GL code shows in the item no. field, and has a blank in the G/L Account no. (refer below)
Ah! It appears you are using the Table Builder.
Two questions:
First, how are you relating the G/L Entry table to the Sales Invoice Line table?
Secondly, have to specified to Include Sales Invoice Line Rows only when G/L Entry is found?
Thanks Harry, you've nailed it! It definitely has removed the blanks.
I also wanted to do a union so that I could include all my credit memos in with my invoices report. I have read a bit online but don't really understand how to do it. Both the Sales Invoice Line & Sales Cr.Memo Line tables are very similar. Is it easy enough to join them in one report?
thanks
Rodney
Hello Rodney -
Typically, retrieving similar information from multiple NAV tables requires that to separate NL functions {NL(Rows), NL(Columns), NL(Table), etc) be used.
You could create multiple NL functions and then use Excel's pivot capabilities to combine them.