Skip to main content

Hi

status of contract included on search on these transactions.

If we want to  schedule a batch for billing in these transactions. which status of contract will be included on the list ?
only status 300 ? or more if we add status before or after 300 ?

Thanks and Regards

Hi Anthony,

In relation to the status of the contract, when I ran this process on a v15.4 SU1 environment, the following part of the WHERE clause indicates what would be picked up:

 

Where ( cconth.node_id in ('') or 1=1 or cconth.node_id is null) and (((cconth.cconth_stat_id >= 200) And (cconth.cconth_stat_id < 400)) Or
    (cconth.cconth_stat_id >= 600) Or (cconth.cconth_stat_id Is Null))

 

From this, it appears any contract status between 200 and 399 will be used or any status 600 or higher (Canceled contracts still should be invoiced for their billing periods that had not been invoice yet for example.)

Hope this answers your question.


Reply