Dynamic selection of payment details

Objects can be used to dynamically select the payment method and supplier bank account ID when recording a new supplier invoice in 'Supplier Invoice. Record' (APS100), 'Supplier Invoice Batch. Open' (APS450), or APS450MI.

Before you start

You must consider this setup before you can use the dynamic selection of payment details when recording a new invoice in (APS100), (APS450), or APS450MI:
  • You must add the field group APPBS in 'Field Group. Open' (CRS108) by using F14='Gen data'.
  • You must add the object control parameter 'Selection of payment' in 'Available Object Ctrl Parameters. Open' (CMS016) by using F14='Gen data'.
  • You must set up the selection types 1-'Payment method' and 2-'Bank account ID' in 'Generic Object Control Table. Open' (CMS017).
  • You must set up selections in 'Selection of Payment Details. Open' (APS092).

General control object

For each selection type, objects from the field group APPBS can be used in any order. You can use up to ten priorities per selection type. This table lists the objects that you can select in (CMS017):

Object Description Selectable values in (APS092) Applicable
&BSCD base country Select from country codes specified in 'Country. Open' (CRS045). Selection type 1 and 2
&CUCD currency Select from currencies specified in 'Currency. Open' (CRS055). Selection type 1 and 2
&FTCO from/to country Select from country codes specified in (CRS045). Selection type 1 and 2
&PYME payment method - accounts payable Select from payment methods for accounts payable specified in 'AP Payment Method. Open' (CRS071). Selection type 2
&SPYN payee Select from suppliers specified in 'Supplier. Open' (CRS620). Selection type 1 and 2
&SEPB SEPA These are the alternatives:
  • 0 = No, not a SEPA country
  • 1 = Yes, SEPA country

The value indicates whether the from or to country has 'SEPA country' selected in (CRS045).

Selection type 1 and 2
&ECYN Intrastat/Extrastat These are the alternatives:
  • 0 = No
  • 1 = Yes, Intrastat
  • 2 = Yes, Extrastat

The value indicates the selected option for 'Create Intrastat or Extrastat' for the from or to country in (CRS045).

Selection type 1 and 2

Selection of payment details in (APS092)

The objects selected in (CMS017) are the field headings in (APS092). You can set up different conditions to select the payment method or supplier bank account ID in (APS092).

Selection type 1 - 'Payment method':
  • The first field is required.
  • You do not have to set all fields, but they must be set from left to right with no gaps.
Selection type 2 - 'Bank account ID':
  • The first field is required.
  • You do not have to set all fields, but they must be set from left to right with no gaps.
  • You cannot use payment methods with payment class 2-'Check' or 4-'Draft' to select the bank account ID.

You can use a date range as an exception, both from and to dates must be set. If you set a date range on the selection in (APS092), that payment method or supplier bank account ID is used if the accounting date on the invoice is within the date range.

Enter an invoice in (APS100) or (APS450)

When you specify an invoice in (APS100) or (APS450), default values for currency, from or to country, and base country are retrieved. If the default values match a selection in (APS092), the payment method is set according to that selection. The supplier bank account ID is set according to the selection if the default values match a selection in (APS092) and the bank account ID exists for the payee in 'Bank Account. Open' (CRS692). If the bank account ID does not exist for the payee, the bank account ID is selected as if the values do not match a selection in (APS092).

If the default values do not match a selection in (APS092), the payment method is retrieved from the payee in 'Supplier. Define Purchase & Financial' (CRS624) and the supplier bank account ID with the highest priority in 'Bank Account. Open' (CRS692) is selected. If there is a local exception for the supplier or payee and the division in 'Supplier. Open/Division' (MFS620), the payment method in the local exception is used on the invoice and the supplier bank account ID are retrieved from (CRS692).

In (APS100), you can manually change the default values, and the payment method and supplier bank account ID are updated.
Note: In the Switzerland country configuration, you can only use the dynamic selection of payment details if 'Invoice ref' =1, 2, or 3 on the selected FAM function in (APS100).

Enter an invoice in APS450MI

When you specify an invoice in APS450MI, transaction AddHead, you must set the parameter 'Get payee defaults' (GPDF) to 1 to update the 'Payment method' and 'Supplier bank account ID' according to selections in (APS092). If you set the field 'Partial validation' (PVLD) to 1 and the payee defaults match a selection in (APS092), the payment method and supplier bank account ID are updated accordingly.

MI transactions

The API APS092MI (Selection of payment details) is the API for (APS092), the transactions Add, Cpy, Dlt, Get, Lst, and Upd are available.

Limitations

  • If you make changes to the payment method on a payment proposal in 'Suppl Payment Proposal. Update Details' (APS137) or 'Suppl Payment Proposal. Update Details' (APS631), the supplier bank account ID is not automatically updated. 
  • If you make changes to an invoice in 'Acc Payable. Change Sep Invoice' (APS201) or APS201MI, the payment method or supplier bank account ID is not automatically updated.
  • If you specify an invoice prepayment type 2, 3, or 5 in (APS100), no dynamic selection of payment details is used.
  • The payment method and supplier bank account ID are only dynamically selected in (APS450) if you select invoice type 06-'Final invoice' or 20-'Supplier Invoice'.
  • Selections from (APS092) are only retrieved if you set the field GPDF to 1 in APS450MI. If not, the details specified in APS450MI are used.
  • The dynamic selection of payment method cannot be used if 'Invoice ref' = 4 on the FAM function in 'FAM Function. Open Details' (CRS406) for country configuration Switzerland.