Documents v20.1

Allows users to scan and retrieve documents while they work in Sage 200, with no additional document management software or indexing steps required. The document indexing information is stored within the Sage 200 SQL database for fast searching. The documents are stored within the Sage 200 attachments path to ensure all documents are backed up within your Sage backup plan.

Release notes:

Make it easier to find your content with:

Expand content Collapse Content New Features Only Issues Resolved Only Release Only Pre Release Only Hot Fix Enhancements Important Only

Know the release number? Use quick search:

201.0.27

Issues Resolved
Issues Resolved
  • Resolved an issue in the documents web api where it was not checking the external product Id when adding documents

Date applied: February 26, 2021

201.0.26

Issues Resolved
Issues Resolved
  • Added a new instrument to delete migrated documents
  • Fixed an issue in document automation where an error would be displayed if there was no default PL job or Job Header configured in job costing
  • Resolved an issue on the process invoice screen where it was hiding the job costing controls if Job costing integration was enabled (rather than disabled)

Date applied: February 26, 2021

201.0.25

Issues Resolved
Issues Resolved
  • Resolved an issue when importing invoices in document automation where a sort was being applied twice

Date applied: February 24, 2021

201.0.24

Issues Resolved
Issues Resolved
  • Resolved an issue where add and view buttons would not be added to sales and purchase enquiry if document count column disabled

Date applied: February 24, 2021

201.0.23

Issues Resolved
Issues Resolved
  • Resolved errors that would occur on transaction enquiry when document count columns are not enabled

Date applied: February 24, 2021

201.0.22

Issues Resolved
Issues Resolved
  • Resolved an issue when saving training templates where an error could be displayed when saving new fields

Date applied: February 17, 2021

201.0.21

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Removed totals from the process invoice grid as they were causing performance issues when values edited in the grid
  • Changed the DevExpress PDF viewer to use direct X for rendering to work around issues with untrusted fonts
  • Resolved an issue in document automation where the job costing transactions would not create if order lines were set as confirmation not required
  • Resolved an issue in document automation where the second reference would not get set for POP invoices being manually recorded
  • Fixed an issue with the multiple document viewer form where two columns had the same memento
  • Carriage returns and new lines are now trimmed from feedback to cogidocs

Hot Fix Enhancements
  • Added the remittance date into the document description for supplier payment generation

Date applied: February 16, 2021

201.0.20

Issues Resolved Hot Fix Enhancements Important
Important Info
  • Removed document count progress bars from nominal, cashbook, sales and purchase transaction enquiry and replaced with loading the document counts on the item add event.

Issues Resolved
  • Fixed a typo in the reference cogidoc field
  • Changed the process invoices screen to not validate goods despatched for free text returns
  • Resolved an issue when reading outlook attachments where no attachments would be read due to a change in office

Hot Fix Enhancements
  • Added the ability to fine tune supplier details that are uploaded to cogidocs

Date applied: February 9, 2021

201.0.19

Issues Resolved
Issues Resolved
  • Changed the document automation screen to first validate invoices with the full invoice number, then fall back to checking the invoice number with leading zeros removed.

Date applied: January 25, 2021

201.0.18

Issues Resolved
Issues Resolved
  • Added the ability edit data in the invoice lines grid in Document automation
  • Resolved an issue when validating invoices where the validation grid would not refresh when clicking the validate button at the bottom of the screen (document automation)

Date applied: January 19, 2021

201.0.17

New Features
New Features
  • Added the ability to add documents to Batch and Serial numbered receipts

Date applied: January 18, 2021

201.0.16

Issues Resolved
Issues Resolved
  • Resolved an issue in document automation where an error could be displayed if item line extraction enabled, but a line was not matched

Date applied: January 6, 2021

201.0.15

Hot Fix Enhancements
Hot Fix Enhancements
  • Added a web api extension for adding documents to the post purchase and sales invoice and credits web api methods

Date applied: December 31, 2020

201.0.14

Issues Resolved
Issues Resolved
  •  Changed item line extraction in document automation to only validate GRN and invoice quantities against matched lines
  • Changed document automation to only check for variance if item line extraction is not enabled, otherwise it will check for variance per line

Date applied: December 24, 2020

201.0.13

