Solved

Alliance - Batch billing contract or Consolidated billing batch

  • 13 April 2022
  • 1 reply
  • 46 views
athobie
Rank
Userlevel 4
Badge +11

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

icon

Best answer by Phil Seifert 13 April 2022, 13:02

View original

1 reply

Phil Seifert
Rank
Userlevel 7
Badge +21

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


Terms & ConditionsCookie settings