i am trying to set up a recurring reversing journal in
Oracle GL, my problem is i have income balance of £30k that
i only want to show 1/12th in a period over 12 months. can
any one help me set it up . i want to show
P01-13 opening balance £30k less £27500
P02-13 reverse P01-13 journal
P02-13 opening balance £30k less £25000 etc. or does anyone
know of another way it can be done automatically every month.
- 1 Answers
- 2343 Views
- Honda, Oracle, I also Faced
- E-Mail Answers
Answer Posted / Ravish Babu Bharti
In Oracle GL, you can create a recurring reversing journal using general ledger (GL) journals and the Recurring Journals feature. Here's an example of how you can set up your desired scenario:
1. Create a new GL journal with the opening balance of £30k as a debit to the income account and a credit to cash or bank.
2. Set up the recurring journal with a frequency of monthly, starting in period P02, and adjusting the amounts accordingly (P02-13: Debit income account £27500 and credit cash/bank £30k; P03-13: Debit income account £25000 and credit cash/bank £30k).
This method allows you to create a recurring reversing journal that will automatically adjust the opening balance for each period.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
As you know account executives need to be talented salespeople. Do you have experience making sales?
WHICH QUESTIONS ASKED IN EPFO IN 2009.
rate of vat on gold purchase local & o.m.s. & rate of % in sale local & o.m.s.
Can you send me advertisement format for lost of E-1 form. kindly do the needful urgently. Thanks AP
PLZZZZZZZZZZZZ HELP ME FOR THE PREPARATION OF TEST JR.EXECUTIVE (ADMIN)IN ATM IAM APPEARED 1ST TIME IN THIS TEST MY TEST CENTER IS RAWALPINDI MY CONTACT NO IS 03338907330
what is your opinion regarding T.V shows on youth
hi, this is shanthi kumar(M.Com). i would like to attend interview in genpact company.please send finance interview questions and interview details. thank u very much
Dear sir , 1-what is diffrence local tax & vat 2 -what is sales tax. tds. service tax challan & return due date(monthly & quartly, annually) 3- what is deprecation rate in company act 4-what is income tax latest limit-
How many invoices on average do you handle on a weekly/monthly basis?
Tell me what is your track record for consistently achieving your targets?
Why did you choose the a-levels you did?
The following information is extracted from the audited books of accounts of a chain of food stores for the period ended 31st December 2015. Revenue Statement (Trading and Profit and Loss Account for the year ended 31st December 2015. BWP’000 BWP’000 Sales 460 Cost of good sold (220) Gross profit 240 Wages 50 Other expenses 30 (80) Net Profit 160 Note: The purchase figure included in the cost of goods sold of P255 000. Balance Sheet as at 31st December 2015 BWP’000 BWP’000 Fixed Assets 400 Current assets: Stock 80 Debtors (trade) 120 Bank 400 ----- [600] Current liabilities: Trade creditors 300 ------ [300] 300 Net Assets 700 ==== Financed by: Share capital 600 Revenue reserves 100 ------ 700 Shareholders Funds 700 ===== Required: (a) Calculate the following accounting ratios: (i) Current ratio (ii) Acid test ratio (iii) Stock turnover (in days) (iv) Debtors turnover (in days) (v) Creditors turnover (in days) (vi) Return on capital employed (ROCE) (vii) Gross profit percentage (viii) Net profit percentage (b). Give a brief comment on the performance of the company, based on the above ratios.
Tell me do you have any professional experience of this field?
VAT PER SURCHARG KAB SE KIS DATE SE LAG RAHA HAI
why i want to join Hawkins company
