Prev
Next
Forums Financial Management Lawson S3 Financials

RW assistance

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Boyd
Advanced Member
Posts: 39
Advanced Member
5/16/2011 9:41 PM
    I am a RW novice and need assistance creating a report. The report (a standard income statement) I would like to create is for a certain level group that I created. I would like the report to show only the information from the level group and at the same time consolidate the results of like accounting units into one on the report. So far the only luck I have had is to either show one of the accounting units or the consolidated group. As of now I am using a style 1 report.

    Any thoughts are appreciated.

    Boyd
    MarciaM
    New Member
    Posts: 1
    New Member
    5/27/2011 6:23 PM
      Hi Boyd,
      A solution I represent will do this for you. We will do a direct connect to your Lawson GL database and allow multiple consolidations upon accounting units, companies, etc in Excel. Let me know if you would like information on this. We have many Lawson S3 clients running our software. This means your current P&L you have in Excel, we can make it "live" by getting data directly from the database. This will allow you to drill back into the summary items on your P&L all the way back to your sub ledgers. As well, your data will be real time while performing consolidations to eliminate rekeying of data, data manipulation, and exportation of static data.

      Let me know if you would like more information as we can assist you in other ways, like report distribution.

      Thanks,

      Marcia

      Boyd
      Advanced Member
      Posts: 39
      Advanced Member
      6/1/2011 12:31 PM
        Marcia
        Thank you for the response. I think I have seen this product in a demo. Unfortunately I don't have the dollars or resources to add any functionality at this time.
        Boyd
        Gail Gudgel
        Basic Member
        Posts: 14
        Basic Member
        6/1/2011 2:11 PM
          Boyd, like you, we do not have the financial resources to purchase other products, especially when a well contructed Report Writer can get the job done. There are a varity of solutions to get disparate hiearchy units/levels to show and combine in a report. For style 1 reports, because the level is determined on the report form, you would have to utilize additional formats-assigning a separate format that has a level override to the row that has a different structure than the 1st group you started with at the report level - you would need to be sure to have the Total Option set to Yes, by Format. Or use a style 3 report - which is probably the easiest way to combine different levels/units. if you get lost you can contact me: ggudgel@urmstores.com