Hi. I have a small balance write off that was accidentally put to a prior year. It has a balanced status. We would like to delete it but I can't figure out how to delete it. Has anyone run into this issue before?
*This post is locked for comments
Thanks. I did. You aren't able to pull them up in initialize mode.
I believe you have a couple of options. However, there is one part of your explanation that does not sound correct. You stated that the batch has a balanced status. A balanced status typical means that the debits = credits and that they = the batch control total but the batch has not been released. Since the small balance/credit write off screen does not have a field for indicating handling, the batch should have released and should have a U status (if not posted to the GL at this time) and not a B status. the following assumes that the batch has the U status.
If your main concern is with the general ledger and not the AR reports, you can enable initialize mode, open the GL journal transaction screen, select the module AR and then select this batch in question and change the posting period there (assuming you have initialize mode rights to the 0101000 screen). This will fix the GL side but will not change any of the AR reports. If the batch has been posted then this will not work.
Your other option is to do the above and run the following SQL statements:
Update ARDOC set perpost = yyyymm, perclosed = yyyymm where batnbr = 'xxxxxx'
Update ARTRAN set perpost = yyyymm where batnbr = 'xxxxxx'
Update ARADJUST set adjgperpost = yyyymm, perappl = yyyymm where adjbatnbr = 'xxxxxx'
Update ARDOC set perclosed = yyyymm where custid+doctype+refnbr In (select custid+adjddoctype+adjdrefnbr From ArAdjust Where AdjBatNbr = 'xxxxxx')
These SQL queries will fix up the AR side
I have tried initialize mode and this doesn't work. I tried this through the invoice and maintenance screen. Are you aware of another place to pull up small balance write off batches? Thanks! Serena
Have you try initialization mode? Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (