Results 1 to 4 of 4

Thread: Financial Statements SQL Query - F0006 F0901 F0902

  1. #1

    Question Financial Statements SQL Query - F0006 F0901 F0902

    First post on this site. Inherited a OneWorld Xe environment on Microsoft SQL Server. Need to pull in via SQL query from F0006 F0901 F0902. Anyone have this query available to read in balance sheet and P&L data? Basically trying to do an M&A financial roll-up to a new company defined in another ERP.

  2. #2
    To add a little more clarity I'm trying to pull from Microsoft SQL 2000 server into SQL (Reporting) or Infor SX.e Progress DB (Primary ERP). Daily financial balance sheet, profit and loss (P&L), trial balance, and cash flow. Starting with Balance Sheet.

  3. #3
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,229
    Dude,

    you're not going to get an answer because its not just a simple query. I'd want money to come up with what your asking because its going to take some time and effort plus a lot more information from you.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  4. #4
    Thanks for the response. Go ahead and PM or email me a list of questions so the time and effort can be estimated/quoted.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.