Define Currency and Calendar

Oracle Apps R12 General Ledger Course Oracle R12 General Ledger
32 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$15
€14.22
£11.84
CA$20.98
A$23.06
S$20.15
HK$116.75
CHF 13.28
NOK kr165.77
DKK kr106.06
NZ$25.51
د.إ55.09
৳1,786.11
₹1,265.56
RM67.07
₦25,122.15
₨4,153.57
฿520.60
₺516.94
B$86.81
R271.60
Лв27.80
₩20,955.80
₪56.05
₱885.29
¥2,336.46
MX$303.09
QR54.50
P203.35
KSh1,942.50
E£745.50
ብር1,839.57
Kz13,689.91
CLP$14,569.35
CN¥108.69
RD$900.14
DA2,001.45
FJ$34.06
Q115.38
GY$3,125.48
ISK kr2,066.10
DH149.33
L273
ден873.89
MOP$119.82
N$270.23
C$550.04
रु2,019.53
S/56.72
K60.14
SAR56.31
ZK412.89
L70.76
Kč359.40
Ft5,826.69
SEK kr164.97
ARS$15,026.33
Bs103.65
COP$66,110.23
₡7,597.64
L377.64
₲116,406.56
$U641.25
zł61.68
Already have an account? Log In

Transcript

In this video we are going to discuss about define currency and calendar define currency under calendar. Yesterday last video already we had created chart of account a chart of accounts is a collection of segments okay. So, we created our company's chart of account, it is a collection of four segments like the first one is a company segment, second one is the department segment, third one is the account segment and the fourth one is the product segment. After defining the segments and we created value sets for each segment, and assign the value set to those segments that already completed. Now, after assigning the value sets to the segment, the next step is go to define Go to enter the values on wireless sets go to enter the values on each and every valid search. So already we discussed already we declared four segments each segment there is a one separate values that we assigned.

Now go to enter the values on each and every value set. Okay, so a value set is a collection of valid values. Now go to enter the values on each and every segment. In our company structure there is already four segments already declared we entered four segments. Now go to enter the values on each and every segment after entering the values then go to define a currency under calendar. Okay, so now let's go to login to the application.

Login to application okay now go to log into the GL module. Now go to log into the GL module. Now go to log into the GL module how to log into the GL model with the help of the GL irresponsibility. Okay. Fine. Switching responsibility login to application with help of us enemies operations and password is welcome and go to the GL responsibilities there is a responsibility.

Already the Oracle Application provided when standard responsibility to GL model. It is a GL responsibility, then the ledger we should operations us here General Ledger vision operations USA. So it is their standard responsibility of their GL modules were to log into the GL module which helps of this responsibility. the help of this responsible they gotta log into the GM module. Okay, select the responsibility, the reservation operations Yes. And go to Okay.

Now it displays all the GL menus. Now it displays all de GL menus. Okay. So yesterday already we created our company Chart of Accounts. The name of the chart of account is test accounting structure right. The name of the chart of account is test accounting structure.

Already, we created a study guide In that chart of account we declared four segments. Now go to enter the balance on each and every segment. How we can enter what is the navigation is setup financials like surface key values. The navigation is sector financials Lexus key values what is the navigation and setup financials plexuses key values displays the value set window. This is the value set window. First go to query de application segments.

The application numbers General Ledger were to query the general ledger application And what is the title title means here flexible title. So, what is a flexible title? A flexible title is accounting flexible right. A flexible title is accounting flexible and what is the structure of your chat if I could go to Select your structure? What is a structure chart of account structure? First accounting structure right.

So, accounting structure yesterday already we created right got to select your structure name and what is the first segment in this structure What is your first two segments? The first segment is company right. Go to query one segment, enter the segment Select the segment from the list of values already. The segments already be declared In a company chart of account test account and structure is the name of the chart of account in the chart of account the first segment is a company segment got to select the first segment and then go to click on Find go to click on Find button okay. So, this is a valid signal here itself we are going to enter the values on each and every segment. Now what is the value?

So, always the arkell application accepting the course what is the company names because in the company segment we are going to enter the company names right. Suppose if you have multiple companies, we enter all the company names into that company's segment. What is the name of your company's got to enter their names because, but instead of entering the name the Oracle Application accepting the course Does your company code go to enter the code? Suppose the code means you take any numeric values. Suppose I'll take the company code as 01. And what is the name of your company enter the name of your company into that description field.

Suppose our companies TCS test underscore ACS okay. Suppose if you have multiple companies enter all the company names into that companies segment and enter all company names into their company segment. Okay. Okay, now are labeled is this from month to means from date and to date these two dates are not mandatory and it's not a parent company. So two level is not mandatory. And one more of qualifiers are described here.

