• Search Forums
    Advanced Search Topics Posts
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
New Poster
New Poster
Congrats on posting!
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
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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.