Purchase orders · Bulk path
Create POs from spreadsheet
Upload one file to create multiple purchase orders. Abandoned uploads are not saved — finish the flow in one go.
- Upload
- Validate
- Preview
- Done
Things to know
- In Multi-PO mode, the origin column groups rows into separate POs.
- UOM is read for display only — quantity is validated against the master record.
- PO date in the sheet is used for validation; the create date is set to today on commit.
- In bulk path, the same customer is used as both bill-to and ship-to.
Upload mode
Multi-PO groups rows by origin into separate POs. Single-PO creates one PO per supplier & customer pair.
- origin
- supplier_code
- customer_code
- po_date
- product_code
- quantity
- unit_price
- gst_rate
- uom · optional
- remarks · optional
purchase_orders_may.xlsx
184 KB · Multi-PO mode · just now
No rows match this filter
Clear filters or switch the severity tab to see other rows.
+ 4 more POs · expand each to inspect lines
Creating purchase orders
Each PO is created in sequence. A failure on one does not stop the rest.
6 of 7 purchase orders created
One group failed to commit. The successful POs are live and visible in the order book; the failed one can be retried below.
POs created
6
Lines committed
191
Order value
₹ 19,00,752
Result by PO
This file isn't a supported spreadsheet
Salesdiary couldn't read orders_may.pdf. Re-export the file as .xlsx, .xls or .csv and try again.
- orders_may.pdf · 2.4 MB
- detected MIME: application/pdf
- expected: spreadsheet/xlsx, xls, csv
No PO lines were found in the file
The header row was detected but no data rows followed. Add at least one line and re-upload.
- purchase_orders_may.xlsx · 12 KB
- header row present · 14 columns mapped
- data rows: 0
Required columns are missing
The file was read, but these columns must be present. Add them and re-upload — the template has them in the right order.
- supplier_code · missing
- quantity · missing
- gst_rate · missing
Multi-PO mode needs an origin column
Rows are grouped into separate POs by origin. Either add the column to the file, or switch to Single-PO mode and use supplier + customer as the grouping key.
Every row in this file has a hard error
There's nothing usable to preview. Re-export the file with the highlighted issues fixed and re-upload. Common causes:
- supplier_code does not match any active supplier
- customer_code does not match any active customer
- product_code does not match the catalog