P21 - Generate Customer Statement for Customers Who Have No Open Balance

P21 - Generate Customer Statement for Customers Who Have No Open Balance

Issue

The following article explains how to print customer statements for customers who have no balance.


Resolution

Customers with no balance for whom you wish to generate statements must be set to the Statement Type of Balance Forward on the General tab in Customer Maintenance.

When generating statements for these customers, you will need to ensure that the 'Suppress Zero Balance Statements' option is unchecked on the Criteria tab of the Generate Customer Statements Report.

If a customer is set to the Statement Type of Open Item, zero balance statements cannot be generated.

If you wish to convert a customer from the Statement Type of Open Item to Balance Forward, you can do so via the AR > Transaction > Convert Customers to Balance Forward window.

Open Item and Balance Forward simply determines how and what invoices the statement displays:

Open Item: In invoice date sequence, the customer's statement lists each invoice that has not been paid. Credits and payments received are shown as negative amounts. The Total Due is shown on the bottom of the statement.

Balance Forward: The customer receives a summarized statement (resembling a credit card statement) of their account. The Balance Forward statement shows the beginning balance (which is the balance of the last statement issued to the customer), a chronological list of all activity on the account since the last statement (including any payments received), and provides the current balance due.


(From Epicor, see attached)

    • Related Articles

    • How to Modify Customer Notes

      Go to the 'Customer Notepad Maintenance' screen 1. Enter Customer ID in the 'Customer ID' Field 2. To find all the notepads for that customer, double click on the Note ID box 3. You will see a list of all notes that exist for the customer. 4. Select ...
    • How to Create Customer Part Numbers while entering an Order / On-The-Fly Part Setups

      The ability to create customer part numbers while entering an order is a very helpful and easy process. These are a few quick screenshots to describe how its done. 1.  Enter the item that you want to customize on your order and then right click in ...
    • Outlook Always Asks to Save or Open

      When I double click on an attachment, I’m being asked whether I would like to open or save the file. I would like to open it but I don’t want to answer this question again. There is an option which says “Always ask before opening this type of file” ...
    • Sharing Sensitive Information

      Sensitive Information The best and safest way to transfer sensitive information (such as a credit card number) will always be through a direct phone conversation. However, there may be some instances where you are dealing with an overseas customer or ...
    • Scrapping / Adjusting Out Material at RMA Entry

         Scrapping/Adjusting Out Material at RMA Entry           1. You can save yourself time by adjusting out material at the time of RMA entry.  Start by opening up RMA Entry and entering your header information as you normally would.              2. ...