A/P Vendor Activity Screen

Click this button to view the details for a selected document.

This button appears on the following tabs:

• Payments. You can select any payment, and then click Document to view the original entry in the A/P Payment Entry screen.
• Transactions. You can select any transaction, and then click Document to view the transaction in the original entry screen.

This button appears on the following tabs:

• Payments. You can select any payment, and then click Open to view details about the payment. For more information, see A/P Payment Information Screen.
• Transactions. You can select any transaction, and then click Open to view details about the history of the transaction. For more information, see A/P Document Information Screen.

The Optional Fields button appears only if you use Sage 300 Transaction Analysis and Optional Field Creator.

Click this button to view optional fields assigned to the transaction.

In multicurrency ledgers, use these fields to select the currency in which to display information. You can display amounts in the functional currency for the ledger or in the vendor's currency.

Type F to select Functional currency, or type V to select Vendor currency. You can also click your choice, or use the Up or Down arrow key on your keyboard to highlight your choice, and then press Enter.

This field displays the amount of the credit limit that the selected vendor allows your company.

This field indicates whether the vendor account is active.

This field displays the amount of the last invoice that was posted to the vendor's account.

This field displays the document date entered with the last invoice you posted to the account.

This field displays the amount of the last payment you sent to the vendor and posted to the account.

This field displays the date of the last payment that was posted to the account.

This field indicates whether the account is on hold.

This field shows the current number of open (unpaid) invoices in the account. You cannot edit the figure.

This field displays the current net amount owed to a vendor, including all invoices, credit notes, debit notes, payments, and adjustments posted to the account. You cannot edit the figure.

This field shows the outstanding retainage balance for the vendor.

This field displays the total amount of outstanding prepayments that have been posted to the vendor account. You cannot edit the figure.

This field displays the current number of outstanding prepayment transactions in the account. You cannot edit the figure.

Use this field to select the vendor whose account activity you want to view.

You can type the number in the field, or use the Finder or navigation buttons to select the vendor number.

Tip: After you specify the vendor number, you can click the Zoom button to display the vendor record in the A/P Vendors screen, where you can view or edit it.

Type the date from which to age (count back) to determine the balance to display in each aging period. All outstanding transactions will be listed unless they were posted after the cut-off date.

Specify whether to age balances by the document dates used in the transactions or by the due dates:

• Due Date. Select this option to display outstanding balances.

  Current transactions are those with due dates that are later than the Age As Of date. The first period starts at one day past the due date.

• Document Date. The first period includes transactions with document dates that are earlier than the Age As Of date.

  Current transactions are those with the same date as or a later date than the Age As Of date.

Aging periods are assigned for Accounts Payable on the A/P Options screen, but you can temporarily change the lengths of the periods when viewing individual accounts on this tab.

The aging periods you specify in the Vendor Activity screen have no effect on the aging periods set on the A/P Options screen.

The cutoff date lets you include or exclude transactions that are more recent than the Age As Of date.

Type the last date for which to include transactions in the balances. Only transactions that were posted to the vendor's account on or before that date are selected.

Select this option if you want to include prepayments in the statistics.

Select this option if you want to include in the statistics transactions that are on hold.

The code for the bank from which you issued this check.

This is the check number Accounts Payable assigned when it printed the check, or the number entered manually in the Payment Entry screen.

Bank Services uses the check number to identify all checks in Sage 300.

The check status can be outstanding, cleared, or reversed.

This field displays the currency in which the check was written.

This is the entry number of the payment or prepayment transaction in the batch. (You can identify it as a payment or prepayment if you select the check, and then click the Open button.)

Specify whether to list payments in order of check number or document date.

Tip: Click the Ascending/Descending button beside the Order By field to change the display from ascending to descending order, or from descending to ascending order, for your Order By selection.

This is the amount that appeared on the check, in the currency that the check was written.

To see the check amount in the vendor currency or the functional currency, highlight (select) the check on the table, and then click Open.

The payment batch is the one to which you added and posted the payment or prepayment transaction.

This field displays the date you made the payment.

If you paid by check, this date was on the face of the check.

This field displays the remit-to name that appeared on the check.

Depending on your selection for the Order By field, specify the check number or the document date with which to start the list of payments.

Select the status of the payments you want to review:

• All
• Cleared
• Outstanding
• Reversed

Enter or use the Finder or the navigation buttons to select the vendor whose checks you want to view. You must enter a vendor number.

In multicurrency ledgers, use these fields to select the currency in which to display information. You can display amounts in the functional currency for the ledger or in the vendor's currency.

Type F to select Functional currency, or type V to select Vendor currency. You can also click your choice, or use the Up or Down arrow key on your keyboard to highlight your choice, and then press Enter.

This field displays the vendor's currency code.

Specify the type of documents to display:

• All
• Invoices
• Debit notes
• Credit notes
• Interest charges
• Unapplied cash
• Payments
• Prepayments

Select this option to include fully paid invoices, credit notes, and debit notes in the list of documents.

Select this option to include information for pending transactions, including the pending payment total, pending discount total, and pending balance for each document.

Specify how to list documents. You can list documents by:

• Document number
• PO number
• Sales order number
• Due date
• Document date
• Current balance

Tip: Click the button beside the Order By field to change the display from ascending to descending order, or from descending to ascending order, for your Order By selection.

This field indicates the retainage amount that was posted for the document, before any outstanding retainage was invoiced.

This column shows whether a document has an On Hold or Forced status.

This field appears if you selected the Include Pending Amounts option on the Transactions tab.

The Pending Adjustment Total field shows the adjustment total for a selected document, including adjustment transactions that you have entered but not posted.

This field appears if you selected the Include Pending Amounts option on the Transactions tab.

The Pending Balance field shows the balance for a selected document, including transactions that you have entered but not posted.

This field appears if you selected the Include Pending Amounts option on the Transactions tab.

The Pending Discount Total field shows the discount total for a selected document, including transactions that you have entered but not posted.

This field appears if you selected the Include Pending Amounts option on the Transactions tab.

The Pending Payment Total field shows the payment total for a selected document, including transactions that you have entered but not posted.

This field indicates the outstanding retainage balance that remains for the document.

This field displays the due date entered with the original retainage document (the date that retainage is due).

Depending on your selection for the Order By field, specify the number, amount, or date with which to start the list of transactions.

Tip: If you use the Finder, you can use the Find By field to specify a different order by which to list documents.