You’re offline. This is a read only version of the page.
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
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.
@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.
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.
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.
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.
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
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.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (