+3Hi,
I am trying to do a GI get Month-To-Date, Year-To-Dae & Prior-Year Sales totals for an inventory item.
There are multiple warhouses setup.
I am using the INTran table, with a condition of the item & the TranType of Invoice.
If I sort the results in Site Order (SIteID), the results do show in Site order.
However, if I set the grouping to be by SiteID, results are totaled correctly by do not appear in Site Order.
Is there a way to sort by the grouping conditions?
No grouping:
Best answer by Naveen Boga
Hi
+19Hi
+3Here is the XML of the Inquiry.
It has the Grouping checked
Thank you for any assistance.
+19Hi
+8Hi
Although the INTran data access class is configured to display the SiteCD when you add the SiteID to the result grid, your GI is actually sorting based on the SiteID field. You can see this by looking at the SQL trace after viewing the GI. I would suggest that you add the INSite DAC and sort on the SiteCD, which it looks like is what
...
WHERE ( [INTran].[CompanyID] = 2) AND ( [INTran].[BranchID] IS NULL OR [INTran].[BranchID] IN ( 22, 16, 20, 17, 21)) AND ( [INTran].[InventoryID] = @P0 AND [INTran].[TranType] = 'INV')
GROUP BY [INTran].[SiteID]
ORDER BY [INTran].[SiteID] OPTION(OPTIMIZE FOR UNKNOWN)
+3Thank you both!
That worked great!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.