Our organization has had a lot of changes in upper management and they are requesting reports based on data which I do not believe is easy to combine/compile. Management believes there should be an easy and low cost way of providing the reports. I have tried to explain the reporting capabilities (or lack thereof for their requests) and they requested that I do some research.
We use manufacturing and have Horizons Light Manufacturing connected to GP.
Does someone have a way to get data which combines GP transactions with Horizon transactions and can view SOP and POP with inventory and Horizons? We do have Smartlist, but we cannot get all the data needed in a common format in order to provide the reports requested.
Here are examples of the questions being asked:
1) HMS Costed BOM VS Actual Costed BOM with lot size by location
2) breakdown of each component tagged to what % of annually spend it is associated with
3) Margins by item number and/or lot number and see allocation/destination of each shipment
4) Analysis of where we should be producing each product line
5) Breakdown of a specific sale (by just one transaction or over a period of time specified) showing the BOM cost (so, GP will provide the finished goods cost, but they want to know what was the individual component actual costs for that sale or sales).which includes yield gain/loss.
The above are just a few of the requests, I would appreciate responses on if there are easy and low cost methods (less than a couple of thousand dollars). If you believe this is not possible, please voice those too. Thanks for everyone's input.
Best regards,
Dale
