
ACS Industries receives a flood of purchase orders via email in every format — PDFs, spreadsheets, images, even plain-text emails. Manual entry was slow, error-prone, and couldn’t keep up with volume.
“Thanks to Lido, we’re processing ~400 weekly POs automatically with complete accuracy. We avoided a new hire and saved a chunk of money while reliably automating PO processing.”
Like Lucifer Lighting, ACS Industries needed to extract PO data from dozens of different vendor and rep formats and push structured data into their ERP system — without building templates for each one.
Can we split header info and line items into separate sheets from the same PDF?
Yes. Set up one sheet for order-level info (customer, PO number, shipping address) with “extract multiple rows” turned off, and another sheet for line items (part numbers, quantities, unit prices) with it turned on. Both extract from the same document, and re-extraction within the first 24 hours doesn’t use additional credits — so you can iterate on your column setup without burning through pages.
Can it reference our internal customer list to flag new vs. existing customers?
Yes. Lido can reference a maintained list of known customers via a context document or a lookup sheet within the same workbook. It adds a column automatically indicating whether each order is from a new or existing customer. You can then use filtered views to route new customer setup to finance and existing customer orders straight to entry — no manual sorting required.
What about wasted pages like terms and conditions — do those count as credits?
No. You can set page ranges to exclude terms and conditions pages, so you only use credits on the pages that contain actual order data. This is a common concern for teams receiving multi-page POs where only the first one or two pages contain the information you need.