I'm trying to extend the NAV003 - Customer Sales and Profitability report by including resource sales. Right now the report uses the Item Ledger Entry table which excludes the resources sold.
In SQL I would start with the Cust. Ledger Entry table and join the other table for all my data needs. Then in the select I would use the coalesce function to display the non-null item or resource data in a single column.
Alternately, I would use a union to combine the data into one table. I tried the union in Jet but thus far haven't had success.
Thanks in advance
Mike
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi DairyReports.
You would need to completely modify the original table of this report to make those changes. I would personally start over and recreate the report as opposed to trying to change the stock one.
If you want to attach where you are and describe how you are stuck then I am happy to take a look. Using the Customer Ledger Entry table as your base table may not provide as much detail as you are looking for since it will sum by the doc number and in the original report it was looking at all the detail of the sales.
Hope this helps and if you want to send the report over and describe what you are trying to do then I'll take a look.
Best.
Jason
Please sign in to leave a comment.