Extract purchase data with Intelligent Document Recognition (IDR)

Extract purchase data with Intelligent Document Recognition (IDR)

Extract data from purchase invoices, receiving notes, and credit notes, reducing errors and significantly reducing manual entry time. Intelligent document recognition uses AI to compare document information with what exists in Cin7 Core without requiring exact matches for product SKUs or names.

Purchase IDR does not create purchase orders. You can extract purchase invoice, stock received, and credit note data for an existing purchase order.

Prerequisites

  • IDR must be included in or added to your subscription.

  • Purchase/sale import permission is required.

Extract purchase invoice data

Extract invoice lines from documents for simple, advanced, dropship, and service purchases.

  1. Select Purchases from the main menu, then Purchases.

  2. Open an authorized purchase order. If you process purchases Stock first, Stock received must also be authorized.

  3. Go to the Invoice tab.

  4. Select Extract from file.

  5. Drag and drop your invoice, or upload from your device. If you're integrated with Google Workspace, you can select a file from Google Drive. This will start AI recognition.

  6. Check the AI mapping of the purchase invoice. Use the drop down fields to change the mapping of any fields, and select N/A for any fields that are not relevant. You can use the document preview and the available field mappings to help.

    • You must map either product Name or SKU to continue.

  7. Click Add and save to add the purchase invoice lines.

  8. Check that your invoice lines are correct and edit any incorrect matches. Purchase IDR uses AI to match invoiced products with the linked purchase order, without requiring exact matches for name and SKU in the supplier's invoice.

    • If Cin7 Core can't find a match automatically, you can see the product name in the invoice line Comment to help you find a match.

  9. Authorize the purchase invoice to finish. This adds the invoice PDF to the purchase order Attachments.

Extract receiving note data

Extract stock receipt lines from documents for simple and advanced purchases.

  1. Select Purchases from the main menu, then Purchases.

  2. Open an authorized purchase order. If you process purchases Invoice first, Invoice must also be authorized.

  3. Go to the Stock received tab.

  4. Select Extract from file.

  5. Drag and drop your receiving note, or upload from your device. If you're integrated with Google Workspace, you can select a file from Google Drive. This will start AI recognition.

  6. Check the AI mapping of the receiving note. Use the drop down fields to change the mapping of any fields, and select N/A for any fields that are not relevant. You can use the document preview and the available field mappings to help.

    • You must map either product Name or SKU to continue.

  7. Click Add and save to add the stock received lines.

  8. Check that your stock received lines are correct and edit any incorrect matches. Purchase IDR uses AI to match received products with the linked purchase order, without requiring exact matches for name and SKU in the supplier's receiving note.

    • If Cin7 Core can't find a match automatically, you can see the product name in the line Comment to help you find a match.

  9. Authorize stock received to finish. This adds the receiving note PDF to the purchase order Attachments.

Extract purchase credit note data

Extract invoice lines from documents for simple, advanced, dropship, service purchases, and standalone credit notes.

  1. Select Purchases from the main menu, then Purchases.

  2. Open a purchase order with an authorized invoice.

  3. Go to the Credit note tab.

  4. Select Extract from file.

  5. Drag and drop your credit note, or upload from your device. If you're integrated with Google Workspace, you can select a file from Google Drive. This will start AI recognition.

  6. Check the AI mapping of the credit note. Use the drop down fields to change the mapping of any fields, and select N/A for any fields that are not relevant. You can use the document preview and the available field mappings to help.

    • You must map either product Name or SKU to continue.

  7. Click Add and save to add the credit note lines.

  8. Check that your credit note lines are correct and edit any incorrect matches. Purchase IDR uses AI to match products with the linked purchase invoice, without requiring exact matches for name and SKU in the supplier's credit note.

    • If Cin7 Core can't find a match automatically, you can see the product name in the line Comment to help you find a match.

  9. Authorize the credit note. This adds the credit note PDF to the purchase order Attachments.

  10. Go to the Unstock tab.

  11. Copy from credit note, then authorize.

Document requirements

Define each section of the document clearly defined, with line items, headers, and totals organized as they would appear in a typical purchase document. Position field values under the expected field names.

  • Purchase IDR supports PDF, JPG, JPEG, and BMP formats.

  • Each purchase invoice, receiving note, and credit note must be a separate document.

  • Only one document uploaded at a time.

  • Maximum document size is 5MB.

  • SKU and Product name are required fields and should be located in separate columns.

Available mapping fields

Cin7 Core can map the following fields to fields extracted with purchase IDR. Unmapped fields are auto-filled from the purchase order document header.

Purchase invoice

Document header field Description
Invoice number Supplier's purchase invoice number
Invoice date

Purchase invoice issue date

Due date Purchase invoice due tate
Invoice total Purchase invoice total

words

Invoice line field Description
SKU* Product SKU in Cin7 Core
Name* Product name
Comment Invoice line comment
Supplier SKU Supplier's SKU for the product
Quantity Product quantity
Price

Product price

Discount

Product discount

*Either SKU or Name must be mapped.

Receiving note

words

Invoice line field Description
SKU* Product SKU in Cin7 Core
Name* Product name
Supplier SKU Supplier's SKU for the product
Batch / serial # Product batch or serial number
Expiry date

Product expiry date

Quantity

Product quantity

Location Stock receipt location
Date received Stock receipt date. If no date is provided or recognized, Cin7 Core uses the current date.

*Either SKU or Name must be mapped.

Purchase credit note

Document header field Description
Credit note number Supplier's purchase invoice number
Credit note date

Purchase credit note issue date. If no date is provided or recognized, Cin7 Core use sthe current date.

words

Invoice line field Description
SKU* Product SKU in Cin7 Core
Name* Product name
Comment Invoice line comment
Supplier SKU Supplier's SKU for the product
Quantity Product quantity
Price

Product price

Discount

Product discount

*Either SKU or Name must be mapped.

Was this article helpful?

Have more questions? Submit a request