1,135
*This post is locked for comments
Very good. when you get a chance, please indicate that the suggestion resolved your situation by indicating that using the option on the thread so that it will now show with a green check mark.
You are a life-saver. That was it. I was using ar08600_wrk_aradjust_custid on the select tab to make my selection, which explains the results I was getting. I switched to using ar08600_wrk.custid and now I get the full list.
Ruben,
When you run statements for a single customer are you doing that by loading a pre-defined template or are you using the select tab to select the customer id? In either case, what table/field are you using for the customer id selection? It sounds like you either are using a template that also filters to documents that have had some sort of payment applied or you are using the aradjust table to select the customer instead of ARDoc. The statement program works off a view (vr_08600_wrk) so you want to make sure that you use vr_08600_wrk.custid to select the customer and not vr_080600_wrk.aradjust_custid as the later will only find documents to which either a payment or credit memo has been applied.
I am having the same issue described in this thread. I found that the ARDoc Statement Date is some date in the past. All of my customers are set for Open Item Statement Format and all are in the same Statement Cycle. When I run statements for all customers, all companies, I get all of the invoices listed on the statements and the total balances are correct. If I run the statement for a single customer, I only get invoices that have had a payment applied to it, but the total balance is still correct.
How do I get all of my open invoices to show up on the statement?
Thanks to all. After additional research yesterday, they had not released a batch with some 12/31 invoices until after the Aging/Statement process. It was just confusing on the surface until I looked at the table data with the process dates. Re-aging solved the issue.
Thanks,
David,
Are you saying that a current invoice does not show at all on the statement or that it shows with a zero balance or are you saying the amount of the invoice is not in the current aging field on the statement?
In order for an invoice to show on the current statement it must have a non-zero balance or was paid by a payment or credit memo that is not part of the current statement and the invoice must have a statement date equal to the statement closing date for the statement cycle that the customer belongs to.
You can run a SQL query on ARDoc for the reference number of the invoice and look at the curydocbal value, the stmtBal value and the stmtdate value comparing it to the date showing on the AR Close screen for the statement cycle of the customer. You can also run a query against ARAdjust for that reference number in the adjdrefnbr field and see what credits have been applied to that invoice (if any) and what the adjgdocdate was for that credit application.
My guess is that you closed the statement cycle more than once on different days relegating the invoice to be a member of a previous statement close or that the invoice has been paid with a payment that is not part of the current statement or something along these lines as opposed to a problem with the software. The view for statements is complex looking at many factors to determine if the invoice is part of the current statement or part of the beginning balance.
that brings up another question. Is the customer set up for balance forward or open item statements?
Hi David,
I assume you are closing the statement cycle prior to printing statements? Do some customers have current data on their statements and others don't?
Do you have a customized Statements report in the Usr_Rpts folder? If so, try renaming that file and see if the statements show current invoices in the Print Preview.
How do the Statements Cycles look? Are the aging buckets correct?
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (