Prev
Next
Forums Lawson S3 Financials

Variance report

Sort:
You are not authorized to post a reply.
Author
Messages
Chandra
Basic Member
Posts: 6
Basic Member
3/30/2009 8:03 PM

    I am creating a budget variance report in reporting services. I am looking for (1) Revenue  --  Acutal / Budget    and    (2) Expenditure - Acutal / Budget.  I was able to go after some tables like GLTRANS, FBDETAILand etc.

    Can some one help me please identifying what table should I go after for my requirements (1) and (2) above for Acutals and Budget ?

    Thanks

    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    3/31/2009 7:58 PM
      i dont think this can be addressed as a standard answer since depending on how you implemented Lawson and your COA is set up will differentiate how to successfully accomplish this. A few things to remember are:

      -You cant join FBDETAIL and GLAMOUNTS/GLUNITS directly since Budget is by account and actuals are by account and date
      -Revenue and Expenditure will be based on the account mappings that relate to the those roll ups
      -it may be possible that your company is using summary accounts that hold the mappings

      you may get better response if you post this in the Lawson EPM (Enterprise Performance Management)>Lawson Business Intelligence/Reporting/Crystal

      John can probably move this for you too.

      hth
      matt
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      k-rock
      Veteran Member
      Posts: 142
      Veteran Member
      3/31/2009 8:33 PM
        I always used a union query to view the tables by account, then calculated a variance in whatever tool I was using.
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
        3/31/2009 9:09 PM
          I have a couple in the store (https://www.lawsonguru.com/store.aspx) that do budget vs actual. Have you looked at those to see if they come close to your needs?
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.