Manual reporting in spreadsheets
Known for patient safety, client used outdated approach to logistics
A rapidly growing company in the specialty pharmaceuticals market, the client has established its niche in selling generic versions of well-known injectable drugs. The company’s products are in the oncology, anti-infective and critical-care categories of medications. A key aspect of the client’s brand is patient safety and reduction of medication errors through enhanced product labeling and packaging. However, the company was using a third-party logistics provider to manage sales, receivables and inventory. The third party provided data in spreadsheet format.
From spreadsheets to integrated, automated reporting
The client wished to move from spreadsheets to an integrated ERP system that would provide actual inventory balances, sales results and accrual factors. In addition, the client wanted to automate its daily sales reporting activities.
WHAT THE TEAM DID
JD Edwards EnterpriseOne implementation
The Grant Thornton LLP technology services consulting team installed the JD Edwards EnterpriseOne ERP system — an integrated applications suite — and implemented automated financial, supply chain, procurement and sales functions. This tool allows sales data to be received from the third-party logistics provider and then loaded as sales orders in JD Edwards EnterpriseOne, taking full advantage of advanced pricing rules to book order level accruals. This process significantly reduces manual adjustments made at month-end and provides real-time daily sales data used in management decision-making.
Integrated, live financial and supply chain data
With the integrated project implementation, the client achieved automated daily sales reporting, live perpetual inventory balances and streamlined accrual. This eliminated reliance on spreadsheets: Financial and supply chain data is now integrated and updated live through the JD Edwards EnterpriseOne system. Management is now able to react to sales and inventory trends as they emerge, allowing the organization to be more proactive.