Prev
Next
Forums Financial Management Lawson S3 Financials

Periodic Accurals

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
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.