Opinions please - industrial equipment repair

SOLVED

We have been using ACCPAC since the DOS days, at least since I started in 1994.

Historically, we did a small amount of service and repair work, but the bulk of our business was distribution - simple in and out of product with no added value.

In the last year or so, that percentage is changing, so that we are doing a lot more repair work - customer sends in equipment, we estimate, quote, and repair. The vast majority of the repairs are simple labour plus inventory, and occasionally some non-inventory costs.

Up to this point, we have been managing by using Bills of Material, assembling the inventory into a master item, and then billing it out in OE. This was always a work-around - as it doesn't allow us to actually cost the sale and determine actual profits. For example, neither labour nor non-inventory items are included in the ACCPAC cost. In order to manage this whole process, there is a LOT of duplicate data entry - for instance, all of the component items are actually entered into the sales order to create a requirement and so that we know where they are to be allocated to when they are received. Then they are also entered into the Bill of Material. Many of the items being used in the repairs are also stock items for us, that we may sell individually, so we need to account for that. All in all, it sort of works, and it was OK when we didn't do a lot of it.

Now, this is becoming unmanageable, so we are looking into add-ons that might help. I have PJC installed on a demo database and it is overwhelming. It seems like so much more than we possibly need and adds a layer of complexity that I am not sure will justify the advantages for the type of work we are talking about here. In addition, because many of the repairs we do are to the same piece of equipment (which we have an I/C master item for), and we want to track that, we would end up having to run multiple reports in order to get the data we require - i.e. searching O/E and also searching PJC. It seems like such a paradigm change, I am concerned it might be too difficult to implement.

From my understanding, Service Manager and MiSys are even more complex, so I don't think that is the answer.

Does anyone have any experience with managing this type of business within Sage 300? Any recommendations? Running Sage 300c 2017 currently