Skip to main content
Solved

Mass reschedule of billing schedule Out of Synch?

  • January 9, 2022
  • 2 replies
  • 56 views

bskallerud
Hero (Customer)
Forum|alt.badge.img+12

After updating from v12.5 to 15.2 we find that roughly half our contracts (5000+) have the status of Billing Schedule Out of Synch. Is there a way to mass reschedule?

Best answer by Phil Seifert

Hi Bjørn,

Digging through my resources, I found something you can try using this API as part of an import template:

<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
  <session email="" alias="">
    <state bc_name="CustomerContract" is_allow_save_changed="true">
      <action name="data">
        <main>
          <row number="1">
            <cconth_id dtype="string" in_var="" out_var="">{ContractID}</cconth_id>
            <cc_invoke_resched in_var="" out_var="">Y</cc_invoke_resched>
          </row>
        </main>
      </action>
      <action name="execmacro">
        <attribute bo_name="main" macro_name="RESCHEDULE" />
        <attribute dtype="string" in_var="" value="N" />
      </action>
      <action name="execmacro">
        <attribute bo_name="main" macro_name="SAVE" />
      </action>
    </state>
  </session>
</root>

The source data should be a spreadsheet containing the Contract ID’s you are looking to reschedule. I would advise testing this with small datasets first and not all 5000 contracts at one time.  First test the API with the Interactive API module using a single contract.

Hope this helps.

Phil

 

 

2 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • Answer
  • January 9, 2022

Hi Bjørn,

Digging through my resources, I found something you can try using this API as part of an import template:

<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
  <session email="" alias="">
    <state bc_name="CustomerContract" is_allow_save_changed="true">
      <action name="data">
        <main>
          <row number="1">
            <cconth_id dtype="string" in_var="" out_var="">{ContractID}</cconth_id>
            <cc_invoke_resched in_var="" out_var="">Y</cc_invoke_resched>
          </row>
        </main>
      </action>
      <action name="execmacro">
        <attribute bo_name="main" macro_name="RESCHEDULE" />
        <attribute dtype="string" in_var="" value="N" />
      </action>
      <action name="execmacro">
        <attribute bo_name="main" macro_name="SAVE" />
      </action>
    </state>
  </session>
</root>

The source data should be a spreadsheet containing the Contract ID’s you are looking to reschedule. I would advise testing this with small datasets first and not all 5000 contracts at one time.  First test the API with the Interactive API module using a single contract.

Hope this helps.

Phil

 

 


bskallerud
Hero (Customer)
Forum|alt.badge.img+12
  • Author
  • Hero (Customer)
  • January 9, 2022

Thanks, Phil

 

Very helpful