Purchase orders vs. goods received vs. supplier invoices

Files you need

• Purchase order lines: What you ordered from suppliers, line by line, with the agreed price.For example: ERP purchase order lines, Odoo / Zoho purchase orders export, PO tracker spreadsheet.
• Goods received notes (GRN): What your warehouse actually received and accepted against each PO.For example: ERP goods receipt / GRN lines, Warehouse receiving log, 3PL inbound receipt report.
• Supplier invoice lines: Supplier bills booked in your AP, at line level with the PO reference.For example: ERP vendor bill lines, AP invoice register (line level), Supplier invoice scan to Excel.

The Microsoft Dynamics 365 Business Central connector can fill: Purchase order lines, Goods received notes (GRN), Supplier invoice lines.

What Sawwi checks

• Invoiced, not received: Supplier billed for goods with no goods received note. Hold payment.
• Invoiced more than received: Invoiced quantity is above the accepted quantity (received minus rejected).
• Billed above PO price: Line amount is higher than invoiced qty × the PO unit price.
• Invoice without a PO: Invoice line whose PO and SKU aren't on any purchase order.
• Duplicate supplier invoice: The same supplier invoice number and SKU is booked more than once.
• Received, not invoiced: Goods received with no supplier bill yet. Accrue as GRNI (goods received not invoiced).
• Received more than ordered: Warehouse accepted more units than the PO allows.
• Receipt without a PO: Goods received against a PO number or SKU that isn't on any purchase order.
• PO overdue, nothing received: Expected date has passed and nothing has been received.
• Partly received: Open PO balance: fewer units received than ordered so far.
• Billed below PO price: Usually a discount or a wrong PO price. Check before the PO is reused.