Accounts Receivable > Transaction Processing > AR Cash Posting Worksheet

AR Cash Posting Worksheet

You use this program to enter the payment amounts received from customers and to view the unpaid invoices for those customers. You can optionally apply the customer payments entered.

This report is designed to assist you in deciding to which invoice(s) the amounts received should be allocated, before you begin entering payments or adjustments using the AR Payments and Adjustments program.

Toolbar and menu

Field Description
Options  
Posting period Use the Change Posting Period program to indicate the period into which to post the transaction. This defaults to the current period when no period is specified.

See Password considerations in Notes and warnings.
Generate Select this to display the customer's outstanding invoices in the Cash Posting Worksheet Report pane.
Duplicate Customer Warning

Select this to display a warning when you add a second payment detail entry for the same customer.

You can override the warning and still add the entry.
Print  
Cash Worksheet Report Print the contents of the Cash Posting Worksheet Report pane.
Journal Report Print the AR Cash Journal report. A blank report is generated if no journal details are displayed in the Reviews pane.
Post Functions
Option Description
Post Unapplied Post captured checks to the customer's account without allocating them to any invoice (i.e. as an unapplied payment).
Post Automatic by Invoice Post captured checks as automatic payments against outstanding invoices in invoice sequence.
Post Automatic by Date Post captured checks as automatic payments against outstanding invoices in date sequence.

Entry Details

You can enter the details of the payments received from the customer which have to be allocated to invoices.

Field Description
Add Add a line in which to enter a payment entry.
Delete Delete the highlighted payment detail entry.
Print Print the entries in this pane.
Customer Enter the customer from whom the payment was received.
Payment date Enter the date on which the payment was received.
Bank Indicate the SYSPRO bank into which the payment was deposited.
Check Enter the customer's check number.
Payment amount Enter the payment amount to be allocated.

Cash Posting Worksheet Report

This displays the entry details, including the unpaid invoices against the relevant customers when you select the Generate option.

It also displays details of the payments posted according to the Post Function selected. The total payment amount and the number of checks display the totals of the payments posted, and the details of the payments are reflected when you expand the invoice details.

Field Description
Invoice/Type/Terms Displays the transaction type from the ArInvoicePay table, and can be one of the following:

  • Adjustment

  • Credit memo

  • Debit memo

  • Payment

  • Exchange rate revaluation

  • Tax relief adjustment

  • Customer payment

Reviews

This displays all the journals created for posted transactions during the current run of the program.

Notes and warnings

Password considerations

Password access to the following functions in this program may be defined in the Password Definition program. When defined, the password must be entered before you can access the function.

Field Description
AR Posting to a previous month This password restricts access to posting Accounts Receivable transactions to a previous period (see Multi-period accounting).