Roberts Mart logo

Customer Profile

Roberts Mart are leading suppliers of printed flexible packaging, collation shrink wrap, laminated films, lidding films, polythene bags and paper products.

Customer Details

The Challenges

  • Drive efficiency improvements
  • Enable easier management of the many thousands of SKU codes – records
  • Keep lead times up to date
  • Large amounts of data

Our Solution

  • SYSPRO 6.1
  • DataSwitch
  • Advanced Planning & Scheduling (APS)
  • Data Import Utility

Benefits Gained

  • Removed physical task of updating records
  • Live data transferred to SYSPRO which helps planners
  • Very easy to get everyone up to speed
  • Make better use of peoples time by not having to do manual updating

Read in Full

Roberts Mart were longing for a system that would allow easy management of thousands of SKUs and their records, each of which requires regular price reviews and updates. With SYSPRO and DataSwtich they are able to update thousands of records in hours rather than days.

Roberts Mart sends manual updates packing with SYSPRO data import utility

Leeds-based flexible packaging manufacturer Roberts Mart & Co Ltd is installing a new SYSPRO enterprise resource planning (ERP) system to drive efficiency improvements for both sides of its business – Romar, which manufacturers polyethylene film, and Roberts Mart, which converts the film into a wide range of packaging solutions. The phased implementation project is now well underway, with the organisation using SYSPRO’s financial modules for both Roberts Mart and Romar.

Benefits

Through it’s investment in the latest SYSPRO 6.1 edition from K3 Syspro (K3), Roberts Mart & Co. are anticipating a wide range of benefits once the system is fully up and running.

A small yet important feature that is delivering immediate results is the firm’s take up of DataSwitch. Simple, easy to install and a low cost utility program, DataSwitch is a quick method of updating stock-keeping unit (SKU) information.

DataSwitch is a quick method of updating stock-keeping unit (SKU) information. DataSwitch exports data from SYSPRO into Microsoft Excel spreadsheets and enables users to benefit from easy updating, without having to go into several thousand individual records held in the ERP system.

The innovative Excel Data Import Utility enables users to amend information in the spreadsheet then import the data back into SYSPRO, automatically changing the records held in the ERP system’s database.

Simon Roberts, Commercial Director, and Claire Fitzsimmons, Customer Services Manager, at Roberts Mart take up the story.

“Once we embarked on the new SYSPRO installation, we recognised the need for a way of easily managing the many thousands of SKU codes and records we have for raw materials and finished goods. Each of these items requires price reviews and updates on a regular basis. We also need to keep the lead times up to date, whether it is an issue with a particular supplier or to align with customers’ changing requirements,” says Simon Roberts.

The standard approach, explains Simon Roberts, would require accessing each record to update them individually, which would require a significant amount of time. This was a situation to avoid and so K3 was consulted for a solution.

“K3 recommended that we look at the Excel Data Import Utility. The demonstration showed us that we could use the software to export all of the SKU codes and records held in SYSPRO into a spreadsheet, allowing us to quickly update them and import them back into the ERP database/system. The speed of operation would reduce the physical task of updating the records to a couple of hours, whereas it would take several days if done the old way,” says Simon Roberts.

“Claire Fitzsimmons adds: “We manage a very large amount of information in terms of SKU codes for finished goods and raw materials. The Data Import Utility provides a simple, user-friendly method of keeping the information up to date. It allows me to also delete data using the spreadsheets. This provides an immediate update to the records in SYSPRO once it is imported back into the system. Being able to complete the various updates on a spreadsheet in this way is an important time-saving benefit.”

There are also benefits for factory planning from using the Data Import Utility reports Claire Fitzsimmons.

“We need to assign lead times to each raw material SKU code. This is important because these lead times drive our best of breed third party APS [Advanced Planning and Scheduling] system. The lead times change regularly, and, if you consider that we have over 3500 raw material SKUs, it would be a mammoth task to update the records manually each month – and sometimes they’ll need updating weekly,” she says.

“We can also be selective and update information on the fly whenever necessary. Which means virtually live data is being transferred to SYSPRO, which again helps the planners. It means that as soon as SYSPRO is amended, so is the APS system.”

The Data Import Utility is also useful for managing multiple SKU records of similar items beyond changing the lead-time details, allowing any of the fields within the records to be updated simultaneously.

“The SKU code updates are the most immediate and obvious benefit but we can see that it will be useful for easier management of all the other data fields in the records. If you have multiple records of similar items, for example, it would take a long time to manually change all of them. This way allows it be done instantly,” says Claire Fitzsimmons.

Both Simon Roberts and Claire Fitzsimmons highlighted the ease with which the Data Import Utility was installed.

“K3 spent just half a day on site, including the installation; the software installation only took an hour. The rest of the time was spent training me to use the software. If you are familiar with the way SYSPRO works, it is very easy to get up to speed so training is minimal,”
says Claire Fitzsimmons.

“If we hadn’t invested in this software, Claire would be tied up doing all the updating herself. So, not only does this free up her workload, we are able make better use of her time rather than having a large portion of it consumed with updating the system,” adds Simon Roberts.

Related Reading

Packaging – Making the Throw-Away Profitable

There’s nothing to get excited about. There are no bells and whistles, you can’t eat it, it doesn’t fly, and even if it is beautifully designed and made; it is destined to play second fiddle to the product it is packaging. Unfortunately, that’s just the nature of the packaging – it’s a throw-away. So how do manufacturers of packaging make the throw-away profitable?

Choosing a New ERP Solution is in the Can for William Say & Co

Manchester-based K3 Syspro has won a contract for a highly flexible manufacturing, financial and distribution system from Bermondsey’s last surviving traditional tin box and canister manufacturer William Say & Co. Ltd. The firm is the last of its kind operating from Bermondsey, London’s historic tin can manufacturing base.