Payment Wizard

[Former Member]

Dear All,

Why to use payment wizard?

How to use payment wizard?

Regards,

S.S

[soloboysree]

Hi Former Member,

your asking 2 questions

1.Why to use payment wizard?

Ans: The use of payment wizard, if enables you to generate INCOMING and OUTGOING payments single or multiple transaction in a single transactions through bank transfer or cheque transfer mode and also having facility for multiple filters due invoices like customer wise, document wise, due date wise & Value wise in the tab selection criteria then we have filtering data what we have it easily .

2.How to use payment wizard?

Ans: Kindly find the following procedure step by step

Payment Wizard

Open the payment wizard and select either new payment run, or use a previously saved payment run.

General Parameters

Select general parameters for the payment run. You can add a new payment run name. The date for the payment run, and the next payment run date

Select outgoing or incoming payments, and whether it is a check or bank transfer. This will change the types of recommendations you received from the payment wizard.

Select your numbering series and confirm. Likely this will not need to be changed. You can also filter based on min payments, and whether it is determined on document or payment. This is for if your are saving the payment run.

Can also include BP reference number.

Business Partner

Based on the general parameters of the payment run, the wizard will allow you to select based on Business partner code.

You can also filter based on business partner group, and properties. You can choose to add expanded selection criteria such as a UDF or other master data.

Add these vendors to the list and check the business partners for this payment run.

Document Parameters

Business partners have now been selected for the payment run, but we have not defined what types of documents will be included for these vendors.

You can create a selection priority based on due date, posting date, cash discount or pay-to details.

Then you select the types of filters for the AP or AR transactions that you are creating a payment run for. This can allow you to narrow down your payment run, or expand it.

Payment Method

Based on the data provided in the previous parameters it provides the selection for the payment method.

Because we have selected outgoing check, and the types of business partners, it has selected the “out chk” payment method for this payment run.

Clicking the box on the left selects this payment run.

It is important to confirm the max out going amount or it will not allow to process the pay run.

Recommendations

Based on the criteria provided, the wizard generates a list of recommended payments.

In this case this has generated a list of 4 payments for vendors, and a total amount of ~$95k. This also contains information regarding the GL account, the check amount, if there are multiple checks based on business partner master data, and the notes for the outgoing payment.

You have the option to remove lines, or add manual lines at this stage.

You now have the option to save the payment run, save the recommendations, execute a payment order, or execute an actual payment run.

The wizard will confirm that it has executed the payment run successfully.

Printing

The summary notes what types of documents were created. In this specific run there was a payment and a check created.

This gives us the option to print a check as stated on the right hand side. If the check checkbox isn’t shown this is due to no checks being created in the payment run.

You can print the checks directly from this screen.

The selection of the print button will open the document printing selection criteria.

Regardless of the checks have been created, we are simply selecting to print these checks now.

You select the bank information for the document printing, this will generate all the bank information based on the check.

Selecting okay on the selection criteria opens the Print checks for payment screen.

This allows you to select the next check no. and shows the internal id for this check number, along with other relevant information for these documents to be printed

It is important to have both check and bank transfer payment methods setup prior to the payment runs.

May be its useful to you incase any further support reach out to us

[jitin_chawla]

Hi,

Payment Wizard functionality is helpful if the user needs to create multiple payment documents in one go. Mass handling of the open documents and creating a payment is supported through this functionality.

Using the Payment window may be cumersome as it can have only one Business Partner for which the payment can be created. However, using Payment Wizard, multiple Business Partners can be selected and the open documents for all selected Business Partners can be executed together to create payment documents.

Hope it clarifies.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Dear Suresh,

Refer this link.

http://help.sap.com/saphelp_sbo2005asp1/helpdata/en/a2/19b63e1734e16fe10000000a114084/content.htm

Thanks,

Srujal Patel

[former_member541807]

hi,

Payment Wizard

The Payment Wizard in SAP Business One creates automatic payment for clearing A/R and A/P invoices with the automatic creation of incoming payments and outgoing payment using bank transfers, bill of exchange and/or checks for payment.

