Collapse AllExpand All

2.4.  Receivables Workbench

The Receivable workbench is designed to consolidate on one screen the functions performed by accounts receivable personnel. To view the Receivables workbench, go to Accounting > Accounts Receivable > Workbench. The following screen will appear:

Receivables Workbench

When viewing the Receivables workbench, you are presented with the following options:

Customer

Select all or specific customers whose receivables information you want to display.

Tip

To generate results in the display you first have to select the QUERY button. If you are not seeing any results, this is probably the reason why.

Debits

Select to include only invoices and debit memos in the display.

Credits

Select to include only credit memos in the display.

Both

Select to include both debits and credits in the display.

Unposted

Select to include unposted invoices in the display.

Find Document #

Enter the number of the document you want to locate. The record you are looking for will be highlighted in the display.

Due Date

Specify one of the following document due date options:

All

Select to include all due dates in the display.

On or before

Select to include only documents having due dates on or before the date you specify.

Between

Select to include documents having due dates falling between the dates you specify.

Receivables

Displays the current list of receivable open items for the specified customer, based on the parameters you specify. Documents in the display may include invoices, sales credits, debit memos, and credit memos. 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. You can change the color for the following document types using the 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.

Get G/L Distribution Date

When you select Void Posted Invoice from the right-click menu, the Get G/L Distribution Date window will pop up. This window gives you the option to choose which date the general ledger will use for the voided invoice.

To manage cash receipts on the Receivables workbench, select the Cash Receipts tab. The following screen will appear:

Receivables Workbench Cash Receipts

When managing cash receipts on the Receivables workbench, you are presented with the following options:

Cash Receipts

Displays the current list of unposted cash receipts for the specified customer.

Note

Once a cash receipt is posted, it will no longer appear in the cash receipts list.

To process pre-authorized credit card payments on the Receivables workbench, select the Credit Card tab. The following screen will appear:

Receivables Workbench Credit Card
Show

Select from the following options to include in the display:

Expired

Lists all credit cards, including expired cards.

Valid Days

Displays credit cards which expire on after the number of days selected.

Credit Card

Displays the current list of pre-authorized credit card charges for the specified customer. Pre-authorizations are generated from the Payments tab of the sales order header.

The following buttons are unique to this screen:

POST

Highlight a pre-authorized credit card charge amount and then select this button to authorize the charge. When a pre-authorization is authorized, a cash receipt in the authorized amount will be created, posted, and automatically applied to a credit memo or customer deposit (if customer deposits are enabled at your site).

Tip

You only get one chance to post a credit card pre-authorization. Once a pre-authorization is post-authorized, it will no longer appear in the Pre-authorized Credit Card Charges list.

VOID

Highlight a pre-authorized credit card charge amount and then select this button to void the pre-authorization.

AMOUNT

Specify the amount of the post-authorization. By default, the pre-authorized amount will display here. However, you may override the default amount. After posting, a cash receipt for the customer will be generated in the amount entered here (i.e., the post-authorization amount).

To view the dashboard associated with your receivables, select the Dashboard tab. The following screen will appear:

Receivables Workbench Dashboard

The Receivables dashboard includes the following pre-loaded dashboard panes, which you can either remove or supplement with additional panes at any time:

AR Customer Balances

Displays the customer's receivable balances.

AR Sales By Month

Displays customer sales by month.

Dashboard panes are used to contain charts, which are populated using datasources. To create a new dashboard pane, select the ADD button located toward the bottom of the Dashboard window. The following screen will appear:

Add new Pane

When creating a new dashboard pane, you are presented with the following options:

Pane Title

Enter a title to identify the pane.

Pane Description

Enter a brief description to describe the pane.

Datasource

Specify which datasource you want to use as the source for the dashboard pane's chart. The dashboards package includes several stock datasources. You may also create custom datasources on your own. For more information, please see Section 13.1.9, “Datasources”.

Chart Type

Specify which chart type you want the dashboard pane to display. The chart type options will be limited to the types specified on the selected datasource definition.

Layout Grid Width

Specify how many panes you want displayed in a row on the Dashboard screen, from as few as one to as many as three across. The layout grid width options will be limited to the layout options specified on the selected datasource definition.