Learn to identify customer bad-debt for which no provisions, or inadequate provisions, have been made. Management do not declare bad-debt in order to hide the fact of not meeting accounts receivable targets. This course gives you the fraud scenario, the SAP data you need from ECC or S/4HANA, the Python code and logic, and a hands-on dashboard with an AI chatbot to test your data literacy.
Video lessons · Quiz included · Certificate of completion
€99,00
30-day satisfaction guarantee · Cancel anytime
Understand the real fraud scenario behind the analysis.
Get the exact SAP data and Python logic to run it.
Practise on a live dashboard with an AI chatbot.
Main risks If your organization does not post provisions for bad debt then they could be liable for a fine…
Customer invoice When a customer invoice remains uncleared (no clearing document: AUGBL) as shown in the picture below, then it…
Payment terms To calculate the age of a customer invoice, we need to know when it was due. The payment…
Payment terms To calculate the age of a customer invoice, we need to know when it was due. We can…
Identify accounts that are used for doubtful debt In order to find the accounts that are used for doubtful debt,…
Identify accounts that are used for doubtful debt In order to find the accounts that are used for doubtful debt,…
Consult the dashboard below to see if you can find provisions for bad debt not posted.
Founder, 300Framework · Former Big 4 SAP audit lead
For 25 years I sat on the audit side of SAP — chasing exceptions, untangling P2P breakdowns, explaining to finance teams why their controls weren't catching what they thought.
The 300Framework distills what actually works: the questions that surface real risk, the SAP queries that pull the right data, the workflows that turn findings into fixes. It's the playbook I wish I'd had on day one.
SAP Certified · Big 4 alumna · 189 courses authored · Based in Lisbon
The risk
Management do not declare bad-debt in order to hide the fact of not meeting accounts receivable targets.
What you’ll learn
This course teaches the Provisions for bad debt not posted analysis from the Financial reporting area of the 300 Framework (Provisions): how to identify customer bad-debt for which no provisions, or inadequate provisions, have been made. We start with the real-life fraud scenarios behind it, then give you the accounting and SAP background you need to judge whether the data is genuinely pointing to a problem in the specific context of your organisation.
The data and the code
You’ll get the exact SAP data required to run this analysis from either ECC or S/4HANA — the relevant tables, fields and how to join them — followed by a walk-through of the Python code and its logic: the filters, the joins, the algorithms, and the Artificial Intelligence tools you can layer on to enhance your result set.
Test your skills
Finally, you’ll put it into practice on a real dashboard, answering questions from our chatbot to find the exceptions in the data and choose the most interesting samples to investigate.
Taught by our experts in fraud detection, internal audit, internal control and SAP.
READY WHEN YOU ARE
Get instant access. Lifetime updates within your access period. Cancel anytime.
€99,00
30-day money-back guarantee · Instant access · Certificate included
The methodology behind 25 years of SAP audit excellence.
by Aufinia