Separate certain branches from Financial Statements

SOLVED

We have recently come into the need of breaking out a certain branch location from our regular financial statements.  In any of the parameters that come from the canned parameters, it will only let you select a range, and not any specified values.   It seems to go directly to excel and avoid a crystal report (from what I can tell).   Does anyone have any suggestions to be able to perform what I'm trying to do?


I saw there is a "Financial Statement Builder" but it just says START and CLOSE, so I'm assuming that is an extra module we don't have.


We are using 6.0 right now with upgrade to 2014 happening end of December.

Parents
  • 0

    Uh, click Start.... that takes you into Excel. FR is added to Excel under Add-ins as FR. No extra purchase necessary. Note that it only works with 32 bit Excel.

    Click Help, Documentation and open the ENG folder, look for Financial Reporter User Guide. Follow the tutorial in the User Guide, it's not rocket surgery.

    You need to use GL segments to do the report you are looking for. The canned reports are very generic, most companies require reports to be written for their needs.

  • 0 in reply to Ettienne Schwagele

    yes, we use segments obviously.  only really trying to figure out how to pull out the -150 from a range of (-100,-101,-140, -150, -160, -180)

    I looked in excel and don't see a financial reporting tools, so maybe I need to download some add-ons.  That being said, it doesn't really sound like a solution.  I'm not an idiot by any means, so please hold off on the comments.  We are all adults

Reply
  • 0 in reply to Ettienne Schwagele

    yes, we use segments obviously.  only really trying to figure out how to pull out the -150 from a range of (-100,-101,-140, -150, -160, -180)

    I looked in excel and don't see a financial reporting tools, so maybe I need to download some add-ons.  That being said, it doesn't really sound like a solution.  I'm not an idiot by any means, so please hold off on the comments.  We are all adults

Children