Home » Knowledge Center » Articles »
I’m going to share with you a little bit, just so you can see how we’re working with the code. So this is a Qlik app. And in our Qlik app, we have some really exciting programmes that you can get access to, and you have to see all of the rules.
It’s all about the general ledger, but it’s also about being able to analyse that general ledger in the most automated and efficient way, because we’ve got so many entities all over the world that we need to audit, and we just want to have a quick check site. It’s not the auditor’s job to actually implement a control, right? But it can be the auditor’s job to be able to do a quick check. But actually in this code, and this line is really important.
Play Video
We always put the comment, like there’s comments that you know exactly what we’re doing, and that’s really important. But you have to make sure that your team are putting really good, clear comments all the way through their code, and that the code is clean, because if it’s not, it basically means that person doesn’t know what they’re doing, and probably they made a whole lot of mistakes. And it’s only when you’ve got your code really nicely organised, and with a very nice naming convention and stuff like that, that you can follow it and you can look through it in five minutes and know exactly what’s going on.
So this is the first thing we do, is we get all of our fields from the general ledger. And you can see some things here, which is really helpful. Over time, you get to know these fields in SAP, and some fields in SAP, they just have codes.
And it’s like, what does that mean? And in SAP, you get the table, you got the general ledger, you’re really happy, like, OK, now we’re going to do some journal entry testing and stuff. And you look in the column and it just says, what is that? And you can spend a long time going through blogs and everything, trying to work out all those codes and mean. And some of the codes are pretty much standard, always exactly the same, and some of them are not.
So some of them are like, you know, document type, you have to actually go into another table, get back the description, stuff like that. And some of them, like this one, this one is the account type. They are always the same.
So it just depends. And you get to know them. And this code is really going to help.
And you’ve also got all the keys, you know, like, how do we join this to that? That’s something that David was asking about, like, yeah, but how do I find out, how do I join this table to that table? If you’re into that and if you’re doing this stuff, then at least for the general ledger, it’s going to really help you. And there are other tips that you really need to know about. It’s like, we don’t actually care if we have the status here that’s anything but blank.
Because if it’s, if it’s not blank, it’s not even something that’s going into general ledger, it’s in the SAP database, but it’s not actually something that’s even going to impact your financial reporting. And so we don’t care about it, right? So we should just totally ignore it. Then we have to convert everything into US dollars because you’ve got different company codes, you’ve got different local currencies and stuff like that.
And you don’t want to mix all of that stuff up together. Then we want to find out if things have to do with payments. And we’ve got to get information from the chart of accounts.
And then we’ve got to go through the posting key. What does it mean? What does the document type mean? What do all these other description fields, and we add them all together. And then we get all of our master data information, like the supplier, what kind of supplier is it? Inter-company supplier? Is it a one-time vendor? Is it a normal supplier? What kind of thing is it? Has it got a tax code? Is it linked to another customer? Who created it? All that stuff.
And the same with the materials. Is it generic materials, non-generic material? And what kind of material is it? And so all that stuff’s really important, really good to be able to filter your dashboard on those kinds of things. Because you might want to say, all right, I just want the FCPA controls, but I don’t care about raw materials.
I only care about goods and services and stuff like that. So that’s the kind of thing you want to be able to do really fast on your FCPA dashboard and all this information is really useful. And then we want to put things in buckets.
So this is, for example, an asset sale, asset return, asset adjustment, or it’s something to do with vendors. So it could be we’re netting a vendor and customer together, or we’re doing a supplier adjustment, or if we’re doing something normal, we are having a supplier invoice or a supply payment. So there’s all the different keys, all different flags that we are using in order to go through all of the SAP data and at the end produce our dashboard.
That’s going to help us to quickly see all the different types of exceptions, like all the journal entries, for example, for suppliers that don’t have a tax code or the customers that don’t have a tax code or all the general journal that are netting between a customer supplier and those two things are not even related. Like it’s all of these different flags that we want to be able to do. So we’re going to get a dashboard like this one, but we’re going to have a lot of different filters and we’ve had to filter really quickly on all of those FCPA questions and also going to have some nice graphs, like for example, you might want to have a map and you’ve got a map and you can see all of the journal entries about suppliers that are in the Bahamas and things like that.
So that’s, that’s what we are preparing for you. All you need to do is send me an email and let us know, yeah, I’d really like to have a copy of that app. Can you send it to me? And then we’re going to set up the link and we’re going to let you have access to the really exciting QlikSense app.
And if you haven’t got QlikSense, don’t worry because you can get free trial. And I think you can get it for two weeks and that will enable you to like go through, have a look, try it out and all that stuff.
Knowledge Center
Legal
-
Aufinia
Registered at: 1205 12/F TAI SANG BANK BUILDING, 130-132 DES VOEUX ROAD CENTRAL, HK
Registry of Hong Kong: 1717129
Contact us: [email protected]
© 2024 All rights reserved