The Bill of Exchange payment means is relevant for the Belgium, Brazil, Chile, China, France, Italy, Japan, Korea, Portugal, and Spain.

Prerequisites

To use the payment wizard you should make the following definitions:

Define Banks

Define Payment Methods

Define Payment Run Defaults

Define default payment methods for business partners.

Definitions in the Business Partner Master Data

Definitions in A/R and A/P invoices and credit memos

Process

1. Choose: Banking Payment Wizard . The first window provides a brief introduction to the Payment Wizard function. Choose Next to start the Payment Wizard.

2. Make the required choices in each step and move to the next step by choosing the Next button.

Result

Once a payment run is executed the following occurs:

· The relevant incoming payments and/or outgoing payments are created. The checkbox Created by Payment Wizard in these documents is selected.

· The paid A/R and/or A/P invoices are closed, and the Applied Amount field is updated accordingly

· If the payment run involved bank transfer or bill of exchange, the respective electronic file is created.

Payment Wizard: Step 1 - Payment Run Selection

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

To open the wizard, choose Banking Payment Wizard .

Payment Wizard: Step 1 u2013 Payment Run Selection

Start New Payment Run Creates a new payment run process.

Load Saved Payment Run Opens a table from which you can choose a saved payment process to run:

View Executed Payment Runs u2013 Displays the payment runs that are have already been executed.

Payment Run Name u2013 Name of the payment run.

Date u2013 Date when the payment run was saved or executed.

Total u2013 Total amount of the payment run.

No. of Pmts u2013 Number of payments created by the payment run.

Status u2013 Indicates whether the payment run has been executed or just saved.

Go to Final Step u2013 Skips directly to the final step.

Payment Wizard: Step 2 - General Parameters

The following are the fields in the second step of the Payment Wizard.

To open the wizard, choose Banking Payment Wizard .

Payment Wizard: Step 2 u2013 General Parameters

Payment Run Name Automatically defined, unique code, which you can change if required.

Posting Date Specify the posting date of incoming/outgoing payments to be created by the payment run.

Payment Type You can create both outgoing and incoming payments in the same payment run:

Outgoing displays all open A/P invoices matching your previous selection.

Incoming displays all open A/R invoices matching your previous selection.

Payment Means Applicable for Chile, BL, Spain, Portugal, Italy, and France.

Specify the payment means to be used in the payment run:

For outgoing payments: check, bank transfer or bill of exchange

For incoming payments: bank transfer or bill of exchange

Payment Wizard: Step 3 - Business Partners - Selection Criteria

The following are the fields in the third step of the Payment Wizard.

To open the wizard, choose Banking Payment Wizard .

Selection Criteria

Selection Column Select the business partners to include in the payment run.

Business Partner Balance Current balance for the business partner

Add Opens the BP Properties window, where you can specify selection criteria to display business partners in the table.

Payment Wizard: Step 4 - Document Parameters

Use this window to specify document parameters.

To open the wizard, choose Banking Payment Wizard .

Payment Wizard: Step 4 u2013 Document Parameters

Selection Priority Specify the field by which invoices to be cleared will be sorted in this payment run.

A/P Transaction Available only if you selected Outgoing Payments in Step 2.

A/P transactions complying with the following parameters will be included in the payment run:

Due Date From...To...u2013 Specify a due date to include A/P invoices or manual journal entries whose due date is within this range. If tolerance days were defined, the 'due date to' for the payment run will be calculated as follows: .

Posting Date From...To...u2013 Specify a posting date range to include A/P invoices or manual journal entries whose posting date is within this range.

Document Date From...To...u2013 Specify a document date range to include A/P invoices or manual journal entries whose document date is within this range.

Amount From...To...u2013 Specify an amount range to include A/P invoices or manual journal entries whose total amount is within the defined range.

Number From...To...u2013 Specify a document number range to include A/P invoices or manual journal entries whose number is within the defined range.

A/R Transactions Available only if you selected Incoming Payments in Step 2.

Due Date From...To...u2013 Specify a due date range to include only A/R invoices whose due date is within the defined range.