Issues Resolved
Issues Resolved
  • Changed document automation to check whether the job on the PO line matches the job on the invoice header as well as the item code and description etc
  • Added additional validation to document automation to check invoice dates are not before 01/01/1753 when period based transaction date validation is enabled

Date applied: December 23, 2020

201.0.12

Issues Resolved
Issues Resolved
  • Resolved an issue on the rapid purchase invoice screen where documents count not be re-indexed if CIS was enabled for the supplier because Sicon Construction was changing the invoice second ref

Date applied: December 23, 2020

201.0.11

Issues Resolved
Issues Resolved
  • Resolved an issue in document distribution where all credit notes would be included in the email instead of outstanding
  • Changed document automation to trim any white space from invoice numbers
  • Improved the performance of the process invoice screen by only validating when data is changed or the invoice has not been validated once already

Date applied: December 22, 2020

201.0.10

Issues Resolved
Issues Resolved
  • Fixed an issue in the job costing documents view where return transactions were being handled incorrectly

Date applied: December 21, 2020

201.0.9

Issues Resolved
Issues Resolved
  • Changed all date format parsing to dd-MM-yyyy from MM-dd-yyyy in Document Automation

Date applied: December 21, 2020

201.0.8

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Resolved an issue on the process invoices form where a changes made by other users message could be displays in some circumstances
  • Resolved an error that would occur when deleting a works order

Hot Fix Enhancements
  • Added a drop down to the user settings grid to pick whether a user has a full licence or view only licence
  • Added the ability to attach and view documents to the goods despatched form
  • Added the ability to check required documents on the goods despatched form

Date applied: December 3, 2020

201.0.7

Hot Fix Enhancements
Hot Fix Enhancements
  • Added a new setting to document automation to look up pop order lines based on the item code in an analysis code
  • Added a new setting to document automation to look up pop order numbers based on the order no in an analysis code

Date applied: November 26, 2020

201.0.6

Issues Resolved
Issues Resolved
  • Fixed the check for required documents on the works order screen
  • Set the max length of the application name text box in document automation to 32 characters.

Date applied: November 26, 2020

201.0.5

Hot Fix Enhancements
Hot Fix Enhancements
  • Added 3 way matching to document automation

Date applied: November 26, 2020

201.0.4

Issues Resolved
Issues Resolved
  • Resolved an issue with re-printing invoices and credits through document distribution where the default layout would be used

Date applied: November 26, 2020

201.0.3

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Changed the document automation variance check to be based on net value rather than gross

Hot Fix Enhancements
  • Added the ability to add documents via the Documents Web Api

Date applied: November 26, 2020

201.0.2

Issues Resolved
Issues Resolved
  • Fixed an issue on the view item details form where an error would be displayed if the user did not have add and view permission
  • Changed sending statements through document distribution to include credit notes
  • Changed re-printing invoices and credits in document distribution to always use the default layout

Date applied: October 31, 2020

201.0.1

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Changed the works order form to check for the required documents setting on form close

Hot Fix Enhancements
  • Added the ability to apply the default template for a supplier to all untrained invoices in the current view (document automation)
  • Added settings to document automation to validate the second reference has been read. Can be override per supplier
  • Added the ability to file and index outlook read receipt items

Date applied: October 27, 2020

201.0.0

Issues Resolved New Features
New Features
  • Added a type drop down to the document automation screen to change the invoice type
  • Added settings for narrative extraction to document automation
  • Added a setting to control the vat code used for purchase ledger invoices and credits if there is no vat on the invoice, this can be overridden by supplier
  • Added the ability to save a training template and apply this to other invoices
  • Added validation to document automation to check the purchase order lines all have valid nominal codes
  • When an invoice is trained, the system will now ask whether to update the other invoices for the same supplier that have not been trained
  • Scripted the invoice module re-print sales invoice and credit forms
  • Changed the process invoices screen to show a text box instead of the PO number lookup if POP Order Matching is not enabled, this will allow any free text document no to be entered
  • Changed the document count worker to check for additional documents when showing the document count in the list, eg, goods received notes for orders etc.
  • Added the ability to select different distribution layouts for different criteria
  • Added the ability to add documents to CRM Companies, People, Tasks, Opportunities and Tenders
  • Added the ability to specify a header PDF to merge onto Document Distribution reports
  • Added the common enable module form to the menu
  • Added query code and query note columns to the process automation invoices screen, there are visible if the queried radio button is selected
  • Added an option to right click and view supplier on the process automated invoices screen
  • Enabled the right click export to excel function on the process automated invoices screen
  • Added sender email address column to the process invoices screen
  • Added the ability to find a purchase order by line on the process invoices screen
  • Added a setting to hide the import / export options
  • Changed the document automation invoice screen to remember the invoice grid column location and sizes
  • Added settings for variance to document automation. Invoices that done match the PO but are within the variance amounts configured will now show as valid
  • Document Automation will now check whether the supplied is a Construction supplier and show the deductions form when submitting invoices to WAP.
  • Added a progress bar to the document automation screen to show current status loading, saving validating etc
  • hanged the document automation screen to allow cancelling the current process when closing
  • Added validation to the process invoices screen to validate supplier not marked as inactive
  • Added the ability to put a query flag against an invoice
  • Added an option to the auto invoice screen to not auto reload
  • Added a new column to the document automation invoice screen to show the GRN Status
  • When invoices are recorded against document automation the nominal lines will now be taken from the PO and a variance line added where the value is different
  • Added the ability to email contract renewal reminders through document distribution
  • Invoice screens will now opened maximized when opened from document automation
  • added validation to the record pop invoice form to ensure quantities have been entered when opened from document automation
  • Added a new setting to document automation to determine whether purchase ledger invoices and credits should submit directly to WAP
  • Added the ability to filter invoices on the process auto invoices form
  • Added a new option to the process AI invoices screen to show invoices with GRN issues only

Issues Resolved
  • Resolved an issue in the invoice module where the script for the amend credit note screen was not being fired
  • When loading a training template, only digits and decimal points will be read for amount fields (currency symbols excluded)
  • Resolved an issue when sending supplier accounts to cogidocs where the error would not be shown if encountered
  • Resolved an issue on the process invoices screen where if an error would occur, subsequent invoices would not be processed
  • Resolved an issue in document automation where it was trying to use a job costing assembly that may not be installed.
  • Changed the export invoices routine in document automation to save the invoices before trying to export
  • Changed the document automation method to get invoices in export stage to also get invoices specifically in Ready State.
  • Resolved an issue with the index document form where an error could be displayed when trying to wire up drag an drop events and the current thread is not an STA thread
  • Changed the document automation process to create one customer record but an application for each sage 200 company
  • Added additional validation when processing invoices to check the invoice has not been changed an updated by another user
  • resolved spelling issue on settings page Acceptible > Acceptable
  • Resolved an issue when viewing document on the amend quotation form where a not supported exception would be thrown
  • Changed document automation to not checked for required documents when an invoice is saved (as a document will be added)
  • resolved an issue with the export settings button on the settings screen
  • Resolved an issue on the settings form where a duplicate key error could be shown when updating users in some circumstances
  • Resolved an issue in document automation where a variance line would not be added to the invoice if job costing was installed but integration was not enabled
  • Removed the option to set up a document automation account in trial mode, all accounts will now be created on the production server to avoid having to retrain and re-upload suppliers. he free test documents will now apply to the live portal
  • Removed the Advanced options button from document automation settings on the settings form and supplier account
  • Changed document automation to hide other invoice application types (only standard UK type is now shown)
  • Removed the text ‘DMS’ from the multiple document viewer form
  • Edited the job costing tip to Read Sicon Projects instead of Job Costing
  • Renamed the calculate DMS folder size button to Calculate Document Archive size
  • Added validation to document automation to validate the invoice no is not greater than 20 characters
  • Changed document automation to truncate the invoice no to 20 characters
  • Changed document automation to check whether the invoice has changed by another user when putting it on query and also to save the record as its queried or unqueried
  • Changed the print SOP invoices routine to not open the preview window and write directly to outlook as there is a memory leak in the sage report preview window when opening multiple reports
  • Resolved an issue in document automation where a given key was not present in the dictionary message could be displayed when processing POP invoices
  • Changed document automation to check whether records have been changed when saving the invoices and to prompt to reload if so.
  • Changed the document automation screen to only download invoices in export stage
  • Changed the document automation screen to only download invoices that have not previously been saved to the database.
  • Resolved an issue in document automation where form locks would be left in the database after submitting an invoice to WAP.
  • Resolved an issue in document automation where importing exported invoices could result in an object reference not set error if the media had not been downloaded already.
  • Changed the run all statements form to run the standard sage report outside of the background thread so the report an be previewed if configured that way.
  • Minor error handling enhancements to customer statements
  • Resolved an issue with the block invoices with no GRN setting where if an order had some lines with no GRN it could not be processed.
  • Resolved an issue loading the AI invoice screen where an error could be displayed if no invoices
  • Improved the performance of the document automation screen
  • Improved the memory usage when searching for invoices by email address
  • Resolved an issue in document automation where the narrative would not copy from the PO line when in automatic processing mode.
  • Resolved an issue in document automation where the second reference would not be set to the PO number when recording a manual invoice against a PO
  • changed the process invoices screen to hide on hold and inactive suppliers
  • Changed the upload suppliers screen to skip inactive accounts
  • Changed the cogidocs api to used TLS 1.2 by default but roll back to TLS 1.1 and 1.0
  • Changed the run statements form to check the settings on the customer account and only generate specific statements
  • Changed the auto invoice screen to only allow training in export stage
  • Changed the auto invoice screen to only allow editing in export stage
  • Resolved an issue with the GRN status column on process auto invoices where it would not show the correct status for invoices where some lines are fully received on an order and some are not received at all
  • Fixed an issue on nominal transaction enquiry that resolves and object reference not set error when the add or view buttons are not visible
  • Fixed an issue on the process AI invoice screen where it was not setting the max length allowed for some of the string fields
  • Resolved an issue on the customer statements form where reports were not generated if a balance filter was entered
  • Disabled Training mode for invoices with no supplier
  • Improved the memory usage of the print and email button when printing multiple invoices
  • Resolved an issue in document distribution where an error would occur when deleting a document that had been added to a distribution report
  • Shortened the text in the radio buttons on the process invoices screen
  • Changed the process invoice screen to update the supplier on the invoice incase it was saved in export stage without a supplier
  • Changed the un-link cogidocs account option to prompt separately as to whether to delete the suppliers or not from the cogidocs portal
  • Resolved an issue in document automation where the record POP invoice credit screen was not setting the line values for selected additional charge lines unless manually refreshed
  • Document will no longer throw an error if recipients cannot be resolved, instead it will pop open the outlook window if set to send automatically
  • Changed document automation to split recipient email addresses when there are multiple email addresses in a contact
  • Changed document distribution to print collection notes for only the selected items on the outstanding payments screen (if items selected)
  • Changed document distribution to use the invoice number instead of the sales order number when printing invoices
  • Resolved an issue in document automation where an error could be thrown if the GRN lines collection for an invoice was null instead of an empty collection
  • Resolved an issue when checking there are received quantities for an order where it was not checking the line and confirmation intent types
  • Fixed an issue when checking for user features targets where a null reference exception could be thrown
  • Changed the invoice processing screen to default the invoice quantities for the orders if the invoice value matches the PO value completely
  • Resolved an issue merging email templates where the supplier account name and reference were not being merged for remittances
  • Resolved an issue on the re-print invoice / credit notes screen where the merge was using the first order number for every email.
  • Resolved an issue on the stock item maintenance form where an error could be thrown if the user did not have view rights
  • Resolved an error that could occur when moving the mouse over the PDF document viewer without a valid PDF loaded
  • Added handling on the PDF viewer during painting to check the page number of an OCR field is not greater than the number of pages in the PDF
  • Removed the print preview button from the email template editor
  • resolved an issue with the process invoices screen not remembering the sort column correctly
  • moved options to add and view documents from despatch notes to sales orders
  • Invoices with GRN issues will now be excluded from the invoices needing attention list in document automation
  • Auto invoices will no longer load if the module is not enabled
  • Addded additional null reference handing to the Transaction Enquiry forms
  • Removed auto loading of AI invoices if filters are visible on form load
  • Changed the way the system checks for documents on the POP Invoice credit history form for a purchase order line. This resolves and issue where invoices could be viewed on an order but not the line
  • Resolved and issue with dragging and dropping attachments from outlook caused by office update 908 build 11929.29752 to version 2004 build 12730.20250
  • Resolved an issue when opening the invoice credit entry form from document automation where the job details were not set if job costing ran before document automation

Date applied: October 27, 2020