So a little bit We discussed in Oracle Application the qualifiers and the two types. The first one is flexible qualifier and second one is data segment qualifier. The first one is flexible qualifier and second one is the segment qualifier. Solid is the flexible qualifier solidi attachable at the time of declaring the segment we must ensure that as flexible qualifiers okay. So, there is a two types of qualifiers flexible qualifiers are mandatory one is balancing segment qualifier and second one is that natural So, this was the mandatory qualifiers you must include a sign that qualifies for the segment that is completed and the second type of qualifier is segment qualify. The segment qualifies are the two types a low budgeting and low cost I know budgeting under ello posting.

So why do you find this to us enabled only? Okay segment qualify sub two types ello budgeting ello posting for each and every segment by default these two are yes okay. So this is the first company values so like this if you have multiple companies, we are going to create multiple values here. Go to the second line I have one more companies 02 and what is the name of your company that stands for telco test underscore telco. Okay, it's another company so enter the company name, test underscore telco and assign the qualifiers same qualifiers okay and suppose I have one more company 03 cordis the name of the company is test underscore disco. So like this See how to enter the company name suppose if you have multiple companies so minimum we required the one company and maximum you can enter more than companies also.

Okay so now I have three companies I in Canada three company names into the company's segment okay got to set up friendly then got the saved and evil reckon message transection complete a recursive pregnancy Okay, close it okay. So this is a company segment like this and like this you enter the value Sunda department segment also And then the values on that department segment okay same navigation go to Korea departments same navigation sector financials flexitarians key values go to query the company application. So, the application is a general ledger and title is accounting flexible and the structure is just accounting structure. And the second segment is that if I go to click on the file, so departments in any company you take there is a different departments are there right. Any company you take there is a different type of departments are their go to define them?

Department details one by one Suppose what is a code holiday they use the company double digit code right now what do you say triple digit code for the depositor? So first time using 0000 means no department suppose I enter the description as no department notified 10 minutes is agenda only. So whatever the transaction was selected for deposit no 00 so that transaction is relating to overall companies not a particular department means it's the overall company department for all companies, not a particular department. Okay, I'm saying flexible qualifiers to qualify low budgeting Allah posting low turnover and the goal to give the department's suppose 10101 operations department okay. Line 02 production department 103 finance department and 104 HR department like they say how to declare their departments one by one like this How to declare the departments one by one. Okay.

So go to savage and closet okay. And the third segment is account segment right gotta enter the balance on each at a car segment, same navigation corridor icon segment. Dayton's application is general ledger title is a content lexical segment is sorry structure is display content structure and segment is a concept. In the icon segment we are going to enter all the mandatory icons in the icon segment we are going to enter all the mandatory accounts. So, there is a different icons out there right. So, go to enter the icons one by one the company maintains different type of accounts like they maintain assets they maintain their expenses, they maintain the liabilities that maintain the incomes.

Okay. So, different icons they can have go to create different icons here mandatory Okay, so the code is 1001 It's a four digit number. So first is a cash account. That is a cash because capacity hacker sign the qualifier right. So here, additional qualifiers also displayed because of The National account because we assigned account is a national account right the segment set qualifier we assigned a national account qualify right national economies. So all the accounting rules are applicable to this account and what does arrows what comes in debit what goes out credit all expenses losses are the debit all incomes and gains aka credit because of the qualifying it will asking that what is a contra type because there is a different type of accounts right?

According to the account type only the defaults are becoming debit and credit. Allah budgeting Ella posting that normally displays that to qualifies for all the segments but especially for a count segment. We must include assign that account type also the content type is enabled because of the national account. Okay, there is a different type of icon types are there expenses, losses, assets, liabilities units. What is the first second is that cash what is a cash is an expense account that it is a set account and it is a liability it is ownership or is a revenue what is the cash cash cash in cash in bank sorry cash in hand is nothing but asset right select the type of work on this asset the remaining two are not mandatory third party control account and reconciliation okay okay the second one is bank bank cash at Bank is also one type of asset right chain asset and go to define some expenses expenses expenses comes under the type of expenses.

Okay and what is the difference? Any type of expenses are maintained by the company suppose for example, salaries paid. So, company code to pay the salaries to employees right salary says that expense for the company and that is the income for the employer, the company find effort that is expense, whereas employment after that is income expense and the suppose the company paid to rent to office. So, it is also one type of expense like this you have to do all our expenses and sometimes the company maintain some incomes are revenues, incomes are nothing but their revenues. incomes are nothing but revenues what they received. So, company receives that interest on the invoices industry scan industry See, suppose maybe they can have some sort of deposits or any other interest that is the revenue the type of assets so company always maintain some mandatory code that is read at retail ending second its ownership back on the second is mandatory for the journal processing.

It's a wonder the type of account is of ownership and suspicion suspense account. The suspense account is also mandatory and when the suspense account is mandatory whenever they create any wrong entries is a debit amount and credit amount and debt and the suspense account is enabled. And translation adjustment account translation adjustment, so, this account is mandatory for them. translation of currency means if they want to translate the currency from any other from from functional currency to any other currency at the time we require this translation adjustment Okay, so I entered this different accounts Okay, whenever we need any new accounts at the time we have to add that to that account segment any at any time you can add other items. Okay And finally for the segment is a product segment before the test and reduce product select now we don't have any products under the product values either zero or no products right so only two qualified say we can close it.

So does that does I listen? Okay okay Got to create a currency currency means company functional currency. So, already by default the Oracle Application can condense different types of standard currencies are out of all currencies we need to select one as our functional currency okay. So, go to enter your currency, the navigation is set up currencies define setup currency is defined. So, what is your currency how to decide the currency means according your company location, suppose your companies in India or function currencies I Anna are your companies in us You are compunction, currencies $1 right. So, based on the company location you are going to define that currency suppose my companies in India I entered my current currency as test underscore I am a name of the currencies Standard is the name of currencies Indian countries in India and the symbol is Rs precision is to calculate the decimal points by default take the decimals other two decimals.

Okay? This is our function currency after that go to St. So always the company maintains only one functional currency and they can have multiple reporting currencies if you want to work on in any one reporting Currency later we'll assign the reporting currency Not now. So, this is our PST is INR is our functional currency okay and next one is the calendar. In the GL there is a two types of calendars right one is a fiscal calendar and second one is the financial calendar. So go to define one calendar compulsory one calendar is down.

First go to define the type of calendar setup, financial calendars types, setup financial calendars types. What is the period name, test underscore period. period is minimum one day maximum is 31 days. Test underscore period periods is a minimum 151 day bye So Mr. T one does something and that our cafeteria name is test underscore periods. How many periods in a year so totally I entered 12 periods but is it type of calendar fiscal calendar month starts from first to January ending is 31st or December. description is not mandatory I'm going to save it Okay, next up is go to define a certain set of 12 period calendar, setup financials, calendars accounting.

Go to view the calendar named test underscore calendar and description is not mandatory and what is that period prefix the first period is January 2018. That's the period at the end name. Here is 2018 quarter is better numbers one starts from first of January 2018 to 31st January 2018. Like this, you have to define all the periods. February has two periods and 2018 first quarter second month 01 2018 to 2018 2018. next March that's the period 2018 quarter 01 March 2018 31st Of March 2018. April best affiliates 2018.

Second quarter for the month 01 April 2018. Theater April 2018. Man superiors who does an 18 second quarter that's the Manta 01 may 2018 31st of may 2018. June as two periods 2018 our second quarter 601 June 2018. Theater June 2018 Rely as to period. Third quarter seventh amantha 01 July 2018 31st July 2018.

August as two periods 2018 third quarter eighth Amanda 01 August 2018 31st of August 2018. September 2018 third quarter, ninth the month September 2018. Back to September, two donated over two periods. who donated for the quarter? 10th Amanda 01. October 2018.

October 2018. Now remember as to 2018 for the quarter 11th a month 01. November 2018. Happy sad. Number 2080. December is the period 2018 for the court.

The month is 01 December 2018 31st December 2018. Okay. So like this we have to define all the 12 periods after that go to save it. Transaction complete a 13 liquor supplements okay closet at the time of closing it displays What message do you want to validate the currently displayed calendar on your calendars so now go to whatever whenever we create a new calendar new machine should go for the validation of the calendar and validation means checking the IRS so we don't run the validate all the calendars we want to validate only our calendar on what to click on current. So now displays the one message to our calendar validation concurrent request status by 941758. Okay, so here one standard program is turning for validation of the calendar.

Go to see whether the program is successfully completed or not. If this program is successfully completed, your calendar setup is Complete how we can say means go to the View and the cost Go to View request. Find now the calendar program is completed successfully after completing of this calendar after completing of this program your calendar setup is completed successfully. Okay. So now we created resources Chart of Accounts currency and calendar right. Chart of Accounts is a collection of segments already be declared for segment Company department accountant product and also we enter the values on each and every segment that has are completed and second one is we declared our company functional currency what is our company functional currency is the INR we declared the company functional currency as an add on and now we declared our calendar.

So our company calendar is a fiscal calendar it starts from first of January and ending is 31st to December total it contains 12 months okay. So we declared alpha three says okay, we created all the three senses. After creating the three senses the next step is go to define that primary ledger. The next step but step is go to define the company primary ledger with help of this resistance. So that setup will say into the next video

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.