Number From...To...u2013 Specify a document number range to include only A/R invoices whose number is within the defined range.

Payment Wizard: Step 5 - Payment Method - Selection Criteria

The following are the fields in the fifth step of the Payment Wizard.

To open the wizard, choose Banking Payment Wizard .

Selection Criteria

Select the payment methods to include in the payment run.

G/L Bank Acct G/L account linked to the bank defined for the payment method.

G/L Intm Acct G/L interim account defined for the payment method.

Max. Incoming Amt Available only for payment methods of the incoming type. Specify the maximum amount to be recorded in the bank account defined for the payment method for the current payment run.

Max. Outgoing Amt Available only for payment methods of the outgoing type. The default amount is the bank's current credit balance (if it exists), which is the maximum amount paid from your bank for this payment method. You can overwrite this value.

G/L Balance Current balance of the bank account linked to the payment method.

G/L Interim Acct Bal. Balance of the interim account as a result of this payment run.

Expected G/L Balance Bank account balance after the payment run process. This is a combination of the current balance as displayed in the G/L Balance field and the balance of the G/L interim account.

Payment Wizard: Step 6 - Recommendation Report

The following are the fields in the sixth step of the Payment Wizard.

To open the wizard, choose Banking Payment Wizard .

Payment Wizard: Step 6 u2013 Recommendation Report

Deselect the invoices and payments that should not be included in the payment run.

Pmt No. A counter field numbering the payments recommended for creation. Choose to view the related documents.

Balance Due .

G/L Account Code Offsetting account in the journal entry that will be created by the payment. This will be either the bank G/L account or the G/L interim account, depending on the payment method definition.

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

Payment Currency Currency of the payment.

Installment No. Sequential number of the installment paid.

• 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.

Total .

If this amount is changed, a partial payment is created and the Payment Amount is updated accordingly. After the Payment Wizard has been executed, the Paid/Credited field in the invoice is also updated.

More Information

Payment Wizard: Step 7 - Save Options

The following are the fields in the seventh step of the Payment Wizard.

To open the wizard, choose Banking Payment Wizard .

Payment Wizard: Step 7 u2013 Save Options

Save Selection Criteria Only Saves the selection criteria for the invoices.

This does not reserve the selected open invoices for this payment wizard only. You can still clear the invoices using either the incoming or outgoing payment documents or using a new payment wizard.

When loading a saved payment wizard, it will not display invoices cleared by other methods.

Save Recommendations Saves the recommendations for invoices.

This option reserves the selected open invoices for this payment wizard only, which means that open invoices saved under this option cannot be cleared using the incoming or outgoing payment documents or using a new payment wizard.

Execute Runs the payment and creates the corresponding incoming and/or outgoing payment documents.

Payment Wizard: Step 8 - Payment Run Summary

The following are the fields in the eighth step of the Payment Wizard. The window appears only if you executed the payment run.

Payment Wizard: Step 8 u2013 Payment Run Summary

Payments were added Number of payments created in the payment run.

Checks were added Number of checks created in the payment run.

Bank transfers were added Number of bank transfers created in the payment run.

Payment Wizard: Step 9 - Document and Report Printing

Specify the information required in this step of the Payment Wizard.

To open the wizard, choose Banking Payment Wizard .

Payment Wizard: Step 9 u2013 Document and Report Printing

Outgoing Payments, Incoming Payments Prints the outgoing and/or incoming payments created in the payment run.

Non-Included Transactions, Country Summary, Currency Summary, BP Summary, Payment Method Summary, Bank Account Summary, Payment Summary Select the relevant options to print the respective reports. Choose to display each report.

Payment Wizard: Step 10 - Checks for Payment Printing

The following are the fields in the tenth step of the payment wizard. The window appears only if the payment run created checks for payment.

Payment Wizard: Step 10 u2013 Checks for Payment Printing

Bank Name, Bank Account Name and the number of the bank account for which the check was created.

From...To... Range of check numbers drawn from the bank account specified in the previous column.

Print Opens the Document Printing - Selection Criteria window, where you can set the required parameters for the check printing.

regards,

Fidel