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) / Reversing Imported AR ...
Microsoft Dynamics SL (Archived)

Reversing Imported AR Batch.

(0) ShareShare
ReportReport
Posted on by msangregorio 190

Hi.

I used the "Transaction Import" feature to generate a single batch in my AR module that was used to create a variety of invoices for different customers. I'd like to reverse the effects of this and essentially undue this import and posting so that I may then upload a new batch. An across the board discount to all customers was not applied and I'd very much like to not have to address this on a customer level basis. I have not applied any payments to the invoices generated but have closed the period that the import is in (if that matters).

Any advice would be appreciated. Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversing Imported AR Batch.

    No problem.  Just telling you what your options were.  One note, however, when I indicated that there was a way to hide the bad invoices and corresponding credit memos I meant only from the customer statements.  They would still show on reports like the customer trial balance, document register and such.  What we would do would be to set the stmtdate on the ardoc for those bad invoices and offsetting credit memos to a statement date prior to the current statement date.  Since both would have 0.00 balances and look like they appeared on  a prior statement, your current statements would not show them.

  • msangregorio Profile Picture
    msangregorio 190 on at
    RE: Reversing Imported AR Batch.

    @Rick - Thank you. All the invoices in the batch are "bad" but I'd rather not have phantom data hidden from view (which is what I believe will happen if I do as you suggest). Appears as if the answer is that Dynamics will not allow me to "un-release" (which is a shame because that seems as if it would come in handy) but that a similar import of CM will do the trick.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversing Imported AR Batch.

    There is always a way but some are not "approved".  the first question is whether when you said "posted" you meant posted to the GL or merely released the batch (is it's status U or P)?  Do you really care about the accuracy of the data shown on the customer history screen or not?  the reason for this question is that data is updated upon the release of an AR batch and if we dump the batch through some queries, this history will not be accurate.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversing Imported AR Batch.

    Both suggestions will work as described but that will leave both the incorrect invoice and the corresponding credit memo on the customer's statement and it sounds like you would prefer to not have these show on the statements at all.  SL does not give you a way to un-release a batch but there is a way to hide certain transactions on a statement by running a SQL update query against the ardoc file.  If you are interested in doing this and have access to SQL Management Studio (or someone who does), I can provide that query.  If you do want to do this, the ease depends on whether the batch containing the incorrect invoices contains only those incorrect invoices or it also contains invoice you do not want to hide from the statements.  From you description of what caused this, it sounds like it might be all invoices from one batch.

  • msangregorio Profile Picture
    msangregorio 190 on at
    RE: Reversing Imported AR Batch.

    I appreciate both answers and I understand that I can import an entire batch of Credit Memos but that is not preferable.

    Is there a way to reverse or delete the batch I already posted? I'd much rather have that option than going customer by customer.

    Thank you again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reversing Imported AR Batch.

    Assuming the imported batch has been released, you can follow Perumal's advice & enter a Credit Memo one at a time, or try the following:

    1) Open the import file and save it under a new name;

    2) Change all of the Document Types from "IN' to "CM";

    3) Import this file;

    This will import offsetting credit memos for all of the invoices.  You would still need to apply these CM's to the original invoices.

    From here, you can then re-import the invoices with the correct discounts.

    John

  • Suggested answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: Reversing Imported AR Batch.

    Hello MSANGREGORIO,

    You just tried Transaction Import feature for Invoice & memo screen.Since you haven't applied any payments against the Invoice, you have to the following steps for reversing the AR batch

    1.open Invoice/Memo screen

    2.Select Type as "credit memo"

    2.Select the customer which you have created the invoice against the customer.

    3.Enter extended price amount for the Invoice amt

    4.Fill the control amount & Total Amount & Doc amount

    5.Save and Release batch.

    This will reduce your customer balance.You can check this using customer Trail Balance Report.

    Hope this explains.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans