Boosting Productivity with Automated Order Data Management

Click to download

Highlights

Industry: F&B, Retail & Consumer Products
Solution: Customised utility for Sage 300
Results: 

• Greater productivity
• Eliminate risk of human error
• Facilitate management of manpower cost 

Challenge

A multinational cosmetics and fragrance retailer in Singapore had to manually enter numerous orders in different formats from in-flight services and duty-free stores (collectively called “operators”) into its Sage 300 accounting system. New order data was manually recorded on Excel order forms, which had to be submitted to its overseas HQ by a given deadline to enable timely invoicing and stock replenishment. Another challenge was the need to manually reconcile order confirmations from the HQ with the corresponding order entries captured earlier in Sage 300 to prepare invoices. These tedious processes were not only time-consuming, but also presented a high risk of human error in order data entry and invoicing.

Solution

Stone Forest IT (SFIT) assessed the client’s pain points and proposed a customised utility for Sage 300 with the following capabilities:

• Automatically convert operators’ orders into a format recognised by Sage 300
• Populate the Excel order forms for submission to the client’s HQ within minutes
• Instantly reconcile order confirmations from the HQ with corresponding order entries in Sage 300 and update local stock quantity records
• Rapid consolidation of orders into a packing list and invoice generation

Results

After implementation, the client enjoyed the following:

• Greater productivity, with 50% reduction in man-hours required for order data management
• Eliminate risk of human error in order data entry and invoicing
• Facilitate management of manpower cost

SFIT brings together expertise and vast experience in customising Sage 300 solutions to meet the diverse needs of businesses and enhance their productivity.