Most of our orders are Projects so we heavily use Customized Items. Evidently when we use use Standard Items on a Project it is considered a Customized Item so its usage does not increment the itm001.uscu field.

To compensate for this and get the full usage, someone developed a query that looks for the usage of the standard item in the pcs700 table where pcs700.kost is either 6 or 7 then adds this total to the itm001.uscu

I wanted to check if this was a valid calculation so I figured running the same totaling query on inv700.quan where kost = 6 or 7 should match the counter in itm001.uscu but every part's total is way to low so something is clearly missing.

How is the itm001.uscu field calculated in BaaN?

looks a valid calculation. On the other hand oen could have done a customization to update the usage field in item master.