Hi,
I am still green to creating Generic Inquiries. I am trying to create a GI that displays the total inventory Items including qty and amount for each customer invoice. Then from there I am going to create a dashboard that shows the top selling items for each inventory item by qty. Here are screenshots for my total setup. How can I get the Customers Invoices to consolidate/filter correctly in my GI? Let me know or what conditions/settings I am missing? I have also attached an export of the GI if needed.
Thank you,
Frances Pantelidakis
Screen 1 Tables Setup:
Screen 2 Relations Setup:
Screen 3 Sort Order:
Screen 4 Results Grid:
Screen 5 Output of GI:
Best answer by Naveen Boga
View original