Validating invoices

From 1Archive help
Revision as of 12:53, 6 November 2013 by Jef.laethem (talk | contribs) (Adding, editing and deleting posting data in the document view)

Jump to: navigation, search

After scanning, and the OCR process (recognition) the invoices have to be validated in “My tasklist”.

In “My tasklist” you have two subdivisions:

  • “To Validate”: invoices to be validated and booked.
  • “Exception handling”: invoices in status invalid, which need special attention.

1 Selecting the appropriate document type

Two different document types per company are available:

  • Incoming documents, for processing the incoming invoices and credit notes.
  • Outgoing document, for processing the outgoing invoices and credit notes.

You can toggle between these two document types by hovering DocumentType.png and selecting the appropriate document type.

2 Selecting individual invoices for validation

Location: Archive - My Tasklist – Invoice list > click Magnifier.png (View the document)

To select the invoice for validation, select Magnifier.png (View the document) at the beginning of the invoice list.

3 Invoice validation view

The left hand side of the page shows the information of the invoice header fields (header data).

At the top of the header fields you have following icons available:

  • FieldsHeader.png (Header fields) displaying the header information.
  • FieldsTechnical.png (Technical fields) displaying the technical information.
    • ScanPRO ID, identification number in the ScanPRO system.
    • Current workflow status of the document.
      • “Validation”: indicating that the invoice still has to be validated.
      • “Create”: in case of manual adding an invoice, still to be validated.
      • “Exception”: indicating that the invoice is possible invalid, e.g. duplicate invoice.
      • “Cancelled”: invoice is canceled.
      • “Wait feedback”: invoice is sent to the accounting system and is waiting for an update with voucher number and date.
      • “Ended”: invoice is fully processed.
    • Indexed: Yes/No, indicating if a full text search has been performed on the document.
    • Reception method, the way the document came into the system:
      • Web scanning
      • Mail
      • Manual creation (add document)
      • XML (electronic invoice)
    • Scan user
    • Scanning date.
    • Incoming date into ScanPRO.
    • Cancel reason, in case the invoice has been scanned.
    • Accountant, the person who booked or cancelled the invoice.
  • FieldsAttachment.png (Attachments) displaying [ the attachments].
  • FieldsNotes.png (Comments) displaying [ comments].
  • FieldsRelated.png (Related documents) displaying related documents, not in use for current version.

The [ action menu] for the document is displayed above the header fields. The availability of the functions in the menu bar are dependent on the workflow status.

The lines at the bottom of the page are the account lines (posting lines). An invoice has always to contain at least one account line.

The right hand side part of the page shows the scanned invoice image. If the document consists of several attachments, you can browse using the arrow buttons in the bottom right of the image screen.

  • BlockFirst.png go to the first attachment.
  • BlockPrevious.png go to the previous attachment.
  • BlockLast.png go to the last attachment.
  • BlockNext.png go to the next attachment.

Use the acrobat scroll bar to navigate to a specific page in the document.

At the left bottom of the image screen you have following possibilities:

  • Save.png (Download) for downloading the image.
  • Outgoing.png (Detach) for detaching the image and putting it on a second screen, this will facilitate the input of data. If you want to disable the detachment, just close the detached screen.


Possibilities only available after definitive booking in the accounting package:

  • Signature.png (Signature) for downloading the signature of the image.
  • Key.png (Public key) for downloading the public key of the image.
  • Validate.png (Validate) for checking if current image has been modified since archiving.
  • Annotating information on top of the invoice image: date/time when feedback received from accounting package (voucher number), voucher number and accountant.


On the left top of the image screen you have two buttons, one for selecting the image the second to view the invoice log. You can toggle between invoice image view and invoice log view, by clicking on the appropriate icon:

  • Images.png (Images) image view.
  • EventLog.png (Log) invoice log view.


All invoices have a log which contains all the events related to the invoice. The log is updated with following information:

  • Import: When a document arrives in the archive, a log entry is added.
  • Processing: A log entry will be added for each step during automatic processing, like thumbnail creation, annotating, signing, routing of the document. When an error occurs during processing, a log entry of type “Error” will also be added.
  • User action: When a user performs following actions:
    • Set ready for download.
    • Cancel document.
  • No log is added when changes are made in the header or line fields at moment of saving.

4 Adding, editing header invoice data in the document view

Location: Archive - My tasklist - Invoice View - Header tab 15x15px (default)

Validating header data is only available in “My tasklist”.

The field order you view is general and cannot be changed.

To move from one field to another, use TAB.

If your system has different lookup lists for different companies, the lookup lists contain options specific to the selected company.

Some of the fields are prefilled by the scan batch definitions and by the scanning (OCR) results.

Fields that are filled in by the scan batch definitions, if selected, are:

  • Journal
  • Invoice type
  • Year
  • Fiscal period
  • Vat period

Fields that are filled in by the OCR (recognition) server, if recognized, are:

  • Supplier/customer
  • Invoice number
  • Invoice date
  • Due date
  • OGM
  • Currency
  • Net amount
  • Vat amount
  • Total amount

Fields can have different background colors:

  • Yellow : the scanning has found different possibilities, the most probable value is proposed, by clicking on the field you can see and select the other possible values.

Note: You have always to ENTER a yellow field.

  • Red : the values of these fields are required and not found by the OCR server or the validation check performed on that field is not correct.

Note: You have always to ENTER a red field.

Note: No invoices with fields in yellow or red background can be transferred to the accounting package.

Some header fields are filled in automatically based on the values available in the other fields.

  • “Tax system”: based on a field of the supplier data.
  • “Due date”: automatically filled in by the recognition server or calculated based on the supplier/customer payment term. For details of the due date proposition see [ Appendix Due date].
  • “Currency”: for details see [ Appendix Currency].

You have different options to enter data:

  • Start typing a value (code or name) directly in the field, the different options appears and you can select the right value.
  • Selecting a value from a lookup list, having a search button ListPicker.png
  • In a free text field, like description, you can enter whatever you want, no value control will be performed.

For selecting suppliers or customers: see [ selecting suppliers]/customers.

For selecting dates: see [ selecting dates].

4.1 Selecting suppliers/customers

If you don’t find the appropriate supplier by typing in its name or code in the supplier field you can open the supplier/customer dialog box by clicking ListPicker.png next to the supplier, displaying the list of all suppliers.

In the dialog box, you can search the appropriate supplier by typing in a code or name, [ wildcards] can also be used.

If you want to use the advanced supplier search, choose the appropriate filter field on which you want to search. For example on “VAT number” or on “city”. Enter a value in the next field, ENTER or click “Apply filter”. Suppliers matching the criteria are automatically shown in the supplier list.

Note: The number of suppliers in the list is limited to 10 at a time. To view the other search results, press:

  • BlockFirst.png (First page) go to begin of the list.
  • BlockPrevious.png (Previous page) go to the previous page of the list.
  • BlockLast.png (Last page) go to the end of the list.
  • BlockNext.png (Next page) go to the next page of the list.

Note: Sorting by clicking on the supplier field name can also facilitate your search.

Note: Aliases are not used.

4.2 Editing suppliers/customers

Editing the basic supplier data is possible in the supplier dialog box.

After [ selecting a supplier] click on Edit.png (Edit) for the supplier which you want to edit. An extra box containing all basic supplier data will open and you can edit the appropriate fields. Click Save button.png to save your supplier data. By releasing the invoice to your accounting package, the supplier info will also be updated in the accounting package.

Note: Desactivating suppliers have to be done in the accounting package.

4.3 Adding new suppliers/customers

If the appropriate supplier is not available in the supplier list, you can add supplier data by clicking on Add.png (Add). Click Save button.png to save your supplier data. By releasing the invoice to your accounting package, the supplier will be added in the supplier list and a code will be created automatically.

Note: The code you enter in the supplier data box will be overwritten in the accounting package, as it is the accounting package which is responsible for assigning supplier codes. After the invoice is definitive booked, the new supplier code will be available in the ScanPRO system.

4.4 Selecting dates

If the appropriate date is not correct or empty, you can change the date by editing this field or by clicking the date picker 15x15px and selecting the correct date.

  • Previous month.png go to the previous month.
  • Previous year.png go to the previous year.
  • Next month.png go to the next month.
  • Next year.png go to the next year.

Note: Use “w” as shortcut for “today” date.

