WAP Version 19

WAP is a locally installed web based application designed specifically for real-time integration with Sage 200. Providing data entry and approval processing for business documents including Requisitions, Invoices, Expenses, Timesheets, Holidays, Sales Orders and HR. Approvals can be based on parameters such as nominal code, project/job, user, document type and value. Real-time analysis of committed costs, nominal and project actual costs against budgets.

WAP

Search by different WAP software:


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:

192.0.2

Issues Resolved
Issues Resolved
  • [NFS] Added missing indexes for invoices, proposed payments and approval routes
  • [NFS] Changed the confirm goods received page to check the Sage POP Setting ‘allow processing of unauthorized orders’ and allow receipt if enabled
  • [RB] Improved Cookie management to allow storing data separately for logged in user and delegate user when a user is able to switch delegates
  • [JSV] Fix Expense approval page calculating budgets and slowing the page down when budget tab set to not show
  • [JSV] Fix Expense approval showing budget tab when setting says to hide it
  • [RB] Users will now receive a notification when a holiday request cancellation has been rejected

Date applied: December 11, 2019

192.0.1

Issues Resolved New Features Hot Fix Enhancements Important
Important Info
  • Added [SOPAttachment] field to [SageDatabase] table

New Features
  • [JS] WAP App – Goods received functionality now available

Issues Resolved
  • [RB] Resolved an issue on various reports when a user doesn’t have permission to select the “By Delegates” report filter option, but does have permission to access all delegates where the report would as default return all users.
  • [JSV] Fix Supplier applications and subcontractor orders trying to default the Sage database to one that doesn’t support supplier application approval in WAP
  • [JSV] On project requisition lines, if a default nominal code is loaded, clicking the ‘clear’ button will reload all the nominals
  • [JSV] Fix Service generating errors when saving PDFs with edit protection
  • [JSV] Fix Errors when editing supplier applications with Sub contractor order lines
  • [JSV] Fix sub contractor order lines not calculating the cumulation for measured works when generating a supplier application from an order
  • [JSV] Fix subcontractor order lines not showing phases and stages on the edit order page
  • [JSV] Fix subcontractor order lines allowing save when no job activity specified
  • [JSV] Fixed MRP orders not posting to Sage once fully approved
  • [JSV] Fixed incorrect tax calculation when changing net value on supplier application
  • [JSV] Fixed supplier application asking for exchange rate when editing and submitting a previously entered application
  • [JSV] Fixed supplier application info button trying to show ‘Waiting for’ for documents that are not waiting for anyone
  • [JSV] Fixed supplier application info button trying to display job manager for documents with no job manager
  • [JSV] Fix Time and attendance screen not filtering job costing job headers by job correctly
  • [JSV] Fix multipage PDFs only allowing page one to be shown when viewing from expense entry page
  • [JSV] Added analysis label columns and values to Expense lines and mileage reports
  • [NFS] Fixed customer delivery address encountering an error on sales order return returning to CRM
  • [RB] Resolved an issue with Project Requisitions when attempting to edit the description field of a previously saved line which would not update the description when saving
  • [JSV] Subcontractor orders will only delete new order lines
  • [JSV] Supplier applications allow negative lines

Hot Fix Enhancements
  • [JSV] Added ability to add an attachment to the SOP Detailed report
  • [JSV] Supplier applications now automatically adds negative lines for deductions

Date applied: December 9, 2019

191.0.38

Issues Resolved Hot Fix Enhancements Important
Important Info
  • Added [SOPAttachment] field to [Sagedatabase] table

Issues Resolved
  • [RB] Resolved an issue on Sales orders and Quotes screens where the Print Detail report could not be viewed

Hot Fix Enhancements
  • [JSV] Added ability to add an attachment to the SOP Detailed report

Date applied: December 2, 2019

192.0.0

Issues Resolved New Features Important
Important Info
  • Added ability to specify whether to allow viewing of expenses for other users in the current User’s business unit. This is configured on a system level, but can be overwritten by user type – This change will cause a change in behaviour. Currently all users can see expenses by their business unit. Following this upgrade, this permission needs to be explicitly granted through system or user type settings
  • There are now settings per payment group in the WAP addon for which payment groups get picked up for approval in WAP. These settings will default to off on upgrades and will need to be configured.

New Features
  • Added Order line tab to Supplier applications
  • Add new ‘cumulative’ column to page where subcontractor order is used to generate a supplier application
  • Added ability to apply a user filter to results returned from Goods Received and Invoiced Report
  • Added admin process to add invoice lines with no matching costing
  • The ability to set whether free text entry is allowed for Project requisitions can now be configured per user type
  • Changed location and wording of setting “Hide Free Text Entry” in Display section of Requisition settings to be located in the Functionality section along with “Enable Free Text Entry for Requisitions.
  • Added page size options to Goods Invoiced and Received report
  • Timesheet submission report will not show check boxes for weeks before a user’s employment start date (if set) A tooltip has been added to say “Employee’s start date is after this date”
  • Timesheet submission report to show “N/A” for weeks before user started employment
  • When putting an invoice on hold or taking it off hold, an approval history entry will be generated
  • When putting an invoice on hold or taking an invoice off hold, an popup will be displayed allowing the user to send an email of the status change to a supplier
  • Added budget tab to Expense approval page
  • Added ability to add phases and stages to sub contractor order lines
  • Added the ability to lock timesheet weeks by business unit
  • Moved TOIL setting to ‘Functionality’ and Changed it to read ‘Enable TOIL’
  • Set Toil to disabled by default
  • Subcontractor order will pick up the default job header set in Sage
  • Added the ability to reject individual project requisition lines
  • Added the ability to populate freetext requisition item from a Sicon Catalogue item
  • Added new email favourites popup for requisition print. Emails entered are added to favourites and can be selected in future
  • Added settings to determine whether when budget checking that transactions are outside of the specified period are included in the budget
  • Moved the ‘Enabled Intercompany Features’ setting from the sales order tab to the costing tab
  • The WAP service will now call intercompany to check whether intercompany nominal postings need to be made when approving/posting an invoice or credit.
  • Added setting to escalate approval after a time period has expired.
  • Added ability to specify whether to allow viewing of expenses for other users in the current User’s business unit. This is configured on a system level, but can be overwritten by user type
  • Invoice Supplier selection filter options for hiding “All suppliers” and “Approved Suppliers” will now also be applied on PO Invoice recording
  • Added seperate option to invoice module to Remove ‘All suppliers’ and Remove ‘approved suppliers’ options from supplier filter dropdown
  • Added a new tab to expense approval to show subsistence details
  • FileGuid added to File Table
  • Added setting to hide project requisition description box
  • Added ability to edit notes during approval for Requisitions, Project Requisitions and Timesheets
  • Added the ability to set spare fields on Requisition and Sales Order Entry
  • Add on list page improvements, allow grouping
  • Added Addon Details page to dynamically display AddOn drill down fields
  • Added new setting “Stock Item Preferred Supplier must match Order supplier” If this is enabled, users won’t be able to save a stock item unless the preferred supplier for the stock item matches the order’s supplier
  • Added hotupdate method for requisition delivery dates in the service
  • When Requisition delivery dates changed for posted orders, details stored in a queue table for the service to pick up and update the Sage Order
  • Added ability to flag invoices as Urgent in Sage (WAP Addon)
  • Added settings to automatically print and email requisition on posting to Sage
  • WAP service will now automatically set the WAP Addon WAP Url if is empty
  • Flag read only analysis codes for Requisitions and Salesorders and prevent editing
  • Added Goods Invoiced and Received Quantities Report
  • Allow User nominal account to have line and approval values for different document types
  • Changed the usernominal import to include document type
  • Added document type to approcal route reports (user nominal list etc)
  • Added functionality which will allow for more granular system setting implementations based on Sage Databse, User Type and User.
  • Added ability to set ‘Enable Free Text Entry’ as a setting by Sage Dataase, User Type and User
  • Added ability to set ‘Requisition Supplier Filter’ as a setting by Sage Dataase, User Type and User
  • Replaced setting to Hide supplier stock unit and pricing with a more detailed setting that will allow users to show, hide, enable or disable the controls rather than just show or hide
  • Added ability to set ‘Supplier/Unit Pricing Display’ as a setting by Sage Dataase, User Type and User
  • Added Requisition ‘Enable Item Description Amendment’ as a setting by User Type. The default Value is true
  • Added Project Requisition ‘Enable Item Description Amendment’ as a setting by User Type. The default Value is true
  • Added download urls to mobile app links screens
  • Changed the WAP service to check the new SiconWAPPLProposedPayments table to only pick up suggested payments for payment groups that are enabled
  • Added settings to turn off posting for individual modules, this will update the documents to not require updating which will keep them accessible in WAP.
  • Added code to check for supplier application attachments
  • Allow warehouse to be edited when receiving goods
  • Added additional filters to the job enquiry list
  • Added actual and committed totals for filtered items to the job enquiry page
  • Made the columns resizable on the job enquiry page
  • changed long text not to wrap on the job enquiry page
  • Added ‘Update Database’ button to system page to run the database update scripts
  • Added setting to hide the ‘Confirm as service’ option from Requisitions
  • Added check for WAP database connection before processing – service will stop if the database cannot be accessed
  • Added the abilty to view DMS documents for actual nominal transactions in budget enquiry

Issues Resolved
  • Prevent supplier application amounts from being edited if it has order lines
  • Prevent Orders and project requisitions using application suppliers
  • Fixed sage timesheet lines not loading holiday line ID correctly if generated from holiday request
  • Fixed sage timesheetlines not being removed from the timesheet when related holiday cancelled
  • Resolved an issue that would cause the Expense Item details for Meals and accommodation subsistence to always return the Expense Item details for the default Domestic or Foreign subsistence
  • Fixed Failed WAP documents getting reset to Approved
  • Fixed mandatory holidays not being removed from sage timesheets using reprocess tool or mandatory holiday removal tool
  • Fixed mandatory holiday list not updating when new holiday added or deleted
  • Fixed timesheet holiday request lines not being set correctly for sicontimesheets
  • Fixed timesheet holiday request lines not being removed when holiday cancelled
  • Fixed job costing revenue headers showing in the selection tree for timesheets. They are already removed from the dropdown list
  • Show Sage document information on Sales order returns and quotes if submittable
  • Fix Invoice approval by document checking the gross value instead of the net value
  • Fix error when adding user nominal account with no document type selected
  • Fix invoice approval page showing line number as editable when editing the line
  • Resolved an issue on Sales orders and Quotes screens where the Print Detail report could not be viewed
  • Resolved an issue where Setting the Sales Order Date to no automatically populate the date would still populate the Order Date
  • Resolved an issue with sales orders where validation would fail due to a missing delivery date for any Sales Order type other than Sales Orders e.g. Quotes when the system setting to automatically populate delivery date is disabled
  • Dashboard notifications will now clarify the Sales Order Type e.g. Sales Order, Quote, Sales Return rather than just displaying “SalesOrder”
  • Removed paging from User Type Allocation Page. All allocated user types will now be visible
  • Credit Card Statement imports using the Default WAP import template will no longer validate the Additional Notes field as a required field
  • Removed duplicate Hide ‘Nominal Account’ from Stock Line Entry setting from requisition settings page
  • Corrected various Sales Order/Quote/Sales Return related pages where the Sales Order type would not be displayed consistently, leading to accidental creation of incorrect sales order types or being navigated to incorrect existing document or approval pages
  • Resolved an issue when clicking a Project Requisition awaiting approval notification on the dashboard which would direct you to the existing Project Requisition rather than the approval screen
  • Fixed an issue with navigation menu where the SOP Return menu header would still be visible even when there are no items contained in the section
  • Fixed an issue on Requisition Stock Entry where the stock warehouse would automatically be selected for a user from the Stock ite warehouse, despite the user not having the warehouse allocated
  • Fixed the error message displayed when a user does not have permission to change warehouses on a stock item and the stock item’s default warehouse is not allocated to the user to clarify during validation that the line can not be saved due to a permissions issue rather than that no warehouse has been selected
  • Fixed approval escalation not working for timesheets and proposed payments
  • Added approval history entry when an item can’t be escalated because an approver does not have enough approval value
  • Fixed error in the service ‘Could not load file or assembly App_GlobalResources’
  • Fixed user nominal wizard not updating cache when adding/removing nominals
  • Fixed user nominal wizard deleting all nominal entries when a document type selected
  • Fixed user selection control not filtering by user roles
  • Fixed Loginactivity not being hidden when editing a Sage timesheet and the setting is set to hide it
  • Fixed error when checking for Sicon timesheets for approval on dashboard page
  • Fixed Sage timesheet reports erroring when database name has an apostophe in
  • Fixed editing timesheetlines on approval showing editing controls for non editable fields
  • Fixed an issue where costing dropdown was not populating first time in when editing a timesheet line during approval
  • Resolved an issue on Requisition Stock Entry where the unit price would be reset to zero when changing the buying and pricing units or the line discount
  • Resolved an issue when WebAPI is configured and displaying Stock Item Images is enabled that would cause the page to become unresponsive for long periods after selecting a second stock item on the page when WAP is unable to reach the WebAPI service
  • Resolved an issue on various reports where users with “Access All Delegates” permission wouldn’t be able to view records from Delegates unless they were also allocated though the Delegate allocation screen
  • Fixed Order Approval report displaying “Goods Received History Report” as report heading
  • Resolved an issue on Goods Received history where Records were not restricted to Sage Databases the user has access to
  • Resolved an issue on Goods Received and Invoiced report where Records were not restricted to Sage Databases the user has access to
  • Goods Received and Goods Receipt Amendment screens will no longer display order lines that do not require confirmation
  • Fix invoice approval showing “N/A” in the Phases column when Phases are not enabled in Job costing settings
  • added handing for provider: TCP Provider, error: 0 – The semaphore timeout period has expired.) errors in the data tier
  • Fixed timesheet line approval not showing phases/stages column if sage is setup to only use activities
  • Resolved an issue with failed invoice and expense postings due to a Sage bug when the Tax rate of the first item being processed is 0%
  • Addressed an issue with Invoice posting when recording PO Invoices in Sage against Requisitions raised in WAP when DMS is enabled and WAP is configured to automatially approve matching invoices, which could potentially lead to a duplicate nominal analysis entry on the completed invoice
  • Fixed phases and stages selection not appearing when editing an existing item first time in (was loading for subsequent edits)
  • Changed sub contractor order messages to be warnings rather than errors when required fields missing on save
  • Fix invoices entered in WAP not posting job costing information through to Sage if not linked to a PO
  • Resolved issue on Goods Invoiced and Received report which would only allow for details from a single database to be returned, no matter whether a company was selected or which company was selected to filter by
  • Requisition import validation will no longer fail if budget checks fail. Over budget requisitions will be created, but will not be submitted, even if the option to submit is enabled
  • Requisition import validation will no longer fail if order justifications are required. Requisitions will be created, but will not be submitted, even if the option to submit is enabled
  • Added document types to nominal wizard and ‘Nominal Accounts’ pages
  • Added information text to user nominal selection pages
  • Resolved an issue with the approval route import template where there was a mismatch between the document type description for an Absense and the required document type to be entered’ Users can now enter Absence as a document type
  • Fix SOPReturn expanding the wrong menu group page load
  • Fix SOPReturn view returning to sales order page/list when closing
  • Fix Dashboard loading sales order approval page for SOPreturns
  • Fix goods reveived history report not showint the document number by default
  • Value and percentage variance checking is now always enabled if the overall variance setting is enabled
  • Resolved an issue where the setting the “Hide Free Text Entry” on project requisitions would not hide the Free Text Entry button on Project requisition entry if the user is configured to allow Item description amendment
  • Resolved an issue on various pages that require checking for Stock Filter mode and Supplier Pricing Visibility that would cause en invalid cast exception
  • Default spare fields view to collapsed for requisitions etc
  • Fix supplier nominal acccout selection visibility being linked to customer creation settings
  • Fixed expense lines not saving/processing job costing phases/stages/activities
  • Resolved an issue on various document types where rejecting the only item on the document would cause any lines added while the document still has a status of rejected to have a line number of 0
  • Resolved an issue with failed invoice and expense postings due to a Sage bug when the Tax rate of the first item being processed is 0% – The error reported by Sage is “The nominal analysis total does not match transaction net value.”
  • Fixed an issue in the requisition process that could cause MRP orders to have the update status reset before they were cancelled in Sage
  • fixed an issue where supplier contract details were not being set on the order for MRP orders
  • Fix unpaid holiday not picking up the correct default project when adding timesheet record
  • Fix automated email process failing to generate PDF correctly
  • Fix budget drill down not showing for expense project budget
  • Resolved an issue with Mileage entry where a user type with permission to view all vehicles would be unable to view vehicles not allocated to them
  • Clear unsubmitted timesheet notification for user when timesheet is submitted
  • Check if stockitemnominal code is not null when fetching (sales order errors)
  • Added ‘clear’ button to sales order stock item batch line entry nominal control
  • Fixed filtering on sales order stock item batch line entry nominal control
  • Fixed site not loading if auto login enabled and any Sage database login details incorrect
  • Fix Analysis codes not synchronising between Sales order Header and delivery tab if setting on to show the top 2 analysis codes on the header
  • Fix analysis codes not loading on Sales order header
  • Fix sicon catalogue item not setting buying unit description when adding to order free text line
  • Fix document type reminders not always emailing to users. Now checks user roles for each usertype the user is part of.
  • Added check for deleted jobs when converting subcontractor order to supplier application
  • New supplier request will now restrict the nominal account list to nominals the user is allowed to select.
  • Fixed holiday not always being flagged as an extension
  • Approval Route Import will no longer attempt to validate Sage Database when the specified document type is Absence
  • Resolved an issue with Requisition Stock item import where a validation error would be encountered if no nominal details are specified, but a job and ost header with a default nominal has been specified. The validation would indicate that no nominal was entered
  • Resolved an issue with Requisition Stock Item import when a Warehouse is specified where the import wouldn’t be able to identify the supplied warehouse for the specified stock item
  • Fix project requisitions showing as approved when one or more lines are rejected
  • Fix project requisition approval showing wrong captions for qty and unit price columns
  • Attachments will now be deleted when an invoice or expense is deleted
  • Fixed an issue in the invoice process where invoices would be deleted and picked up again if there were not valid nominal accounts this would cause it to check for attachments for each invoice which lead to the same attachments being downloaded multiple times
  • Fix email ‘to’ address not allowing multiple addresses
  • Fix error that occurs when updating the database from the button on the system update page which then runs the auto update routine that relies on a setting that was just added. Settings are reloaded before returning to the login page.
  • Fix email not sending to multiple email addresses, can be separated with a ‘;’ character
  • Removed some of the setup steps with the initial setup wizard that are no longer required
  • Resolved an issue on Approval route single route entry where the selected nominal would not be correctly set, causing users to be unable to create new or edit existing routes
  • Fixed error messages in the service when a duplicate deleted Sage database has the same name as a current database
  • Fix error with spare number fields when creating new requisition/sales order
  • Fix project requisition notes field error when adding over 155 characters
  • Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line
  • Resolved an issue with Order entry where an arithmetic overflow SQL exception would be encountered when attempting to add a new line when spare fields are not enabled
  • resolved an issue on the subsistence entry control where a subsistence start time could be entered that was after the subsistence end time
  • Project requisition notes field no longer restricted in length
  • Resolved an issue on timesheet approval page where notes entered by the requesting user and notes updated by the approver would not be displayed or saved
  • Fix DBUpdate script erroring with collation errors when trying to create settings stored procedures
  • Fixed approving project accounting orders taking a long time (up to 1hr) to expand lines when budgeting on with complex project structure and lots of orderlines
  • Added additional handling for index out of range errors on timesheet approval
  • (App) Found two bugs in the mileage line validation which was removing the Project item ID from a mileage line, now using the MileageSplitValueInstrumentV2 to validate the line and sometimes the PRDocStatus was null which seems to be impossible but added a check just in case.
  • Resolved an issue when initial setup wizard is run which would cause the setup wizard to be continually rerun rather than logging into WAP
  • Resolved an issue on User Nominal Allocation import page where the option to maintain existing allocations would be unchecked for some WAP themes when the page is loaded
  • Resolved an issue with Approval Route editing on invoice line where newly added users in the approval route would use their approval value for document type “None” rather than “invoice”
  • Resolved an issue on expense line entry where a user would be unable to select a credit card when the user has multiple credit cards allocated and there is no default configured
  • Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line when the system is configured to not allow business mileage entry, but use mileage amendment instead and a user selects the mileage box, but does not enter a value
  • Resolved an issue when upgrading from version 17 of WAP to a later version which would cause all orders entered before the date of the upgrade to not appear on the goods received screen
  • Updated initially configured Fuel Rates to bring it in line with the latest HMRC advisory rates
  • Resolved an issue on Sales Order Line Free text entry where users would be unable to specify numeric values to more than 2 decimal places. All numeric fields now allow more than 2 decimal places
  • Resolved an issue when saving a Sales Order Free Text line which would encounter a Not Implemented Exception
  • Limited New Supplier Request Postcode text length to a maximum of 10 characters in line with the maximum field size allowed by Sage
  • User starting holiday import will now include a line number of the erroring line when the import encounters validation issues
  • Resolved an issue on Timesheet Totals report which would encounter a SQL exception if there is a Sage database configured with an apostrophe (‘) in the description field
  • changed the TA book on job control to allow booking onto operations with zero quantity.
  • Fixed an issue when turning on out of office where the out of office approval route entries dont have the Sage database Id set
  • Fixed an issue on the expense approval page where it was using the line number from the invoice line table rather than the expense line/mileage table
  • Fix subcontractor nominal account not changing to job header default
  • Allow Supplier application self approval when generated from Subcontractor order
  • Allow WAP User time and attendance settings to be visible when using construction module when not using timesheets
  • Fix supplier application notification emails getting cleared before being sent
  • fixed an issue on sales order entry where there was a sql deadlock issue
  • Changed all file, image and PDF handlers to validate a user is authenticated before serving data. All handers now take a unique file GUID rather than simple file paths
  • Fix multipage pdfs throwing an error when trying to view subsequent pages when approving an invoice
  • Fixed freetext order line asking for nominal account when one is selected when costing module set to ‘None’ supplier with no default selected
  • WAPUser is given write permission to Sage databases on setup (required for Sicon timesheets etc)
  • Allow login line start and end time to be set to 00:00
  • Fixed an issue on timesheet approval where an error would be displayed if the rows are grouped and approve or reject all in group was clicked
  • changed the data tier to pass the inner exception for SQL errors when rethrowing a SQL configuration exception rather than hiding it
  • Renamed event log sources to WAP Service and WAP Web App
  • The size of the event log will now increase to 250MB automatically
  • Added better logging in the Datatier class to show stack trace information when an error occurs there
  • Resolved an issue with Expense Line CSV import where incorrectly validation would fail due to duplicate cost headers.  This error would occur if the costing module is Job Costing/Project accounting, the user doesn’t have access to all Cost Headers/Project Items, but does have access to multiple Cost Headers/Project Items
  • Resolved an issue on Timesheet entry when Jobcosting is configured to automatically set cost header from cost rate which would cause Timesheet Lines to be saved without a Job Manager
  • Resolved an issue on Timesheet Totals reportwhere the user would encounter an “Unable to cast object” exception when attempting to view a timesheet
  • Fixed construction valuation being posted with no nominal account net value
  • Removed warning when closing construction sub contractor order
  • Fixed unprocessed job costing timesheetline hours method posting authorised hours to committed
  • Changed the goods received page to not allow selecting a future date for the receipt
  • Fixed freetext order line asking for nominal account when one is selected when costing module set to ‘None’
  • Resolved an issue in the WAP service which would cause oorder lines in WAP to retain their original values and quantities if they were completely removed in Sage through a process such as writing off incomplete orders.
  • Addressed an issue where a user would be able to allocate and validate stock items against a supplier while adding a stock item, but then subsequantly be able to change the selected supplier on the order header.
  • Fixed sub contractor order line not updating the nominal account selection when changing the job header
  • Resolved an issue on various report export pages where users would be unable to convert text to decimal values for use in calculations
  • Removed the print buttons from PO Detail and WO summary reports when using Chrome. Chrome does not execute the commands from these buttons, but does not notifiy the user, which gives the appearance that the report is not working. Chrome users will need to use the open to new page button instead
  • Fix expense line not deleting attachment when deleting the line
  • Subsistence Expense Types will no longer be displayed on expense type maintenance screens if the system isn’t configured to allow subsistence claims
  • Resolved issues with Requisition Import template
  • Fix invoice approval only Usertype not being selectable for global default route
  • Fix Construction Sub contractor order not showing phases and stages
  • Fix Construction Sub contractor order not retaining default job header when adding rows
  • Fix job and item control showing tree button when set to not show
  • Addressed an issue where the WAP service would occasionally encounter a timeout issue while reading invoice data from WAP
  • Resolved an issue with requisition analysis settings where users would be unable to change the mandatory analysis validation behaviour
  • Resolved an issue with approval notifications when notifcations are configured by Document Item, where the approval notification would always state that the item was approved by ‘yourself’
  • Fix Sales order analysis code read only check returning wrong value
  • Fix Rejected invoices that have been sent to a custom approval route not being shown in the Rejected tab
  • Added Setting to default Sales order delivery date(s)
  • Added new default holiday project type for Bank holiday and Mandatory holiday
  • Fixed mandatory holiday tool and bank holiday tool erroring when using Sage timesheets
  • Fixed an issue on nominal budget enquiry and job costing budget enquiry where the DMS document could not be accessed due to a change in browser security
  • Fix allowance lines being included in the hours totals for Sicon Sage timesheets
  • show allowance lines with different colour background for Sicon Sage timesheet page
  • WAP Service will now check if POP/SOP Analysis codes can be amended before updating from Order/SalesOrder
  • Resolved an issue where performing a final receipt for a quantity of zero would not update the WAP order to be completed
  • Resolved an issue on Requisition Stock entry which would cause a Javascript error when Supplier units and pricing is configured to be hidden for the current User Type
  • Fixed an issue in the existing requisitions screen where clicking the requisitions raised by my business unit quick link would throw and error.
  • Added some additional code to the invoice process to check whether any invoices references or dates have been updated in Sage after the invoice was picked up and update them in WAP if they have
  • Resolved an issue onVarious Requisition Related pages where the Unit and pricing details would be displayed despite the user type permission not allowing
  • Resolved an issue on Requisition Stock entry when a user type is configured to hide unit pricing, which would allow users to still affect unit prices by changing the Buying unit and buying price unit fields
  • Fixed Sales order menu group still appearing when user has no sales order permissions
  • Fixed new stock item requests not setting the default supplier correctly
  • Resolved an issue on Expense Approval report where the Payment Method column would not be visible
  • Resolved an issue on Expense approval page where the disaplyed exchange rate in currencies view would display the Expense supplier’s exchange rate compared to base rather than the exchange rate for the line
  • Resolved an issue in the service where job costing employees were read once then cached and never checked again, this meant new employees added would not get picked up by the service.
  • Fix Sage Timesheet line status not always reading correctly
  • Fix current timesheets page showing duplicate timesheets
  • Fix Hot update method in service setting timesheetline status incorrectly
  • Resolved an issue with approval route creation when a user returns from being out of office where out of office rules would still be applied to approval route creating for a time after turning off Out of Office.
  • Fixed an issue in the approval route wizard page where job header only routes could not be created as a job could not be selected beforehand
  • Fixed an issue in the approval route import page where job header routes only could not be imported
  • Added additional handing for index out of range exceptions in perform dataselect events on the budget enquiry
  • Renamed more instances of ‘Proposed Payments’ to ‘Suggested Payments’
  • Fix Sicon Sage timesheets picking up lots of old records to process missing transactions – limited process to 6 months old
  • Fix the wrong page being loaded when clicking on the timesheets hyperlink on the dashboard when sicon sage timesheet are being used
  • Fixed the Sage connection edit page not loading the SOPQuote email address and body details
  • Fix Sage timesheet line hours lookup generating an error
  • Changed the approval route builder to not allow ‘requester’ type entries on expenses, holiday requests, or invoice variance routes.
  • Fix Sage timesheets failing when processing deleted timesheet line hours
  • Fix timesheet line not setting start and end times for decimal only entry when using sicon sage timesheets. The App needs these set to pick up the data correctly
  • Changed the job enquiry list to support ‘contains’ filtering
  • Change the Goods received history report title to read correctly
  • Add PO Number to Goods received history report
  • WAP App – Updated the upload holiday request method to define the sync item type as app was not uploading holiday correctly.
  • Allow sales order service items to be despatched even though they can’t be allocated
  • Changed the approval route builder to not allow ‘requester’ type entries on expenses, holiday requests, or invoice variance routes.
  • Fix Sage timesheets failing when processing deleted timesheet line hours
  • Fix timesheet line not setting start and end times for decimal only entry when using sicon sage timesheets. The App needs these set to pick up the data correctly
  • Changed the job enquiry list to support ‘contains’ filtering
  • Change the Goods received history report title to read correctly
  • Add PO Number to Goods received history report
  • WAP App – Updated the upload holiday request method to define the sync item type as app was not uploading holiday correctly.
  • Allow sales order service items to be despatched even though they can’t be allocated
  • Show “N/A” for quantity allocated on sales order service item lines
  • Flag up when selecting Job costing job with Phases/stages but no activity
  • Fixed job costing Activity name not showing on costing selection summary
  • Prevent Job costing Phase and stage from being selected (activity only)
  • Changed job costing phases/stages selection header to read ‘Select Job Activity’
  • Addressed an issue encountered with timesheets when upgrading from a version of WAP earlier than 19 to a version 19 or later, which would lead to newly approved timesheets failing to post due to invalid timesheet status on some older timesheets
  • Added additional handling to WAP service start up for when the sage admin service cant be connected to when checking the WAP licence
  • Resolved an issue in the install update script that would cause the installer to fail due to a SQL issue during initial install
  • Fixed issue with project accounting where bringing invoices across for approval wouldn’t always contain the project and item information
  • Fixed a display issue on Timesheet entry page where Pay Rate totals would incorrectly add 24 hours to the day’s total if there is an entry with an end time of midnight and timesheet entry format is start and end time

