Hello Mates, How can I unlink the Customer Deposit...
# csvimports
m
Hello Mates, How can I unlink the Customer Deposit From Sales Order and Delete in Bulk, Can this be done via CSV Import? I have around 10000 records to delete.
n
Which are you trying to delete? SO, CD or both? You would deleted the last in the chain first and back through the dependent records.
m
I need to delete Customer Deposit.
l
Have the CD's been applied to an Invoice? If so, you need to delete the DA (Deposit Application) first. I don't think you need to "unlink" the CD from the SO as they are not dependant on each other (just the same as you don't need to unlink an Invoice from and SO before deleting the Invoice).
1
m
@Lee Hopper Dear Lee, Thank you for this. How do I mass Unlink Deposit Application?
👍🏻 1
l
@Maal Dai You can't "unlink" a DA without linking it to something else at the same time. The only thing you can do to get rid of them is delete the DA. To do this on-mass, I think the only way would require a script. This is above my knowledge but if he is checking slack, I know @ERP Experts created a script/suiteapp to be able to do this.
❤️ 1
e
Yes we have an app called Mass Delete where you pass it a Saved Search and it deletes all results until none are left. www.erpexperts.co.uk
m
Thank you so much, I used Map/Reduce to sort this out. Many thanks for your help.