KT Sparks

Italian luxury fashion house · belongs to a worldwide luxury group · process spans seven sister companies

UiPath Robot Linking SAP and Esker Invoices for a Luxury House

Each intercompany invoice from seven sister companies was handled twice: posted in SAP, then linked in Esker. An accountant copied dates, numbers and amounts across by hand, invoice after invoice. Our UiPath robot matches the invoices between the two platforms, books each one in SAP and creates the link in Esker. It is designed to reduce processing time by 80%.

UiPath Robot Linking SAP and Esker Invoices for a Luxury House
Industry
Retail & E-commerce
Function
Finance & Accounting
Region
Italy

Results

80%
planned reduction in processing time
A target set in the process definition, not a measured figure.
7
sister companies handled by one routine
The robot's configuration holds a supplier, VAT code and document type for each.
~25 min
per run when done by hand
Recorded before the build: 24 min 54 s and 155 actions over 17 windows.

01

The challenge

The client is a luxury fashion house in Italy that belongs to a global luxury group. Seven sister companies across Europe send it intercompany invoices. These land in Esker, which is the group's cloud platform for incoming supplier invoices, and sit in a queue for intercompany verification. For each one, someone had to locate it in SAP, post it, then go back to Esker and link it to the SAP document. All of it by hand.

Before the build, the process definition captured the manual baseline: each run took 24 minutes 54 seconds and needed 155 actions, 152 key presses and 96 mouse clicks, spread over 17 windows in 4 applications.

Where the effort went

  • Typing everything twice. For every invoice, the date, number, amount and order reference were copied from one system into the other.
  • Matching by sight. Amount is the only value both systems share, so matching was manual and prone to mistakes.
  • Same routine, seven times. The steps repeated for each sister company, each with a different document type, VAT code and supplier code.
  • Invoices left unlinked. If an invoice was posted in SAP but never linked in Esker, it stayed open in Esker, swelling the queue and the month-end reconciliation.
  • Hours lost. Roughly 25 minutes of clicking and typing for each recorded run.

02

What we did

Our UiPath robot operates SAP and Esker in parallel. It takes the open items out of SAP, pairs them with the invoices waiting in Esker, posts every invoice in SAP and then links it back in Esker.

Six steps from open item to linked invoice

  1. Pull open items from SAP. For the intercompany account, the robot runs the general-ledger line-item report in SAP (FBL3N), sorts the result by partner company and exports it.
  2. Loop through the companies. A configuration file kept by the process owner lists each sister company with its supplier, partner company, VAT code and document type. For each entry, the robot filters the intercompany queue in Esker and exports the waiting invoices.
  3. Match. Every Esker invoice is paired with its SAP open item on amount. Anything without a match is written to the log and skipped.
  4. Post in SAP. In SAP invoice verification (MIRO), the robot fills in the invoice date and number, the amount, the PO reference, the document type and the VAT code. It simulates first, then posts.
  5. Link in Esker. Using the vendor line-item report (FBL1N), the robot finds the number of the SAP document it just created. Back in Esker, it switches the invoice's ERP field over to SAP, away from the legacy system, then attaches the invoice to that document.
  6. Report and notify. It produces a daily Excel report for each company and an exception log, and emails a recap to the process owner when each run finishes.

Built to be safe

  • In demo and highlight modes the team can run the whole process end to end with nothing posted or linked.
  • Posting and linking, the last two steps, only execute in production mode.
  • It is an attended robot on the accountant's own machine. Credentials come from Windows Credential Manager, and no Orchestrator is required.
  • Companies, supplier codes, VAT codes and document types sit in a configuration file owned by finance, outside the code.

Stack

LayerTools
AutomationAttended robot, UiPath Studio, Robotic Enterprise Framework
ERPSAP GUI, automated with Deefinity SAP activities for FBL3N, FBL1N and MIRO
Invoice platformEsker (cloud accounts payable), driven through UiPath UI Automation in Chrome
Settings and reportingConfiguration file in Excel, plus a daily Excel report for each company
Alerts and securityWindows Credential Manager, UiPath Mail activities

03

The outcome

Copying invoices between systems is no longer the accountant's job. The robot is designed to match each invoice, book it in SAP and attach it in Esker, one company at a time, and to report anything it failed to match.

BeforeAfter
Entry per invoiceTwo times, SAP and EskerOne time, by the robot, using matched data
SAP to Esker matchingVisual check on the amountAutomatic, with a log entry if nothing matches
Seven sister companiesOne routine redone by hand for eachA single loop run from a configuration file
Esker link-backManual and easy to forgetHandled by the robot after each posting
Time per runAbout 25 minutes of clicks and typingDesigned to cut it by 80%
  • One robot matches, posts in SAP and links in Esker the intercompany invoices of seven sister companies.
  • The design target is an 80% cut in processing time per invoice, compared with roughly 25 minutes of manual work per run. Actual savings were not measured.
  • Each run produces a per-company report, and unmatched invoices are logged so someone can follow up.
  • No integration project needed. A robot using the same screens as the accountant joined two finance platforms within months.

A risk that is easy to overlook

If two finance systems share just one field, the amount, a simple match will pair the wrong invoices as soon as two of them carry the same value. So the robot works one company at a time, oldest invoices first, logs whatever it cannot match, and keeps a simulate step and production-only switches in front of every SAP posting and Esker link. A wrong match is stopped before it turns into a wrong entry in the books.