Date applied: November 29, 2019

192.0.0 – WAP Addon

Issues Resolved New Features Important
Important Info
  • Upgrading to this version requires an upgrade to 19.2 for WAP

New Features
  • Changed the WAP addon to validate all nominals are valid on invoice entry based on whether there is a nominal account reference
  • Changed the WAP addon to validate all nominals are valid on invoice entry based on the Sage IsValid property on the nominal analysis item
  • Added ability to flag invoices as Urgent during the invoice entry process in Sage 200
  • Added the ability to control whether suggested payments are sent to WAP for approval based on payment group

Issues Resolved
  • Resolved an issue when updating Sage 200C to Winter 2018 enhancement that would cause a missing method exception when posting Self reversing journals
  • Changed the WAP addon to check the overall variation checking setting in WAP so it can be disabled completely on the Sage 200 side if not enabled in WAP.
  • Resolved an issue which would cause order lines in WAP to retain their original values and quantities if they were completely removed by writing off incomplete orders. This in turn would cause Orders to also display incorrect totals and not be marked as completed
  • Resolved an issue with Generated payments where payments allocated directly from payment processing would not be reflected as paid in WAP

Date applied: November 29, 2019

191.0.37

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [JSV] Fixed Timesheet line approval not showing phases/stages column if sage is setup to only use activities
  • [RB] Resolved an issue with failed expense postings due to a Sage bug when the Tax rate of the first item being processed is 0%
    • The error reported by Sage is “The nominal analysis total does not match transaction net value.”
    • This was previously resolved for Project Accounting, but has now been implemented for all costing modules
  • [NFS] Added handing for provider: TCP Provider, error: 0 – The semaphore timeout period has expired.) errors in the data tier
  • [JSV] Fix invoice approval showing “N/A” in the Phases column when Phases are not enabled in Job costing settings

Hot Fix Enhancements
  • Added admin process to add invoice lines with no matching costing

Date applied: November 20, 2019

191.0.36

Issues Resolved
Issues Resolved
  • [RB] Resolved an issue with the approval route import template where there was a mismatch between the document type description for an Absence and the required document type to be entered. Users can now enter Absence as a document type
  • [JSV] Fix invoices entered in WAP not posting job costing information through to Sage if not linked to a PO
  • [JSV] Fixed phases and stages selection not appearing when editing an existing item first time in (was loading for subsequent edits)
  • [JSV] Changed sub contractor order messages to be warnings rather than errors when required fields missing on save
  • [RB] Addressed an issue with Invoice posting when recording PO Invoices in Sage against Requisitions raised in WAP when DMS is enabled and WAP is configured to automatically approve matching invoices, which could potentially lead to a duplicate nominal analysis entry on the completed invoice

Date applied: November 18, 2019

191.11.0

Issues Resolved New Features Hot Fix Enhancements
New Features
  • [RB] When putting an invoice on hold or taking it off hold, an approval history entry will now be generated
  • [RB] When putting an invoice on hold or taking an invoice off hold, a popup will be displayed allowing the user to send an email of the status change to a supplier
  • [RB] The ability to set whether free text entry is allowed for Project requisitions can now be configured per user type

Issues Resolved
  • [JSV] Clear unsubmitted timesheet notification for user when timesheet is submitted
  • [JSV] Check if stockitemnominal code is not null when fetching (sales order errors)
  • [JSV] Added ‘clear’ button to sales order stock item batch line entry nominal control
  • [JSV] Fixed filtering on sales order stock item batch line entry nominal control
  • [JSV] Fixed site not loading if auto login enabled and any Sage database login details incorrect
  • [JSV] Fix Analysis codes not synchronising between Sales order Header and delivery tab if setting on to show the top 2 analysis codes on the header
  • [JSV] Fix analysis codes not loading on Sales order header
  • [RB] Resolved an issue with Mileage entry where a user type with permission to view all vehicles would be unable to view vehicles not allocated to them
  • [JSV] Fix automated email process failing to generate PDF correctly
  • [JSV] Fix budget drill down not showing for expense project budget
  • [JSV] Fix unpaid holiday not picking up the correct default project when adding timesheet record
  • [NFS] Fixed an issue in the requisition process that could cause MRP orders to have the update status reset before they were cancelled in Sage
  • [NFS] Fixed an issue where supplier contract details were not being set on the order for MRP orders
  • [RB] Resolved an issue with failed invoice and expense postings due to a Sage bug when the Tax rate of the first item being processed is 0%.  The error reported by Sage is “The nominal analysis total does not match transaction net value.”
  • [RB] Resolved an issue on various document types where rejecting the only item on the document would cause any lines added while the document still has a status of rejected to have a line number of 0
  • [RB] Added page size options to Goods Invoiced and Received report
  • [JSV] Fixed expense lines not saving/processing job costing phases/stages/activities
  • [JSV] Default spare fields view to collapsed for requisitions etc
  • [JSV] Fix supplier nominal account selection visibility being linked to customer creation settings
  • [RB] Resolved an issue on various pages that require checking for Stock Filter mode and Supplier Pricing Visibility that would cause en invalid cast exception
  • [RB] Resolved an issue where the setting the “Hide Free Text Entry” on project requisitions would not hide the Free Text Entry button on Project requisition entry if the user is configured to allow Item description amendment
  • [RB] Changed location and wording of setting “Hide Free Text Entry” in Display section of Requisition settings to be located in the Functionality section along with “Enable Free Text Entry” for Requisitions.  The setting description now also states “Enable Free Text Entry (Project Requisitions)” for consistency
  • [NFS] Value and percentage variance checking is now always enabled if the overall variance setting is enabled
  • [JSV] Fix SOP Return expanding the wrong menu group page load
  • [JSV] Fix SOP Return view returning to sales order page/list when closing
  • [JSV] Fix Dashboard loading sales order approval page for SOP Returns
  • [JSV] Fix goods received history report not showing the document number by default

