Troubleshooting for A/R settlement workbench options

This document provides assistance and further details when selecting among the available workbench options.

Settle

This option will be executed only if the settlement balance is different from zero and the document has not yet been settled in the current settlement. The amount that will be settled for the marked document, either by an amount paid from the settlement balance or by discounts, depends on the following factors:

1.	Is the settlement running in the single currency mode or in the multi-currency mode?
2.	What is the sign of the document-to-settle free remaining amount? Note: The document free remaining amount is the remaining amount for the document excluding all the order settlement amount reservations related to the document. If the free remaining amount is negative it will be called a payment-type remaining amount. If it is positive it will be called an invoice-type remaining amount.
3.	What is the settlement balance sign i.e., is the settlement balance dominated by invoices (negative) or by payments (positive)?
4.	What is the settlement balance amount?

Single-currency mode

For all the cases listed below, the amounts are primarily calculated in transaction currency. The system currency amounts for the amount paid from the settlement balance and for the discounts (cash and hidden) will be calculated from the corresponding transaction currency amounts by applying the exchange rate retrieved from the subject document (this exchange rate is calculated based on the transaction and system currency original amounts of the document).

Owing to the applied method of the system amount calculation for both the paid amount and the discount amounts, the amounts settled for a document in transaction and system currency will always have the original exchange rate value for the document and thus no document related exchange rate difference will be created for a settled document in the single currency settlement mode.

The above described method of the system currency settled amount calculation, applied for each document settled in the settlement, does not assure that the settlement balance in system currency is zero, if it is zero in transaction currency.

When the settlement balance in transaction currency is zero, the unbalanced amount in system currency corresponds to the total of all the exchange rate differences aggregated for the entire settlement.

The amount unbalanced for a settlement in system currency will be settled by an exchange rate difference document automatically created on the settlement level at the settlement closing process. This document is created only when the settlement is closed in the single currency mode, because if it is closed in the multi-currency mode it is always required that the settlement balance in system currency is zero.

This exchange rate difference document created on the settlement level will never show up on the settlement workbench panel.

1.	Document to settle has a payment-type remaining amount (the free remaining amount for the document is negative).
	If the settlement balance is dominated by payments (i.e. is positive) the entire fee remaining amount of the document will be paid (i.e. settled from the settlement balance). If the settlement balance is dominated by invoices (i.e. is negative) and the fee remaining amount of the subject document does not exceed the settlement balance (the sign of both amounts is neglected), all the free remaining amount of the document will be paid. If the settlement balance is dominated by invoices (i.e. is negative) and the fee remaining amount of the document exceeds the settlement balance (the sign of both amounts is neglected), the entire settlement balance amount will be paid for the document. The document will be only partially settled.
2.	Document to settle has an invoice-type remaining amount (the free remaining amount for the document is positive).
	If the settlement balance is dominated by payments (i.e. is positive) and a cash discount amount is applicable for the document (the main settlement document date is assumed to be the payment date), then:
		If the total of the settlement balance and the applicable cash discount amount is greater than the free remaining amount of the document, a cash discount document with the entire applicable discount will be settled with the document and the rest of the remaining amount will be paid from the settlement balance. The document will be fully settled. If the total of the settlement balance and the applicable cash discount amount is less than the free remaining amount of the document, but the missing amount is not greater than the hidden discount amount allowed for the document, a cash discount document with the entire applicable discount amount will settle the subject document, the entire settlement balance amount will be paid for that document and the rest of the remaining amount will be settled by a hidden discount created. The document will be fully settled. If none of the above is applicable, the entire settlement balance amount is paid for the document, which will remain only partially settled. Neither cash nor hidden discount will be applied in this case. The settlement balance will become zero after the settlement.
	If the settlement balance is dominated by payments (i.e. is positive) and no cash discount is applicable for the document, then:
		If the settlement balance is greater than the free remaining amount of the document, the entire remaining amount will be paid for the document from the settlement balance. If the settlement balance is less than the free remaining amount of the document, but the missing amount is not greater than the hidden discount amount allowed, the entire settlement balance amount will be paid for the document and the rest of the free remaining amount will be settled by a hidden discount created. If none of the above is applicable, only the entire settlement balance amount will be paid for the document. The document will be partially settled and the settlement balance will become zero.
	If the settlement balance is dominated by invoices (i.e. is negative), all the free remaining amount of the document will be paid without any discounts being applied. The negative settlement balance will increase in this case.

Multi-currency mode

For the multi-currency mode settlement the same rules will be applied as for the single currency settlement mode with the following exceptions only:

The settlement balance amount displayed in system currency on the panel, before being used for the paid amount and the discount amounts calculation, will be converted into the subject document transaction currency by using the following exchange rate retrieval scheme (the first applicable rule will be used):

1.	If the document currency is the system currency the system currency amount will be directly used.
2.	If the document has a payment document type, the subject document exchange rate will be applied.
3.	If the main settlement document has a payment document type and the main settlement document currency is the same as that of the subject document the main settlement document exchange rate will be applied.
4.	If the main settlement document has a payment document type, the exchange rate will be retrieved from the exchange rate table for the main settlement document date and the subject document currency, period code and level code, if the latter two are valid.
5.	If the main settlement document has a payment document type, the exchange rate will be retrieved from the exchange rate table for the main settlement document date, for the subject document currency and for the period code and level code stored as default in the A/R control file.
6.	Otherwise, the subject document exchange rate will be used for calculation.

After the settlement balance amount is converted into the subject document transaction currency amount the same rules as for the single currency settlement (see above) are applied to calculate the paid amount and the discount amounts in the document transaction currency.

The system currency amount for each of the created discount documents will be calculated from the corresponding transaction currency amount using the related document original exchange rate (the same rule as for the single currency mode).

However, the system currency amount paid from the settlement balance will be calculated from the corresponding transaction currency amount using the same exchange rate, which was applied for the settlement balance recalculation (see above) and may be different from the document original exchange rate.

If the paid amount exchange rate is different from the original exchange rate for the document, an exchange rate difference document will be immediately created on the document level when the document is settled.

Note: In the multi-currency mode there will be no exchange rate difference document created at the settlement closing on the settlement level.

Fully settle

This option will be executed only if the document has not been settled in the current settlement yet.

The amount that will be settled for the marked document, either by an amount paid from the settlement balance or by discounts depends on the following factors:

1.	Is the settlement running in the single currency mode or in the multi-currency mode?
2.	What is the sign of the document-to-settle free remaining amount? Note: The document free remaining amount is the remaining amount for the document excluding all the order settlement amount reservations related to the document. If the free remaining amount is negative it will be called a payment-type remaining amount. If it is positive it will be called an invoice-type remaining amount.

Single-currency mode

For all the cases listed below, the amounts are primarily calculated in transaction currency and recalculated into system currency using the subject document exchange rate.

Note: All the remarks written for the Single currency mode in the Settle option description above are valid for the Fully settle option, too.

1.	Document to settle has a payment-type remaining amount (the free remaining amount for the document is negative). The entire free remaining amount will be paid for the document, independent of the settlement balance amount.
2.	Document to settle has an invoice-type remaining amount (the free remaining amount for the document is positive).
	If a cash discount amount is applicable for the subject document (the main settlement document date is assumed to be the payment date), then:
		If the applicable cash discount amount is less than the free remaining amount of the document, a cash discount document with the entire applicable discount will be settled with the document and the rest of the remaining amount will be paid from the settlement balance. If the applicable cash discount amount is equal or greater than the free remaining amount of the document, only a cash discount difference document that settles the entire free remaining amount of the subject document will be created. No amount will be paid from the settlement balance in this case.
	If no cash discount amount is applicable for the document, then the entire free remaining amount will be paid from the settlement balance for the document.

Multi-currency mode

For the multi-currency mode settlements the same rules will be applied as for the Single currency mode for the Fully settle option with the only exceptions described in the section Single currency mode for the Settle option.