In this video we are going to discuss about FSC. FSA FSA means financial statement generator. It is a one standard report. In this report we are going to discuss about FSA. FSA means financial statement generator it is a one standard report. It's a profit and loss account.

In the last video, we had we had discussed about this Taliban's report right. Relevance report is also standard report but the structure of the report is given by Oracle only. So, we cannot customize that structure. But the second type of report is FSC. It is a financial statement generator report. It is a profit and loss account report.

According our client requirement, we are going to customize this report. Okay. According our Client requirement we are going to customize the structure of the report. Actually what is a report? A report is a one sentence application when we are going to develop your report if you want to see the backend data into the front end in a one specified format editing we are going to develop the report editor and we are going to develop here report Okay. So now, I have a profit I have a profit I have a loss I have expenses I have income now I want to show I wonder calculating whether company gets a profit or loss.

How we can calculate wins with help of this report? FSA report. Okay, it is a one standard report but we can customize this report and the structure is given by Oracle. But we can customize that structure according over time. We are going to customize the structure Okay. Now, let us see how to develop this statement generator report log into application actually the financial statement generator report can contains like two sets, but does it two sets mean the first one is their column set and second one is the row sector The first one is that column set and second one is that row set what is the column set means?

Because what does that report columns Okay, what is the report columns and what is the report the rows columns are nothing but a period advice saying let go trial balance report we develop it according to the period wise right. So, it's there we'll develop the quarter period of and one time and after a month total money and also so this is also one year a one time one time quarterly. So, we have to give the expenses according to the period vice columns are nothing but our period names columns are nothing but our period names okay. So, now we are in the march period there is no January transaction there is no February transactions within the march period. So, directly will create a march period report on only one month transactions they can help right Linda transactions we can help and what is the rows many periods will say according to our requirement you can use the periods columns but rows means only three rows at there.

The first one is expenses and second one is income rows and third one is profit or loss. Okay, in this report, we have to give the three rows the one is the expense row second one is in camera and third one is profitable last drone profit our last row Okay, so go to give the three rows and according to the period go to view the columns okay contains a two sets row second column set First we are going to constructing the row set after that column set and then go to run that report go to run that report. Okay. So now go to log into the first step is reports define process. First go to define the role search report to define a rule set. gotta use a rule set name you can give any name The standard scope description is not mandatory and go to click on that define roles.

So what does that roll call? What is the line one? So, like we have to enter the row line so line number row line number. Suppose my line starts with five onwards. And what is that item line item. Now I want to display all the expenses go to view the line heading as expensive.

Okay, in the first line, I entered the heading of the lines expenses and under this heading I'm going to view all the different type of expenses. The company maintenance different type of expenses that enter all the expenses in this savings. Under the different expenses rent, paid salaries. salaries are expenses right? Like does he have to do the expenses one by one? Like this, you have to do the expenses one by one.

After that, go to add all expenses to the line. Total Expenses total expenses. How to alter calculating net total means assigned account assignment click on the assignments. So are the two sets expenses and the combination of two expenses as ledger displays at company zero displays the T department three zeros displayed is a counter image total I want to display to a consolidation rent right? selected to a concert and what is the displaying T for both t t for total B for extend B for both but I want to display that too expensive select that B for both them okay okay now that we selected that to expenses core common Okay, after that go to this is a one cluster of expenses and whatever the secondary income stream go to create a second oh he did self funding from 48 onwards incomes 45 income schools interest dividend total incomes I'm going to add in the two to be under the two incomes one is interest received and dividend received.

So go to add that to expenses to income sorry. Total incomes and go to click on account assignments are the two incomes and select the quarter combinations t t for total company department account interest received and rent recently entered. So here change the display type as a BB for both okay Now go to say this is a second row and whatever the third row first row is expensive. Second, raise the income. And the third row is that profit or loss. Save it and close it new at profit, loss, net profit or loss.

How to calculating the profit or loss go to click on the calculation button go to click on that calculation button. The first ad all incomes sign is plus sign And go to select the income lines then comes lines are 45 to 50 right 45 to 60 to incomes renter sued and dividend received plus second and minus A incomes right select the minus sign and select the expenses here and feed okay. So first we had to add all the incomes after that minus that expenses after that minus expenses on the two lines are mandatory one case one is income line second one is the expense line. First I'll add the all incomes and then minus the expenses minus That expensive okay got to save it. So, these are under three rows, one is the expense row second one is the income raw third one is the profit or loss.

And next is the second set is the columns that go to define that column set. Go to define the column set the navigation is reporter defined column set, reporter defined column set a name of the column row column search. Column shapes are nothing but columns. What does the report columns because report columns will this is a one year report right? So, you have to select all the columns from January to December, you have to select all the columns. But in our case, we have only current period transactions.

So, Right there is no other period transactions okay display only current period transaction but in the real time maybe we develop the report yearly once at the time of year any editor we have to create shortly 12 months January to December or April to 31st of March and each period ways we have to get over expenses, our law incomes and finally calculating the loss of profit or loss. So, if there is it okay then the two amounts are the two lines or maybe expenses greater than two incomes, you will get a profit expenses are greater than two incomes, you will get a loss our incomes are greater than two expenses you will get a profit. Okay, now go to view the column set name you can give any name column set name and go to click on the columns. Just go to the column name. position is a form Position suppose, where you want to display the columns.

Suppose I in the left side I had to give all the column or hair lines right, I had to leave some margin on the left side. So now the first column starts with 50 sorry 41st pasta sequence. Amman type is a PT one currency there as Diana enter them minus one, zero offset is minus one So this is the first column. I'm the go to click on the new 55 second BDD One, two columns are created. If you want to see the column building set, see here two columns I created though I had to leave the left margin for the left side. One, two columns I created my nice 40 pages And second one is up to 35 position like this you can create a different type of columns you can maybe you can get wealthy from columns also.

Why because in the real time we are going to download the report only one time later at the time of year ending on it okay are going to deal with that totally. One year transactions on that means 12 months is magnet. But in our case we only one live one month the transactions are in the one month only few days only. Okay, we can create minimum one or two columns. The first column is a blank second one column with display some values are that's why here there is no income transaction we always use the two expenses unless there is no income transactions. Okay.

You got to save it tonight. clauses. So, these are the two sets are mandatory one is the CRO second second one is that columns after that go to develop that conquered go to call a concurrent program. Reports define report. Report to define report the report name, test report. A row set or a row set is created as an ID column set And then go to run report and then go to click on the run report.

So this action will automatically save your work do you want to continue? Yes. So transaction complete one record upload and save it Okay. Now the report, standard program is running FSA report selected and period is March period. Today's date on the second of March and the currency and goto submit standard program was submitted. This is a program now number 543760.

That doesn't say this because whether the request is successfully completed or not, if it is completed successfully, then you will get out close it Request fine. Now the report is pending refresh it completed got to click on the view. So because we have only limited transactions on the right, this is a structure report structure. Limited transactions are there. Okay, but in the real time we have to develop the report totally one year report right at the time it displays all the content but here we have only limited transactions on Okay, this is the structure of the report. Okay, so this is seven standard Report FSG report.

So trial balance report under FSC both as a standard report, but trial balances we cannot customize their report structure by default whatever the structure given by Oracle we have to follow the structure on it. But whereas the generator report is we can customize that report Okay, we are going to create our own structure of the report okay and what is security rules and account aliases and access set security rules when solidi we assign the security to the serpent's right basically the security those are the three types no security, hierarchical security or non hierarchical security. So always be how to use a non hierarchical security or Levi because whenever we need a security to the segments, so directly we are going to sign in the second To the segment's are live without any permissions with help of that non hierarchical security, but sometimes we sometimes when we require the security means if you want a sign that cross validation rules to the segment's at the time we required the security rules if you want to send out cross validation rules if you want to sign the cross validation rules to that segments okay then we require this security.

Okay, so basically all the security types are given by the Oracle army. All the security types are given by that, or kill. We never created new security types. Using of the security types. We are going to Let's stick the chord combinations. So as a function consultant you must include assign the security to the segments.

Okay, how to assign the security means with help of the wireless section. So security is mandatory for the segment's whenever you want to go for defining that. cross validation rules. cross validation rules. Okay, if you want to sign the cross validation rules at the time we required the security. By default, you must enter to enable the security the segments, how we can enable moves with help of their non hierarchical security.

Always be selected the non hierarchical security only to the segment's with help of the non heroine A security. So whenever we need a security to the segments, so we can assign the security to the segment directly not have any permissions okay and next is access it access it is nothing but the ledger sets already we created when we require this access that means suppose if you want to define the logistics into the applications and data needed by this access section. Suppose in the process of consolidation we require the ledger sets the processing of the consolidation we require the ledger to go to create a ledger set with the help of the primary ledger Tell us about the primary ledger go to create a ledger sets, assign the legit set to the responsibility level. Next a code actually this is also not mandatory in a content area so we'll create a content e SS within the flexible Dolly application on our will create main setup financial laxatives ke le SS Okay, go to query Structure go to query mode press f7 and view the structure name is just accounting structure, application and general ledger select your journey This is your structure number two, you have got to create alias names, template alias names the standard school and what is that template name?

View that account URL is sort of the core combination. Description. Okay, now when I go to save it, so by default that combination Alias Name is created Okay. So after creating the tally is when I enable it so tasking from date and to date from date to date is not mandatory okay? From date and to date is not mandatory go to save it after saving it is permanently saved and after that journal enter new there are no good gentlemen Gentlemen So here the Talia says are created that just means parcels are created. Okay when I select the code combination the costumes are created on select the day we enter the amount for under So that restrictor card or combination that when I select that combination it is restricted right?

Whatever combination the sticker that does that value or not. So this is nothing but I can tell you so still created false claims to the segments. Okay. So these are the reports and the security the security rules are mandatory My stranger assign the security rules my son should assign that security rules to those segments. Okay, these are the two reports are mandatory standard report and FSG report. So this is a one trial balance report and FSA report FSA report is their profit and loss account report.

It is a mandated report you must ensure develop the reports the profit and loss account. Here we are going to show all our expenses are lower incomes using up that two or double calculating that profit or loss on using up the story or going to calculating the profit or loss. Okay, finally, that amount is transferred to balance sheet. So, this is Dr. Maria okay. He had a bye In this creation of flexibles, rising of the statistical pricing of the journals, like a different than a standard journal, recurring journal budgets, consolidations, reporting, currency cross validation. So all these are the important