PPA_BILLINGS table - how it works?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

If we do a WIP Adjustment, a duplicate entry is created in PPA_BILLINGS.

During my test I corrected the quantity from 5 to 7, this is PPA_WIP and existing transaction from August 2019:

 

And in PPA_BILLINGS we have another added field with type A (Adjustment), which still has quantity 5:

 

 

Is this by design? If yes, why the quantity is 5 and not 7. Can you elaborate on this functionality?

Environment

Release : Any

Resolution

For each adjustment there will be 1 record in the PPA_BILLINGS table. This table contains adjustments only and the quantity will be the one before adjustment. So it is normal that the amount does not change.

It is not by design to have two entries for the same transaction if no double adjustment is being done. This can be checked by the APPLY_TO column