On-Hand Totals by Part in BAQ

Kinetic ERP
1

Hello everyone,
Is there any column in BAQ where I can get on-hand by part? (not on-hand by Bin)
As in the example below, when an on-hand is taken from PartBin, the line is divided for each bin. If there is an on-hand column for each part, I want to make it one line for each part. What should I do?
Thanks in advance
image

2

There are a couple of choices here:

  1. PartWhse table, OnHandQty column

  2. PartBin table, but in the BAQ do a Group By the Bin Number, and create a new calculated column which has a formula SUM(PartBin.OnHandQty).

3 Likes
3

There is also a PartQty table with the quantities (per warehouse)