Hot Fix Enhancements
  • [JSV] Added budget tab to Expense approval page
  • [JSV] Timesheet submission report will not show checkboxes for weeks before a user’s employment start date (if set) A tooltip has been added to say “Employee’s start date is after this date”
  • [JSV] Timesheet submission report to show “N/A” for weeks before user started employment

Date applied: November 15, 2019

191.0.35

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [NFS] Value and percentage variance checking is now always enabled if the overall variance setting is enabled
  • [JSV] Fix document type reminders not always emailing to users. Now checks user roles for each user type the user is part of
  • [JSV] Added check for deleted jobs when converting subcontractor order to supplier application
  • [JSV] New supplier request will now restrict the nominal account list to nominals the user is allowed to select
  • [JSV] Fixed holiday not always being flagged as an extension
  • [JSV] Fix budget drill down not showing for expense project budget
  • [NFS] Fixed an issue in the requisition process that could cause MRP orders to have the update status reset before they were cancelled in Sage
  • [NFS] Fixed an issue where supplier contract details were not being set on the order for MRP orders
  • [RB] Resolved an issue with failed invoice and expense postings due to a Sage bug when the Tax rate of the first item being processed is 0%
    • The error reported by Sage is “The nominal analysis total does not match transaction net value
  • [JSV] Fixed expense lines not saving/processing job costing phases/stages/activities
  • [RB] Resolved an issue on various document types where rejecting the only item on the document would cause any lines added while the document still has a status of rejected to have a line number of 0
  • [DK] Fixed an issue with the WAP installer which prevented the update script from being executed in the event that a login with the handle WAPUser existed, but a DB user of the same name did not

 


Hot Fix Enhancements
  • Timesheet submission report will not show checkboxes for weeks before a user’s employment start date (if set) A tooltip has been added to say “Employee’s start date is after this date”
  • Timesheet submission report to show “N/A” for weeks before user started employment

Date applied: November 15, 2019

19.0.33

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [NFS] Fixed an issue in the invoice process where invoices would be deleted and picked up again if there were not valid nominal accounts.  This would cause it to check for attachments for each invoice which lead to the same attachments being downloaded multiple times
  • [NFS] Attachments will now be deleted when an invoice or expense is deleted
  • [NFS] Fixed an issue in the requisition process that could cause MRP orders to have the update status reset before they were cancelled in Sage
  • [NFS] Fixed an issue where supplier contract details were not being set on the order for MRP orders

Hot Fix Enhancements
  • [JSV] Timesheet submission report will not show checkboxes for weeks before a user’s employment start date (if set). A tooltip has been added to say “Employee’s start date is after this date”
  • [JSV] Timesheet submission report to show “N/A” for weeks before user started employment

Date applied: November 13, 2019

191.10.0

Issues Resolved New Features Hot Fix Enhancements
New Features
  • [JSV] Added ability to add phases and stages to sub contractor order lines
  • [JSV] Added the ability to lock timesheet weeks by business unit
  • [JSV] Added the ability to populate freetext requisition item from a Sicon Catalogue item
  • [JSV] Addded new email favourites popup for requisition print. Emails entered are added to favourites and can be selected in future
  • [RB] Removed some of the setup steps with the initial setup wizard that are no longer required

Issues Resolved
  • [JSV] Fix document type reminders not always emailing to users. Now checks user roles for each usertype the user is part of.
  • [JSV] Added check for deleted jobs when converting subcontractor order to supplier application
  • [JSV] New supplier request will now restrict the nominal account list to nominals the user is allowed to select.
  • [JSV] Fixed holiday not always being flagged as an extension
  • [RB] Approval Route Import will no longer attempt to validate Sage Database when the specified document type is Absence
  • [RB] Resolved an issue with Requisition Stock item import where a validation error would be encountered if no nominal details are specified, but a job and ost header with a default nominal has been specified. The validation would indicate that no nominal was entered
  • [RB] Resolved an issue with Requisition Stock Item import when a Warehouse is specified where the import wouldn’t be able to identify the supplied warehouse for the specified stock item
  • [JSV] Fix project requisitions showing as approved when one or more lines are rejected
  • [JSV] Fix project requisition approval showing wrong captions for qty and unit price columns
  • [NFS] Attachments will now be deleted when an invoice or expense is deleted
  • [NFS] Fixed an issue in the invoice process where invoices would be deleted and picked up again if there were not valid nominal accounts. This would cause it to check for attachments for each invoice which lead to the same attachments being downloaded multiple times
  • [JSV] Fix email ‘to’ address not allowing multiple addresses
  • [JSV] Fix error that occurs when updating the database from the button on the system update page which then runs the auto update routine that relies on a setting that was just added. Settings are reloaded before returning to the login page.
  • [JSV] Fix email not sending to multiple email addresses, can be separated with a ‘;’ character
  • [RB] Resolved an issue on Approval route single route entry where the selected nominal would not be correctly set, causing users to be unable to create new or edit existing routes
  • [NFS] The WAP service will now call intercompany to check whether intercompany nominal postings need to be made when approving/posting an invoice or credit.

Hot Fix Enhancements
  • [JSV] Moved TOIL setting to ‘Functionality’ and Changed it to read ‘Enable TOIL’
  • [JSV] Set Toil to disabled by default
  • [JSV] Subcontractor order will pick up the default job header set in Sage
  • [JSV] Added the ability to reject individual project requisition lines
  • [NFS] Added settings to determine whether when budget checking that transactions are outside of the specified period are included in the budget
  • [NFS] Moved the ‘Enabled Intercompany Features’ setting from the sales order tab to the costing tab

Date applied: November 12, 2019

191.9.0

Issues Resolved New Features Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


Important Info
  • [RB] Ability to specify whether to allow viewing of expenses for other users in the current User’s business unit…
    This change will cause a change in behaviour. Currently all users can see expenses by their business unit. Following this upgrade, this permission needs to be explicitly granted through system or usertype settings

New Features
  • [JSV] Added setting to escalate approval after a time period has expired.
  • [RB] Added ability to specify whether to alow viewing of expenses for other users in the current User’s business unit. This is configured on a system level, but can be overwritten by user type
  • [RB] Invoice Supplier selection filter options for hiding “All suppliers” and “Approved Suppliers” will now also be applied on PO Invoice recording

Issues Resolved
  • [JSV] Fixed error messages in the service when a duplicate deleted Sage database has the same name as a current database
  • [JSV] Fix error with spare number fields when creating new requisition/sales order
  • [JSV] Fix project requisition notes field error when adding over 155 characters
  • [RB] Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line
  • [RB] Resolved an issue with Order entry where an arithmetic overflow SQL exception would be encountered when attempting to add a new line when spare fields are not enabled
  • [NFS] resolved an issue on the subsistence entry control where a substistence start time could be entered that was after the subsistence end time
  • [JSV] Project requisition notes field no longer restricted in length
  • [RB] Resolved an issue on timesheet approval page where notes entered by the requesting user and notes updated by the approver would not be displayed or saved
  • [JSV] Fix DBUpdate script erroring with collation errors when trying to create settings stored procedures
  • [JSV] Fixed approving project accounting orders taking a long time (up to 1hr) to expand lines when budgetting on with complex project structure and lots of orderlines
  • [NFS] Added additional handling for index out of range errors on timesheet approval
  • [JS] (App) Found two bugs in the mileage line validation which was removing the Project item ID from a mileage line, now using the MileageSplitValueInstrumentV2 to validate the line and sometimes the PRDocStatus was null which seems to be impossible but added a check just incase.
  • [RB] Resolved an issue when initial setup wizard is run which would cause the setup wizard to be continually rerun rather than logging into WAP
  • [RB] Resolved an issue on User Nominal Allocation import page where the option to maintain existing allocations would be unchecked for some WAP themes when the page is loaded
  • [RB] Resolved an issue with Approval Route editing on invoice line where newly added users in the approval route would use their approval value for document type “None” rather than “invoice”
  • [RB] Resolved an issue on expense line entry where a user would be unable to select a credit card when the user has multiple credit cards allocated and there is no default configured

Date applied: November 12, 2019

191.8.0

Issues Resolved New Features Pre-release Hot Fix Enhancements

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


New Features
  • [RB] Added separate option to invoice module to Remove ‘All suppliers’ and Remove ‘approved suppliers’ options from supplier filter dropdown
  • [RB] Added ability to edit notes during approval for Requisitions, Project Requisitions and Timesheets
  • [NFS] Added the ability to set spare fields on Requisition and Sales Order Entry
  • [JSV] Added Addon Details page to dynamically display AddOn drill down fields
  • [RB] Added new setting “Stock Item Preferred Supplier must match Order supplier” If this is enabled, users won’t be able to save a stock item unless the preferred supplier for the stock item matches the order’s supplier. By default this is false
  • [JSV] When Requisition delivery dates changed for posted orders, details stored in a queue table for the service to pick up and update the Sage Order
  • [RB] Added ability to flag invoices as Urgent in Sage (WAP Addon)
  • [JSV] Added settings to automatically print and email requisition on posting to Sage
  • [RB] Added Goods Invoiced and Received Quantities Report
  • [JSV] Added new default holiday project type for Bank holiday and Mandatory holiday