5 Adding, editing and deleting posting data in the document view

Location: Archive - My tasklist - Invoice View - Posting lines field tab FieldsPosting.png (Posting line fields)

Editing posting data is only available in “My Tasklist”.

You can fill in the posting data of an invoice in the posting sheet at the bottom of the screen.

  • The “Net amount” field is copied from the “Net amount” field of the header. You can change this amount if more posting lines are needed.
    • The “Account” is selected by start typing a value (code or name) directly in the account field, the different options appear and you can select the right value. Data is sorted by the column chosen in the account popup. Another method is by selecting an account from the account list by clicking on ListPicker.png next to the account field.
  • The “Non deductable VAT” field is copied from a field value of the account. If you want to change you can type any value between 0 and 100.
  • “Line description” is automatically copied from the header field “Description”, but can be overwritten.
  • “TAX system” on the line is copied from the header field “TAX system”, but can be overwritten.


For instructions on using a posting template to fill in posting data automatically, see [ Managing posting templates].

To move to the next field of the posting line press TAB.

To create another line in the posting grid press double TAB at the end of the line or click 15x15px (Add line). Automatically a new line is added containing the open difference net amount as net line amount.

To delete a line click Remove.png (Remove line).

Basic amount calculation is available in the amount fields.

Note: If a default template is assigned to a supplier, the posting data will be applied automatically during import of the invoice in the ScanPRO system.

Note: You can resize the width of the columns by selecting the border of the column title and move it to the right or to the left.

6 Managing posting templates

Posting templates will facilitate the posting of data drastically.

6.1 Creating posting templates

Location: Archive - My tasklist - Invoice View > Click “Templates” 15x15px

  • Click “Template” 15x15px in the action button row. The Posting template manager dialog box opens.
  • Click 15x15px (Add template) to create a template.
  • The posting details as filled in the normal posting sheet of the document are copied as posting line fields of the template.
    • For the amount field you can use percentage or fixed (value) to distribute the header amount over the posting lines. If you leave the amount field empty then you have to fill it in when entering the posting data for an invoice during the validation process.
      • If you use percentage, make sure you will have 100% over all the lines.
    • The amount in the template is based on net amounts, without VAT.
    • You can add extra lines by clicking the add button 15x15px (Add line).
    • You can delete a line by clicking the delete button Remove.png (Remove line).
    • Note: In the Posting template manager dialog box no auto completion rules are available.
    • Note: Order field will line up the posting details when template is applied.
  • Each created template has its own code and name.
    • Code
    • Name, the proposed name can be overwritten.
  • A template can be bounded to a specific supplier or to be general for the whole company.
    • If a supplier is selected, then this template is specific for this supplier.
    • If no supplier is selected, the template will be created for the company, not bounded to a specific supplier. This template will not be applied by the processing at import of the invoice.
  • If you indicate the template as default, it will be applied automatically by the processing if an invoice is imported for this supplier.
    • Note: There can be only one default template per supplier, if you indicate a new template as default template, the older template will become non default.
    • Note: The template is not automatically applied when you change from supplier in the header data.
    • Note: Default template are not used for company bounded templates.
  • To save the template click “Save”, otherwise “back”.

6.2 Edit posting templates

Location: Archive - My tasklist - Invoice View > Click “Templates” 15x15px

  • Click “Template” 15x15px in the action button row. The Posting template manager dialog box opens.
  • Click Edit.png (Edit template) to edit the template.
  • To save the changes to the template click “Save”, otherwise “Back”.

6.3 Cancel posting templates

Location: Archive - My tasklist - Invoice View > Click “Templates” 15x15px

  • Click “Template” 15x15px in the action button row. The Posting template manager dialog box opens.
  • Click Remove.png (Remove template) to remove the template.


7 Action buttons available for validating invoices

Following action buttons are available in the validation screen:

7.1 Close invoice view

Location: Archive - My tasklist/ All documents - Invoice View > Click “Close”

You can close the document without saving the data, by clicking 15x15px (Close) in the action button row.

7.2 Save invoice data

Location: Archive - My tasklist - Invoice View > Click “Save”

You can save the validated data, by clicking 15x15px (Save) in the action button row, without sending the invoice to the accounting package.

7.3 Send invoice to the accounting package

Location: Archive - My tasklist - Invoice View > Click “Set ready for download”

After validating the invoice header fields and adding the posting lines, you can send the invoice to the accounting package by clicking 15x15px (Set ready for download) in the action button row.

7.4 Cancel an invoice

Location: Archive - My tasklist - Invoice View > Click “Cancel document”

If you don’t want to transfer the invoice to the accounting package you can cancel the invoice by clicking Remove.png (Cancel document) in the action button row. You have always to give a cancel reason when canceling an invoice.

Note: Depending on your settings in “[ My account]” after clicking the above mentioned buttons you will see the list or the next invoice in the list.

7.5 Apply template

Location: Archive - My tasklist - Invoice View > Click “Templates” 15x15px

  • Click “Template” 15x15px in the action button row. The Posting template manager dialog box opens.
  • A list of available templates for the selected supplier and the company bounded templates are displayed.
    • If no supplier is selected, only the company bounded templates are proposed.
  • Select a template. The posting details of the selected template are shown at the bottom.
  • To apply the selected template click “Apply template”, otherwise “Cancel”.
  • After applying, the posting grid of the document will be updated by the posting grid of the template you applied.
    • Note: If there is a correction amount, then this amount will be added on a new line.
      • Example: If you have a line with fixed amount 100 € in your template and the invoice has a net amount of 300 €, the correction amount of 200 € will be added on an extra line, if there was not a second line defined.


7.6 [ Save as template]

8 Automatic header data checks

The system checks the invoice data and accounting lines against control data such as periods and Vat tables.

  • Check on duplicate invoice number for same supplier. Check based on same supplier, same invoice type and number, invoice date within the same year.
  • Net amount plus Vat amount has to be equal to total amount in the header data.
  • Total net amount of the postings lines have to be equal to the net amount in the header data.
  • Vat check: Vat amounts of the posting lines have to be equal to the Vat amount in the header data.
  • Vat period and fiscal periods have to be open, and has to be in the selected “year”.

Note: No amount tolerances are allowed.

Invalid fields are colored in red background.


9 Auto completion rules

In order to facilitate the input of header and posting data, ScanPRO has built in different auto completion rules:

  • Copy of the “tax system” field available in the supplier record, to the “tax system” field in the header data of the invoice.
  • Copy of the “tax system” field in the header data to the posting lines of the invoice.
  • Copy of the “non deductable” field available in the account record, to the “non deductable” field in the posting lines, in case no value is available zero will be filled in the “non deductable” field.
  • [ Calculation of due date].


10 Handling attachments to invoices

Location: Invoice view > click 15x15px (Attachments)

You can only add attachments to an invoice in following status in My Tasklist:

  • To validate
  • Exception handling

Adding attachments to invoices:

  • In the invoice view, click 15x15px (Attachments).
  • Click 15x15px (Add attachment) under “Attachments” if you want to upload a new attachment.
  • Click 15x15px (Add version) next to the filename if you want to upload a new version of this attachment.
  • Choose the file for upload.
  • Select “Exportable” if you want that this attachment is automatically included in PDF downloads.
  • Click “Save” to save the attachment to the invoice or “Back”.
  • The attachment overview list contains following information:
    • Filename of attachment.
    • User who has uploaded the attachment.
    • Date of upload.
    • Automatically exportable to PDF: yes or no.

Removing attachments from invoices:

  • Select the attachment or version of the attachment you want to remove by clicking on Remove.png(remove attachment).
  • Note that the scanned invoices cannot be removed.

Downloading attachments from invoices:

  • Select the attachment or version of the attachment you want to download by clicking on 15x15px (download attachment).

Viewing attachments from invoices:

  • Select the attachment or version of the attachment you want to view in the right part of your screen File:View.png (open attachment).

==

11 Adding comments to invoices

Location: Invoice view > click 15x15px (Comments tab)

You can only add comments to an invoice in the following status in My Tasklist:

  • To validate.
  • Exception handling.

Adding comments to invoices:

  • In the invoice view, click 15x15px (Comments).
  • Enter the comment you want underneath next to the “Save” button.
  • Click “Save” to save your comment.
  • Time and user are added automatically.

Note: No comments can be removed.