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?
Solved
Alliance: Possible to cancel Contract Line (Product) through import or script
+11Best answer by Phil Seifert
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.
+23Hi 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.
+11Awesome, 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.