Would anyone know why a GI would not allow the ability to use a Sum function on a specific line for the Total Aggregate? Every other line has the ability to select a dropdown and choose a function - this is the only line which does not.
Solved
GI - Sum Function for Qty Avalilable
Best answer by JReppard
I found that the field we were pulling was not an actual field in the tables, but rather a calculated field which would not allow it to have a sum at the bottom of the GI. We recreated the calculation on our own and it allowed for it to be summed up.
+4
Are there other tables you have joined in?
Sometimes it can be a good idea to peel back layers of the GI to see if the functionality is regained, then add layers back to find where the behavior is seen again.
You could also try uploading your GI in the thread to see if we see the same issue with the same GI.
On a side note though, this field is not an actual field (non-existent in the DB) so it could be affected by other joins or if the field is customized in some way?
I attached it .
Hi
I found that the field we were pulling was not an actual field in the tables, but rather a calculated field which would not allow it to have a sum at the bottom of the GI. We recreated the calculation on our own and it allowed for it to be summed up.
Thank you for sharing your solution with the community
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.