Issues Resolved
  • [RB] Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line when the system is configured to not allow business mileage entry, but use mileage amendment instead and a user selects the mileage box, but does not enter a value
  • [RB] Resolved an issue when upgrading from version 17 of WAP to a later version which would cause all orders entered before the date of the upgrade to not appear on the goods received screen
  • [RB] Updated initially configured Fuel Rates to bring it in line with the latest HMRC advisory rates
  • [RB] Resolved an issue on Sales Order Line Free text entry where users would be unable to specify numeric values to more than 2 decimal places. All numeric fields now allow more than 2 decimal places
  • [RB] Resolved an issue when saving a Sles Order Free Text line which would encounter a Not Implemented Exception
  • [RB] Limited New Supplier Request Postcode text length to a maximum of 10 characters in line with the maximum field size allowed by Sage
  • [RB] User starting holiday imprt will now include a line number of the erroring line when the imprt encounters validation issues
  • [RB] Resolved an issue on Timesheet Totals report which would encounter a SQL exception if there is a Sage database configured with an apostrophe (‘) in the description field
  • [NFS] changed the TA book on job control to allow booking onto operations with zero quantity.
  • [NFS] Fixed an issue when turning on out of office where the out of office approval route entries dont have the Sage database Id set
  • [NFS] Fixed an issue on the expense approval page where it was using the line number from the invoice line table rather than the expenseline/mileage table
  • [JSV] Fix subcontractor nominal account not changing to job header default
  • [JSV] Allow Supplier application self approval when generated from Subcontractor order
  • [JSV] Allow WAP User time and attendance settings to be visible when using construction module when not using timesheets
  • [JSV] Fix sipplier application notification emails getting cleared before being sent
  • [NFS] fixed an issue on sales order entry where there was a sql deadlock issue
  • [NFS] FileGuid added to File Table
  • [NFS] Changed all file, image and PDF handlers to validate a user is authenticated before serving data. All handers now take a unique file GUID rather than simple file paths
  • [JSV] Fix multipage pdfs throwing an error when trying to view subsequent pages when approving an invoice
  • [JSV] Fixed freetext order line asking for nominal account when one is selected when costing module set to ‘None’ supplier with no default selected
  • [JSV] WAPUser is given write permission to Sage databases on setup (required for Sicn timesheets etc)
  • [JSV] Allow login line start and end time to be set to 00:00
  • [JSV] Fixed an issue on timesheet approval where an error would be displayed if the rows are grouped and approve or reject all in group was clicked
  • [NFS] changed the data tier to pass the inner exception for SQL errors when retrowing a SQL configuration exception rather than hiding it
  • [NFS] Renamed event log sources to WAP Service and WAP Web App
  • [NFS] The size of the event log will now increase to 250MB automatically
  • [NFS] Added better logging in the Datatier class to show stack trace information when an error occurs there
  • [RB] Resolved an issue with Expense Line CSV import where incorrectly validation would fail due to duplicate cost headers. This error would occur if the costing module is Job Costing/Project accounting, the user doesn’t have access to all Cost Headers/Project Items, but does have access to multiple Cost Headers/Project Items
  • [RB] Resolved an issue on Timesheet entry when Jobcosting is configured to automatically set cost header from cost rate which would cause Timesheet Lines to be saved without a Job Manager
  • [RB] Resolved an issue on Timesheet Totals reportwhere the user would encounter an “Unable to cast object” exception when attempting to view a timesheet
  • [JSV] Fixed construction valuation being posted with no nominal account net value
  • [JSV] Removed warning when closing construction sub contractor order
  • [JSV] Fixed unprocessed job costing timesheetline hours method posting authorised hours to committed
  • [NFS] Changed the goods received page to not allow selecting a future date for the receipt
  • [JSV] Fixed freetext order line asking for nominal account when one is selected when costing module set to ‘None’
  • [RB] Resolved an issue in the WAP service which would cause oorder lines in WAP to retain their original values and quantities if they were completely removed in Sage through a process such as writing off incomplete orders. This in turn would cause Orders to also display incorrect totals
  • [RB] Addressed an issue where a user would be able to allocate and validate stock items against a supplier while adding a stock item, but then subsequantly be able to change the selected supplier on the order header. Users will no longer be able to amend the order supplier if there are any stock items on the order
  • [JSV] Fixed sub contractor order line not updating the nominal account selection when changing the job header
  • [RB] Resolved an issue on various report export pages where users would be unable to convert text to decimal values for use in calculations
  • [RB] Removed the print buttons from PO Detail and WO summary reports when using Chrome. Chrome does not execute the commands from these buttons, but does not notifiy the user, which gives the appearance that the report is not working. Chrome users will need to use the open to new page button instead
  • [JSV] Fix expense line not deleting attachment when deleting the line
  • [RB] Subsistence Expense Types will no longer be displayed on expense type maintenance screens if the system isn’t configured to allow subsistence claims
  • [RB] Resolved issues with Requisition Import template. An object reference exception would be encountered if costing is enabled and force project selection is set to “no” or The costing module is not Job Costing and no Costing Header has been specified. Analysis code validation would not check whether Sage allows the analysis code to be amended. Import template now also has an import reference field to enable linking lines to a header to avoid issues where entering lines in the wrong order could cause lines to be allocated to the incorrect header
  • [JSV] Fix invoice approval only Usertype not being selectable for global default route
  • [JSV] Fix Construction Sub contractor order not showing phases and stages
  • [JSV] Fix Construction Sub contractor order not retaining default job header when adding rows
  • [JSV] Fix job and item control showing tree button when set to not show
  • [RB] Addressed an issue where the WAP service would occasionally encounter a timeout issue while reading invoice data from WAP
  • [RB] Resolved an issue with requisition analysis settings where users would be unable to change the mandatory analysis validation behaviour
  • [RB] Resolved an issue with approval notifications when notifcations are configured by Document Item, where the approval notification would always state that the item was approved by ‘yourself’
  • [JSV] Fix Sales order analysis code read only check returning wrong value
  • [JSV] Fix Rejected invoices that have been sent to a custom approval route not being shown in the Rejected tab
  • [JSV] Added Setting to default Sales order delivery date(s)
  • [JSV] Fixed mandatoryholiday tool and bank holiday tool erroring when using Sage timesheets
  • [NFS] Fixed an issue on nominal budget enquiry and job costing budget enquiry where the DMS document could not be accessed due to a change in browser security
  • [JSV] Fix allowance lines being included in the hours totals for Sicon Sage timesheets
  • [JSV] show allowance lines with different colour background for Sicon Sage timesheet page
  • [JSV] WAP Service will now check if POP/SOP Analysis codes can be amended before updating from Order/SalesOrder
  • [JSV] Resolved an issue where performing a final receipt for a quantity of zero would not update the WAP order to be completed

Hot Fix Enhancements
  • [NFS] Added a new tab to expense approval to show subsistence details
  • [JSV] Added setting to hide project requisition description box
  • [JSV] Add on list page improvements, allow grouping
  • [JSV] WAP service will now automatically set the WAP Addon WAP Url if is empty
  • [JSV] Flag read only analysis codes for Requisitions and Salesorders and prevent editing

Software dependancies: Requires an upgrade to the WAP addon

Date applied: November 12, 2019

191.7.0

Issues Resolved New Features Pre-release Hot Fix Enhancements Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


Important Info
  • [NFS] There are now settings per payment group in the WAP addon for which payment groups get picked up for approval in WAP. These settings will default to off on upgrades and will need to be configured.

New Features
  • [JSV] Allow User nominal account to have line and approval values for different document types
  • [JSV] Changed the usernominal import to include document type
  • [JSV] Added document type to approval route reports (user nominal list etc)
  • [RB] Added functionality which will allow for more granular system setting implementations based on Sage Databse, User Type and User. Selected system settings can now be overridden as a combination of Sage Database, UserType and User.
  • [RB] Added ability to set ‘Enable Free Text Entry’ as a setting by Sage Dataase, User Type and User
  • [RB] Added ability to set ‘Requisition Supplier Filter’ as a setting by Sage Dataase, User Type and User
  • [RB] Replaced setting to Hide supplier stock unit and pricing with a more detailed setting that will allow users to show, hide, enable or disable the controls rather than just show or hide
  • [RB] Added ability to set ‘Supplier/Unit Pricing Display’ as a setting by Sage Dataase, User Type and User
  • [RB] Added Requisition ‘Enable Item Description Amendment’ as a setting by User Type. The default Value is true
  • [RB] Added Project Requisition ‘Enable Item Description Amendment’ as a setting by User Type. The default Value is true
  • [NFS] Changed the WAP server to check the new SiconWAPPLProposedPayments table to only pick up suggested payments for payment groups that are enabled
  • [JSV] Allow warehouse to be edited when receiving goods
  • [JSV] Added ‘Update Database’ button to system page to run the database update scripts
  • [JSV] Added setting to hide the ‘Confirm as service’ option from Requisitions

Issues Resolved
  • [RB] Resolved an issue on Requisition Stock entry which would cause a Javascript error when Supplier units and pricing is configured to be hidden for the current User Type
  • [NFS] Fixed an issue in the existing requisitions screen where clicking the requisitions raised by my business unit quick link would throw and error.
  • [NFS] Added some additional code to the invoice process to check whether any invoices references or dates have been updated in Sage after the invoice was picked up and update them in WAP if they have
  • [RB] Resolved an issue onVarious Requisition Related pages where the Unit and pricing details would be displayed despite the user type permission not allowing
  • [RB] Resolved an issue on Requisition Stock entry when a user type is configured to hide unit pricing, which would allow users to still affect unit prices by changing the Buying unit and buying price unit fields
  • [JSV] Fixed Sales order menu group still appearing when user has no sales order permissions
  • [JSV] Fixed new stock item requests not setting the default supplier correctly
  • [RB] Resolved an issue on Expense Approval report where the Payment Method column would not be visible
  • [RB] Resolved an issue on Expense approval page where the disaplyed exchange rate in currencies view would display the Expense supplier’s exchange rate compared to base rather than the exchange rate for the line
  • [NFS] Resolved an issue in the service where job costing employees were read once then cached and never checked again, this meant new employees added would not get picked up by the service.
  • [JSV] Fix Sage Timesheet line status not always reading correctly
  • [JSV] Fix current timesheets page showing duplicate timesheets
  • [JSV] Fix Hot update method in service setting timesheetline status incorrectly
  • [RB] Resolved an issue with approval route creation when a user returns from being out of office where out of office rules would still be applied to approval route creationg for a time after turning off Out of Office.
  • [NFS] Fixed an issue in the approval route wizard page where job header only routes could not be created as a job could not be selected beforehand
  • [NFS] Fixed an issue in the approval route import page where job header routes only could not be imported
  • [NFS] Added additional handing for index out of range exceptions in perform dataselect events on the budget enquiry
  • [NFS] Renamed more instances of ‘Proposed Payments’ to ‘Suggested Payments’
  • [JSV] Fix Sicon Sage timesheets picking up lots of old records to process missing transactions – limited process to 6 months old
  • [JSV] Fix the wrong page being loaded when clicking on the timesheets hyperlink on the dashboard when sicon sage timesheet are being used
  • [JSV] Fixed the Sage connection edit page not loading the SOPQuote email address and body details
  • [JSV] Fix Sage timesheet line hours lookup generating an error
  • [NFS] Changed the approval route builder to not allow ‘requester’ type entries on expenses, holiday requests, or invoice variance routes.
  • [JS] Fix Sage timesheets failing when processing deleted timesheet line hours
  • [JS] Fix timesheet line not setting start and end times for decimal only entry when using sicon sage timesheets. The App needs these set to pick up the data correctly
  • [NFS] Changed the job enquiry list to support ‘contains’ filtering
  • [JSV] Change the Goods received history report title to read correctly
  • [JSV] Add PO Number to Goodsreceived history report
  • [JS] WAP App – Updated the upload holiday request method to define the synchitem type as app was not uploading holiday correctly.
  • [JSV] Allow sales order service items to be despatched even though they can’t be allocated
  • [JSV] Show “N/A” for quantity allocated on sales order service item lines
  • [JSV] Flag up when selecting Job costing job with Phases/stages but no activity
  • [JSV] Fixed job costing Activity name not showing on costing selection summary
  • [JSV] Prevent Job costing Phase and stage from being selected (activity only)
  • [JSV] Changed job costing phases/stages seletion header to read ‘Select Job Activity’
  • [RB] Addressed an issue encountered with timesheets when upgrading from a version of WAP earlir than 19 to a version 19 or later, which would lead to newly approved timesheets failing to post due to invalid timesheet status on some older timesheets
  • [NFS] Added additional fitlers to the job enquiry list
  • [NFS] Added actual and committed totals for filtered items to the job enquiry page
  • [NFS] made the columns resizable on the job enquiry page
  • [NFS] changed long text not to wrap on the job enquiry page
  • [NFS] Added additional handling to WAP service start up for when the sage admin service cant be connected to when checking the WAP licence
  • [RB] Resolved an issue in the install update script that would cause the installer to fail due to a SQL issue during initial install
  • [JSV] Fixed issue with project accounting where bringing invoices across for approval wouldn’t always contain the project and item information

Hot Fix Enhancements
  • [JSV] Added download urls to mobile app links screens
  • [JSV] Added code to check for supplier application attachments
  • [JSV] Added check for WAP database connection before processing – service will stop if the database cannot be accessed

Date applied: November 12, 2019

191.5.1

Issues Resolved Pre-release Hot Fix Enhancements

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


Issues Resolved
  • [RB] Fixed a display issue on Timesheet entry page where Pay Rate totals would incorrectly add 24 hours to the day’s total if there is an entry with an end time of midnight and timesheet entry format is start and end time
  • [RB] Resolved an issue when performing an upgrade from a version 17 or earlier installation of WAP to a Version 19 or later version of WAP. Orders that were created or submitted prior to the upgrade, but approved after the upgrade would be created with all lines having “Confirmation not required” as confirmation intent in Sage
  • [RB] Resolved an issue on goods received screen which would allow users to receive items with a “Confirmation not required” confirmation intent
  • [JSV] Fix SOP Quote requesting customer details when submitting a prospect account
  • [JSV] Fix Sales order not requesting customer account when submitting an order for a prospect account
  • [JSV] Fix Sales order reporting ‘Cannot Find CRM Company’ when creating customer account to submit order created from Qute with a prospect account
  • [JSV] Fix Failed documents having the Failed flag cleared when re-processing (all document types)
  • [NFS] Added code to the service to detect server shutdown and shutdown the service
  • [NFS] Added additional handling to teh service to handle when the SQL server is not accessible.
  • [NFS] Fixed an error that could occur in the service when using spindle document capture when no documents have been added to the spindle data set at all

Hot Fix Enhancements
  • [NFS] Added the ability to view DMS documents for actual nominal transactions in budget enquiry

Date applied: November 12, 2019

191.5.0

Issues Resolved New Features Pre-release Hot Fix Enhancements

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


New Features
  • [JSV] New settings page and links
  • [NFS] Added Job Costing Job Paid status to the Job costing List
  • [RB] Added columns for Vat, Gross and Tax Rate Name to invoice approval line view. Renamed ‘Value’ column to ‘Net’

Issues Resolved
  • [JSV] Fix approval history tab showing orphaned line details for new documents
  • [RB] Fixed an issue with welcom emails where no email would be sent if more than one welcome email had been sent prior to the email thread performing the email sending had re-run
  • [RB] Resolved an issue where users would receive their welcome email multpile times
  • [RB] Systemwide changes to have more consistent display and use of Net, VAT and Gross field descriptions and column displays
  • [NFS] Fixed an issue on the existing invoices screen where some of the quick links would now show credit notes
  • [RB] Resolved an issue on Suggested Payments Approval Page where column headings wouldn’t match up with column content
  • [RB] Mileage Report will now correctly display the vehicle registration
  • [RB] Changed wording on User page for Mileage details to clarify that the claimed mileages relate only to the current year.
  • [RB] Added totals for all historic mileage on user page seperately from Year To Date totals
  • [RB] Resolved an issue when returning to orders search page after a previous search where the supplier selection would remain disabled while the supplier is selected
  • [RB] Resolved an issue when entering a new Requisition when system is configured to auto populate supplier from stack item, which would cause the first entered stock item not to be saved

Hot Fix Enhancements
  • Added a new setting to determine whether the nominal is defaulted on free text line entry
  • [RB] When filtering the mileage report by Week start date or Document Date, the mileage date will be used rather than the expense date. Submitted and Fully approved date will still use Expense date
  • [NFS] Renamed Proposed Payments to Suggested Payments in all places where possible

Date applied: November 12, 2019

191.4.0

Issues Resolved New Features Pre-release Hot Fix Enhancements

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


New Features
  • [JSV] Added ‘Planned’ column to job costing enquiry budget tab
  • [JSV] Added ‘Planned Purchases’ Tab/screen to job costing enquiry screen
  • [JSV] Added Service methods for SOP Returns
  • [JSV] Added system default SOPReturn report
  • [JSV] Added SOP Return pages and links
  • [JSV] Added SOP Return pages and links
  • [JSV] Added usertype permissions for SOP Returns
  • [JSV] Added thumbnail viewer to view Goods received note on requisition line order receipt viewer
  • [JSV] Added Goods received history report

Issues Resolved
  • [RB] Resolved an issue where expense line and mileage line imports would incorrectly fail validation due to Nominal account validation issues. When the specified nominal account has not been included in the users’ nominal account allocation in user maintenence, regardless of whether the user has access all permission or has access to the nominal as allocated in expense type, validation will fail
  • [RB] When attempting to import csv files, the error message will more clearly explain when the file couldn’t be read or is corrupt, rather than just stating tht no import file has been selected
  • [JSV] Fixed timesheet submission reminders not always getting generated
  • [JSV] Fixed timesheet submission reminders not including the last full week
  • [JSV] HR processing checks HR enabled before processing
  • [NFS] Approval routes will now be deleted when a value band is deleted
  • [JSV] Fix planned purchases always showing check box
  • [JSV] Fix planned purchases checkboxe positions not being maintained when filtering
  • [JSV] prevent planned purchase lines being self approved when approver submits
  • [NFS] Approval routes will now be deleted when a value band is deleted
  • [RB] Resolve issue on timesheet approval where a user would encounter an index out of range exception after clicking Reject All in the Timesheet Lines Tab
  • [NFS] Fixed an issue in the WAP service where temporary DMS documents were not cleared after being created in WAP
  • [JSV] Fix Sales orders not prompting for a delivery address if document approval required is turned off
  • [JSV] Fix project requisition not filtering job costing header by job
  • [JSV] Fix Job costing transaction for Sales order not linking properly to the Sales order (job enquiry screen not showing linked order)
  • [JSV] Add allocated column to Sales order despatch screen
  • [JSV] Sales order despatch qty field has a max number based on previous despatch and allocated qty
  • [JSV] Prevent Sales order despatch for lines that have insufficient allocation
  • [JSV] Changed Sales order free text nominal account selection to be the same as stock order nominal selection (search and clear buttons)
  • [JSV] Remove unused Sales order settings (auto populate delivery dates)
  • [JSV] Fix country selection error when editing user
  • [JSV] Changed Sales order free text nominal account selection to be the same as stock order nominal selection (search and clear buttons)
  • [JSV] Remove unused Sales order settings (auto populate delivery dates)
  • [JSV] Fix Job costing settings causing object not found error when editing timesheet
  • [NFS] Removed all places when loading job costing lists where it was checking the exclude from job list setting (except in job costing enquiry)
  • [NFS] Changed the stock item entry page to perform all callbacks when the stock item callback has finsished to prevent data getting cleared when controls are used before the page is updated
  • [NFS] Changed the stock item entry page to select the warehouse automatically after the stock item selected if there is only one to choose from
  • [JSV] Add setting to global file to increase devexpress script execution permissions. Some sites reporting script execution issues with devexpress reports
  • [JSV] Fix non-display countries only showing the country ID for sales orders when they are already set on the order
  • [JSV] Fix Delivery address control not loading the contact name for default delivery addresses
  •  [JSV] Removed code that would allow users to view all entries in the job costing list if they had permission to view all jobs. Just uses usertype permission or only shows their job manager jobs if off
  • [JSV] Fixed SOP Quote using salesorder email fields on report
  • [RB] Resolved an issue where “Awaiting your approval” notifications wouldn’t be displayed for approval users of Requisitions unless they could also approve expenses
  • [RB] Resolved an issue on dashboard notifications where a user would potentially not get an “Awaiting approval” notification when notifications are set to be sent by Document Type and the user has items to approve
  • [JSV] Fixed an issue on the budget enquiry page where it was not filtering nominal accounts based on user permissions
  • [JSV] Fix Approval route progress incorrectly reporting ‘no current step’ error when no sage database ID set in the approval route progress table
  • [JSV] Fixed multipage pdf viewer not displaying subsequent pages
  • [NFS] Fixed an issue in the nominal budget enquiry report where selecting an individual nominal account would not filter the results
  • [RB] Resolved an issue where Rejected invoice items would be routed down the correct rejected invoice approval route, but the invoice not marked as Rejected if the invoice contains only one item for the user to reject or the Reject All option is used

Hot Fix Enhancements
  • [JSV] Added ‘Planned’ column to budget tab in job costing enquiry screen
  • [JSV] Allow project requisitions to be partially approved, generating orders for selected lines
  • [JSV] Allow planned purchases to be filtered by ‘containing’
  • [JSV] Add info icon and hover over summary to planned purchase list

Date applied: November 12, 2019

191.3.1

Issues Resolved New Features Pre-release Hot Fix Enhancements

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


New Features
  • [JSV] Update Planned purchase and planned purchase history in Sage when order is processed with planned purchase lines
  • [JSV] Planned purchases list page
  • [JSV] Planned purchases CSV Import
  • [JSV] Create Requisition from planned purchase

Issues Resolved
  • [JSV] Fix delete absence approval routes not working
  • [JSV] Fix not being able to change Sales order delivery address once selected
  • [JSV] Fix CostToComplete changes not updating back into Sage
  • [JSV] Fix Cost to complete page asking for reason for change when nothing has been changed
  • [JSV] Cost to complete page checks job costing setting to enable/disable hours to complete editing
  • [NFS] Resolved an issue when creating MRP orders in WAP where the supplier part no pwas not being populated
  • [NFS] Resolved an issue when updating MRP Orders in Sage where the order line details were not being updated for Waiting Order Lines
  • [JS] Updated the app links for app centre and app store within the UpdateDB script
  • [JS] If the approval history text was not poulated the web page would error.
  • [JSV] Fixed Project requisition not saving the warehouse ID
  • [JSV] Fixed project requisition erroring when a stockitem id set to 0
  • [JSV] Fixed Stock item entry on requisition erroring when qty is changed and no supplier selected
  • [JSV] When entering Company Expense Items, the credit card will automatically be selected if the user has only one credit card allocated and it is not marked as the default credit card
  • [RB] Resolved an issue that would cause some notifications to be sent an excessive amount of times despite the email thread being configured to not re-send emails
  • [RB] Resolved an issue that would cause some notifications to be not be sent at all despite the email thread being configured to re-send emails
  • [NFS] Fixed an issue when building approval route progress where user type entries were not respecting the self approval setting for removing requestors from the approval route or replacing with the configured alternate user account.
  • [NFS] Phases, Stages and ACtivities will now check the Job Costing Perentage complete filter setting in WAP and filter out records with a higher percentage complete.
  • [NFS] Job Costing Templates and Estimates are now filtered out of selection in WAP
  • [NFS] Works Order Templates, Estimates and Suggestions are now filtered out of selection in WAP
  • [RB] Disabled ability to make any amendments or resetting of approval routes for Invoices that are on hold
  • [RB] Renamed DMS headers and labels to read Sicon Documents in System Settings
  • [RB] Resolved an issue with amendment of goods received that wouldn’t allow saving amendments if the “Allow duplicate Supplier document number entry” system setting is disabled
  • [RB] Resolved an issue on Search pages where the Loading panel would remain visible after changing Tabs when they user does not have permission to view all or approve the specific document type
  • [RB] Resolved an issue on Expense Line entry when system is configured to use Credit Card statement imports and to lock expense currency to user account currency where the currency selection would not be disabled, and therefore stil be editable
  • [RB] Resolved an issue on Requisition Search page which would cause the loading panel to remain visible after clicking the link to export the results to Excel
  • [JSV] Default empty Sales order delivery dates to Sales order date if self approving – set to current date if document approval not required.
  • [JSV] Fix sales orders never getting marked as Failed
  • [JSV] Added allowable warnings for sales orders having delivery dates in the past
  • [JSV] Fix Job costing enquiry not displaying phases and stages
  • [JSV] Supplier application list defaults to user’s default database
  • [JSV] Fix duplicate valuation lines when self approving sub contractor order
  • [RB] Resolved an issue with copying orders where a user with access to multiple companies would be able to switch the selected company, but still have the orders from the initial company selectable in the Orders list
  • [NFS] Fixed an issue in the job costing budget checker where it was not exluding lines for deleted Sage databases
  • [NFS] Fixed an issue in the job costing budget checker where it was not detecting the job budget if no variation was selected for the job
  • [NFS] Fixed an issue in the job costing budget checker where it was not finding lines without outstanding sent to sage value (only lines that were not sent to sage at all)

Hot Fix Enhancements
  • [JSV] Added filecheck to CSVImport page to check if a file has already been used to import data
  • [JSV] Added button to delete all approval routes for a specific database
  • [JSV] Added a warning for deleting all approval routes when database selected
  • [JSV] Fixed Sales order Quotes printing using Sales order layouts instead of Quote layouts
  • [JSV] Moved the ‘terms and conditions landscape’ setting out of the requisition section in Admin
  • [JSV] Sales orders and quotes now use the ‘terms and conditions landscape’ setting
  • [JSV] HE: Sales orders and quotes now use the ‘terms and conditions landscape’ setting
  • [JSV] add options to CSVImport page to show all lines (not just errors) and show imported insformation
  • [JSV] CSVImport page highlights errored lines in red
  • [JSV] Added ability to create supplier applications from sub contractor orders

Date applied: November 12, 2019

191.0.34

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [NFS] Attachments will now be deleted when an invoice or expense is deleted
  • [NFS] Fixed an issue in the invoice process where invoices would be deleted and picked up again if there were not valid nominal accounts this would cause it to check for attachments for each invoice which lead to the same attachments being downloaded multiple times
  • [RB] Resolved an issue on Approval route single route entry where the selected nominal would not be correctly set, causing users to be unable to create new or edit existing routes

Hot Fix Enhancements
  • [NFS] Added settings to determine whether when budget checking that transactions are outside of the specified period are included in the budget

Date applied: November 6, 2019

191.0.33

