Good day 🙂,
I’m hoping someone is able to help point me in the right direction to fix the following error. I’ve put togehter a GI that shows users how many times a particular product has been short delivered in the last 2 weeks.
I’ve managed to put the GI together, and it shows the correct information. However, when you try and apply a filter to the columns that shows the aggregated information, I get the “Object must be of type Int32” error.
From past experiences, this means that the data is formatted in the incorrect data type. I have thus tried changing the data type to CInt/CLong/CShort, but still getting the same error. I’ve also tried to use the Schema Field setting to e.g. POLine.LineNbr - that also didn’t help.
Initially I had the aggregated field set to OrderQty, and then doing a count on that. I thought that this might be causing the issue, and have since changed it to the OrderNbr column (which seems to be a more logical ‘countable’ column), but the same error occurs.
Can anyone spot any obvious issues in the GI or perhaps know of a way to fix this error?
PS. The column in question here is the “Times Short Delivered” column. The “Times Fully Delivered” coulmn displays similar information, and is also giving the same error, but I think if we’re able to solve the one, the other one’s solution would be the same.
Your assistance is highly appreciated.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/131a73ae-9076-459a-bcb8-72ce3419f95b.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7b168602-a1dc-4f82-b376-7a9140d3161f.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f2e61214-aad2-41fe-a035-aa5f52bef211.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/db0da02a-1215-4b58-ae5e-8d2d3c673c81.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a41a414a-43cc-443d-876a-f54f7de4bd56.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1aa6068d-842a-4dea-8dfd-7768b2ea5306.png)
Best answer by chris49
View original