Collapse AllExpand All

2.6.2. Open Receivables

To view the complete list of open receivables, go to Accounting > Accounts Receivable > Reports > Open Receivables. The following screen will appear:

Open Receivables

Note

If a customer's open receivables balance exceeds their credit limit, the customer will automatically be placed on credit warning. In addition, any new or open sales orders for the customer will also be placed on credit hold.

When displaying open receivables, you are presented with the following options:

Customer

Select all or specific customers whose open receivables you want to display. To generate results in the display you must first select the QUERY button. If you are not seeing any results, this is probably the reason why.

Date Range

Specify the following date range options:

Document

Select if you want to show open receivables whose document date falls within the specified date range.

Due

Select if you want to show open receivables whose due date falls within the specified date range.

Start Date

Open receivables having document or due dates (depending on selection) on and after this date will be displayed.

End Date

Open receivables having document or due dates (depending on selection) on and before this date will be displayed.

As of Date

Specify the date you want the open receivables to be relative to. The report will include any open receivables which were open—that is, not yet paid—as of the specified date. This feature provides point-in-time open balance functionality. The payment date used as a reference for the As of Date field is the G/L distribution date, not the posting date.

Show

Specify which of the following options you want to display:

Debits

Select to include only debit balance documents in the display.

Credits

Select to include only credit balance documents in the display.

Both

Select to include both debit and credit balance documents in the display.

Only Items with Incidents

Select to include only documents having linked CRM incidents in the display.

Unposted

Select to include unposted documents in the display.

Print

When viewing open receivables for a single customer, you can select from the following two print options. These options are not available when viewing open receivables for more than one customer. The choice made here governs which type of document will be printed when you choose to print this report.

List

Select if you want to print the list of the customer's open receivables.

Statement

Select if you want to print a customer statement.

Receivables

Display lists open receivables by customer, using the specified parameters. The right-click menu includes many options, including the ability to enter cash receipts and incidents linked to the receivable. You can also void posted invoices and sales credits from the right-click menu—as long as they are unapplied. To un-apply documents, use the Reverse Application option on the Receivables Application screen. To change the color for the following document types, adjust your locale settings: customer deposit (alternate) and credit memo (emphasis).

Note

You can refund credit card charges using the right-click menu. This option only works for credit memos specifically created from credit card transactions.

Tip

If you are using the Authorize.Net payment gateway, refunds must be processed at least one day after the original charge. Authorize.Net does not allow you to refund a transaction that was charged on the same day.

The following buttons are unique to this screen:

PRINT

If the customer selection is for a group of customers, this button will print the report associated with this screen. If a single customer is displayed then the PRINT button gives a menu of choices. Select from one of the following print options:

List

Print the report associated with this screen.

Statement

Print an receivables statement report for the selected customer. If the selected customer has an EDI profile attached, you may encounter an EDI processing interface when printing the receivables statement.