Medicon moved all warehousing and inventory control to a hosted solutions provider Unleashed. They had outgrown the provision that Sage 200 Accounts provided and wanted a more dynamic and remotely accessible solution. The objective was to phase Sage 200 out before annual licence renewal, post data migration to the Unleashed platform.

Their main supplier in Germany require weekly reports on inventory movement provided in a specific CSV format, which Sage did supply with a little manual manipulation. Unfortunately, Unleased could not provide this exact report as 2 pieces of required data was unobtainable from the reporting mechanism within their reporting area.

Therefore Sage had to be used to export these missing parts of the jigsaw and joined with the Unleashed Export file. Medicon approached us to see if we could extract this additional information in some way possibly through the Unleashed API to produce the complete report, thus removing the need for Sage 200 access requirements. Sage 200 licence renewal deadline presented a very short development window of four weeks.