Need help understanding why the item below still shows on the OPEN plus current AR Customer Trial Balance report. We've applied the payment but wonder if there is another step in order to get this removed from the report. Customer balance shows as zero, but something continues to keep this item on the report.
*This post is locked for comments
Thank you Rick, this detailed explanation worked and they are now cleared off the OPEN Customer Trial Balance report.
Are you certain that the payment was actually applied to the invoice on the payment application screen. If you entered the payment but failed to apply the payment (left the amount applied as 0.00) then you would have this issue. I suggest you start a new payment application batch for $0.00 and attempt to pick up this unapplied payment and apply it to the invoice. If the payment is not available (F3 on the Number field) then it sounds like the original payment application batch may have suspended during its release. Open the release AR batches screen and see if the original payment application batch is showing with an S status and, if it is, attempt to release it. If this payment is available when you start a new payment application batch, apply it to the invoice.
I just replied with a copy of the report. Are you able to view it?
Cust ID Tran Date Tran Type Entered Periods Posted Closed Doc Amount
8/18/2017 PA 08-17 08-17 -125.75
7/24/2017 IN 07-17 07-17 125.75
In what period was the payment applied? What's the value in the PerClosed field of ARDoc for the invoice?
No the invoice is posted to period 07-17 and the payment is posted to period 08-17
Is the invoice and/or the payment in the same period for which you're running the report?
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 (