hi i have following table and data to get opening and closing balance of every account opening balance required gdate<02-oct-2013 here is my table
- Regards Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com) LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b.
- Now compare the AGING - 7 BUCKETS – GL ACCOUNT with the TRIAL BALANCE to see if the balance in the Sub Ledger as shown by the Aging report is the same as in the Trial Balance. Technical (Table details): Query to Identify the Code Combination ID (assuming Account code is of 5 segments separated by a period).
- Wrote query as below based on JE_HEADERS and JE_LINES. Please have a look into this. After running this query, for some accounts begin_balance and end_balance amounts are mismatched when compared with to Trial Balance Report Output.
- Summary 2 Trial Balance Report Review general ledger account balances and activity for combinations of account segment values with the values of a secondary segment you specify. You also specify a range of values for a third segment, which are used to control report page breaks.
Wrote query as below based on JE_HEADERS and JE_LINES. Please have a look into this. After running this query, for some accounts begin_balance and end_balance amounts are mismatched when compared with to Trial Balance Report Output.
i need following result
closed as off-topic by Ben, Jan Doggen, Annjawn, gcochard, Sean VieiraMar 5 '14 at 4:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'This question appears to be off-topic because it lacks sufficient information to diagnose the problem. Describe your problem in more detail or include a minimal example in the question itself.' – Ben, Annjawn, gcochard, Sean Vieira
2 Answers
This is more of a comment because it doesn't answer the question. Your query simplifies to:
Some notes. order by in a subquery or CTE is not useful, unless you are selecting rownum in the next outer query. If you want the results ordered, then put an order by in the outer query.
The query itself doesn't make sense. Why would the opening balance come from the previous account number? Usually such terminology is used for dates on a particular account, and you have eliminated all dates in the group by clause.
Gl Trial Balance
Gordon LinoffGordon LinoffYou keep changing your requirements, but based on what you shown at the moment, this works:
Gta san andreas iso ps2. • Sky Force Reloaded Sky force Reloaded is a upgraded version of a popular game about spectacular air battles with many enemies and bosses. • Poker Offline Poker Offline offers the familiar gameplay that stays true to our traditional poker experience with a good design and play style of Poker game. You have a variety of shields, guns, missiles, lasers, bombs, magnets, bonuses, and much more. Go into battle on a powerful flying ship, to defeat opponents! Become the best car thief in this exciting Android game.
Which is the same logic I linked to before, when you had different data. Dj studio 5 pro apk. SQL Fiddle.
I'm not sure why you're showing your opening balance as positive though; seems wrong when all you have are debits. If that really is what you want then just swap how the balance is calculated:
SQL Fiddle.
Alex PooleAlex PooleNot the answer you're looking for? Browse other questions tagged sqloracleoracle11goracle10g or ask your own question.
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
Detail Trial Balance Report
Review your general ledger actual account balances and activity in detail. You can run this report for balances and activity entered in your functional currency or STAT, or translated to a foreign currency.The report prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity, and ending balance for the period you specify. General Ledger reports debits as positive amounts and credits as negative amounts.
Parameters
Trial Balance Meaning
When you request this report, General Ledger prompts you to enter the following:Pagebreak Segment: Choose any account segment other than your account segment. General Ledger prints a separate page for each value of the segment you choose.
Pagebreak Segment Low/High: Enter the range of Pagebreak Segment values for your report.
Currency: Choose your functional currency, a foreign currency or STAT. If you choose a foreign currency, this report shows youraccount balances translated to that currency.
Period: Choose any open accounting period in your calendar.
Amount Type: Choose PTD (period-to-date), YTD (year-to-date), or PJTD (project-to-date).
Selected Headings
Refer to the selected heading descriptions below for additional information.Account: account segment value for each account.
Description: description of your account segment value.
Accounting Flexfield: a line for each account.
Oracle Database Query
| Previous | Next | Contents | Index | Navigation | Glossary | Library |