Version 2 of zap Audit has been released, so over the next couple of weeks we are going to take a closer look at the multitude of new features it has to offer. In today's article, we will examine the benefits of the new dashboard, including the “process house”, what exactly it is all about, and why many of our customers find it so useful. In addition, the new dashboard provides a quick overview of findings.
In auditing, the focus is frequently on financial accounting and the commercial processes of purchasing and sales. But there are of course other business processes that are worth considering. This time we are therefore going to take a look at SAP logistics and identify where you can make the simplest quick wins in auditing. We will focus our attention here on the "movement types" in the SAP MM module.
Normally, outliers are referred to as extreme values that deviate highly from other observations. The causes of this can be manifold and range from fluctuations during measurement and experimental errors to more novel types of phenomena. In the following case, however, it is rather down to a lack of knowledge, omission or simple laziness in the execution of business processes. What we are going to discuss below is the matter of documents which, contrary to expectations, may or may not have a corresponding purchase order reference.
All day, every day, companies are now collecting enormous amounts of data about their products, customers or by simply using their information systems. Such increased availability of data raises one important question: how to use the gathered data to generate meaningful information? What is important is to connect the data and discover patterns. There are several buzzwords / terms you may have already heard related to this approach, such as Data Mining, Multivariate statistics, Machine Learning and Artificial Intelligence. Sometimes it is hard to tell the difference between these various terms.
If you want your financial accounting in SAP to be nice and clean, you need to keep things tidy. Sometimes you have to make corrections, and in financial accounting, this means making reversals. How much there is to learn about "clean" accounting becomes especially noticeable when you take a closer look at the work involved in performing a proper "cleanup". So, without further ado, let's now turn our attention to your reversals in financial accounting. This may seem a pretty dull topic, but ultimately it is one which touches on fundamental topics such as the tidiness of your bookkeeping and you may even find some weird reversals that give the impression that your transactions have not been booked in a timely manner.
Inventory differences are troublesome in many ways. After determining differences, it is often necessary to do a recount just to find out that there are some goods in the corner of a warehouse corner somewhere that nobody had thought of. At least any direct impact on profit and loss will have been avoided however. Still, it is not always possible to be so lucky. Things can get particularly unpleasant when it comes to valuable or theft-sensitive goods. You can find out exactly what valuable or theft-sensitive goods are, how they are labeled in SAP and what an analysis relating to inventory differences may look like in this blog post.
It is no longer always easy to ensure total transparency in international business relations. They are nevertheless subject to high compliance requirements. In recent blog posts, we have looked at the topic of how to analyze business relationships with countries which may potentially prove problematic. These first and foremost include payments to countries that might be suspected of money laundering and the issue of export restrictions. In today's blog post, I would like to complete our discussion of this topic and show you how to perform an analysis in SAP to identify dangerous deliveries to "rogue states".
In accounting, it is normal to always pay special attention to what is going on with your own bank accounts. This is where the cash flows in or out – depending on the circumstances. In today's blog post, though, I would like to show you how to use the data structures in SAP to find out where your money has gone. This means we will concentrate on cash outflows and look at the corresponding offsetting accounts. To try it out for yourself, there some suitable queries you can execute in SQL. You’ll need to be determined though, because this time things will be get very SQL-heavy, something for real freaks of data analysis among you auditors out there. Welcome to the Audit Data Scientist’s guide to SQL DIY hacking guide.
Only a small fraction of companies worldwide generally do trade in export-restricted goods. Nevertheless, SAP has still come up with and marked the appropriate fields for configuration in the customer master data. In this blog post, we will show you what export-restricted goods actually are, give you a broad overview of the issues involved and show you what possibilities of analysis exist in SAP.
Having already identified the top 10 "rogue states" in our last Blog Post, this week we can now go on to analyze whether any payments have actually been made to a bank account in one of those dubious states and if so to what extent. So without further ado – let's get down to business and get our hands dirty!