+11Hi
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
Best answer by Phil Seifert
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.
+24Hi 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
