Line Items are only used where the Document Type is ‘InvPO’ (Invoice with Purchase Order) where Purchase Order and / or GRN matching is required.
Line Item recognition is a 2-step process:
- Firstly, Spindle Purchase Invoice Recognition will try to find line items on the document using the formula Quantity x Unit Price = Net Value
- Once the line items have been found, it will try to find the matching line items on the Purchase Order (using a look up against your master data).
Important: For the line item matching to succeed, the Pos (position) column is the most important and must be matched / set correctly.
Correct the Line Items manually
If the line item hasn't been populated correctly, then you can click into the fields that are red and enter the correct line data.
Selecting line item values from the document
You can select values from document rather than keying them manually e.g. click into the Unit Price field and then click on the Unit Price on the document using your mouse. This will populate the value from the document into the Unit Price field.
If the Pos (position) is blank on the line:
- Click into the Order Number field
- Press F4 to search for Purchase Order line items in your EPR system (master data)
- Find the correct line on the Purchase Order that matches the line from the Purchase Invoice
- Look at the 'Position no.' and enter it into the Pos field on the Purchase Invoice line
- Close the search table by clicking on Close
If the Order Number is not found in the search table
Please contact your system administrator so that they can ensure that the Draycir Cloud Synchronisation Agent Windows Service is running on your server. If this service has stopped running the data in Spindle Purchase Invoice Recognition may not be up to date.