Business One in Action - In the Dunning Wizard Function, How Are Dunning Levels Assigned to an AR Invoice?

(1)

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com

Business One in Action - In the

Dunning Wizard Function, How Are

Dunning Levels Assigned to an AR

Invoice?

Applies to:

SAP Business One,

Accounting

,

Reporting

Summary:

This article explains in-depth how the system uses the effective days defined in the Dunning Terms to

determine whether an AR Invoice has reached the specified Dunning Level.

Author:

Lorna Real, Senior Support Consultant, GSC, SAP Business One

Company: SAP

Created on: December 2009

Author Bio:

Lorna Real joined SAP in 2007 and is currently active as Senior Support Consultant for SAP Business One.

She has worked as both technical and business consultant. She authored this article as a direct response to a

partner enquiry during the Expert-on-Phone project, where she consulted on mainly Logistics and Finance

In the Dunning Wizard Function, How Are Dunning Levels Assigned to an AR Invoice? ... 3

Copyright ... 11

(3)

In the Dunning Wizard Function, How Are Dunning Levels Assigned to an AR Invoice?

Documentation Resource Centre:

How to Set Up an Automated Dunning Process in 2007 A & B

Prerequisites

1. The Dunning definitions have to be set in the database according to the document mentioned above.

2. In the Business Partner Master Data and in the A/R Invoice -> Logistics tab, the Block Dunning Letters

option is not ticked.

3. The A/R Invoice meets the criteria specified in the Steps 2, 3 and 4 of the Dunning Wizard function.

4. The A/R Invoice meets the ‘Dunning Level’ criteria specified in the Dunning Term window.

Notes



In Step 4 of 6 of the Dunning Wizard, if the option Display All Open Items is ticked, all open invoices

will be shown regardless of whether or not they meet the criteria defined for the next dunning level.



This article will focus on the 3

rd

prerequisite which is on the Dunning Level criteria.

In order to get more information about the pre-requisites in Dunning, refer to the

How to Set Up an Automated

Dunning Process in 2007 A & B

in the Documentation Resource Centre.

(4)

The dunning term has two dunning levels defined as follows:

Dunning Letter 01 – Effective after 2 days

Dunning Letter 02 – Effective after 3 days

(5)

Scenario

(6)

(7)

3. Do not select the Display All Open Items checkbox.

4. The Dunning Wizard displays A/R Invoice 170 created in step 1 above. This is because the A/R Invoice

meets the criteria for the first dunning level. That is, the current system date (21.05.2009) covers the

required dunning date (20.05.2009) of the A/R Invoice. Thus:

Due Date + Effective Days (Dunning Letter 01)

= 18.05.2009 + 2 Days

= 20.05.2009

In the Level column, the value ‘1’ is displayed to indicate that the document meets the criteria in dunning

level 1.

(8)

5. Create a second A/R Invoice for C1011 with Due Date of 20.05.2009.

6. Run the Dunning Wizard again as at 21.05.2009, the current system date with the same settings as Steps

2 and 3 above. Notice that A/R Invoice No. 172 (created in Step 5) is not shown.

(9)

This is because the current dunning date does not cover the required dunning date calculated as follows:

Due Date + Effective Days (Dunning Letter 01)

= 20.05.2009 + 2 Days

= 22.05.2009

7. If the Display All Open Items is selected, A/R Invoice No. 172 appears in the list.

Note the value ‘0’ in the Level column. This indicates that the document did not meet any of the dunning

level criteria defined in the dunning term.

The Dunning Level only increases after the wizard is executed. The system does not automatically use the

highest dunning level. Thus, even if the document meets the criteria of Dunning Level 2 in the Dunning

Terms – Setup window, the Dunning Level will still show ‘1’, if the document has not been previously

(10)



SAP Business One in Action Catalog Page



DRC:

How to Set Up an Automated Dunning Process in 2007 A & B

(11)

Copyright

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.

Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Oracle is a registered trademark of Oracle Corporation.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

Java is a registered trademark of Sun Microsystems, Inc.

JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this docume nt serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("S AP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

Business One in Action - In the Dunning Wizard Function, How Are Dunning Levels Assigned to an AR Invoice?