Notifications
Announcements
No record found.
How do I clear a voided invoice from my A/R aging balance?
*This post is locked for comments
You need to define what you mean by a voided invoice. SL does not have a way to void a released invoice. You can void a batch containing the invoice but then the invoice would not be on your aging. So, do you mean that you created an offsetting credit memo or did you try to void the invoice by creating another invoice and inverting the GL accounts used or did you do something else that is not explained in your question?
It was an Invoice Reversal. The invoice is showing up on my AR aged balanced, as a positive and negative amount. I would like to clear it. I've done it before but I cannot remember how it was done. Thanks for any help.
Still not sure how you ended up with that situation since you cannot create an invoice for a negative amount. Even if you could, you would not be able to apply it to the original invoice because payment application only allows payments and credit memos to be applied. Does the negative invoice have a different reference number than the original and did it come from another batch?
Regardless of how you got it, if you are comfortable with SQL queries you could do the following:
You want to set the docbal and curydoc bal on both the original and reversing invoices to 0. You also need to set the perclosed field on both to a period of some sort (the current AR period or the posting period of the original documents will do. These steps will take the two items off of the aging but will leave a small hole that may or may not be a concern. Normally, when a credit is applied to an invoice or debit memo there is a corresponding aradjust record created but doing just the above will not create that aradjust record. Without it noting bad happens but reports like the customer trial balance will not show the negative invoice applied to the positive invoice when run for the posting period of the invoices.
I am still curious as to how that negative invoice got created in the first place.
I didn't create the negative invoice, the system did. I'm guessing it happened after the reversal of the first invoice.
When looking at AR aged report, under Type Ref Number, the first invoice is IN 234 and the second reversing one is CM 235, then the corrected invoice is IN 236. Hope that helps.
Maybe we have a terminology issue here. From what you just said, you have two invoices and one credit memo. Is it that credit memo that you are calling the negative invoice? If so, and that credit memo (235) offsets the bad invoice (234) then all you need to do is use the payment application screen to start a new batch for $0.00 and select the customer, switch the document type to credit memo, use F3 on the next field to select your credit memo and apply it to the invoice and you have retired the 234 and 235 leaving just 236.
Sounds correct Rick. Sorry about the confusion and thank you for the help!
I am having a similar issue. I created an invoice. It was incorrect. So I did a invoice reversal and duplication. Posted the invoice and then proceeded to apply the payment in payment applications as you have stated. Then I ran aged A/R several days later and the credit memo invoice was on aged a/r. How is this possible if I have applied the payment? I even went into payment applications to make sure I have applied payment and there is no invoice to apply payment to therefore it must have already been done. What can I do to wipe this credit memo off of my aged a/r given the circumstance stated above. I appreciate all of your help. you can reply back to btack@jgmsinc.com or directly on here. Thanks again.
You must create a debit adjustment (in the voucher screen, change from "Voucher" to "Debit Adj") to reverse the original invoice. Once you have done that, then you create a "Zero Check", which will offset the two against each other and remove them from your aging.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
