Prev
Next
Forums Lawson S3 Financials

Periodic Accurals

Sort:
You are not authorized to post a reply.
Author
Messages
NickM
Basic Member
Posts: 7
Basic Member
2/5/2009 1:55 PM
    We currently have Lawson 9.0.

    On a periodic basis the Financial Planning and Analysis (FP&A) Team will need the Final actual data export (i.e. the financial data for each period that composes the financial statement) out of Lawson so I can upload it into our budget/forecasting tool.  We use Adaptive Planning. Export should only contain GL # and Actual.

    Can I do this through Microsoft Add-ins? Or do I need to go after it using the oracle database. I would think Addins should work.
    dcaiani
    Veteran Member
    Posts: 52
    Veteran Member
    3/6/2009 3:41 PM
      It sounds like a pretty simple addins qry. Use the GLAMOUNTS table and grab the ACCOUNT field and the CYPAMTX (with X being the period number that you want) field. You will have to set the criteria for the company and fiscal year and then you should be in business.
      You are not authorized to post a reply.