Changing Cash Receipt Column Views

You can display a variety of information about your open invoices by changing the column view. For example, to view open invoices by the customer's purchase order number, select a column view that includes the Customer PO# column.

To change column views:

1. From the A/R menu, select Cash Receipts to display the Cash Receipts window.

2. Enter or view a cash receipt.

3. From the View menu, select Change View to display a list of possible column views.

4. Select one of the following to display the corresponding columns in the Cash Receipts window:

• Invoice# / Stat / Open Amt / Discount DateAmt

  Column	Description
  Invoice #*	A number that identifies an open invoice. To search the table for an invoice number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match. You can also use this field to search for an open amount.
  Status	A code that identifies the status of the invoice, for example, on hold. Use the Valid Customer Invoice Status Codescontrol maintenance record to define these codes.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Disc...*	The date by which the customer must pay the invoice to receive a discount.
  Disc Avail*	The discount to which the customer is entitled if they send payment before the expiration date.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Customer PO# / Stat / Open Amt / Discount DateAmt

  Column	Description
  Customer PO#*	A number that identifies the invoice using the customer's purchase order. To search the table for customer PO number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match. You can also use this field to search for an open amount.
  Status	A code that identifies the status of the invoice, for example, on hold. Use the Valid Customer Invoice Status Codescontrol maintenance record to define these codes.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Disc...*	The date by which the customer must pay the invoice to receive a discount.
  Disc Avail*	The discount to which the customer is entitled if they send payment before the expiration date.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Invoice# / Due Date / Open Amt / Discount Amt

  Column	Description
  Invoice #*	A number that identifies an open invoice. To search the table for an invoice number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Due Date	The date by which you must receive the invoice for the customer to avoid finance charges.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Disc Avail*	The discount to which the customer is entitled if they send payment before the expiration date.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Invoice# / Invoice Date / Open Amt / Discount Amt

  Column	Description
  Invoice #*	A number that identifies an open invoice. To search the table for an invoice number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Invoice Date	The date you sent the invoice to the customer.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Disc Avail*	The discount to which the customer is entitled if they send payment before the expiration date.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the  discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Invoice# / Customer PO# / Open Amt

  Column	Description
  Invoice #*	A number that identifies an open invoice. To search the table for an invoice number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Customer PO#	A number that identifies the invoice using the customer's purchase order.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Customer PO# / Due Date / Open Amt

  Column	Description
  Customer PO#*	A number that identifies the invoice using the customer's purchase order. To search the table for customer PO number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Due Date	The date by which you must receive the invoice in order for the customer to avoid paying finance charges.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Customer PO# / Invoice Date / Open Amt

  Column	Description
  Customer PO#*	A number that identifies the invoice using the customer's purchase order. To search the table for customer PO number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Invoice Date	The date you sent the invoice to the customer.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Release # / Due Date / Open Amt

  Column	Description
  Release#*	A supplementary number on the customer's purchase order. To search the table for a supplementary number on a customer's PO, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match. You can also use this field to search for an open amount.
  Due Date	The date by which you must receive the invoice in order for the customer to avoid paying finance charges.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the discount, cash, and adjustments.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Release # / Invoice Date / Open Amt

  Column	Description
  Release#*	A supplementary number on the customer's purchase order. To search the table for a supplementary number on a customer's PO, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Invoice Date	The date you sent the invoice to the customer.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Old Invoice# / Stat / Open Amt / Discount Date&Amt

  Column	Description
  Old Invoice #*	A number that identified this open invoice on your previous system.
  Status	A code that identifies the status of the invoice, for example, on hold. Use the Valid Customer Invoice Status Codescontrol maintenance record to define these codes.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Disc...*	The date by which the customer must pay the invoice to receive a discount.
  Disc Avail*	The discount to which the customer is entitled if they send payment before the expiration date.
  Discount	The amount of the available discount applied to the invoice. You can override this amount, if needed.
  Cash	The amount of the cash applied to the invoice. You can override this amount, if needed. The system updates this amount for any discounts or adjustments.
  Balance*	The remaining open amount on the corresponding invoice after the system has applied the discount, cash, and adjustment amounts.
  Note	Any additional information about the cash receipt or invoice.

  *View-Only

• Invoice# / Invoice Date / Open Amt / Branch

  Column	Description
  Invoice#	A number that identifies an open invoice. To search the table for an invoice number, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Invoice Date	The date you sent the invoice to the customer.
  Open Amount*	The amount of the invoice that the customer has not yet paid.
  Branch	The branch number from which the order originated.

   

• Release# / Branch / Invoice Date / Open Amt

  Column	Description
  Release#	A supplementary number on the customer's purchase order. To search the table for a supplementary number on a customer's PO, enter all or a portion of the number in this field and press Enter. The system displays the matches to your search in a drop-down, or jumps to the invoice if there is a single match.
  Branch	The branch number from which the order originated.
  Invoice Date	The date you sent the invoice to the customer.
  Open Amount	The amount of the invoice that the customer has not yet paid.

   

See Also:

Cash Receipts Overview