Mega supermarket spots stock discrepancy of tens of millions amid ERP system migration
- Reference: 1727944259
- News link: https://www.theregister.co.uk/2024/10/03/asda_21m_discrepancy_erp/
- Source link:
Asda migrated from the legacy SAP system run by former owner Walmart to a new instance of S/4HANA, hosted in the Microsoft Azure cloud, following a deal announced in December 2021. The same month, Manhattan Associates announced that the supermarket had chosen its Manhattan Active Warehouse Management software to help "evolve" its logistics network in the UK.
Asda IT staff shuffled off to TCS amid messy tech divorce from Walmart [1]READ MORE
The Major Incident report distributed at the start of this week states a mismatch of approximately £21 million ($28 million) had occurred "between Manhattan SCI and SAP closing stock reports across two months affecting quarterly reporting." The retailer's annual revenue is around £24 billion ($32 billion).
It said there had been a 10 million item mismatch for June that had been fixed in the Manhattan system, while efforts to fix an 11 million item mismatch in July were ongoing. "The plan is currently to post manual corrections to stores once the finance team has gone through the Manhattan data," it adds.
The report warns the issue could "potentially lead to the delay of the publication of validated financial information and increase the risk of dysfunctional commercial decision-making alongside a delay [to] Asda's consolidation of group-wide financial results."
[2]
A spokesperson for the retailer told us: "Like other large businesses, we run regular data checks to ensure the stock received and invoices raised are aligned. A recent check identified a minor discrepancy in how the data appeared in a report and was quickly rectified. This had no financial or operational impact whatsoever."
[3]Sainsbury's bags a ticket to RISE with SAP, hoping not to trip like Asda
[4]Hangover from messy Walmart tech divorce ongoing at Asda
[5]Transformation chief leaves Asda amid Walmart divorce IT projects
[6]Asda kisses Walmart goodbye with half a billion dollar tech breakup bill
It is understood that Asda runs a reconciliation task between its stock holding in depots and its invoicing records in finance as a "business-as-usual process."
Asda's move to SAP's latest in-memory ERP system, S/4HANA, is part of "Project Future," the name given to its technology separation from Walmart, the US retail giant that sold the UK supermarket to the Issa brothers and TDR Capital in February 2021.
[7]
In January, [8]The Register reported on delays to the project – which also includes front-end POS systems – after Asda was forced to extend its arrangement with Walmart to continue supporting back-end systems until February 2024.
Asda had intended to finish the project by the end of 2024, but in a blog post published late last month, the company said it would prioritize the conversion of around 850 sites including smaller supermarkets, and Asda Express convenience stores during the remainder of 2024. It said the bulk of customers shop in larger stores, which it would convert to the new system from early January 2025 onward following the peak Christmas trading period.
[9]
"This is a sensible and pragmatic approach for the business during the 'Golden Quarter' period. It is also the right thing to do for customers, as it will help to give them the best possible Christmas – with Asda's commitment to uncompromising value and an enhanced product offering," the [10]blog post said . ®
Get our [11]Tech Resources
[1] https://www.theregister.com/2024/06/17/asda_tupe_tcs/
[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2Zv5rQQrroCZoV3csRxe6rAAAAJg&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[3] https://www.theregister.com/2024/09/17/sainsburys_rise_with_sap/
[4] https://www.theregister.com/2024/08/29/asda_it_woes_continue/
[5] https://www.theregister.com/2024/07/09/transformation_chief_leaves_asda/
[6] https://www.theregister.com/2024/07/01/asda_walmart_separation_costs/
[7] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Zv5rQQrroCZoV3csRxe6rAAAAJg&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[8] https://www.theregister.com/2024/01/23/asda_sap_delay/
[9] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Zv5rQQrroCZoV3csRxe6rAAAAJg&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[10] https://corporate.asda.com/20240925/project-future-driving-asdas-transformation
[11] https://whitepapers.theregister.com/
Re: "a minor discrepancy"
When your turnover is $24,000,000,000, then $10,000,000 is 0.04% of revenue, it's barely a rounding error
Just slap fines on store managers ..
.. amounting to 21 million pound in total, and all will be well !
TLDR version
a mismatch of approximately £21 million
The retailer's annual revenue is around £24 billion
a minor discrepancy ... had no financial or operational impact whatsoever."
That's not the half of it....
The company is drowning in debt, the idiot brothers who bought it are having some sort of family feud, the asset strippers (TDR) have majority control now and they can't recruit a CEO regardless of how much money is on offer.
They've had to get the 75 year old (mainly retired) ex-CEO of M&S to take over from moron #1 (Mohsin Issa) on a temporary basis until someone can be persuaded to be the whipping boy (CEO). Issa can't be left in charge because he's clueless.
If anyone has been in one of their larger supermarkets then they can't have failed to notice the epically long queues at the self-scan checkouts and perhaps one in ten tills actually open (but often broken - card readers). Add to that the chaotic supply of product to the shop floor, not very attractive pricing (in-store & fuel station) and they're fucked for the busiest time of the year.
That's what you get when two idiots borrow shitloads of money from asset strippers to buy a business they know ZERO about. If Walmart couldn't make a decent return on capital with Asda over three decades then two wide boys were always going to crash and burn.
"a minor discrepancy"
Man do I wish I could label $10 million as a "minor discrepancy" in my accounting !