Customer Detail Transactions

Customer Detail Transactions

Fund Accounting > Accounts Receivable > Customers > Customer Detail Transactions 

The menu option under Customer Summary allows you to display invoices, receipts, or both (All). Records > Customers > Customer Detail. 

This screen displays the A/R invoices and receipts for a customer in great detail. Invoices and receipts with multiple lines are displayed as separate lines, which allows you to see the G/L accounts and comments since they are at the detail level. This screen displays the invoices followed by the payment, which are grouped together and color-coded so they appear grouped together. Voids appear in red.


Header

Customer ID: Customer IDs may be manually keyed, or the Customer list may be displayed by clicking the search icon.

Period Range: You may enter a range of transaction months/years to browse. Information will be displayed based on the columns selected in the View setting at the top right of the screen.

Type: Option to filter for All with Balances, Invoices, Invoices with Balances, Receipts, Receipts with Balances. It dictates the general ledger account to which the invoice debit was entered.

Display Cash Application Entries: Displays all lines, including Void and Write-Off entries for the selected customer.

Totals for Range: Calculates the total Invoices/Receipts for the selected period.

Totals for Customer: This function calculates the total Invoices/Receipts for the customer's lifetime, regardless of the selected period.

View: This allows you to save your settings for which columns are displayed or hidden and in what order.

  • To hide or unhide columns, click the customize columns button and check which columns will be displayed.
  • To order columns, you can either click the customize columns button or drag the column header to where you want them.

You can save a view by clicking the save view button. This ability is based on user menu permissions.


Menu Buttons

Edit: After an invoice has been posted, the only thing you may edit is the Invoice#, Comments, Invoice Date, or Accounting Period. If the G/L account# or amount is wrong, you may enter reversal transaction/s to correct it. After a receipt has been posted, you may only edit the Check/Ref#, Receipt Date, Period, and Comments. The ability to edit is based on user menu permissions.

Void Invoice/Receipt: This opens the Void screen, where an Invoice or Receipt can be voided. The invoice status has to be Unpaid to be voided. The ability to void is based on user menu permissions.

Write Off: Opens the Write-Off screen where an Invoice or Receipt can be written off. An invoice status has to be partially paid or unpaid before it can be written off. Receipts can be written off at any status. The ability to Write Off is based on user menu permissions.

Cash Application: Apply Receipts/Unapply Receipts: Open the Cash Application screen where Open A/R Credits are applied or unapplied to Open Invoices.

Attachments: These documents are associated with the A/R Invoice or Receipt (Microsoft accepted file format). Attachments can be added at the time of invoice or receipt entry or later from the customer transaction history screen. Select the invoice or receipt to add/edit attachments.

Print Invoice/Receipt: To print an invoice/receipt, click to highlight an Invoice/Receipt line and select Print Invoice/Print Receipt.

Email Invoice: Opens the Email Forms to select the Distribution email address and the invoice form. The Email To populates from the Customer Record.

Reports: Print, Export only visible rows to Excel, or Export all rows to Excel.


Display

The user may double-click on an Invoice/Receipt to review or edit the entry.

Right-clicking on any displayed row allows you to browse the Batch, Cash Application Batch, Invoice/Receipt, Pay Invoice, or Void for the selected row.