Skip to main content

We have a situation where we have imported (and activated) a set of contracts/contracts lines. One of the lines is for a product that should not have been on the contracts - so we now need to either cancel these lines or - second best - set the value to 0. I can’t an import to do this - is it possible to do thsi kind of change through an import or with a SQL script?

Hi Bjørn,

You might try using this import that is standard:

 

I used the API within this import definition and it successfully removed the contract line I targeted.  You would need to supply the cconth_id and the ccontl_id for the line you want to delete.

 


Awesome, Phil. I overlooked that one. Doing a trail run in UAT now - looks promising. Need to do a batch with Interim contract billing to clean up after, but that is peanuts!


Reply