BAQ Question for Taking the Sum of a Query

Kinetic ERP
1

I built a BAQ that could return partnumbers, company, and qty on hand. How do I go about returning instead of let’s say twenty rows of the same part number with different quantities on hand the sum of their respective quantities? Our part numbers are serialized so one part number only ever goes to one customer. I’m looking through the forums and documentation, but I thought I’d ask as well.

2

I think I found my answer
Calculated fields “SUM”

2 Likes
3

Hi peter you can use a SUM() Calculated field and a Group By on the other fields.

2 Likes