Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nhsa
  • Order by date
  1. nhsa

    script to implement web analyser

    Hi, I'm using oracle 9i on a server , and microsoft iis 6.0 is running on other server, I want to create a stored procedure, that read log file exist on iis server, and insert data on a table on oracle server. I want this procedure to run on daily basis, updating table content, then I will...
  2. nhsa

    PTD or YTD??

    Hi... I created a profit and loss report for all years in discoverer, Shall I use YTD calculation or PTD calculation in this report? This report is not based on period name, I displayed only period year, but I guess since the YTD calculation is comulative, the total on year will be wrong? How...
  3. nhsa

    fund inquiry screen

    Hi... I'm trying to create a report in discoverer that match what is appearing in the fund available inquiry screen , I created a report that read data from gl balances table , the budget and actual figures are correct but the encumbrance figures are wrong, I checked the GL records and compare...
  4. nhsa

    Security on accounting flex fields

    Hi... I'm trying to create a budget variance report that may be accessed by different departments, there are some security roles on the account flex field that let the users see thier departments data only , it's working fine on ERP screens but my report shows all the data, from where I can...
  5. nhsa

    GL account heirarchy

    Hi... I'm trying to create a report in discoverer that shows first the summary figures and then goes down to the account details, I want to create a hierarchy of the accounts, example: + assets + current Assets + -------- + -------- + -------- + liabilities + -----...
  6. nhsa

    Invoice, POs and MRs from GL

    Hi and thanks fro your reply,I have one comments regarding calculating YTD field, now from gl_balances table I used the opining balances with the period amount to calculate YTD , now from gl_je_lines , I will use only period amount,How can I check if the values I calculate are correct? I mean I...
  7. nhsa

    Invoice, POs and MRs from GL

    Hi... I have a report that shows the actual YTD , Budget YTD , Encumbrance YTD. I want to create another report that list the invoices data from GL since they are represent the Actual YTD figure in the first report. I tried to list the data from GL_je_lines table , but these amounts are...
  8. nhsa

    Leave Adjustment

    Hi... I need to create a leave adjustment report, where I can list employee name, type of leave , original day of leave , original last day of leave,actual day of leave , actual last day of leave and leave balance. Actually , I don't know where can I do the adjustments and where can I get...
  9. nhsa

    YTD actual and YTD budget

    Thanks a lot...............
  10. nhsa

    YTD actual and YTD budget

    Hi... How can I calculate YTD actual and budget from gl_balances table? I found this formula when I searched through metalink : YTD = begin_balance_dr + period_net_dr - begin_balance_cr - period_net_cr but when I use it and compare the report output with the system data , I get some figures...
  11. nhsa

    Budget variance report

    Thanks Alot mdwyer......
  12. nhsa

    Budget variance report

    Hi... I need a help on how to develop budget variance report in discoverer, I want to create a report listing account , budget , commitments, actual and available fund and I don't know where can I get these information? I tried to get the sql from fund inquiry screen but it seems that these...
  13. nhsa

    MR approval notification

    Thanks mdwyer for ur reply, MR is stand for Material requisition, but where can I find this pl/sql package that you talking about. thanks
  14. nhsa

    MR approval notification

    Hi... in our system , when the manager approve the MR , a notification message will send to the preparer telling him that the MR is approved , I need to modify this by sending a message to preparer and requester , but I don't know where can i find this process to modify it, and what shall i...
  15. nhsa

    Invoice Approval date?

    I checked the table and I didn't find any column? But I have an idea i'm not sure if it's correct or not since I'm new to the ERP applications, if the invoice is validated , can we change any field on it, because if the system will lock this record , then the last update will be the date when...
  16. nhsa

    Invoice Approval date?

    Hi and thanks for your help , I checked the table and it's empty, because we are not using approval workflow , we just let the user to choose validate check box from the action screen , Is this means that we can not see who validate invoices? Thanks in advance
  17. nhsa

    Invoice Approval date?

    Hi... I'm trying to find out where is the invoice approval date, and approval by fields exist in the tables? We are using a manual method to approve invoices , using validate check box , and I want to create a report showing invoice created date, created by , validation date and validated by...
  18. nhsa

    Copy concurrent data

    Thanks very much Kccbb, I read the loader part from system administration document , but I could not under stand where shall i find this configuration file ? is it exist or I should create my own configuration file? Thanks again for ur help regards
  19. nhsa

    Copy concurrent data

    Hi... I'm new in dealing with oracle erp applications,I wonder if there is a way (script) to copy the concurrent data ( executable,define , parameters) from server to another server, because it took lots of time to reenter and define request in the production were we already defined them on...

Part and Inventory Search

Back
Top