Issues Resolved
Issues Resolved
  • [RB] Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line
  • [JSV] Project requisition notes field no longer restricted in length
  • [JSV] Fix Rapid timesheets not loading default cost/charge rates for project accounting
  • [JSV] Fixed approving project accounting orders taking a long time (up to 1hr) to expand lines when budgeting on with complex project structure and lots of orderlines
  • [NFS] Added additional handling for index out of range errors on timesheet approval
  • [NFS] Fixed an issue on timesheet appeoval where approve all in group would throw and error
  • [JS] Found two bugs in the mileage line validation which was removing the Project item ID from a mileage line, now using the MileageSplitValueInstrumentV2 to validate the line and sometimes the PRDocStatus was null which seems to be impossible but added a check just incase.
  • [RB] Resolved an issue with Approval Route editing on invoice line where newly added users in the approval route would use their approval value for document type “None” rather than “invoice”
  • [RB] Resolved an issue on expense line entry where a user would be unable to select a credit card when the user has multiple credit cards allocated and there is no default configured
  • [JS] WAP App update to expense line properties to pull through exchange rate and update the line correctly
  • [NFS] resolved an issue on the subsistence entry control where a substistence start time could be entered that was after the subsistence end time

Date applied: November 6, 2019

19.0.32

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [RB] Resolved an issue with Approval Route editing on invoice line where newly added users in the approval route would use their approval value for document type “None” rather than “invoice”
  • [RB] Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line
  • [JSV] Fixed approving project accounting orders taking a long time (up to 1hr) to expand lines when budgeting on with complex project structure and lots of orderlines
  • [JSV] Project requisition notes field are no longer restricted in length

Hot Fix Enhancements
  • [JSV] Added setting to hide project requisition description box

Date applied: November 4, 2019

191.0.32

Issues Resolved
Issues Resolved
  • [RB] Limited New Supplier Request Postcode text length to a maximum of 10 characters in line with the maximum field size allowed by Sage
  • [RB] Resolved an issue on Sales Order Line Free text entry where users would be unable to specify numeric values to more than 2 decimal places. All numeric fields on Sales Order Line Free text entry now allow more than 2 decimal places
  • [RB] Resolved an issue when upgrading from version 17 of WAP to a later version which would cause all orders entered before the date of the upgrade to not appear on the goods received screen
  • [RB] Resolved an issue on Mileage line entry which would encounter a SQL arithmetic overflow exception during saving of a mileage line when the system is configured to not allow business mileage entry, but use mileage amendment instead and a user selects the mileage box, but does not enter a value

Date applied: October 25, 2019

191.0.31

Issues Resolved
Issues Resolved
  • [NFS] changed the TA book on job control to allow booking onto operations with zero quantity
  • [RB] Resolved an issue on Timesheet Totals report which would encounter a SQL exception if there is a Sage database configured with an apostrophe (‘) in the description field

Date applied: October 22, 2019

191.0.30

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [NFS] Fixed an issue when turning on out of office where the out of office approval route entries don’t have the Sage database Id set
  • [NFS] Fixed an issue on the expense approval page where it was using the line number from the invoice line table rather than the expenseline/mileage table

Hot Fix Enhancements
  • [NFS] Added a new tab to expense approval to show subsistence details

Date applied: October 18, 2019

191.0.29

Issues Resolved Hot Fix Enhancements Important
Important Info
  • Database change [FileGuid] column added to [File] Table

Issues Resolved
  • [JSV] Fix multi page pdfs throwing an error when trying to view subsequent pages when approving an invoice
  • [JSV] Allow login line start and end time to be set to 00:00
  • [NFS] Fixed an issue on sales order entry where there was a sql deadlock issue
  • [NFS] Changed all file, image and PDF handlers to validate a user is authenticated before serving data. All handlers now take a unique file GUID rather than simple file paths

Hot Fix Enhancements
  • [JSV] Added setting to hide project requisition description box

Date applied: October 18, 2019

191.0.28

Issues Resolved
Issues Resolved
  • [JSV] Fixed free text order line asking for nominal account when one is selected but costing module is set to ‘None’
  • [JSV] WAP SQL user will now be granted write permission to Sage databases on setup (required for Sicon timesheets etc)

Date applied: October 16, 2019

191.0.27

Issues Resolved
Issues Resolved
  • [RB] Resolved an issue on Timesheet entry when Jobcosting is configured to automatically set cost header from cost rate which would cause Timesheet Lines to be saved without a Job Manager
  • [RB] Resolved an issue with Expense Line CSV import where incorrectly validation would fail due to duplicate cost headers.  This error would occur if the costing module is Job Costing/Project accounting, the user doesn’t have access to all Cost Headers/Project Items, but does have access to multiple Cost Headers/Project Items
  • [NFS] Changed the data tier to pass the inner exception for SQL errors when rethrowing a SQL configuration exception rather than hiding it
  • [NFS] Renamed event log sources to WAP Service and WAP Web App
  • [NFS] The size of the event log will now increase to 250MB automatically
  • [NFS] Added better logging in the Datatier class to show stack trace information when an error occurs there
  • [NFS] Fixed an issue on timesheet approval where an error would be displayed if the rows are grouped and approve or reject all in group was clicked

Date applied: October 16, 2019

19.0.31

Issues Resolved Important
Important Info
  • Requires and upgrade to the WAP addon.  Minimumn Version 190.0.9

Issues Resolved
  • [RB] Resolved an issue on various report export pages where users would be unable to convert text to decimal values for use in calculations
  • [RB] Resolved an issue in the WAP service which would cause order lines in WAP to retain their original values and quantities if they were completely removed in Sage through a process such as writing off incomplete orders.  This could lead orders to display incorrect totals
  • [NFS] Changed the goods received page to not allow selecting a future date for the receipt
  • [JSV] Allow login line start and end time to be set to 00:00
  • [RB] Resolved an issue with Expense Line CSV import where validation would fail incorrectly due to duplicate cost headers.  This error would occur if the costing module is Job Costing/Project accounting, the user doesn’t have access to all Cost Headers/Project Items, but does have access to multiple Cost Headers/Project Items
  • [NFS] Fixed an issue on timesheet approval where an error would be displayed if the rows are grouped and approve or reject all in group was clicked

Date applied: October 15, 2019

191.0.26

Issues Resolved Important
Important Info
  • Requires and upgrade to the WAP addon.  Minimumn Version 191.0.8

Issues Resolved
  • [RB] Addressed an issue where a user would be able to allocate and validate stock items against a supplier while adding a stock item, but then subsequently be able to change the selected supplier on the order header.  Users will no longer be able to amend the order supplier if there are any stock items on the order
  • [RB] Resolved an issue in the WAP service which would cause order lines in WAP to retain their original values and quantities if they were completely removed in Sage through a process such as writing off incomplete orders. This could lead orders to display incorrect totals
  • [JSV] Fixed free text order line asking for nominal account when one is selected but costing module is set to ‘None’
  • [NFS] Changed the goods received page to not allow selecting a future date for the receipt
  • [JSV] Fixed construction valuation being posted with no nominal account net value
  • [JSV] Removed warning when closing construction sub contractor order
  • [JSV] Fixed unprocessed job costing timesheetline hours method posting authorised hours to committed
  • [RB] Resolved an issue on Timesheet Totals report where the user would encounter an “Unable to cast object” exception when attempting to view a timesheet

Date applied: October 14, 2019

191.0.25

Issues Resolved
Issues Resolved
  •  [JSV] Fixed sub contractor order line not updating the nominal account selection when changing the job header
  •  [RB] Resolved an issue on various report export pages where users would be unable to convert text to decimal values for use in calculations
  •  [RB] Removed the print buttons from PO Detail and WO summary reports when using Chrome. Chrome does not execute the commands from these buttons, but does not notifiy the user, which gives the appearance that the report is not working. Chrome users will need to use the open to new page button instead
  • [JSV] Fix expense line not deleting attachment when deleting the line

Date applied: October 8, 2019

191.0.24

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [JSV] Added Setting to default Sales order delivery date(s)
  • [RB] Addressed an issue where the WAP service would occasionally encouter a timeout issue while reading invoice data from Sage
  • [JSV] Fix Rejected invoices that have been sent to a custom approval route not being shown in the Rejected tab
  • [RB] Resolved an issue with approval notifications when notifications are configured by Document Item, where the approval notification would always state that the item was approved by ‘yourself’
  • [RB] Resolved an issue with requisition analysis settings where users would be unable to change the mandatory analysis validation behavior
  • [JSV] Fix invoice approval only Usertype not being available for selection for the global default route
  • [JSV] Fix Construction Sub contractor order not showing phases and stages
  • [JSV] Fix Construction Sub contractor order not retaining default job header when adding rows
  • [JSV] Fix job and item control showing tree button when set to not show
  • [RB] Resolved issues with Requisition Import template
    • An object reference exception would be encountered if costing is enabled and force project selection is set to “no” or The costing module is not Job Costing and no Costing Header has been specified
    • Analysis code validation will now check whether Sage allows the analysis code to be amended
    • Import template now also has an import reference field to enable linking lines to a header to avoid issues where entering lines in the wrong order could cause lines to be allocated to the incorrect header

Hot Fix Enhancements
  • [RB] Added Goods Invoiced and Received Quantities Report
  • [JSV] Flag read only analysis codes for Requisitions and Salesorders and prevent editing
  • [JSV] WAP service will now automatically set the WAP Addon WAP Url if is empty

Date applied: October 4, 2019

19.0.30

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [RB] Resolved an issue where performing a final receipt for a quantity of zero would not update the WAP order to be completed
  • [JSV] WAP Service will now check if POP/SOP Analysis codes can be amended before updating from Order/SalesOrder
  • [JSV] Added new default holiday project type for unpaid leave
  • [JSV] Added Setting to default Sales order delivery date(s)
  • [JSV] Fix Sales order analysis code read only check returning wrong value
  • [JSV] Fix Rejected invoices that have been sent to a custom approval route not being shown in the Rejected tab
  • [RB] Addressed an issue where the WAP service would occasionally encounter a timeout issue while reading invoice data from Sage

Hot Fix Enhancements
  • [JSV] Flag read only analysis codes for Requisitions and Salesorders and prevent editing

Date applied: October 4, 2019

191.0.5

Issues Resolved
Issues Resolved
  • [RB] WAP Addon – Resolved an issue with Generated payments where payments allocated directly from payment processing would not be reflected as paid in WAP

Date applied: October 1, 2019

190.0.8

Issues Resolved
Issues Resolved
  • [RB] WAP Addon – Resolved an issue with Generated payments where payments allocated directly from payment processing would not be reflected as paid in WAP

Date applied: October 1, 2019

191.0.23

Issues Resolved
Issues Resolved
  • [JSV] Clear unsubmitted timesheet notification for user when timesheet is submitted
  • [JSV] Unsubmitted timesheet report will now check if any standard working hours are set on a submitted timesheet to prevent holiday only timesheets being reported as fully submitted
  • [JSV] Fixed Attachments added when emailing goods received notes not getting cleared and being attached to subsequent emails
  • [RB] Resolved an issue on Requisition Stock entry which would cause a Javascript error when Supplier units and pricing is configured to be hidden for the current User Type
  • [JSV] Fixed ‘HotUpdate’ flag not getting set on sage Timesheet line hours
  • [RB] Resolved an issue where performing a final receipt for a quantity of zero would not update the WAP order to be completed
  • [JSV] WAP Service will now check if POP/SOP Analysis codes can be amended before updating from Order/SalesOrder
  • [JSV] Fix allowance lines being included in the hours totals for Sicon Sage timesheets
  • [JSV] Show allowance lines with different colour background for Sicon Sage timesheet page

Date applied: September 27, 2019

