I would like to create a report that basically gets the invoice number from the sales header and then displays all the line itesm in susequent columns and not rows. I can do this all day with the line items as rows. I cannot seem to get the items to autofill columns to the right after the sales invoice number.
Thanks,
Kelly
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Kelly,
Depending on what you mean, this could be an easy one or a complex one.
If you mean you want to print a single invoice, the solution is very easy. But if you wish to report multiple invoices columns, then it's a bit more complex. Instead of typing it out here, I enclosed a report that does both tricks.
Please note that I used the Sales Invoice Line table only. The NL function in Cell C7 on both sheets displays only those invoice nos that have items on it. Thus invoices with only G/L Accounts, Resources or any other type of line then Item will not be reported.
The example was based on Excel 2007, saves as Excel 97/2003, NAV 4 SP3, Jet Reports 7 - all Dutch versions.
Does this solve your question? And if you have any additional questions please let us know.
Please sign in to leave a comment.