Vendor transactions list page

Article
06/03/2022

View settlements

The View settlements button on the Action Pane provides quick access to the settlement history and detailed information about the settlement transaction. You can also show additional transactions that are related to the selected transaction, either because they were part of the same settlement or because they are payments that were created in the same payment journal.

Select Accounts payable > All vendors.
Select a vendor that has transactions, and then, on the Action Pane, on the Vendor tab, select Transactions.
Select a transaction to research, and then, on the Action Pane, select View settlements.

The View settlements dialog box appears, and shows the selected transaction and all documents that have been settled against it. This dialog box resembles the settlement history view, but it includes all related documents.
In the dialog box, you can perform various tasks. Select one or more vouchers, and then select one of the following buttons:
- View related – Show all the payment journal transactions and general journal transactions for the vendor that were created in the journals in which the documents shown in the list were created. For example, if a payment is shown, then all of the payments in the payment journal in which it was created will be shown. If an invoice or payment is shown and it was created in a general journal, then all of the documents in the general journal in which it was created will be shown. All the settlements that are related to list of documents are also shown. While you're viewing related payments, the label of this button changes to View settlements. Select View settlements to show only the transactions that were shown when you first opened the View settlements dialog box.
- View history – Show the settlement history for the vouchers. Select Close to close the dialog box.
- View accounting – Show all vouchers that are related to the selected documents. Select Close to close the dialog box.
- Export – Export the selected vouchers to Microsoft Excel.
- Settle transactions – This button appears only if the original document that was selected wasn't fully settled. When you select this button, the Settle transactions dialog box appears, where you can select transactions for settlement.
- Undo settlements – This button appears only if the original document that was selected was fully settled. When you select this button, the Undo settlements dialog box appears, where you can undo the settlements that were done for that document.

Global transactions

The Global transactions button also displays on the Vendor transactions list page. This button lets you view all transactions for a vendor across all legal entities. The Vendor transactions list page shows transactions only for the legal entities that the user has access to, based on their security settings.

The list page will show all transactions for vendors that have the same party ID as the vendor that you started with. For example, if vendor US-001 in one legal entity has the same party ID as vendor DE-001 in another legal entity, all transactions for both vendor IDs are shown.

The menus on the Vendor transactions list page vary, depending on the legal entity for the transaction. For example, if a feature is available only for Swiss legal entities, the menu options for that feature appear only when a Swiss transaction is selected.

To access the feature, follow these steps.

Select Accounts payable > All vendors.
Select a vendor, and then, on the Action Pane, on the Vendor tab, in the Transactions group, select Global transactions.

More transaction filters

The filter for showing open transactions has been replaced with a new filter that lets you view more combinations of transactions. The following options are available in the Show field:

All – Show all transactions for the selected vendors (open and closed).
Closed – Show only transactions that have been fully settled and closed.
Open – Show only transactions that haven't been fully settled.
Open including closed on or after date – Show only transactions that haven't been fully settled on or after a date that you specify. When you select this option, you can change the date that is shown next to the filter. Transactions that have a Last settlement date value on or after the date that you specify are shown in the list, even if those transactions are fully settled as of the current date. However, the balance represents the balances as of the current date, not as of the selected date.

Select the Hide currency revaluations check box to hide currency translation transactions.

Modify due dates and discount dates

You can update due dates and discount dates for open customer transactions. In release 8.1, you can now add due dates to the Vendor transactions list page. By clicking on the due date in the Vendor transactions list page, you can also change due dates, discount dates, payment terms, and cash discount terms in the Update due date and cash discount dates dialog box.

Activate the feature

To add due dates to the Vendor transactions list page and change payment settings for a transaction by using the Update due date and cash discount dates dialog box, follow these steps.

Select Accounts payable > Setup > Accounts payable parameters.
On the Settlements tab, set the Show due date and allow edit option to Yes.
To enable this feature, new fields have been added to vendor transactions. Those fields will be filled in when a new transaction is completed. They will also be filled in when you open the Update due date and cash discount dates dialog box. When you set the Show due date and allow edit option to Yes, you will see the Update payment information dialog box. To update existing transactions immediately, select Update all existing transactions. Alternatively, to fill in the fields only for new transactions, select Continue without update.

The due date is now added to the Vendor transactions list page, so you can easily modify the due date and cash discount dates for transactions.

Modify the payment settings

The Vendor transactions list page shows all transactions for a vendor. When you select the due date for a transaction, a dialog box appears. This dialog box shows the base date for due date and discount calculations, due date, payment terms, cash discount terms, and cash discount dates.

Each field has a different effect on the transaction when you edit it:

Edit the base date - The due date and discount dates are changed as if the base date is the document date.
Edit the due date - Only the due date is changed
Edit the discount dates - Only the discount dates are changed.
Edit the payment terms - The due date is changed, based on the base date and the payment terms.
Edit the cash discount terms - The cash discounts are changed, based on the base date and the cash discount terms.

When you've finished editing the payment settings, select Close to save your changes.