At Eureka Solutions, we welcome challenges, working tirelessly to make our clients lives easier. A company specialising in the import and distribution of tablewear and food service solutions was referred to us from a member of our business partner network.
Having grown over the years the company now re-export their goods to 12 countries, known for their innovation and high-quality products, much like ourselves; the company focus on providing exceptional customer service.
The Problem
The company import their goods via shipping containers from overseas. They were struggling as they had limited visibility of the goods inside these containers and were unable to record the date of arrival, meaning they were required to individually receive individual stock items in every container, taking up a significant amount of time.
Staff were also forced to manually cross reference open purchase orders and check off goods received, leaving data vulnerable to errors resulting in orders being missed, which had a detrimental impact on their customer service.
The Solution
Working to our client’s brief we devised a bespoke solution which would give them enhanced visibility of goods in transit and automate the receipt and allocation of container contents.
Our development would allow users to record shipping containers along with their estimated date of arrival and the goods within, receiving these with one click.
A new screen would be created within Sage 200 giving users the functionality to create containers, selecting suppliers and date of arrival. They would then be able to enter a list of stock items and quantities held within each container.
Users would also be given the facility to drill down into container contents and delivery dates, allowing them to give customers accurate timescales on stock replenishment.
Finally, we would create a process for the goods received within containers to be automatically checked off purchase orders from the relevant supplier, starting with the oldest based on order date.
A “save and receive” button would be created to automatically allocate goods received to open sales orders.
The Result – Full Container Visibility
Following the implementation of our bespoke development, the company now have full visibility and traceability of goods in transit, whilst benefiting from automation of the receipt and allocation of goods against sales and purchase orders.
This has resulted in a 50% reduction in data processing time and increased data accuracy due to the removal of human error.
Our bespoke development has ensured that our client is able to effectively and efficiently manage their stock items in order to meet customer demand and deliver an unrivalled level of customer service.
If you feel that your business processes are restricted by the limitations of standard Sage 200, please contact us to discuss your requirements, or read more about our bespoke development as award-winning developers, we specialise in helping businesses get the most out of Sage 200.