Hi,
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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1fdc7fbf-f8ac-4143-a010-65d770818252.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/94142212-02a0-4b54-ae92-341beafd27ca.png)
Best answer by Naveen Boga
View original