Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

AR Statements missing Current Invoices

Posted on by 1,135
Since upgrade to SL2011 FP1 Service Pack 2, the AR statements do not print any current invoice amounts. Payments in current month will show against prior period invoices, but current month invoicing does not appear in the current bucket. AR Aging shows current data so the aging does not match the statement.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Statements missing Current Invoices

    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.

  • Ruben Juarez Profile Picture
    Ruben Juarez 175 on at
    RE: AR Statements missing Current Invoices

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Statements missing Current Invoices

    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.                      

  • Ruben Juarez Profile Picture
    Ruben Juarez 175 on at
    RE: AR Statements missing Current Invoices

    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?

  • David Callery Profile Picture
    David Callery 1,135 on at
    RE: AR Statements missing Current Invoices

    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,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Statements missing Current Invoices

    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?

  • RE: AR Statements missing Current Invoices

    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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans