Hi sir id like to ask about FSG account assignment. I have a liability account which i want to map or assign on both assets and liability but i want FSG to assess its net ending balance i.e. if its a net credit then balance will be presented under liability and zero in asset or if a net debit, balance will be presented under asset and zero in liability. Thank you for sharing!
Hi I am creating Budget report with 3 column: Budget (seq 10) , Actual Amt (seq 20) and Fund Available ( seq 10 - seq 20) . All assignments at column set. But my Fund Available is not coming. What could be the reason?
Hi, is it possible to create FSG Budget report? If yes, what could be the possible Row set, on high level. Like for GP report, it is Revenue, COGS, GP. Could you please give example because I am unable to define row set structure for Budget FSG report.
Hi Arvind, I have a question regarding operating unit. Can you please tell me what function a operating unit do and what is the need of operating unit? Can we see the balance sheet at operating unit level? I am aware about that operating unit separate transactions at sub leger level and it defines at ledger level.
Yes, you are right. Operating unit is defined to separate business transactions. Every client is different and hence depending upon the business scenario, we setup Operating unit. A separate business unit can be setup as a OU or a each state can be defined as one OU etc.... Balance sheet is generated at Legal Entity/Company code level
How can I change the report output from HTML to Excel? (i.e. trial balance report in Vision Operations GL) When I go to output I do not have the option to select a different output. Thanks!
@@yasirarafat797 Format of Financial statements (i.e. Balance Sheet, P&L) differs from country to country and it takes considerable amount of time to create them and test... So, its not possible for me to create them in this test environment... But you can use the steps mentioned in my video as the base and create them on your own
i have 10 legal entities and i want to show every legal entity in separate column and under every legal entry i want to columns "last year" and "current year" then values should be displayed under it
Hi,, one ques.. in FSG we can map any COA segment at row and column set level both. Lets take an example of natural account. At row set level I have mapped natural account {1,2,3,4,5} and at column set level I have mapped natural account {3,4,5,6,7}. So what would the actual value would display in FSG? Would it be: #1. {3,4,5} or #2. {1,2,3,4,5}
Do you mean to say that you are assigning Account assignments at both Rowset level and Column set level? If so, what exactly is the business requirement? Why do you want to do that?
Hi Sir, Requirement is to get qtd trial balance, if I pass parameter as Dec-18, I want the data for current qtr i.e Dec-18 and for previous year same qtr i.e dec-17. Is this requirement possible in FSG?..
Try one column with Amount type of "QTD-Actual" with offset of "0" and the next column with Amount type of "QTD-Actual" with Offset of "-12" (Assuming you have 12 periods in the calendar)
Clear, short and precise. Thanks
Thanks
Great video sir. This would be very useful to understand the use of FSG. From this point it can get more elaborate.
Glad it was helpful!
thank you Sir for these useful short videos..
You are most welcome
Simply good. short and precise!
Thanks
Great explanation keep posting more videos
Sure. Please stay tuned to my channel
GOOD START
Thanks
I want to make all legal entities and as column with current and last year in trial balance report. please let me know what i have to do...
Sorry, can you rephrase your question... Do you want to show the data of all legal entities combined in single column?
Superb
Thanks
Gud one dude
Thanks
Thanks
You are welcome
Good one...
Thanks
Please you have any videos relevant to FSG Row order and display set
Not yet... Probably, i will add this to my to do list of topics and will let you know once i create a video for this topic
Thanks, i will wait for this...
Does similar functionality or concept exist in fusion also?
Yes, in fusion, you can build these kind of reports using FRS (Financial Reporting Studio) functionality
Hi sir id like to ask about FSG account assignment. I have a liability account which i want to map or assign on both assets and liability but i want FSG to assess its net ending balance i.e. if its a net credit then balance will be presented under liability and zero in asset or if a net debit, balance will be presented under asset and zero in liability. Thank you for sharing!
Hi I am creating Budget report with 3 column: Budget (seq 10) , Actual Amt (seq 20) and Fund Available ( seq 10 - seq 20) . All assignments at column set. But my Fund Available is not coming. What could be the reason?
We're you able to see your required numbers under Budget and Actual Amt columns? Whether the issue is only for Funds Available column?
Hi, is it possible to create FSG Budget report? If yes, what could be the possible Row set, on high level. Like for GP report, it is Revenue, COGS, GP. Could you please give example because I am unable to define row set structure for Budget FSG report.
There is no predefined row set structure, you need to create the Row set based on your business requirement
Hi Arvind,
I have a question regarding operating unit.
Can you please tell me what function a operating unit do and what is the need of operating unit?
Can we see the balance sheet at operating unit level?
I am aware about that operating unit separate transactions at sub leger level and it defines at ledger level.
Yes, you are right. Operating unit is defined to separate business transactions. Every client is different and hence depending upon the business scenario, we setup Operating unit. A separate business unit can be setup as a OU or a each state can be defined as one OU etc.... Balance sheet is generated at Legal Entity/Company code level
How can I change the report output from HTML to Excel? (i.e. trial balance report in Vision Operations GL) When I go to output I do not have the option to select a different output. Thanks!
Watch my video till end and you can see that there is a option to select the report template layout to get the output in excel..
Is it possible to generate whole financial statements? E.g. balance sheet, Income statement?
Yes, its 100% possible.... Thats the main purpose of FSG reports
@@OracleEbizandFusionVideos thanks. Can you make a whole video on this? It will be very helpful.
@@yasirarafat797 Format of Financial statements (i.e. Balance Sheet, P&L) differs from country to country and it takes considerable amount of time to create them and test... So, its not possible for me to create them in this test environment... But you can use the steps mentioned in my video as the base and create them on your own
@@OracleEbizandFusionVideos thanks again. I'll try
i have 10 legal entities and i want to show every legal entity in separate column and under every legal entry i want to columns "last year" and "current year" then values should be displayed under it
Probably you need to include legal entities/company codes in Column set and select Period type as "YTD" and "YTD-1"
Thanks
Thanks
How to import trial balance report in excel. Version 12.1.3 is it possible...?
Upload Trial Balance as Web ADI journal... Its possible in any version of R12
Hi,, one ques.. in FSG we can map any COA segment at row and column set level both. Lets take an example of natural account. At row set level I have mapped natural account {1,2,3,4,5} and at column set level I have mapped natural account {3,4,5,6,7}. So what would the actual value would display in FSG? Would it be: #1. {3,4,5} or #2. {1,2,3,4,5}
Correction for #2: {1,2,3,4,5,6,7}
Do you mean to say that you are assigning Account assignments at both Rowset level and Column set level? If so, what exactly is the business requirement? Why do you want to do that?
Hi Sir,
Requirement is to get qtd trial balance, if I pass parameter as Dec-18, I want the data for current qtr i.e Dec-18 and for previous year same qtr i.e dec-17. Is this requirement possible in FSG?..
Try one column with Amount type of "QTD-Actual" with offset of "0" and the next column with Amount type of "QTD-Actual" with Offset of "-12" (Assuming you have 12 periods in the calendar)
This good clear and shot .what about the options ?
Which Options are you referring to? Can you be more specific?