How to use the Dunning Wizard How To Guide
How To Guide SAP Business One 8.2 & 9.0 How to use the Dunning Wizard Overall Business Processes FINANCIAL Related Business Process FINANCIAL ACCOUNTING Responsible Department ACCOUNTING Involved Departments ACCOUNTING Last Updated 08/01/2014 Copyright © 2014 Supernova Consulting Ltd. All rights reserved. The current version of the copyrights, trademarks, and disclaimers at www.supernova-consulting.com/files/Supernova_Disclaimer.pdf is valid for this document. This content may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, or any information storage or retrieval system, without written permission. Requests for permission should be directed to [email protected], +357-25-817880, or mailed to Supernova Consulting Ltd, P.O. Box 56747, 3309, Limassol, Cyprus QF 4.19.14 – v1 – 27/09/2012 Approved by: KDS Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Created by: EPP Page 1 of 25 How To Guide SAP Business One 8.2 & 9.0 CONTENTS Background ........................................................................................................................................ 3 Glossary ............................................................................................................................................. 3 Prerequisites ....................................................................................................................................... 4 Step 1: Define Dunning Interest and Dunning Fee A/c ................................................................. 4 Step 2: Create Dunning Terms ....................................................................................................... 5 Step 3: Define Dunning Terms for Customers .............................................................................. 7 Exclude irrelevant A/R invoices from the dunning process .......................................................... 8 To exclude a specific invoice ..................................................................................................... 8 To exclude all invoices created for a specific customer ............................................................ 8 Example of a Dunning Wizard .......................................................................................................... 9 Step 1: Wizard Options ................................................................................................................ 10 Step 2: General Parameters .......................................................................................................... 10 Step 3: Business Partner – Selection Criteria .............................................................................. 11 Step 4: Document Parameters ...................................................................................................... 12 Step 5: Recommendation Report ................................................................................................. 14 Step 6: Recommended and Service Invoices ............................................................................... 17 Step 7: Processing ........................................................................................................................ 19 Step 8: Results.............................................................................................................................. 21 Journal Entry ................................................................................................................................ 23 A/R Invoice .................................................................................................................................. 24 Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 2 of 25 How To Guide SAP Business One 8.2 & 9.0 Background A company needs to monitor their incoming payments to ensure that customers’ bills are paid on time. When a customer does not do that, the company needs to activate a multilevel collection process, such as telephone or written reminders. To solve this issue and to automate the process, SAP Business One provides a dunning wizard, where the user can produce and send reminder letters to customers. The processes run through all customers, checks for any outstanding A/R invoices and transactions that represent debt, and enables the user to print and send reminder letters of different levels of severity. In addition, the dunning wizard lets you automatically post service invoices for interest and fees charged with a dunning letter. That functionality works through the following six modules of SAP Business One: 1. Open A/R invoices, including invoices that are partially credited or partially paid 2. Invoices that include instalments 3. A/R credit memos 4. Incoming payments that are not based on invoices 5. Manual journal entries with at least one row posted to a customer 6. Opening and closing balances transactions Glossary The following is a list of dunning related terms and definitions: Term Dunning interest rate Description A late payment fee based on a percentage of the overdue amounts in unpaid invoices. Dunning letter A reminder or warning letter used to collect outstanding payments. Dunning level Level of communication to customers for accounts receivable. Dunning is a methodical process of contacting customers to collect unpaid bills. It generally starts at the first level with a reminder and progresses on to warning letters and severe warnings as accounts become seriously overdue. Dunning term The fees and interest rate charged to customers who reach a dunning level. The dunning wizard compares a selected dunning level to all open customer documents, such as A/R invoices. If a customer reaches a dunning level, the dunning terms are specified in a dunning letter. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 3 of 25 How To Guide SAP Business One 8.2 & 9.0 Prerequisites To start using Dunning Wizard the user must first perform the following preparations. Step 1: Define Dunning Interest and Dunning Fee A/c To be able to automatically post interest or fees using service invoices, the following must first be performed: • Go to Modules → Administration → Setup → Financial → G/L Account Determination • Click the Sales tab • Click to open General tab within the Sales tab • • Dunning Interest: select the account where interest will be posted. Dunning Fee: select the account where fees will be posted. Note: The Dunning Interest A/c and Dunning Fee A/c (both G/L Accounts) will need to be defined with the assistance of the accounting department. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 4 of 25 How To Guide SAP Business One 8.2 & 9.0 Step 2: Create Dunning Terms Dunning terms are based on dunning levels and contain parameters and values required by the dunning process run. • Go to Modules → Administration → Setup → Business Partners → Dunning Terms • • • Code: define a unique number for a specific dunning term. Name: define a unique and meaningful name for the dunning term. Dunning Letter Method: select of the following values from the dropdown list. o One Letter per Invoice: create a dunning letter for each invoice. o One Letter per Dunning Level: group all the debts related to the same dunning level into one dunning letter. This option is selected by default. o One Letter per BP: create one letter for each business partner, even if the debts of the customer comprise more than one dunning level. Apply Letter Layout by Highest Level: if you select this option the template for the highest dunning level of all documents included in the letter is used. o Note: This field is available only if you choose the dunning letter method One Letter per Dunning Level or One Letter per BP. Dunning Levels: in the Dunning Level section of the window, either add, edit, or remove dunning levels with the following fields: • • Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 5 of 25 How To Guide SAP Business One 8.2 & 9.0 • • • • • • o Letter Layout: Select the dunning letter number that corresponds to the dunning level. For example, to add dunning level 4, choose Dunning Letter 04. Or Select All which is a general layout suitable for all dunning levels. o Effective After: Enter the number of days after which the dunning level takes effect. This field is disabled when the selected dunning level is All. o Fee per Letter: Enter the fee charged for a specific dunning letter. When the fee is related to the dunning level All, it is relevant only for the combined dunning letter. o Minimum Balance: Enter a minimum balance amount for the chosen dunning letter. If the debt of the customer is lower than the minimum balance defined, the dunning letter is not issued, even if the dunning level is already effective. o Interest: Calculates interest for the dunning level. Letter per BP Term: The values you enter here are used in the dunning letters to the customers instead of the ones defined for the dunning levels in the table. o Note: This field appears only if you use the dunning letter method One Letter per BP and have not selected the Apply Letter Layout by Highest Level checkbox. Bank Interest %: Define the interest rate to be used in calculations in the dunning letter: o Number of Days in Year: the default value is 360. Enter a different value, if required. o Yearly Interest Rate: to be used for calculating the interest per year. o Number of Days in Month: The default value is 30. Enter a different value, if required. o Note: This field appears only if you selected at least one Interest option in this window. Automatic Posting: Specify whether to automatically post interest and fee, interest only, or fee only when creating a dunning letter for a customer. o If you choose to automatically post interest and/or fee, a service invoice is created in the dunning run that posts the interest and/or fee. To enable this, accounts for posting interest and fee must be specified. The default accounts are taken from the G/L account determination. However, you can change this setting by choosing the (Browse) icon and specifying different accounts. o You can also choose not to post any interest or fee. Exchange Rate for Interest Calculation: Choose whether to use the original exchange rate defined in the invoice, or to use the exchange rate defined for the day on which the dunning letters are created. Base Amount for Interest Calculation: Choose whether to calculate the interest on the remaining amount (default option) or on the original sum of the debt. o Note: This field appears only if you select at least one Interest option in this window. Base Data for Interest Calculation: Choose whether to calculate interest starting from the due date or the last dunning run. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 6 of 25 How To Guide SAP Business One 8.2 & 9.0 Step 3: Define Dunning Terms for Customers To define default Dunning Terms for all customers: • Go to Modules → Administration → System Initialization → General Settings • Click to BP tab • Default Dunning Term for Customer: select a value from the dropdown list. A user is able to select a default Dunning Term from the existing or to create a new by selecting the option Define New. To define Dunning Terms for a particular Customer: • Go to Modules → Business Partners → Business Partner Master Data • Click on the Payment Terms tab • Dunning Term: define a different Dunning Term per customer. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 7 of 25 How To Guide SAP Business One 8.2 & 9.0 Exclude irrelevant A/R invoices from the dunning process To exclude a specific invoice • • Go to Modules → Sales A/R → A/R Invoice Select the invoice and click the Logistics tab. • Block Dunning Letters: Tick the checkbox and the system will automatically exclude the specific invoice. To exclude all invoices created for a specific customer • • Go to Modules → Business Partners → Business Partner Master Data Select a customer and click on Accounting tab. • Block Dunning Letters: Tick the checkbox and the system will exclude all invoices of the specific customer. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 8 of 25 How To Guide SAP Business One 8.2 & 9.0 Example of a Dunning Wizard Now the user is ready to start using the Dunning Wizard. Example: A/R Invoice: Customer C20000 Posting Date 23.09.2009 Due Date 23.10.2009 Due Amount 2820.39 Type A/R Invoice Dunning Terms: Letter Layout Dunning Letter 01 Dunning Letter 02 Dunning Letter 03 Dunning Let. Meth. One Letter Per BP • • • Effective After (Days) 30 60 90 Num. Of Day in Year 360 Minimum Balance 100 200 300 Annual Int. Rate 5 Interest (Ticked) (Ticked) (Ticked) Num. Of Days in Month 30 Go to Modules → Sales – A/R → Dunning Wizard Double click on Dunning Wizard. Then click Next. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 9 of 25 Automatic Posting Interest Only How To Guide SAP Business One 8.2 & 9.0 Step 1: Wizard Options • In this window, select whether to run a saved wizard or to create a new one. • • Start a New or Load a Saved Dunning Run. Select whether to start entering data to execute a wizard run according to a new parameter set, or to run a previously saved wizard. Find: use this text box to locate a saved dunning run. Enter a full o partial name. The system displays the first dunning run that fits the text entered. Click Next to continue to the next step. • • Step 2: General Parameters • Use this window to modify the dunning name and select the dunning level. • Dunning Name: By default it displays the dunning name calculated according to the formula: Wiz + system date + successive number. You can change the name if required. Data of Dunning Run: By default it displays the current date. Read-only. Dunning Level: Specify one particular dunning level or All. • • Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 10 of 25 How To Guide SAP Business One 8.2 & 9.0 • • Dunning Term: Specify one particular dunning term or All. The terms available are taken from the Dunning Terms – Setup window. o If you select All, all business partners can be included in the run, provided that a dunning term is assigned to them and there is some open document to be displayed. o If you select a particular dunning term, only business partners with this dunning term assigned to them are included in the dunning run. Click Next to continue to the next step. Step 3: Business Partner – Selection Criteria • • Use this window to specify the range of customers to include in the dunning run. Press Add button to select the customers. • Then all the customer details will appear in the table. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 11 of 25 How To Guide SAP Business One 8.2 & 9.0 • • • • • • • • Customer Code: The code of a customer included in the dunning wizard run. Customer Name: The name of a customer included in the dunning wizard run. BP Balance (FC): Current balance for the business partner in foreign currency. BP Balance (LC): Current balance for the business partner in local currency. Include Customers with Credit or Zero Balance: Includes customers whose balance is not negative. Such customers might have unpaid or partially paid A/R Invoices and other open transactions that reflect existing debts. Clear Table: Removes the business partner selections for the dunning run. Add: Choose Add to display the BP Properties window and enter the range of the business partners to include in the dunning wizard. Click Next to continue to the next step. Step 4: Document Parameters • Use this window to specify the range of invoice posting dates and to define the document types. • Posting Date From/To: By default displays the current dates. However, you can enter a different date range to include in the dunning wizard. Due Date From/To: Select the documents to include in the dunning wizard by entering a specific due date or a due date range. Document Types: o Include Payments Not Based on Invoices: Includes payments that are not based on invoices. o Include Credit Memos Not Based on Invoices: Includes credit memos that are not based on invoices. o Include Manual Journal Entries: The dunning wizard run considers manual journal entries created for the selected customers. • • Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 12 of 25 How To Guide SAP Business One 8.2 & 9.0 • • − Journal entries originating from JE (created via the Journal Entry and Journal Vouchers windows), OB, and CB (created via Opening Balances or Period End Closing functions) are considered as manual journal entries by the dunning wizard. − If the customer is debited (or credited with negative amount) in the manual journal entry, this journal entry is considered in the dunning wizard run as an A/R invoice. − If the customer is credited (or debited with negative amount) in the journal entry, this journal entry is considered as A/R credit memo. − Note: If the option Block Dunning Letters (in the Form Settings - Journal Entry window) is selected for a specific manual journal entry, this journal entry is not considered by the dunning wizard run, even if the customer for whom it was created is included in the dunning wizard run. Letter Parameters: o Allow Negative Dunning Letter: Specify whether the application should generate a dunning letter if negative document amounts exceed positive ones. o Display All Open Items: Includes invoices and manual journal entries of type invoice that are not yet eligible for a new dunning letter (at a higher dunning level) or any dunning letter. When you choose this option, the dunning letter shows all open invoices, irrespective of their due date, that have not been paid, credited, or reconciled. − Note: This field is enabled and visible only if you selected All in the Dunning Level field in step 2 of the dunning wizard. Click Next to continue to the next step. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 13 of 25 How To Guide SAP Business One 8.2 & 9.0 Step 5: Recommendation Report In this step, the system displays a recommendation report. This window lists the transactions and documents, grouped by customer, for which the system recommends creating dunning letters. The user can select or deselect the customers and documents to be included in the dunning run. • • • • • Time: The exact time that the Recommendation Report was produced. o Transactions and/or documents that match the specified parameters, but were posted after the displayed time, are not included in the recommendation report, and therefore will not be dunned in this run. User: The name of the user who initiated the dunning wizard run. New Due Date: Date to be displayed on printed dunning letter informing customer the date by which the company expects the payment for outstanding items. This date is not copied to the displayed invoices or manual journal entries of type invoice. Include Payments Up To: Specify a date that informs customers of the date that was used to find outstanding items. Customers who have made payments after this date will know that they can disregard the dunning letter. o Example: a user runs the dunning wizard on Monday morning, August 16, 2010. However, payments received during the weekend have not been entered in the system yet. The customer receiving the reminder is informed that the payment made during the weekend is not yet applied and the dunning letter can therefore be disregarded. Detail Lines: o Customer Code: The BP codes of the selected customers. Use the Expand/Collapse icon to view the documents and/or transactions related to a specific customer. o Letter No.: The successive numbers of the dunning letters that are recommended for a specific customer. Use the Expand/Collapse icon to view the list of transactions and/or documents included in each letter. o Level: Dunning level associated with the respective document and/or transaction. If required, you can change this value up to the level defined in the dunning term assigned to the customer. o Doc. No.: The document type, document number, and the specific row number in the document to which the dunning run is applied. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 14 of 25 How To Guide SAP Business One 8.2 & 9.0 o o o o o o o o − Example: The value IN 172/1 indicates that the dunning run is applied to A/R invoice no. 172, row number 1 in the journal entry created by the A/R invoice. This row is the one that is posted to the customer. − Note: If the document type is JE (manual journal entry), OB (opening balance), or BC (closing balance), the row numbering starts with 0 and not with 1. So the value JE 285/0 would represent the first row in journal entry no. 285. Due Date: The due date of each document or transaction to be dunned in this dunning run. If you specified a different due date in the New Due Date field, the new date is considered in the dunning run. Last Dunning Date: Date of the last dunning run, if a transaction or document was included in a previous dunning run. Document Amount (FC): − The original total amount of the document or the journal entry in foreign currency (FC). − Negative amounts represent transactions in which the customer is credited (such as incoming payments). Document Amount (LC): − The original total amount of the document or the journal entry in local currency (LC). − Negative amounts represent transactions in which the customer is credited (such as incoming payments). − When you enter a local currency amount, the foreign currency is not calculated accordingly. Open Amount (FC): − The amount of the document or transaction that is not yet paid, credited, or reconciled in foreign currency (FC). This is the amount to be dunned in this dunning run. − Negative amounts represent transactions that credit the customer (such as A/R credit memos). These transactions are not dunned. Open Amount (LC): − The amount of the document or transaction that is not yet paid, credited, or reconciled in local currency (LC). This is the amount to be dunned in this dunning run. − Negative amounts represent transactions that credit the customer (such as A/R credit memos). These transactions are not dunned. − When you enter a local currency amount, the foreign currency is not calculated accordingly. Interest Days: The number of days for which interest is calculated. You can change this value if required. The days are counted from the due date of the document or transaction, and based on the number of days in one month as defined in the Dunning Terms - Setup window. Interest %: The interest rate for the dunning period. The calculation is based on a formula comprising the annual interest rate and the number of interest days in the year as defined in the Dunning Terms - Setup window. − Formula: Interest % = (Interest days * Annual interest rate) / number of days in year Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 15 of 25 How To Guide SAP Business One 8.2 & 9.0 • o Interest Amount (FC): The interest amount in foreign currency (FC) calculated for this document or transaction. The calculation is based on the definitions made in the Dunning Levels - Setup and Dunning Terms - Setup windows. If required, you can change the amount. When you enter a foreign currency amount, the local currency is calculated accordingly. o Interest Amount (LC): The interest amount in local currency (LC) calculated for this document or transaction. The calculation is based on the definitions made in the Dunning Levels - Setup and Dunning Terms - Setup windows. If required, you can change the amount. When you enter a local currency amount, the foreign currency is not calculated accordingly. o Total incl. Interest (FC): The total amount to be dunned per document or transaction, including the interest amount, if it exists, in foreign currency (FC). − You can change this value if required. − When you change the foreign currency amount, the local currency is calculated accordingly. − In the letter row, the total amount to be dunned with this letter is displayed (from all the transactions and/or documents), including the interest amounts for each document or transaction. If you change the total or interest amount of a specific transaction/document, the total of the letter is updated accordingly. o Total incl. Interest (LC): The total amount to be dunned per document or transaction, including the interest amount, if it exists, in local currency (LC). − You can change this value if required. − When you change the local currency amount, the foreign currency is not calculated accordingly. − In the letter row, the total amount to be dunned with this letter is displayed (from all the transactions and/or documents), including the interest amounts for each document or transaction. If you change the total or interest amount of a specific transaction/document, the total of the letter is updated accordingly. o Fee (FC): The fee per letter in foreign currency (FC), as defined in the Dunning Terms - Setup window. If you change this amount, the new fee is applicable for the current letter only. When you enter a foreign currency amount, the local currency is calculated accordingly. o Fee (LC): The fee per letter in local currency (LC), as defined in the Dunning Terms Setup window. If you change this amount, the new fee is applicable for the current letter only. When you enter a local currency amount, the foreign currency is not calculated accordingly. o Overall Total (FC): The total amount per letter in foreign currency (FC), including the interest and fee. o Overall Total (LC): The total amount per letter in local currency (LC), including the interest and fee. o Auto posting: Indicates whether interest and fee, interest only, fee only, or neither of the two is posted automatically when executing the dunning run and creating dunning letters. The default value is taken from the business partner master data. You can change the setting, if required. Click Next to continue to the next step. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 16 of 25 How To Guide SAP Business One 8.2 & 9.0 Step 6: Recommended and Service Invoices Use this window to view the details of the service invoices and decide if you want to add them. Each line represents one dunning letter according to the previous step of the wizard. The window appears only if service invoices for interest and/or fees are recommended by the dunning wizard. • • • • • • • • • • Execution Date: Date on which the dunning takes place. Posting Date: Specify the posting date. The default value for this field is the date on which the service invoice is created. If required, change the date. Due Date: Specify the due date of the service invoice. Document Date: Specify the document date which is used for tax purposes. If required, change the date. Series: Specify numbering series for the service invoice. Project: Specify the project to which you want to attribute the service invoice. Distr. Rule: Specify the distribution rule according to which the service invoices will be allocated to cost centers. Interest Tax Code: Specify the code of the tax to be applied to the dunning interest for all recommended service invoices. If necessary, you can specify a different tax code for individual service invoices in the table below. Free Tax Code: Specify the code of the tax to be applied to dunning fees for all recommended service invoices. If necessary, you can specify a different tax code for individual service invoices in the table below. Auto. Remarks: If you select this checkbox, the Remarks field in the service invoice is updated with the dunning name and dunning letter number. If you deselect this checkbox, Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 17 of 25 How To Guide SAP Business One 8.2 & 9.0 • • • • • • the Remarks field remains empty or you can specify your own text that should appear on the service invoice. Add.: If you select this checkbox, service invoices for the interest and fee amounts will be added during the dunning run. Doc. No.: Number of the service invoice that is created when the wizard is executed successfully. Letter No.: The successive numbers of the dunning letters that are recommended for a specific customer. Interest Tax Code: Specify the code of the tax to be applied to the dunning interest for a particular service invoice. o Note: If you do not specify a tax code, the wizard will fail and no service invoices will be created. Free Tax Code: Specify the code of the tax to be applied to the dunning fee for a particular service invoice. o Note: If you do not specify a tax code, the wizard will fail and no service invoices will be created. Click Next to continue to the next step. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 18 of 25 How To Guide SAP Business One 8.2 & 9.0 Step 7: Processing Use this window to select an option for processing the dunning wizard. • • • Save Selection Parameter and Exit: Saves the selection parameters but not the recommendation report. It is possible that the next time you run the dunning wizard, the recommendation report will be different due to new or paid invoices. Save Recommendation Report as Draft and Exit: Creates dunning letters based on a specific recommendation report in the future. In addition, invoices, credit memos and payments included in will not be covered by other dunning runs. You can cancel the saved recommendation report. Execute Only, Print Later and Exit: Executes and exits the dunning run for all selected customers and documents. If in the previous steps you chose to automatically post interest or fees by creating service invoices, the following system message appears: “Service invoices will be added. Do you want to continue?” If you choose Yes, the wizard is executed. If you choose No, the wizard is not executed and you can go back to step 6 and select not to post the service invoices. o The dunning level and the last dunning run date are updated for invoices included in the dunning run, unless the invoices were included only as a consequence of your having selected Display All Open Items. o When you select this option and the wizard is executed successfully, the run is set to status Executed, Not Yet Printed. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 19 of 25 How To Guide SAP Business One 8.2 & 9.0 o If the wizard fails, for example, if service invoices could not be created due to missing tax codes, the run is set to status Partially Executed, Not Yet Printed. In this case, no dunning letters are created and the dunning level and last dunning date information is not updated. o You can then load and execute the wizard again after you make the necessary amendments in the wizard (that is, you specify the tax codes or select not to automatically post service invoices for fees or interest). o When a dunning letter is created for a customer, the business partner master data record is updated. In the Accounting tab, the Dunning Date field displays the date on which the dunning letters were created for the last time. o You can print the dunning letters at a later time. To do so, the next time you access the dunning wizard, choose the option Executed, Not Yet Printed in step 1. • • Print Dunning Letters and Exit: Executes, prints, and exits the dunning run for all selected customers and documents. If in the previous steps you chose to automatically post interest or fees by creating service invoices, the following system message appears: “Service invoices will be added. Do you want to continue?” If you choose Yes, the wizard is executed. If you choose No, the wizard is not executed and you can go back to step 6 and select not to post the service invoices. o The dunning level and the last dunning run date are updated for invoices included in the dunning run, unless the invoices were included only as a consequence of your having selected Display All Open Items. o When a dunning letter is created for a customer, the business partner master data record is updated. On the Accounting tab, the Dunning Date field displays the date on which the dunning letters were created for the last time. o When you select this option and the wizard is executed successfully, the run is set to status Executed and Printed Wizard. o If the wizard fails, for example, if service invoices could not be created due to missing tax codes, the dunning letters are not printed and the run is set to Partially Executed, Not Yet Printed. In this case, no dunning letters are created and the dunning level and last dunning date information is not updated. o You can then load and execute the wizard again after you make the necessary amendments in the wizard (that is, you specify the tax codes or select not to automatically post service invoices for fees or interest). If the wizard has already been executed because you selected Execute Only, Print Later and Exit earlier, dunning letters are printed only as recorded on the recommendation report. Click Next to continue to the next step. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 20 of 25 How To Guide SAP Business One 8.2 & 9.0 Step 8: Results When you execute the dunning run, the dunning level and the last date of the dunning letter are updated for overdue invoices included in the dunning run. When you create a dunning letter for a customer, the business partner master data record is updated. In the Accounting tab, the Dunning Date field displays the date on which the dunning letters were created for the last time. • • • If you chose to automatically create service invoices for interest or fees, the respective service invoices are created. The summary report in step 8 of the wizard shows which dunning letters have been created and which errors may have occurred. Finally, right click in the grey area of business partner window, and then click on Dunning History Report option he will be able to see the old reports. Then fill in the Selection Criteria. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 21 of 25 How To Guide SAP Business One 8.2 & 9.0 • Finally click ok and the report will appear. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 22 of 25 How To Guide SAP Business One 8.2 & 9.0 Journal Entry When the above procedures complete successfully then the user is able to see the posting from the Dunning fee or/and Dunning interest through the Journal Entry window. • • Go to Modules → Financial → Journal Entry. Using the navigation buttons go to the last record to view transaction details. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 23 of 25 How To Guide SAP Business One 8.2 & 9.0 A/R Invoice When the procedure is completed, the system creates an A/R Invoice. • • Go to Modules → Sales A/R → A/R Invoice Using the navigation buttons go to the last record to view invoice details. Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 24 of 25 How To Guide SAP Business One 8.2 & 9.0 Copyright © 2014 Supernova Consulting Ltd. All rights reserved. This content may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, or any information storage or retrieval system, without written permission. Requests for permission should be directed to [email protected], +357-25-817880, or mailed to Supernova Consulting Ltd, P.O. Box 56747, 3309, Limassol, Cyprus Copyright © 2014 Supernova Consulting Ltd. All rights reserved. Page 25 of 25
© Copyright 2024