By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Report Designer
4
Posts
3
Users
0
Reactions
1,797
Views
February 20, 2020 6:28 pm
I'm trying to create a report that has all the upcoming expiring products. I'd like to have the report grouped by the month.
Currently, it is sorted by date like this:
Which is based off of =[RowINLotSerialStatus.ExpireDate]. Any suggestions?
3 Replies
March 3, 2020 1:19 pm
@katie-phillips,
If you use Month([RowINLotSerialStatus.ExpireDate]) it'll return the month separated out on it's own. You can create a group based on that output and make the exact date grouping a sub group.
March 6, 2020 6:16 pm
March 21, 2020 8:29 pm
You make want to concatenate Month([RowINLotSerialStatus.ExpireDate]) and Year([RowINLotSerialStatus.ExpireDate]) together.
Otherwise I think March 2020 and March 2021 will get grouped together.