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?
Best answer by Naveen B