ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

PPA_BILLINGS table - how it works?

book

Article ID: 199293

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

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

Component : CA PPM FINANCIAL MANAGEMENT

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

Attachments