191.0.22

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [JSV] Fixed new stock item requests not setting the default supplier correctly
  • [RB] Resolved an issue on Requisition Stock entry when a user type is configured to hide unit pricing, which would allow users to still affect unit prices by changing the buying unit and buying price unit fields
  • [NFS] Added some additional code to the invoice process to check whether any invoices references or dates have been updated in Sage after the invoice was picked up and update them in WAP if they have
  • [JSV] Fixed quote import failing when stock item has no selling/buying unit descriptions
  • [JSV] Fixed salesorder line error when saving and no nominal issues account found
  • [NFS] Fixed an issue in the existing requisitions screen where clicking the requisitions raised by my business unit quick link would throw and error
  • [JSV] Clear unsubmitted timesheet notification for user when timesheet is submitted
  • [JSV] Unsubmitted timesheet report will now check if any standard working hours are set on a submitted timesheet to prevent holiday only timesheets being reported as fully submitted
  • [JSV] Fixed Attachments added when emailing goods received notes not getting cleared and being attached to subsequent emails

Hot Fix Enhancements
  • [JSV] Added download urls to mobile app links screens
  • [JSV] Addded project addresses for sub contractor orders (Construction)

Date applied: September 20, 2019

19.0.29

Issues Resolved
Issues Resolved
  • [JSV] Clear unsubmitted timesheet notification for user when timesheet is submitted
  • [JSV] Unsubmitted timesheet report will now check if any standard working hours are set on a submitted timesheet to prevent holiday only timesheets being reported as fully submitted
  • [JSV] Fixed Attachments added when emailing goods received notes not getting cleared and being attached to subsequent emails
  • [JSV] Fixed salesorder line error when saving and no nominal issues account found
  • [JSV] Fixed quote import failing when stock item has no selling/buying unit descriptions

Date applied: September 20, 2019

19.0.28

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [NFS] Added some additional code to the invoice process to check whether any invoices references or dates have been updated in Sage after the invoice was picked up and update them in WAP if they have
  • [RB] Resolved an issue on Requisition Stock entry when a user type is configured to hide unit pricing, which would allow users to still affect unit prices by changing the Buying unit and buying price unit fields
  • [JSV] Fixed Sales order menu group still appearing when user has no sales order permissions
  • [JSV] Fixed new stock item requests not setting the default supplier correctly
  • [RB] Resolved an issue on Expense Approval report where the Payment Method column would not be visible
  • [RB] Resolved an issue on Expense approval page where the displayed exchange rate in currencies view would display the Expense supplier’s exchange rate compared to base rather than the exchange rate for the line
  • [NFS] Resolved an issue in the service where job costing employees were read once then cached and never checked again, this meant new employees added would not get picked up by the service.
  • [RB] Resolved an issue with approval route creation when a user returns from being out of office where out of office rules would still be applied to approval route creating for a time after turning off Out of Office.
  • [JSV] Fixed the Sage connection edit page not loading the SOPQuote email address and body details

Hot Fix Enhancements
  • [JSV] Added download urls to mobile app links screens

Date applied: September 19, 2019

191.0.21

Issues Resolved
Issues Resolved
  • [RB] Resolved an issue on Expense Approval report where the Payment Method column would not be visible
  • [RB] Resolved an issue on Expense approval page where the displayed exchange rate in currencies view would display the Expense supplier’s exchange rate compared to base rather than the exchange rate for the line
  • [NFS] Resolved an issue in the service where job costing employees were read once then cached and never checked again, this meant new employees added would not get picked up by the service.

Date applied: September 18, 2019

191.0.20

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [RB] Resolved an issue with approval route creation when a user returns from being out of office where out of office rules would still be applied to approval route creating for a time after turning off Out of Office.
  • [JSV] Fix Sage Timesheet line status not always reading correctly
  • [JSV] Fix current timesheets page showing duplicate timesheets
  • [JSV] Fix Hot update method in service setting timesheetline status incorrectly

Hot Fix Enhancements
  • [NFS] Added settings to turn off posting for individual modules, this will update the documents to not require updating which will keep them accessible in WAP.

Date applied: September 16, 2019

191.0.19

Issues Resolved
Issues Resolved
  • [NFS] Fixed an issue in the approval route wizard page where job header only routes could not be created as a job could not be selected beforehand
  • [NFS] Fixed an issue in the approval route import page where job header routes only could not be imported
  • [NFS] Added additional handing for index out of range exceptions in perform dataselect events on the budget enquiry

Date applied: September 12, 2019

191.0.18

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [NFS] Changed the approval route builder to not allow ‘requester’ type entries on expenses, holiday requests, or invoice variance routes.
  • [JSV] Fix Sage timesheet line hours lookup generating an error
  • [JSV] Fix Sicon Sage timesheets picking up lots of old records to process missing transactions – limited process to 6 months old
  • [JSV] Fix the wrong page being loaded when clicking on the timesheets hyperlink on the dashboard when Sicon sage timesheet are being used
  • [JSV]

Hot Fix Enhancements
  • [JSV] Added code to check for supplier application attachments

Date applied: September 12, 2019

19.0.27

Issues Resolved
Issues Resolved
  • [RB] Addressed an issue encountered with timesheets when upgrading from a version of WAP earlier than 19 to a version 19 or later, which would lead to newly approved timesheets failing to post due to invalid timesheet status on some older timesheets
  • [JSV] Allow sales order service items to be dispatched even though they can’t be allocated
  • [JSV] Show “N/A” for quantity allocated on sales order service item lines
  • [JSV] Flag up when selecting Job costing job with Phases/stages but no activity
  • [JSV] Fixed job costing Activity name not showing on costing selection summary
  • [JSV] Prevent Job costing Phase and stage from being selected (activity only)
  • [JSV] Changed job costing phases/stages selection header to read ‘Select Job Activity’
  • [JSV] Fix analysis codes not loading on Sales order header
  • [JSV] Fix Analysis codes not synchronizing between Sales order Header and delivery tab if setting on to show the top 2 analysis codes on the header

Date applied: September 10, 2019

191.0.17

Issues Resolved
Issues Resolved
  • [JSV] Fix Sage timesheets failing when processing deleted timesheet line hours
  • [JSV] Fix timesheet line not setting start and end times for decimal only entry when using sicon sage timesheets. The App needs these set to pick up the data correctly

Date applied: September 9, 2019

191.0.16

Issues Resolved
Issues Resolved
  • [RB] Addressed an issue encountered with timesheets when upgrading from a version of WAP earlir than 19 to a version 19 or later, which would lead to newly approved timesheets failing to post due to invalid timesheet status on some older timesheets
  • [JSV] Flag up when selecting Job costing job with Phases/stages but no activity
  • [JSV] Fixed job costing Activity name not showing on costing selection summary
  • [JSV] Prevent Job costing Phase and stage from being selected (activity only)
  • [JSV] Changed job costing phases/stages selection header to read ‘Select Job Activity’
  • [JSV] Allow sales order service items to be dispatched even though they can’t be allocated
  • [JSV] Show “N/A” for quantity allocated on sales order service item lines

Date applied: September 9, 2019

190.0.7

Hot Fix Enhancements
Hot Fix Enhancements

[JU] Sage 200 WAP Addon Self-Reversing Journal changed to use individual invoice exchange rates, not period or current exchange rates.


Date applied: September 5, 2019

191.0.15

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • [JSV] Fixed issue with project accounting where bringing invoices across for approval wouldn’t always contain the project and item information
  • [RB] Resolved an issue in the install update script that would cause the installer to fail due to a SQL issue during initial install
  • [JSV] Check if stockitemnominal code is not null when fetching (sales order errors)
  • [JSV] Added ‘clear’ button to sales order stockitem batch line entry nominal control
  • [JSV] Fixed filtering on sales order stockitem batch line entry nominal control
  • [JSV] Fixed site not loading if autologin enabled and any Sage database login details incorrect
  • [JSV] Added budget tab to Expense approval page
  • [JSV] Fix Analysis codes not synchronizing between Sales order Header and delivery tab if setting on to show the top 2 analysis codes on the header
  • [JSV] Fix analysis codes not loading on Sales order header
  • [JSV] Clear unsubmitted timesheet notification for user when timesheet is submitted
  • [JSV] Fix error when uploading attachment to new supplier request

Hot Fix Enhancements
  • [JSV] Added a check for WAP database connectivity before processing – service will stop if the database cannot be accessed
  • [NFS] Added additional handling to WAP service start up for when the sage admin service cant be connected to when checking the WAP licence

Date applied: September 3, 2019

19.0.26

Issues Resolved
Issues Resolved
  • [NFS] Added additional handling to WAP service start up for when the sage admin service cant be connected to when checking the WAP licence
  • [RB] Resolved an issue in the install update script that would cause the installer to fail due to a SQL issue during initial install
  • [JSV] Fixed issue with project accounting where bringing invoices across for approval wouldn’t always contain the project and item information
  • [JSV] Fix Failed documents having the Failed flag cleared when re-processing (all document types)
  • [JSV] Fixed a display issue on Timesheet entry page where Pay Rate totals would incorrectly add 24 hours to the day’s total if there is an entry with an end time of midnight and timesheet entry format is start and end time
  • [RB] Resolved an issue when performing an upgrade from a version 17 or earlier installation of WAP to a Version 19 or later version of WAP
    • Orders that were created or submitted prior to the upgrade, but approved after the upgrade would be created with all lines having “Confirmation not required” as confirmation intent in Sage
  • [RB] Resolved an issue on goods received screen which would allow users to receive items with a “Confirmation not required” confirmation intent
  • [NFS] Added code to the service to detect server shutdown and shutdown the service
  • [NFS] Added additional handling to the service to handle when the SQL server is not accessible
  • [NFS] Fixed an error that could occur in the service when using spindle document capture when no documents have been added to the spindle data set at all
  • [JSV] Fix SOP Quote requesting customer details when submitting a prospect account
  • [JSV] Fix Sales order not requesting customer account when submitting an order for a prospect account
  • [JSV] Fix Sales order reporting ‘Cannot Find CRM Company’ when creating customer account to submit order created from Qute with a prospect account

Date applied: September 2, 2019

191.0.14

Issues Resolved
Issues Resolved
  • [JSV] Fixed Failed documents having the Failed flag cleared when re-processing (all document types)
  • [JSV] Fixed SOP Quote requesting customer details when submitting a prospect account
  • [JSV] Fixed Sales order not requesting customer account when submitting an order for a prospect account
  • [JSV] Fixed Sales order reporting ‘Cannot Find CRM Company’ when creating customer account to submit order created from Quote with a prospect account
  • [RB] Resolved an issue when performing an upgrade from a version 17 or earlier installation of WAP to a Version 19 or later version of WAP
    • Orders that were created or submitted prior to the upgrade, but approved after the upgrade would be created with all lines having “Confirmation not required” as confirmation intent in Sage
  • [RB] Resolved an issue on goods received screen which would allow users to receive items with a “Confirmation not required” confirmation intent
  • [RB] Resolved an error in the upgrade script which would cause installations to fail during initial installation
  • [RB] Fixed a display issue on Timesheet entry page where Pay Rate totals would incorrectly add 24 hours to the day’s total if there is an entry with an end time of midnight and Timesheet entry format is start and end time

Date applied: August 30, 2019

19.0.25

Issues Resolved
Issues Resolved
  • [RB] Fixed an issue with welcome emails where no email would be sent if more than one welcome email had been sent prior to the email thread performing the email sending had re-run
  • [RB] Resolved an issue where users would receive their welcome email multiple times
  • [JSV] Fix approval history tab showing orphaned line details for new documents
  • [NFS] Fixed an issue on the existing invoices screen where some of the quick links would now show credit notes
  • [RB] Resolved an issue when returning to orders search page after a previous search where the supplier selection would remain disabled while the supplier is selected
  • [RB] Resolved an issue when entering a new Requisition when system is configured to auto populate supplier from stack item, which would cause the first entered stock item not to be saved
  • [RB] Resolved an issue where expense line and mileage line imports would incorrectly fail validation due to Nominal account validation issues.
  • [RB] When attempting to import csv files, the error message will more clearly explain when the file couldn’t be read or is corrupt, rather than just stating that no import file has been selected
  • [JSV] Fixed timesheet submission reminders not always getting generated
  • [JSV] Fixed timesheet submission reminders not including the last full week
  • [JSV] HR processing checks HR enabled before processing
  • [NFS] Approval routes will now be deleted when a value band is deleted
  • [RB] Resolve issue on timesheet approval where a user would encounter an index out of range exception after clicking Reject All in the Timesheet Lines Tab

Date applied: August 28, 2019