1 / 7

Re-instating balances & Identifying the balance on an Analysis Code

Re-instating balances & Identifying the balance on an Analysis Code. Oracle behaves different to CODA in that balances do not carry forward on Courses and other activities. We therefore have to reinstate the balances before we have a true picture for one year.

serena
Download Presentation

Re-instating balances & Identifying the balance on an Analysis Code

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Re-instating balances &Identifying the balance on an Analysis Code Oracle behaves different to CODA in that balances do not carry forward on Courses and other activities. We therefore have to reinstate the balances before we have a true picture for one year. We have done this by adding the opening balance on account 03300 This Applies to the following Analysis Code Types: AL%, AN%, BA-BF, J%, M %(where applicable; ex UWCM)

  2. Example If a course started in August 2010 the Year To Date Funds Enquiry will look like this, There will be no Brought Forward balance. The Carried forward balance will be £1,800.00 in hand

  3. In the second year we are posting the brought forward balance of £1,800 on account 03300. If you run the Year To Date Funds Enquiry at the end of year 2011 you will see that the balance has now grown to £3,600.

  4. In the 3rd year we will post the brought forward balance of £3,600 on account 03300. If you run the Year To Date Funds Enquiry in year 2012 period 5 you will see that the balance has now grown to £13,100 in hand.

  5. The only issue with this method is that when running a Project to Date Funds Enquiry the accumulated Brought Forward balances are picked up on 03300. Hence the Carried Forward balance is overstated by the £5,400. If you need Project to Date reports then the Brought Forward balance must be deducted.

  6. The balance on an Analysis Code using Project to Date Funds Enquiry With the brought forward balance, Year to Date is correct With Project to Date we ignore 03300 If we ignore 03300 , then we only pick up the legitimate accumulated transactions and not the opening balances. However it is not practical to restrict the search criteria in Funds Enquiry and using File>Export is a better idea.

  7. Using File Export Click within the data area, Then Click FILE, Then Click Export. The data appears in Excel where it can be manipulated

More Related