We use Office Connector (Core Associates) a 3rd party reporting tool that uses Sage 300 data to create any Excel report you like. We use it for our Job Cost Report/projecting tool, with multiple workbook tabs for drill down capability. We also use it for our WIP. You are correct, the Sage canned WIP does not allow for ME cutoff. We've found this to be a great tool, and once you learn it, it's not difficult.
Also, we still use the Financial Statement designer. I've modified the reports to give me the various analyses – like Month over Month comparison, this year to Last year, and budget comparison. I've not switched over to Office Connector for financial reporting yet, but that is certainly an option.
Hope this helps! Also, if you attend the TUG conference in May in New Orleans, they have a whole tract dedicated to Office Connector.
Chief Financial Officer
100 Tower Drive | Beaver Dam, WI 53916
P: (920) 356-1255 | C: (717) 413-6446
I incorrectly identified the 3rd party associated with Office Connector. It's actually Event One software. And I highly recommend it. Easy and flexible.
------------------------------Joe PartonOwnerCabbage Softwarehttps://cabbage4sage.com/Cheshire CT(203) 217-0075------------------------------
Your challenges are certainly not unique (I used to experience them myself)! It's really neat to see all of the different ways people tackle this issue and the different needs that are out there to fill. I've had a few ideas for some new articles for our blog just based on some of the conversation here. Thanks for posting.
And thanks again for the kind mention, best of luck on your search!
Home of the Connection Café.
100 Village Blvd., Suite 200, Princeton, NJ 08540Phone: 609-452-8000 | 888-421-9996 | Fax: 609-452-0474 | firstname.lastname@example.org