馃攳
SAP S4HANA FIORI : Accounts Payable Reporting and Displaying Changes - YouTube
Channel: Abdullah Galal - SAP, CMA
[0]
hi today I'm going to explain how to run important聽
Accounts Payable reports for finance and also聽聽
[6]
how to display the change logs for the supplier聽
master data and also for supplier line items so聽聽
[12]
you can identify the user that did any changes聽
to the system welcome back today I'm going to聽聽
[24]
display some accounts payable reports I'm going聽
to start the demo with SAP FIORI then I'm also聽聽
[30]
going to display the reports on SAP GUI so聽
in case someone doesn't have access to FIORI聽聽
[35]
he can still follow this video and practice the聽
reports and also FIORI has some new functions so聽聽
[41]
even if you are experienced with SAP you are聽
going to find something useful in this video聽聽
[45]
so this is SAP FIORI and I already have a tile聽
group that includes all the reports I'm going to聽聽
[52]
display today this one is analytics for accounts聽
payable so these transactions you can find all of聽聽
[59]
them in the application finder here click on聽
the application finder and you can find them聽聽
[66]
under accounts payable analytics and if in case聽
you are not able to find any of them you can use聽聽
[71]
the search box to look for any transaction so聽
I'm going to go back the reports I'm going to聽聽
[78]
cover today are the aging analysis supplier lists聽
supplier balances and supplier line items then聽聽
[86]
I'm also going to show how you can display that聽
change is done to the system on any line item聽聽
[92]
or in any supplier account so this way you can聽
always track who did that changes and why did he聽聽
[98]
change the master data or the line items so I'm聽
going to start now with the supplier list so we聽聽
[105]
start by putting a company code here so 1710 you聽
can mention different company codes I'm going to聽聽
[112]
keep the vendor field empty you can always mention聽
one vendor or several vendors I'm going to keep it聽聽
[117]
like this then click on go so this is a list of聽
all the vendor master data accounts you have on聽聽
[124]
your system on the company code 1710 you can click聽
on any vendor to display other details so if I聽聽
[130]
click here FIORI is giving me multiple options聽
I can either clear outgoing payments display聽聽
[137]
supplier balances manage supplier line items I can聽
also click on more lengths and this will display聽聽
[142]
other transactions related to the vendor account聽
if I click on the number it is going to display聽聽
[148]
the vendor or the supplier master data so this is聽
the supplier master data this is Daniel spend the聽聽
[155]
city the name supplier account number all the聽
details you are looking for so it has the phone聽聽
[161]
number address everything in the same report you聽
can display the materials that we are buying from聽聽
[166]
this vendor and you can also display the purchase聽
orders the invoices the purchase contracts the聽聽
[174]
activities so actually this is very useful and聽
this is one of the new things I have seen in聽聽
[179]
SAP FIORI so this is for the supplier account聽
mr. data now I'm going to go back to the list
[188]
and go back home to display the other reports聽
the other report I'm going to display is the聽聽
[195]
supplier balances so click on this one so this one聽
will display the supplier balances in a certain聽聽
[203]
company good or indifferent company goods so I'm聽
going to also mention 1710 and press ENTER then聽聽
[211]
go so for the company 1710 in the fiscal year聽
2018 this is the balance of all the vendors we聽聽
[219]
have this is the total debit credit balance and聽
then the cumulative balance adds the different聽聽
[226]
balance from different periods then we have the聽
purchases which are the open purchase orders for聽聽
[231]
the vendors and we have the imputed interest now聽
if you want to display any period you can click on聽聽
[237]
the number and you can also select some specific聽
vendors so for example I'm going to select SUPL I聽聽
[244]
can select this one I can also click on show all聽
items to select multiple vendors so I can select聽聽
[252]
this one this and this then click on OK go so this聽
is the balance the selected vendors now I'm going聽聽
[265]
to display the balance for the period 10 only so聽
I'm going to click here and FIORI has moved to聽聽
[277]
action of manage supplier line items which is聽
the third the report I'm going to display today聽聽
[281]
so this one displays the line items or the聽
invoices and the payments and the different聽聽
[287]
transactions posted on the vendor account you can聽
also change the documents from this screen so for聽聽
[294]
example let's say we have an invoice that should聽
be due tomorrow but we want to change that you did聽聽
[301]
to make it next week as we agreed with our vendor聽
or for any reason so you can actually change some聽聽
[308]
fields in any transaction in SA P so for example聽
let's say I want to change that you date of this聽聽
[314]
one so this is an invoice number two five one four聽
five six and this is the document type this is聽聽
[321]
actually how I know it is an invoice and this one聽
is open this is why it's red which means we have聽聽
[327]
not paid this invoice yet and it is not new yet聽
this is why it has the green sign to display this聽聽
[333]
invoice I can click on the journal entry number so聽
click here and click on the number so this is our聽聽
[341]
invoice the amount is one thousand the supplier聽
number is here we have the our assignment the item聽聽
[347]
text we have the payment method with which is the聽
check and we also have the baseline date 31st of聽聽
[353]
October 2018 and this is the payment term there聽
is a very important note here for any financial聽聽
[359]
transaction once we post the financial document聽
no one is allowed to change the sensitive fields聽聽
[365]
by sensitive I mean the amount the posting date聽
the account numbers and other important fields聽聽
[371]
but if we have authorization we can change some聽
other fields such as the text the payment method聽聽
[379]
the baseline date so some fields can be changed聽
and these are the fields that have no impact on聽聽
[385]
our trial balance on or on our financial聽
recording so in my case I can change the聽聽
[392]
payment method I can change the item payment聽
block I can change the payment term and the聽聽
[397]
baseline date for example so I'm going to go back聽
to the report and show you how to do this so back
[404]
so this is again our the supplier line item list聽
I can change multiple documents at the same time聽聽
[411]
or I can change one by one so for example let's聽
assume that I agreed with this vendor that I'm聽聽
[417]
not going to pay him his invoices on time and I'm聽
going to delay them by one week for example so I聽聽
[423]
can select multiple invoices I can click on edit聽
line items and I can change the baseline date for聽聽
[431]
all of them so for example I'm going to say the聽
baseline date will be at the end of this month聽聽
[435]
so 31st October 2018 and also I can change the聽
payment term so I am going to say if I pay within聽聽
[444]
five days or four days I will get two percent聽
discount within eight days I get one percent聽聽
[449]
discount and the maximum I'm going to pay within聽
ten days you can also change the assignment the聽聽
[455]
text and the Dunning details then click on OK now聽
we have changed the baseline date and the payment聽聽
[463]
terms for these invoices and the changes have been聽
posted now I'm going to go to another screen to聽聽
[469]
display the changes so for example if you are a聽
financial manager and you are willing to display聽聽
[474]
the changes that were done to the vendor line聽
items during the period you can also do this so聽聽
[479]
I'm going to go back home and I'm going to use聽
that display item change look for the supplier聽聽
[485]
click here so for company code 1710 I'm going to聽
display all the changes that happened between the聽聽
[494]
period of 1st of October and the end of October I聽
can also select a user I can select the supplier聽聽
[499]
and entry and then click on go so this is list of聽
all the changes done to the supplier line items聽聽
[509]
in this period on the company code which is very聽
useful to audit that change is done to the system聽聽
[513]
now let's move to the vendor ageing analysis聽
report so I'm going to go back home and click on聽聽
[521]
vendor aging analysis this one the aging analysis聽
displays the invoices that are overdue for certain聽聽
[528]
time intervals and also the invoices that are聽
going to beat you in the future for certain time聽聽
[534]
intervals also so if you check this column it this聽
one is from negative 30 to 0 which means the items聽聽
[540]
that are overdue within 30 days and the items that聽
are due today and then you have the items that are聽聽
[548]
overdue between 60 and 30 days late which means聽
that we were supposed to pay these invoices one聽聽
[555]
month ago and then you have the invoices that were聽
open between 90 and 61 and the invoices that are聽聽
[562]
open and are overdue for 90 days which means that聽
we were supposed to pay them more than 90 days ago聽聽
[569]
and then you also have on the other side these are聽
the invoices that are going to be due within the聽聽
[575]
next month and voices that will be due within two聽
months invoices that are going to beat you between聽聽
[582]
month number two and month number three and these聽
are the time intervals in seb GUI when we want to聽聽
[588]
change the intervals we have to create a new聽
report layout but in SAP FIORI you can change聽聽
[594]
this very easily click on this button and then聽
here you can change the width of the aging grid聽聽
[600]
and the number of the aging credit so for example聽
if I am willing to display the report per week not聽聽
[605]
per month I can make this seven days I can also聽
change the number of the aging grid this one means聽聽
[610]
I'm going to see four weeks in the past and four聽
weeks in the future then click on go now if you聽聽
[618]
check the report you have from zero to negative聽
seven from negative eight to negative 14 so now聽聽
[624]
it is per week and you have four weeks in the聽
past and four weeks in the future you can also聽聽
[629]
click on this number on this column for example聽
and you can display the aging analysis by company聽聽
[634]
code real account per currency per supplier group聽
and you can branch from there to different other聽聽
[639]
reports so you can also branch from this report聽
to the vendor balances and then to the vendor聽聽
[645]
line items to display the exact numbers so I'm聽
going to do a quick example so I'm going to click聽聽
[651]
here I'm going to display these top suppliers聽
connect on this one I want to see the open I聽聽
[659]
can click on open n I can display the supplier聽
balances and they manage supplier add line items聽聽
[665]
so now we see in the aging analysis that we have聽
one point five three million euros that are open聽聽
[671]
and I'm willing to know more details about this聽
so I can click on manage supplier line items and聽聽
[676]
in this report I can display the open items for聽
this vendor so this way you have a complete audit聽聽
[684]
trail so you can go from the aging analysis to聽
the exact invoices that are causing the numbers聽聽
[691]
in their analysis this is it for SAP FIORI now I'm聽
going to move to SAP GUI to tell you exactly where聽聽
[698]
you can find these reports so the reports in sa聽
big GUI can be found under accounting Financial聽聽
[705]
Accounting Accounts Payable information system聽
reports for accounts payable here you have the聽聽
[712]
vendor balances vendor items and the master data聽
so here you can find all the reports we displayed聽聽
[718]
in SAP FIORI for the vendor items for example聽
the due date analysis is the aging analysis聽聽
[724]
for the vendors so if I open this one so this聽
is the vendor aging analysis we have in sa ap聽聽
[729]
GUI as you see the layout is not really detailed聽
and not interactive as the one we found in FIORI聽聽
[735]
but this one can be changed so for example if you聽
are willing to have time intervals the same as we聽聽
[742]
have in FIORI if you are willing to have the time聽
intervals in si B GUI you have to create a report聽聽
[747]
layout and this report layout you can customize聽
in any way you want you can also branch to other聽聽
[753]
transactions same as SAP FIORI so for example if I聽
connect on this number and then click on this call聽聽
[761]
up report you can go to account balances order聽
line items so if I click on account balances so聽聽
[769]
these are the account balances that summed up to聽
the number we have in the vendor aging analysis聽聽
[774]
so this is an example for the reports and si B聽
GUI now the last thing I'm going to show is how聽聽
[780]
to display changes to the vendor master data so聽
for example if someone changes the vendor account聽聽
[786]
number or the vendor email address or the vendor聽
phone number you have access to display who did聽聽
[792]
the changes and when did he do this these changes聽
so you can go to master records and here you are聽聽
[799]
going to find a report which is FA 0 for display聽
changes click on this one now if you select the聽聽
[806]
vendor account number and the company code ASAP聽
is going to display all the changes done to this聽聽
[811]
vendor account and who did them and one so this聽
is it for the accounts payable reporting video I聽聽
[817]
have already recorded other videos to explain聽
the accounts payable invoices and payments so聽聽
[822]
this is a very good starting point to anyone聽
who is willing to learn si ap financials so聽聽
[827]
please go ahead watch all the videos let me know聽
your feedback let me know your questions leave聽聽
[831]
your comments and if you need any help let me聽
know I would be happy to support thank you for聽聽
[837]
watching my videos don't forget to subscribe聽
to the YouTube channel like the Facebook page聽聽
[841]
follow me on lanky then and also helping me by聽
sharing the videos so other people can find them
Most Recent Videos:
You can go back to the homepage right here: Homepage