Turn a PDF purchase order into a sales order
· 2 minute read · Tim
Customer PDFs and ERP sales orders are different objects. This is the path from an emailed PO to a sales order in MYOB, NetSuite, SAP, Xero, and the rest.
A PDF purchase order is the customer’s document. A sales order is yours, in your ERP, against your products and your prices. Turning one into the other is the whole of order entry for a lot of distributors.
What people are trying to automate
Search the ERP forums and the request is specific. On r/SAP, people ask how to take an incoming customer PO from a PDF and create a sales order, the step they know as VA01. On r/Netsuite, the same question shows up as emailed PDFs that should become sales orders, ideally without the customer changing how they order.
The workarounds are familiar. Give the customer a CSV template. Ask them to key the order in a customer centre. Run the PDF through a generic document parser. Paste it into a chat tool and upload the CSV it gives back. Each of those can move a single order. None of them is a calm way to handle the inbox every day, because the next customer’s PDF will not look like the last one.
Why one template per layout falls over
Template tools want the PO number in the same box every time. Wholesale does not work like that. Each account generates PDFs from their own system. Fields move. A scanned copy shows up. The line table breaks across pages. A template that was right in March is wrong in August, and the order still has to ship.
Reading the document is only the first half. The ERP will reject, or worse quietly accept, a line that uses the customer’s item code, a unit it does not sell, or a price from an old tier. Someone still has to match the line to your catalog before it is a sales order.
What has to be true before the ERP will take it
- The customer on the PO is the right account in your ERP.
- Each line maps to one of your products, including when they used their own item code. That mapping is covered in customer part numbers.
- The quantity and the unit are ones you actually sell.
- The price matches their tier, or the difference is one you have looked at.
- A person has confirmed it. Nothing should post while a line is still a guess.
Where OrderWiz fits
You forward the PDF or upload it. OrderWiz reads the lines, maps them to your catalog, and checks prices against that customer’s tier. Lines that did not map, and prices that do not match, sit in needs review. You confirm once. The sales order then posts into MYOB Business, Greentree, Xero, Odoo, Pronto Xi, SAP S/4HANA, Oracle NetSuite, Oracle Fusion, Microsoft Dynamics 365, Sage Intacct, or a custom REST endpoint.
You still review the order before it posts. The typing is what goes.
If this is how orders still land on your team, tell us how they come in.
Written by Tim, who built OrderWiz after working in wholesale distribution.
