I am helping clean up data in our system. We began using Cetec in 2018 and it appears the initial data population created Unapplied Cash in accounts - making AR statements unusable in certain situations. How do I remove this?
https://geminiplasticsinc.cetecerp.com/customer/1024/statement
@sbeausoleil
Unfortunately there isn’t a way to remove that unapplied cash without doing it within the code. This would require billable work from an engineer. If you gave us a list of how many unapplied cash objects you need removed I can get a quote from engineering!
Thanks,
Cetec ERP Support
We have 16 unapplied cash objects that need removal. A quote would be appreciated!
@sbeausoleil
If you can provide the IDs of the unapplied cash objects then it will be 1 hour bill at actual. If it takes more than deleting the objects then it will be 3 hours bill at actual.
Please let me know if you’d like this work done.
Thanks,
Cetec ERP Support
Yes, we would like this work done. When I run the Unapplied Cash report, these are the numbers in the first column. I am assuming this is the ID you are looking for?
125, Amount $345.80
123, Amount $901.60
121, Amount $157.66
119, Amount $42.06
117, Amount $1448.70
112, Amount $.01
106, Amount $139.83
105, Amount $57.74
85, Amount $1871.22
84, Amount $1092.82
83, Amount $1871.82
76, Amount $0.60
29, Amount $138.24
28, Amount $5788.80
7, Amount $241.56
4, Amount $204.84
@sbeausoleil
Yes those are the IDs we need! I will send this over to engineering and they can get started on this work. I will let you know once this is done.
Thanks,
Cetec ERP Support
@sbeausoleil
Apologies for the delay here. Engineering has finished this. We didn’t delete these below.
125, Amount $345.80
123, Amount $901.60
121, Amount $157.66
119, Amount $42.06
117, Amount $1448.70
112, Amount $.01
Those were all attached to AR payments and were not imported and you wanted only the ones that were imported. Also deleting non imported unapplied cash can mess with financials.
Let me know if you need anything else!
Thanks,
Cetec ERP Support