Good day,
We are using Sage 100 to do accounting. This provides an accounting history that can report a loss after it happens. We need a proactive management tool to report progress in the middle of a job. For example, we would like to see time and materials to date. We want to report this information in a specific format, and we want the process to be push-button simple. Phone support advised me that the built-in report writer is too basic to accomplish the format I described. I am exploring our options, including:
- Switch to Sage 300.
- Buy Crystal Reports.
- Buy a customization from a Sage business partner.
- Learn how to customize Sage 100 and do an in-house customization.
In-house development may be plausible because the Job Cost Journal already includes the required information. We only need to reorganize it in the desired format. I could write a VBA macro to reformat the Excel spreadsheet, but the challenge is to make the whole process push-button simple.
Is Sage 100 the right tool for the job? Can anyone recommend methods or 3rd party software to get on the spot job costs from Sage 100 and track the progress of a project?
Thank you for your time,
Ben
