web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Zero balance invoices ...
Microsoft Dynamics SL (Archived)

Zero balance invoices showing on statement

(1) ShareShare
ReportReport
Posted on by Jo Wykerd 1,639

Hi there,

The client has payment allocations and invoices showing on their statement where the balance for each invoice is zero - see below.  In this case neither the invoice or payment should show.  This is only happening for one customer. Statement type is Open Item.  What can i check to see what the problem is?

Statement.png

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Zero balance invoices showing on statement

    Hi Jo

    Did you apply the Payments to the Invoices?

    Chuck Otis

    Winxnet

  • Jo Wykerd Profile Picture
    Jo Wykerd 1,639 on at
    RE: Zero balance invoices showing on statement

    Hi Chuck,

    Yes the user applied the payment to each invoice

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Zero balance invoices showing on statement

    Jo -

    Did some digging. With that partial print screen, it’s hard to tell what is happening.  It is mentioned that the statement type was open item, and  invoices on this statement have a zero balance.  It is suggested to run a query like this in sql server.  Example: If INIR066237 is the first line on the statement, and it shows an invoice for 7555.50, and what looks like a balance of 7555.50.

    select stmtdate, stmtbal, docbal, * from ardoc where refnbr = 'INIR066237'

    When you run that query, what is the stmtbal and what is the docbal?  If the docbal is 0.00 and the stmtbal is 7555.50, then they probably just need to close the statement cycle again.  If the docbal is 0.00 and the stmtbal is 0.00, but the statement is printing a balance of 7555.50, then it is suspected that the statement is customized and there is a problem with the customized report.

    I hope this helps.

    Please let us know.

    Thank you,

    Carolyn

    MSDSL Technical Support

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans