Show TOC

Object documentationPayment Wizard: Step 6 - Recommendation Report Locate this document in the navigation structure

 

The following are the fields in the sixth step of the payment wizard.

The transactions are grouped in the following order:

  1. By business partners

  2. By payment methods

  3. By the grouping options you defined in the payment methods. For more information, see Payment Methods - Setup.

To open the payment wizard, from the SAP Business One Main Menu, choose   Banking   Payment Wizard  .

Payment Wizard: Step 6 - Recommendation Report
Find

Sort a column first, and specify the texts that you want to use as a selection criterion for the column. The first line that matches the entered texts is highlighted in orange. If you do not sort a column, SAP Business One searches the texts in the BP Code column by default.

To sort a column in the report, double-click the column name. The column name will be marked with or . Transactions will be sorted within its payment document.

[Selection Column]

Select the payments or open transactions to be included in the payment run.

Pmt No.

Displays the numbers countering the payments recommended for creation. Choose to view the related documents.

G/L Account Code

Displays the offsetting account in the journal entry to be created by the payment. This is either the G/L account or the G/L interim account, depending on the payment method definition.

Installment No.

Displays the sequential number of the installment to be paid.

Total

Displays the total amount of the transaction or specific installment.

Balance Due

Displays the balance due of the transaction or specific installment.

Discount %

Displays the cash discount specified in the transaction. You can overwrite this value.

Discount Due Date

Displays the last day when you can get the cash discount calculated according to the payment terms linked to the specific transaction.

It displays the document due date when one of the following situation applies:

  • The cash discount is no longer applicable, that is, the posting date of the payment wizard is later than the latest cash discount due date.

  • There is no payment terms information for the specific transaction, for example, a manual journal entry.

  • No cash discount is defined in the payment terms linked to the specific transaction.

  • The cash discount due date is later than the document due date.

To view all potential cash discounts, right-click a transaction row, and choose Possible Cash Discount.

Document Amount

Displays the balance due amount after discount of the transaction. You can overwrite this value.

If this amount is changed, the value in the Pmt Amount field is updated accordingly and a partial payment will be created. After the payment run is executed, the values in the Applied Amount and the Balance Due fields of the transactions are updated accordingly.

Bill of Exchange No.

Specify a number for the bill of exchange payment.

Document Type

Displays the type of the transaction. For example, IN represents A/R invoice. For the complete list of document types, see Transaction Type Abbreviations Legend.

Payment Currency

Select a currency for the payment.

BP Ref. No.
  • For A/P or A/R transactions, displays the value in the Vendor Ref. No. or Customer Ref. No. field in the general area of the corresponding window.

  • For journal entries, displays the value in the Ref. 2 field for the business partner row of the Journal Entry window in the expanded editing mode.

Note Note

The field is not visible by default. You can set it visible through the Form Settings window.

End of the note.
Reference

Specify a reference for the payment. It will appear in the Ref. 3 field for the G/L account row in the expanded editing mode of the journal entry to be created by this payment.

Note Note

This field is available only for bank transfers.

End of the note.
Distribution Rule

Specify a distribution rule for the transaction.

*
  • If the due date of the open transaction is earlier than or equal to the payment wizard posting date (that is, the item is overdue), the column displays an asterisk (*).

  • If the due date of the open transaction is later than the payment wizard posting date (that is, the item is not overdue), the column is empty.

Overdue Days
  • If the open item due date is earlier than the posting date of the payment wizard, the number of overdue days is displayed in red.

  • If the open item due date is equal to the posting date of the payment wizard, 0 is displayed in black.

  • If the item is not overdue (that is, the open item due date is later than the posting date of the payment wizard), the number of overdue days is displayed in black, preceded by a minus (-) sign.

Bank Charge, Bank Charge (FC)

Specify the amount of bank charge for the payment. The default value is calculated as the payment amount multiplied by the bank charge rate you defined in Payment Methods - Setup.

Note Note

The fields are not visible by default. You can set them visible through the Form Settings window.

End of the note.

Note Note

The fields are not available for bills of exchange.

End of the note.

Note Note

The fields are not available for Israel.

End of the note.
Project

Specify the project code for the payment.

Note Note

The field is not visible by default. You can set it visible through the Form Settings window.

End of the note.
Pmt Amount, Pmt Amount (FC)

Displays the payment amount in the local and foreign currency.

For incoming payments, the payment amount is calculated as the document amount minus the bank charge amount.

For outgoing payments, the payment amount is calculated as the document amount plus the bank charge amount.

No. of Checks

Displays the number of checks to be created by this payment run. You can overwrite this value.

A change affects the values in the First Check and Next Check fields because the amounts will be recalculated for the new number of checks.

Note Note

This field is available only for checks.

End of the note.
First Check

Displays the amount of the first check.

  • If there is only one check, this field displays the value in the Pmt Amount field. You cannot change this value.

  • If there is more than one check, this field displays the value in the Pmt Amount field divided by the number of checks defined in the No. of Checks field. You can change this value.

Note Note

This field is available only for checks.

End of the note.
Next Check

Displays the amount of the second check.

  • If there is only one check, this field displays 0. You cannot change this value.

  • If there is more than one check, this field displays the result of the following: (the value in the Pmt Amount field – the value in the First Check field)/(the value in the No. of Checks field – 1). You can change this value.

Note Note

This field is available only for checks.

End of the note.
Payment Order Status

Displays the status of the payment order rows. C stands for closed, which means the balance dues of all the documents in this payment order row are zero, that is, the documents are fully paid, credited, or internally reconciled. This appears only after you choose the Close Payment Order Rows button.

Primary Form Item

For G/L accounts or interim G/L accounts that are cash flow relevant, you can specify the cash flow line item or define a new assignment in the Combined Cash Flow Assignment window.

The default value is the primary form cash flow line item you defined for incoming/outgoing payments on the Cash Flow tab of the General Settings window.

Non-Included Trans.

Choose to open the Non-Included Trans. Report window displaying all transactions not included in the recommendation report with errors.

Refresh

Choose the button to recalculate the recommendation report and the non-included transaction report according to the current data.

Add Manual Row

Choose to create a payment document or a payment order row between a house bank account and a business partner or a target account without referencing any documents in SAP Business One.

To change an already added manual row, double-click the payment order row, and make changes in the Payment Row - Details window.

Caution Caution

If you go to any previous steps in the payment wizard, and then come back to the recommendation report, the manually-added rows will disappear.

End of the caution.
Close Payment Order Rows

Choose the button to close payment order rows in which all the documents have a zero balance due.

Country Specific Field: Japan
Bank Charge Tax, Bank Charge Tax (FC)

Specify the amount of bank charge tax for the payment.

Note Note

The fields are not visible by default. You can set them visible through the Form Settings window.

End of the note.

Note Note

The fields are only available for incoming payments.

End of the note.