web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Small Balance write off
Microsoft Dynamics SL (Archived)

Small Balance write off

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Have you try initialization mode? Thanks

  • Community Member Profile Picture
    Community Member on at

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    Thanks. I did. You aren't able to pull them up in initialize mode.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans