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
Netsuite Tragic
01/10/2021, 2:35 AM
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
Maal Dai
01/10/2021, 9:12 AM
I need to delete Customer Deposit.
l
Lee Hopper
01/11/2021, 11:42 AM
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
Maal Dai
01/22/2021, 8:17 AM
@Lee Hopper Dear Lee, Thank you for this. How do I mass Unlink Deposit Application?
👍🏻 1
l
Lee Hopper
01/22/2021, 11:26 AM
@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
ERP Experts
01/22/2021, 5:36 PM
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
Maal Dai
01/27/2021, 9:37 AM
Thank you so much, I used Map/Reduce to sort this out. Many thanks for your help.