Most analysis programs offer the possibility of scripting in addition to the wide range of functions and commands. The scripting languages list here the sequence of commands and thus form the basis of standardization. Another great advantage of scripts is the enormous execution speed compared to manual processing. The script development requires some experience with macros or other sequential programming languages. In order to facilitate certain aspects, such analysis software like ACL ™ provides useful buttons in the script editor. In addition this "Function-Keys" can also be used in the filter and command line. In this post the "Function-keys" of ACL™ are explained briefly.
An accountant is having a hard time sleeping and goes to see his doctor: "Doctor, I just can't get to sleep at night." "Have you tried counting sheep?" "That's the problem - I make a mistake and then spend three hours trying to find it."
In this article, I will describe the topic “Partial Payments” in SAP® Accounts Receivable. We often receive the following questions: “How do we post a partial payment in SAP®?” “Which amount is cleared?” “Is the customer invoice open or cleared after a partial payment?” “Which clearing logic do we have?” Using an example, I will explain how you could manage a partial payment in SAP®.
Some weeks ago I attended the 3rd “Process Mining Camp”, hosted by Fluxicon. As we have been looking at and working with process mining tools for some time now, this event immediately drew our attention.
An auditor is hard at work, auditing an airline. The auditor cannot understand an excess fuel consumption on a Detroit to Erie route, for flight no. 420. The auditor calls the pilot and demands an explanation. The pilot replies “It was a late night, snow storm was raging, and I lost my bearings.” The auditor demands a statement, “for what?” the pilot asks. The auditor tells him “for lost bearings.”
In this article I will describe elements of “Pricing & Conditions” in SAP® module SD (Sales & Distribution). Pricing and conditions are an important topic for data analytics. Very often we do get questions like “What do I have to know regarding conditions in SAP®?” “How can I find out if conditions can be changed manually?” “In which tables do I find conditions master records and the transaction history for conditions?” Here I will explain which kinds of conditions exist and how they impact the pricing procedure, e.g. the calculation of the product net value.
In June 2014, the dab:Group had the privilege to celebrate its 10th anniversary. The company was founded as a Spin-Off of the Deggendorf Institute of Technology. The foundation of our motto “Changing data into Knowledge” was laid in the years 2002 and 2003 in the lecture “Finance & Controlling” which is given by Prof. Dr. Georg Herde. (the name changed to “IT-Compliance & Audit and Monitoring” these days). Already with the implementation of the degree program “Business informatics” several years ago Professor Herde pushed the topic of data analytics. With him as one of the early adaptors in that exciting area, I am very happy to have a guest column written by him.
In this Blogpost I will share my experience of my visit to the IBS Schreiber data analysis conference on June 26 to 27. IBS Schreiber GmbH has held its annual conference for data analysis in auditing for the fifth time. The event took place in Hamburg. The eight lectures were joined by about 40 people.