By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
0
Reactions
983
Views
July 26, 2023 11:11 am
Is it possible to have an auto incrementing number based off a grouping. I have a GI that is grouping GL entries based on branches and is grouped on branches. I need the GI to number the amount of times the branch shows in the grouping. Example would be branch 1001 shows 3 time so it would have a column that displays 1 2 3 as it goes down the rows. Branch 1002 shows 2 times so it would say 1 and 2 as it goes down and so on.
1 Reply
October 20, 2023 8:04 pm
I think you'd need to do a SQL View for this. Here's an example:
https://stackoverflow.com/questions/16555454/how-to-generate-auto-increment-field-in-select-query
Online Members
