AR Customer Open Item Analysis Drilldown Report

Okay, let us look at one more version of Customer Open Item Analysis. This will allow drill down analysis.

Thank you for reading this post, don't forget to subscribe!

 

 

Okay. Let’s see how it will be useful. It’s available here. Remember I told you when I was explaining about the customer open item analysis, this report, I was telling you that you can also see the due date analysis using this report. We will see how different is this from the earlier report. Choose that one. Put in Sun.

 

 

It says no account selected, right? No records were selected because I think this customer does not have this customer, 50002, does not have any open items, so let’s choose the other customer which is 50001. Sun. Sun. Hopefully, there are some records. Yes, there are some records here. See this. This is the open item’s balance and this is the aging analysis is already due, so it’s under the 0 to 30 band, 31 to 60 band, and so forth. I think the total number of days due is less than 30 days, that’s why it’s under this ban here. Okay. If it’s not due, then it will be displayed under this column.

 

 

Okay. Let’s zoom into this figure. You have the company code level, you can see the balance. Now, the Great Britain level, you can see the balance, means the customer’s country. Customer’s country is Great Britain, so you can see the total balance at the country level. Now if you drill down further, you can go to details of the total, which is these two. Okay, we have one invoice and one reverse invoice, so if I zoom into this, I’ll come to the customer total level. Zoom in again. I’ll go to the document level, document level balance, if I zoom in further, that’s the last level I can go. Document level is the last level I can go. So you have zoomed all the way from document type to company code and country and posting key level and customer level. Once again, if you cannot understand, start from scratch.

 

 

See this? This is something like a hierarchy. You need to understand the hierarchy first before you can understand this report. The document type is the highest hierarchy. This is the balance at the document level, and under the document type, you have the company code level balance, under the company code, you will have the country level balance. The customer’s country, not our country. Customer’s country level balance. Under the country, you can see the posting key level balance. Under the posting key, you see customer level balance. This individual customer. That’s how the hierarchy goes.

 

 

This is the top level hierarchy. When I zoom in, I can see the total at the company code level. See, the document type has been zoomed in, so we’re seeing the balance of the company code level. If I zoom in further, then I will zoom into the company code, I can see the balance of the country code level. This is the customer’s country. If I zoom in some more, I can see the balances at the posting key level. I have this balance made up of two posting keys invoice and reverse invoice. If I drill down further, I can see the customer B. Okay. That’s the last level, I think.

 

 

We have one more level. This is the document type level. From here, I can go to the prospective document. Just bear in mind, select this and call up report. This button here, and it can go to the line items level. It can go to actual document level. See, this is an actual document.

 

 

Alright. Let’s go to the next topic.

 

You may watch the full course on the following YouTube link

https://www.youtube.com/watch?v=mXd6EbeDFp4&list=PLN17Nn94liux88cwVwqbiRQQo1qK4sOdQ&index=31&pp=iAQB