Difference between revisions of "Performing support tasks"

Revision as of 11:58, 22 July 2014 (view source) Onea (talk | contribs) (→‎Filter on validation status) ← Older edit		Latest revision as of 11:53, 10 July 2018 (view source) Nele.scherrens (talk | contribs)
(37 intermediate revisions by 2 users not shown)
Line 1:		Line 1:
	==Searching for invoices==		==Searching for invoices==
		+	In the 1Archive system, any user is allowed to search for documents by using the filter above the archivelist.
		+	<br/>{{note|It's only possible to search for documents when you are in the archive.}}<br/>
−	All user profiles can retrieve invoices of the companies they have user rights for.<br/>	+	Next to the selected document type, there are two icons available for searching documents:
−	You can only search for invoices in the invoice list.	+	* [[image:filterClose.png|link=]] '''"Open filter"''': opens the filter screen.
		+	* [[image:filterLoad.png|link=]] '''"Open favorite filter"''': opens a screen with your favorite filters in it.
−	To search for invoices:	+	===Using the filter===
		+	When opening the filter, following screen appears:<br/>
		+	<br/>
		+	[[image:filter_screen.png|link=]]<br/>
		+	<br/>
		+	{{note|Depending upon your environment, the selected field could be different.}}<br/>
−	* Select the appropriate company and document type: incoming or outgoing invoices.	+	Following fields are available:
−	* Open the search filter by clicking [[image:filterClose.png|link=]] (Open filter), by clicking again on the same icon you will close the search filter.	+	* '''Field''': choose the field on which you would like to filter the documents.
−	* Add a filter line:	+	<br/>{{note|The available fields are all header-, technical- and posting line fields from your environment. See ''[[Validating_invoices|"Validating invoices"]]'' for all available fields.}}<br/>
−	** Select the field you want to filter on, you can filter on:	+	* '''Operator''': choose the operator on which you would like to filter. Possible values are:
−	*** Header fields, like supplier, invoice number…	+	** ''Include'': the field includes the value(s) provided.
−	*** Posting line fields, like account…	+	** ''Exclude'': the field excludes the value(s) provided.
−	*** Technical fields, like status, scanning date…	+	** ''Empty'': choose this in case you want to check on an empty value.
−	** From the drop-down list, select an operator. The available options are:	+	* '''From''' and '''To''': the value of the field has to lie in between these two values.
−	*** Include	+	<br/>{{note|Certain fields only have the possibility to enter a <u>'''From'''</u> value.}}<br/>
−	*** Exclude	+	{{note|Based on the type of the selected field, it's possible to either type in text, select from a [[image:listPicker.png|link=]] "List" or select a [[image:date.png|link=]] "Date".}}<br/>
−	*** Empty, in case there is no value.	+	{{info|Tip: it is possible to search for multiple values inside one filter box by using a semicolon (;). But this only works for text fields, not for numeric, date and lookuplist fields!<br/>
−	** Type a value in the “From” “To” fields, if you want to select a range of values, if you want to select only one value, type only this value in the “From” field. <br/>Values can be selected by typing in the value, or by selecting them from the lookup list, or via the date picker.	+	'''Example''': enter 2017032101;2017032102 to search for invoices with invoice number 2017032101 and 2017032102.}}<br/>
		+	{{info|If you would like to filter on one particular value, add this in the <u>'''From'''</u> field}}<br/>
		+	Adding an extra line to filter on is done via the [[image:add.png|link=]] "Add" button in the left upper corner of the filter screen.<br/>
		+	Removing a line is done via the [[image:remove.png|link=]] "Remove" button in front of each line.<br/>
		+	<br/>
		+	At the bottom of the filter screen, there are four different buttons available:
		+	* [[image:filterClose.png|link=]] '''"Close filter"''': hides the filter screen.
		+	<br/>{{warning|Note that clicking [[image:filterClose.png|link=]] "Close filter" does not clear or apply the current filter.}}<br/>
		+	{{note|When a filter is closed, it can be reopened easily by clicking the [[image:filterClose.png|link=]] "Open filter" button next to the document type.}}<br/>
		+	* [[image:filterRemove.png|link=]] '''"Clear filter"''': remove all applied filters.
		+	* [[image:filterApply.png|link=]] '''"Apply filter"''': applies the filter on the list of documents.
		+	<br/>{{note|Note that the filter icon next to the document type will color red [[image:filterActive.png|link=]] to indicate that a filter is applied.}}<br/>
		+	* [[image:filterSave.png|link=]] '''"Save filter"''': save a filter in your favorite filters.
		+	<br/>{{info|Clicking this button results in the appearance of a pop-up screen where you have to name the filter.<br/>
		+	[[image:save_filter.png|link=]]}}
−	{{Info|if you want to search “from date” till today, you have to specify also the todays date: use “w” as shortcut for the today!}}
−		+	===Using favorite filters===
−	:* You can add more lines by pressing [[image:add.png|link=]]	+	When opening your favorite filters, following screen appears:<br/>
−	:* You can delete filter lines by clicking [[image:remove.png|link=]] next to the line.	+	<br/>
−	* Press the “Apply filter” button to execute the filtering, or just by entering.	+	[[image:favorite_filter_with_values.png|link=]]<br/>
−	* The filter icon will be colored red, in order to indicate that the invoice list contains a filtered list.	+	<br/>
−	* A new invoice list with the selected values will appear.	+	Selecting a filter to apply on the list of documents can be done by clicking the name of the filter.<br/>
−	* By pressing “Clear filter” you can clear your search criteria.	+	Removing a filter from your favorites can be done by using the [[image:remove.png|link=]] "Remove" button.<br/>
		+	<br/>
		+	You can search for a filter using the textbox on top of the screen. Type a value and click ''"Apply filter"'' to search. Removing your search can be done by clicking the ''"Clear"'' button.<br/>
		+	<br/>
	=== Filter on validation status ===		=== Filter on validation status ===
−		+	Something worth mentioning is the ability to filter on validation status.<br/>
−	It is also possible to filter on the validation status:	+	<br/>
−		+	[[image:Filter.png|link=]]<br/>
−	[[image:Filter.png|link=]]	+	<br/>
−		+	Values to filter on are:
−		+	* '''In progress''': the document still needs to be validated in the 1Archive system.
−	''In progress'': ScanPRO still needs to validate the document	+	* '''Valid''': the document is completely valid and contains no red or yellow fields.
−		+	* '''Invalid''': the document is invalid and contains red or yellow fields.
−	''Valid'': document is valid and no fields are colored red or yellow
−
−	''Invalid'': document is invalid and contains red or yellow fields
	==Using wildcards==		==Using wildcards==
		+	In order to facilitate your search, you can make use of wildcards. There are two wildcards available:
		+	* '''*'''
		+	* '''%'''
		+	<br/>
		+	Both wildcards work as follows:
		+	* '''*text''' or '''%text''': searches for all values ending with value "text".
		+	* '''text*''' or '''text%''': searches for all values beginning with value "text".
		+	* '''te*xt''' or '''te%xt''': searches for all values beginning with "te" and ending with "xt".
−	In order to facilitate your search wildcards like “*” or “%” can be used:	+	<br/>{{info|If you just type "text", the search will be based on "text*".}}<br/>
−		+	{{warning|Searching for values in 1Archive is not case sensitive.}}<br/>
−	:* <nowiki>*text, means: all values ending with “text”.</nowiki>	+	{{warning|Using these wildcards is only possible in search dialogs. For example: the search dialog for suppliers in the document view.}}<br/>
−	:* text*, means: all values beginning with “text”.
−	:* te*xt, means: all values beginning with “’te” and ending with “xt”.
−
−
−	{{Note|If you type text, the search will be applied based on ‘text*’.}}
−
−
−	{{Note|Search is not case sensitive.}}
−
−
−	==Saving search criteria as favourite==
−
−	Create a filter as described in <u>''[[Performing_support_tasks#Searching_for_invoices|Searching for invoices]]''</u>.<br/>
−	Give your search criteria a name and save your filter by clicking the “Save filter” button. Note when a favourite filter already exists with the same name, the filter will be overwritten without any notification.
−
−	==Search invoices based on a favourite filter==
−
−	* Select the appropriate company and document type: incoming or outgoing invoices.
−	* Search your favourite filter by clicking [[image:filterLoad.png|link=]] (Open favourite filter), by clicking on [[image:filterOpen.png|link=]] (Close filter) you will close the search filter.
−	* Select your favourite filter by clicking on the filter name, press “Apply filter”. “Clear filter” in order to clear your search criteria.
−	* Additional lines can be added, or lines can be deleted following the instructions under [ Searching for invoices].
−
−	==Exporting invoices to pdf==
−
−	You can export the invoice images to pdf from the invoice list view.<br/>
−	You can select the invoices by <u>''[[Performing_support_tasks#Searching_for_invoices|Searching for invoices]]''</u>, or by selecting invoices for PDF export by selecting the check boxes at the beginning of the invoice list.<br/>
−	You can also select all invoices by clicking the [[image:unselected.png|link=]] box next to the label bar.<br/>
−	Click on [[image:PagePdf.png|link=]] (Export to pdf), to export the images (invoice plus attachments) to a PDF file. For each invoice a new bookmark, containing the ScanPRO ID is created.
−
−
−	{{Warning|Only “exportable pdf attachments” will be included in the PDF.}}
−
−
−	{{Warning|Up to a maximum of 100 documents can be exported per download.}}
−
−
−	==Exporting invoice data to Excel==
−
−	You can export the invoice header data to an Excel file from the invoice list view.<br/>
−	You can select the invoices by <u>''[[Performing_support_tasks#Searching_for_invoices|Searching for invoices]]''</u>, or by selecting the check boxes at the beginning of the invoice list.<br/>
−	You can also select all invoices by clicking the [[image:unselected.png|link=]] box next to the label bar.<br/>
−	Click on [[image:PageXls.png|link=]] (Export to Excel), to export the header data to an Excel file. <br/>
−	You have an option to select the list data, or all data, by selecting “Export all fields”
−
−	* List data: fields are included, which are visible in the list.
−	* All data: all fields are included.
−
−
−	{{Warning|Up to a maximum of 1000 invoices can be exported per download.}}
−
−
−	==Exporting invoice data to zip==
−
−	Similar to <u>''[[Performing_support_tasks#Exporting_invoices_to_pdf|exporting invoices to pdf]]''</u>, you can export the invoice images to a Zip file from the invoice list view.<br/>
−	Folder structure is created based on ScanPro id.
−
−
−	{{Warning|Up to a maximum of 100 documents can be exported per download.}}
−
−
−	==Full text search==
−
−	===Introduction===
−
−	The ''full text search'' feature can be used to find a single (or multiple) document(s) based on a search field which is located at the top of the archive list screen (see screenshot below). <br/>This powerful feature gives the user the ability to search a document on a search value which will be used to search in invoice data, as in text which can be found in the image of the document.
−
−
−	[[image:Search.png|340x67px|link=]]
−
−
−	'''Examples of usage:'''
−
−	* User wants to have a list of documents which have the word “car” in invoice data.
−	* User wants to find an invoice for a notebook which has been bought 1,5 years ago. This invoice contains the serial number of the notebook, but this number is not stored in the invoice data. <br/>By entering the serial number in the search field, the user can still find his invoice.
−
−
−
−	By <u>''[[Performing_support_tasks#Invoice_data|invoice data]]''</u> of the document, the following information of the document is meant:
−
−	* Header data
−	* Technical data
−	* Posting data
−	* Detail data
−
−	The user can’t specify on which field to filter, as the ''full text search'' feature will try to search in all fields of the document. <br/>If he does want to filter on a specific field, the standard filter of ScanPRO should be used (and/or combined with ''full text search'').
−
−
−	By <u>''[[Performing_support_tasks#Image|image]]''</u> of the document, the following information of the document is meant:
−
−	* PDF image
−
−
−	===How does this powerful feature work?===
−
−	====Invoice data====
−
−	When providing a search value, all fields will be checked for a possible match. Depending on the field data type, a conversion is made:
−
−	* Text:
−	** No conversion is made. User can type a word of the text field value. If a part of word is used, the wildcard character (*) should be added. Searching on text is case insensitive.
−	** '''Examples:'''
−	*** Document has a text field which contains the value “Onea NV”.
−	*** The user will find the document if he enters:
−	**** Onea, ONEA, onea, on*, *nea, *ne*, …
−	*** The user will not find a match if he enters:
−	**** Ne, one, …
−
−
−	{{Note|Using a wildcard character in front of the search value, can slow down the speed of searching.}}
		+	==Exporting documents to Excel==
		+	From the archive, it's possible to export the values of the document fields into Excel.<br/>
		+	<br/>
		+	In the archivelist, select the documents you would like to export by checking the checkboxes [[image:unselected.png|link=]] in front of the documents. Documents are selected when the checkboxes looks like this: [[image:selected.png|link=]].<br/>
		+	Click on the [[image:pageXls.png|link=]] "Export to Excel" button to export the values of the document fields.<br/>
		+	When clicking this button, you see following screen above the archivelist:<br/>
		+	<br/>
		+	[[image:export_excel.png|link=]]<br/>
		+	<br/>
		+	This screen allows you to select the fields to be exported. Following selections are available:
		+	* '''Export all header fields''':
		+	** if you check the checkbox, then all available header fields will be exported
		+	** if you don't check the checkbox, then only the fields which are available in the archivelist will be exported
		+	* '''Include lines''': if you check this checkbox, you have the possibility to select the lines which you would like to have in the export. Possible values are:
		+	** ''Posting line fields'': include all fields of the posting lines.
		+	** ''Detail line fields'': include all fields of the detail lines.
		+	<br/>{{warning|Detail line fields are only available in the VIS environment!}}<br/>
		+	{{info|In the Excel export, the header data will be repeated in case multiple posting lines will be exported. For example: when having a document with 2 posting lines, the Excel file will contain a similar header data row for each specific posting line.}}<br/>
		+	Click the '''"Export to Excel"''' button in order to create the Excel file. This will be downloaded to your file system.
		+	<br/>{{info|The export to Excel functionality has a limited number of documents that can be exported:<br/>
		+	* EIS: 1000 documents
		+	* OIS: 1000 documents
		+	* VIS: 1000 documents
		+	* Connected: 5000 documents
		+	* MIS: 1000 documents}}<br/>
−	* Numbers:	+	==Exporting documents to PDF==
−	** A user can search for a number by entering some digits. If the user wants to search for a decimal number a dot (.) or (,) can be used for comma. A thousand separator is not supported.	+	From the archive, it's possible to export documents to PDF.<br/>
−	** '''Examples:'''	+	Select the documents you would like to export by using the checkboxes [[image:unselected.png|link=]] in front of them. Documents are selected when the checkboxes look like this: [[image:selected.png|link=]].<br/>
−	*** Document has a number field which contains the value “1.000,45”.	+	Click on the [[image:pagePdf.png|link=]] "Export to PDF" button to export the documents.
−	*** The user will find a match if he enters:	+	<br/>{{info|All images, including the attachments, will be exported.}}<br/>
−	**** 1000.45, 1000,45	+	{{warning|Only exportable attachments will be included!}}<br/>
−	*** The user will not find a match if he enters:	+	{{info|For each document, a bookmark will be created in the PDF file. This bookmark is based on the ID the document has in 1Archive.}}<br/>
−	**** 1.000,45	+	<br/>{{info|The export to PDF functionality has a limited number of documents that can be exported:<br/>
−	* Dates:	+	* EIS: 100 documents
−	** Only the date format dd/mm/yy is supported (d = day, m = month, y = year).	+	* OIS: 100 documents
−	** '''Examples:'''	+	* VIS: 100 documents
−	*** Document contains a date field which contains the value “18/03/85”.	+	* Connected: 100 documents
−	*** The user will find a match if he enters:	+	* MIS: 100 documents}}<br/>
−	**** 18/03/1985
−	*** The user will not find a match if he enters:
−	**** 18-03-1985, 18.03.1985
−	* Partners & lookuplist items
−	** The user can enter the code or the name of a partner/lookuplist item to find a match. It’s not possible to search on fields of a partner/lookuplist item.
−	** '''Examples:'''
−	*** Document has a partner field which contains the value “Onea NV (5090)” .
−	*** The user will find a match if he enters:
−	**** Onea NV, 5090
		+	==Exporting documents to XML==
		+	From the archive, it's possible to export documents to an XML file.<br/>
		+	Select the documents you would like to export using the checkboxes [[image:unselected.png|link=]] in front of them. Documents are selected when the checkboxes look like this: [[image:selected.png|link=]].<br/>
		+	Click the [[image:PageXML.png|link=]] "Export to XML" button to export the documents.<br/>
−	====Image====	+	<br/>{{info|The exported XML files will be in the 1Archive transfer format.}}<br/>
−	''Full text search'' searches for literally values in PDF images. The user should search for text like it is printed in the image.	+	==Exporting documents to Zip==
		+	From the archive, it's possible to export documents to a Zip-file.<br/>
		+	Select the documents you would like to export using the checkboxes [[image:unselected.png|link=]] in front of them. Documents are selected when the checkboxes look like this: [[image:selected.png|link=]].<br/>
		+	Click the [[image:zip.png|link=]] "Export to Zip" button to export the documents.<br/>
		+	<br/>{{info|The Zip-file contains a folder for each document you selected with all exportable images in it.}}<br/>
		+	<br/>{{info|The export to Zip functionality has a limited number of documents that can be exported:<br/>
		+	* EIS: 100 documents
		+	* OIS: 100 documents
		+	* VIS: 1000 documents
		+	* Connected: 100 documents
		+	* MIS: 100 documents}}<br/>
−	'''Examples:'''	+	==Exporting documents to UBL==
		+	From the archive, it's possible to export documents to UBL.<br/>
		+	Select the documents you would like to export using the checkboxes [[image:unselected.png|link=]] in front of them. Documents are selected when the checkboxes look like this: [[image:selected.png|link=]].<br/>
		+	Click the [[image:PageXML.png|link=]] "Export to UBL" button to export the documents.<br/>
		+	<br/>{{info|Clicking this button will result in a Zip-file being downloaded to your system. This Zip-file contains an UBL invoice per exported document.}}<br/>
−	* Image contains the value: “ … BE.0883.668.416 … “ -&gt; the user needs to type the search value exactly like it’s printed in the PDF. Don’t replace “.” with spaces for example. <br/>Of course, it’s still possible to use a wildcard character like “BE.0883*”.	+	==Mail as PDF==
−	* Image contains the value: “11-09-2010” -&gt; the user needs to type the search value exactly like it’s printed in the PDF. Don’t provide format dd/MM/yy for example.	+	When in the archive, the left sidebar shows a [[image:pagePdf.png|link=]] "Mail as PDF" button. Clicking this button results in following screen that appears:<br/>
−	* Image contains the value: 1.456,57 -&gt; to type the search value exactly like it’s printed in the PDF . Don’t provide format 1456.57.	+	<br/>
		+	[[image:mail_as_pdf.png|link=]]<br/>
		+	<br/>
		+	Following fields are available:
		+	* '''E-mail address''': provide the e-mail address you wish to send the documents to. Default value will be the e-mail address of the currently logged in user.
		+	* '''From''' and '''To''': provide the dates between which the voucher dates of the documents you would like to send are.
		+	Click "Ok" to submit the data and send a merged PDF-file with all documents with voucher dates between the "From" and "To" date.

---

Latest revision as of 11:53, 10 July 2018

1 Searching for invoices

In the 1Archive system, any user is allowed to search for documents by using the filter above the archivelist.

Next to the selected document type, there are two icons available for searching documents:

• "Open filter": opens the filter screen.
• "Open favorite filter": opens a screen with your favorite filters in it.

1.1 Using the filter

When opening the filter, following screen appears:

Following fields are available:

• Field: choose the field on which you would like to filter the documents.

• Operator: choose the operator on which you would like to filter. Possible values are:
  • Include: the field includes the value(s) provided.
  • Exclude: the field excludes the value(s) provided.
  • Empty: choose this in case you want to check on an empty value.
• From and To: the value of the field has to lie in between these two values.

Adding an extra line to filter on is done via the "Add" button in the left upper corner of the filter screen.
Removing a line is done via the "Remove" button in front of each line.

At the bottom of the filter screen, there are four different buttons available:

• "Close filter": hides the filter screen.

• "Clear filter": remove all applied filters.
• "Apply filter": applies the filter on the list of documents.

• "Save filter": save a filter in your favorite filters.

1.2 Using favorite filters

When opening your favorite filters, following screen appears:



Selecting a filter to apply on the list of documents can be done by clicking the name of the filter.
Removing a filter from your favorites can be done by using the "Remove" button.

You can search for a filter using the textbox on top of the screen. Type a value and click "Apply filter" to search. Removing your search can be done by clicking the "Clear" button.

1.3 Filter on validation status

Something worth mentioning is the ability to filter on validation status.



Values to filter on are:

• In progress: the document still needs to be validated in the 1Archive system.
• Valid: the document is completely valid and contains no red or yellow fields.
• Invalid: the document is invalid and contains red or yellow fields.

2 Using wildcards

In order to facilitate your search, you can make use of wildcards. There are two wildcards available:

• *
• %

Both wildcards work as follows:

• *text or %text: searches for all values ending with value "text".
• text* or text%: searches for all values beginning with value "text".
• te*xt or te%xt: searches for all values beginning with "te" and ending with "xt".

3 Exporting documents to Excel

From the archive, it's possible to export the values of the document fields into Excel.

In the archivelist, select the documents you would like to export by checking the checkboxes in front of the documents. Documents are selected when the checkboxes looks like this: .
Click on the "Export to Excel" button to export the values of the document fields.
When clicking this button, you see following screen above the archivelist:



This screen allows you to select the fields to be exported. Following selections are available:

• Export all header fields:
  • if you check the checkbox, then all available header fields will be exported
  • if you don't check the checkbox, then only the fields which are available in the archivelist will be exported
• Include lines: if you check this checkbox, you have the possibility to select the lines which you would like to have in the export. Possible values are:
  • Posting line fields: include all fields of the posting lines.
  • Detail line fields: include all fields of the detail lines.

Click the "Export to Excel" button in order to create the Excel file. This will be downloaded to your file system.

4 Exporting documents to PDF

From the archive, it's possible to export documents to PDF.
Select the documents you would like to export by using the checkboxes in front of them. Documents are selected when the checkboxes look like this: .
Click on the "Export to PDF" button to export the documents.

5 Exporting documents to XML

From the archive, it's possible to export documents to an XML file.
Select the documents you would like to export using the checkboxes in front of them. Documents are selected when the checkboxes look like this: .
Click the "Export to XML" button to export the documents.

6 Exporting documents to Zip

From the archive, it's possible to export documents to a Zip-file.
Select the documents you would like to export using the checkboxes in front of them. Documents are selected when the checkboxes look like this: .
Click the "Export to Zip" button to export the documents.

7 Exporting documents to UBL

From the archive, it's possible to export documents to UBL.
Select the documents you would like to export using the checkboxes in front of them. Documents are selected when the checkboxes look like this: .
Click the "Export to UBL" button to export the documents.

8 Mail as PDF

When in the archive, the left sidebar shows a "Mail as PDF" button. Clicking this button results in following screen that appears:



Following fields are available:

• E-mail address: provide the e-mail address you wish to send the documents to. Default value will be the e-mail address of the currently logged in user.
• From and To: provide the dates between which the voucher dates of the documents you would like to send are.

Click "Ok" to submit the data and send a merged PDF-file with all documents with voucher dates between the "From" and "To" date.