Ok, having looked a little closer at your samples, I may have gotten a little ahead of myself. However, monarch pro is very versatile, with a lot of imagination and a little (sometimes a lot) of time, you can generally get what you need. The problem that I can see here is that there can be more than 1 record per customer (Total objects at this location). Would there be a maximum?HansV wrote:Bob also included that in the first post.VegasNath wrote:Could you provide a small excel sample of what you require?
If each customer had only one record, this would be very easy with monarch.
If there is a low maximum (eg 5) number of records per customer, this would be doable with a little more jiggerypokery.
However, if neither of the above were true, this would be outside my scope.
BUT: I am (in the grand scheme of things) a novice user. I am almost certain that monarch is more than capable of providing what you need. Have you approached monarch technical support for assistance? From a sales point of view, I'm sure they would be able to clarify if it is capable of such a task.
One other problem that I can see is "Location ID 1201557" has 4 records, but the NB on record 1 wraps to a second row. I would have no idea how to handle that, but that does not mean that monarch is not capable.