WAP Help and User Guide – Invoices Module v17

1. Prerequisites - Sage 200

In the Sage 200 Purchase Ledger Settings, enable Purchase Invoice ‘Authorisation Required’ (Purchase Ledger – Utilities – Ledger Setup – Ledger Settings – Processing tab) and set a value at which purchase invoices require approval.

When you enter an invoice into the Purchase Ledger (directly or via Purchase Order Processing) that is over this value, the tick box is set by default to Requires Authorisation and the WAP Invoice. Approval Module will load the invoice.  This replaces the need to use the basic invoice authorisation process in Sage 200 Purchase Ledger but note that this function is still available, depending on whether the feature is enabled on the user’s Role.

When an invoice requires Authorisation, a query status ‘U’ will be applied to the transaction, and the values will not, at this point, post to the associated nominal code/s. We therefore recommend that an Unauthorised Payments  Balance Sheet Code is created and listed in the Nominal Ledger Default Accounts. The invoice value will then post to this Balance Sheet code until the invoice is authorised, at which point it will move from the BS Unauthorised Payment Code and post to the appropriate Nominal. Note: if this code is not set up and added to the Default Nominal Accounts, the value will initially post to the Suspense Account.  The transaction date will be taken from the Invoice date but the Invoice will post to the next available open Accounting Period.

Note: If required, a Reverse Journal, included in the WAP Addons module in Sage, can be run at month end to post the values of any outstanding unauthorised invoices to the appropriate P&L, month end reports can be run, and then the journal reversed to put these unauthorised invoices back to the Balance Sheet.

2. New Invoice

We recommend Sage 200 Users should continue to use the standard functionality within Sage Purchase Ledger and/or Sage POP, entering PL and PO invoices accordingly  The New Invoice  function within WAP is generally recommended for those customers who do not use Sage Commercials and who may be using WAP Requisitions module.

Select the New Invoice button within the Invoices Menu in the side menu:

Filter: Suppliers can be set up as approved suppliers in Sage PL using Sage 200 analysis codes with the supplier selection filtered by Approved, All Suppliers or the category values. For further information on setting up Approved Suppliers, please refer to the WAP Requisitions Help and User Guide.

Supplier: select the Supplier from the drop down list which is drawn through live from the Sage database.  Suppliers that are on hold in Sage will not appear in WAP.

WAP Reference: will be auto populated by WAP once the invoice is saved.

Document Date: will auto populate to the current date but can be changed if required.

Due Date: will auto populate in accordance with the Supplier’s payment terms on their PL Account.

Reference: free text box to enter the invoice number.

Second Reference: free text box, can be used to enter an additional reference, i.e. GRN if required. Alternatively, a system setting can be enabled to auto populate with the WAP reference once saved (System Setup – System Settings – Invoices)

Select Add a new Item and enter the free text description in the details box at the top of the page.  At this point it is also possible to change the Tax Code and add to the Narrative if required.

Select the appropriate Nominal Code from the drop down list or begin typing the account number or name; only codes that have been assigned to the User will appear on the list (see WAP User Setup Help and User Guide for further details).

Enter the total Goods Value and the Tax Value will be calculated automatically.

If Budget checking has been enabled, the details will be shown under the Budget Status and a detailed drilldown displayed by clicking on the budge link.

If a Costing module is enabled, an additional tab will show enabling the User to select the appropriate Job/Project and Job Header/Project Item.  The dropdown selection will only show those Jobs/Projects and Job Header/Project Items that have been allocated to the User.

The Approval Route tab will show the approval route for the document. Note: only if the User has the User Type permission to create Ad-hoc routes will they be able to edit this route; if not, the route will still be displayed but the Edit button disabled/greyed out.

Click Save to save the line to the invoice.

Note: the Invoice Line details box will remain on the screen ready to add further lines but when no further invoice lines are required, click Close.

Once the Invoice is created, the options are:

Save Only: this will allow the User to save the invoice before submitting, i.e. if extra lines or attachments need to be added before the invoice is submitted.  Once the invoice has been saved it will be given a WAP Reference number.

Save and Submit: will send the invoice for approval and depending on User Type permissions, the User may no longer be able to make amendments or delete the invoice.

Close: will close the invoice screen without making any changes.  Note; if the invoice has previously been saved, the invoice will remain on the system even if the page is closed.

Once submitted for approval, the Invoice can be seen on the Existing Invoices screen, with the Waiting for column populated with the Approver.

2.1. Attachments

2.2. Justification

Use this tab to enter any additional notes or information regarding this invoice that will then be visible to the approver (not the Supplier)

Note: if WAP analysis fields have been set up (System Settings – Analysis fields) these will be displayed and can be completed as required.

2.3. Approval History

This tab will only be populated once the Invoice has been submitted and progressed through the approval route.  Any rejections and edits that affect approval will be shown here. Note: lines that do not require approval will not be shown  eg Comment Lines.

A full approval history is therefore recorded.

3. Record PO Invoices

A Purchase Invoice that covers a single supplier and either one or many POs raised and approved in WAP can be recorded by selecting Record PO Invoice from the side menu.  This menu option will only appear if the User has User Type permission to enter PO invoices. We recommend PO invoices should only be recorded in WAP for those Sage 200 Users with no Commercials.

Select the appropriate Supplier and enter the Invoice Date and Reference. It is not necessary to enter the Goods and Tax Value at this point.

Select Find Orders to display all approved and outstanding POs from the chosen Supplier.

From the list displayed choose the appropriate PO/PO’s  that the invoice matches to and click Ok.

Select the PO lines and Goods Received Lines to which the invoice relates to. Note: if the invoice values differ from the PO line, edit the Qty to be Invoiced and or Unit Price on the appropriate line.

Once all details have been checked, the options are to Save and Submit the Invoice straight for approval, or to Save and Open the Invoice which will open up the document with a WAP reference, allowing the User to add Attachments ie. scanned invoice and add Justification notes as required, before submitting the Invoice for approval. Note: once the invoice has either been Saved and Opened or Saved and Submitted, this will then be linked to that Purchase Order/s which will be updated as invoiced.  If in any doubt, untick the lines and select Close.

4. New Credit

Credit notes can be entered into WAP following the same process as for Invoices detailed above.  The ability to enter credit notes is a User Type Permission and therefore certain Users may be able to enter invoices but not credit notes if required.

5. Batch Entry

Select Batch Entry from the side menu and complete the fields as required, using Update to save each batch line.

Once the batch is completed, the invoices can then either be Saved, Saved and Submitted or Closed.  Once submitted, the invoices will follow the configured approval routes and appear in the Submitted tab in Existing Invoices until approved.

6. Existing Invoices

Select Existing Invoices from the side menu to display invoices under the various stages:

New: Invoice has not yet been submitted – only invoices which are entered directly into WAP and have yet to be submitted for approval should appear.

Submitted: Invoice has items awaiting approval.

Approved: Invoice has been approved but not yet posted to Sage

Rejected: One or more items on the Invoice have been rejected

Completed: The Invoice has been posted to sage, or the query flag has been removed (depends

on where the invoice was entered)

Failed: The Invoice failed to post to sage. Please check Event Viewer.

Archived: Not currently possible for Invoices

Use the Quick Links option to display all Active Invoices/Credits, Invoices/Credits awaiting approval or fully approved.  Alternatively, the search option filters can be used to find a specific invoice.  Clicking Apply Filter will display all invoices that the User has permission to view.

Depending on User Type permissions, an Invoice can be viewed/edited.

Show Related Requisitions: only relates to invoices linked to a Purchase Order (see Record PO Invoice)  A pop-up displays the related Requisitions and Requisition lines.

Reset Lines: if a document has been submitted for approval, clicking this will reset all the lines back to the start of their approval routes.  This can be used if a change was made to the invoice or the approval routes.

Copy Invoice: will copy current invoice and create a new document, allowing the user to select a different supplier if required or copy current line details and create a Credit Note.

7. Approve Invoices

Invoices awaiting the User’s approval can either be accessed through the Approve Invoices menu option in the side menu or through the hyperlink on the User’s notification page. Note: the option to ‘Approve Selected Items’ shown in the screenshot below is a User Type permission and we would recommend that this would only be enabled for finance and senior members of staff.

Click on the Arrow next to an invoice line to view the invoice details.

If a scanned document has been electronically attached to the invoice either using Sicon DMS or Draycir Spindle in Sage 200, or the file document was attached to the invoice at point of entry into WAP, the first screen to appear will be the Attachments, enabling the Approver to view a copy of the Invoice.

Notes tab: will display any notes entered when the invoice was created (in WAP only), any  variance notes (see Automatic Invoice Approval) and if the Approver has the appropriate User Type permissions they can Edit or Add New Notes which would then be visible to other approvers in the route.

Budgets tab: If budget checking has been enabled in the System Settings  (System Setup – System Settings – Budgets) the information can be viewed under this tab; either against the Nominal and/or the Project/Job selected if a costing module is integrated.

Approval History tab:  an automatically populated audit trail detailing the approval process to date.

Lines Tab: Select the Lines tab to show the lines that require approval. If an invoice has multiple lines coded to separate nominal codes, it may be that they flow to other users for approval and therefore only the lines for this particular approver will be displayed.

Each line on the invoice can be approved individually, or the entire invoice approved by selecting Approve All . At this point, and if the Approver has the user type permission to amend/edit and invoice, if required select edit on the relevant line to change the nominal code (dropdown will only show those codes allocated to the User) and if Transaction Analysis Codes are enabled within Sage 200 these will be pulled through to WAP and can also be edited as required.

If further information is required and you wish to see the invoice in full,  click the View Details button to open up the invoice. This is particularly useful if the Approver needs to see the original Purchase Order. Select ‘Show Related Requisitions’ at the bottom of the screen to display the order and the order lines details.

Note: Please see section on Editing Invoices for further information regarding re-coding/re-submitting for approval, splitting lines and re-routing. 

7.1. Rejecting Invoices and Credit Notes

This functionality is to be used when the responsibility for the Invoice is not with the Approver and they need to send the invoice back to finance eg incorrect coding. Note: a pre-requisite is that ‘Rejected Invoices and Credits’ approval route needs to have been configured within Approval Route Setup – Approval Routes – Edit Default Approval Routes – Rejected Invoices and Credits and we would normally advise this is a member of the finance team.

When an Approver rejects an invoice or individual lines, a reason for the rejection needs to be entered before selecting the Reject button at the bottom of the page and the Invoice will then go to the User in the Reject Route.

The Approver in the reject route will receive a notification and it will then sit with them until they deal with the query as required eg. re-code and re-submit for approval by Editing the appropriate rejected line, Reset the Line, Save and Submit.

Note: Please see section on Editing Invoices for further information regarding re-coding/re-submitting for approval, splitting lines and re-routing. 

7.2. Holding an Invoice

This functionality is to be used when the responsibility for the Invoice approval remains with the Approver but there may be a query eg price, qty, service received. By placing On Hold, the document cannot be approved and is visible to Finance Teams in the Existing Invoices screen and in reports that the Approver is dealing with the document but there is a query.

To place an invoice on hold, the Approver should select the invoice awaiting approval in their queue, click on the Lines tab, enter a reason in the free text box and click Hold Invoice.

The invoice will now show as On Hold in the Existing Invoices screen and the reason visible by hovering on the blue information icon. Once the query has been answered and the invoice is accepted, the Approver would then take it off hold by selecting the invoice awaiting approval in their queue, click on the Lines tab, and select Unhold Invoice.

If a Credit Note is requested, once it arrives it should be entered into Sage or WAP and will be pulled through to appear in the Invoices and Credits awaiting approval. The Approver would then select the credit in the same way as an invoice, but when approving a credit note an extra ‘Invoices on Hold’ tab is available; this will show any invoices that are currently on hold within WAP for that particular Supplier.  Tick the select box to choose the relative invoice and then select the Action for Invoices:

Approve Invoices: When clicking ‘Approve Credit and Action Invoices’, both the Credit Note and the selected Invoice will be approved together.

Unhold Invoices: When selecting ‘Approve Credit and Action Invoices’, the Credit Note will be approved but the selected Invoice will only be taken off hold and remain in the list to be approved separately.

8. Editing Invoices

Amending an Invoice, whether it was originally entered into Sage and pulled through to WAP for approval or entered directly into WAP, is a User Type permission.  Users can select Edit on the Existing Invoices screen.

In addition, if an Approver has permission to edit/amend and invoice, they can select View Details on the approval screen to open up the invoice for editing.

The invoice will open up and lines can then be edited as required.

8.1. Editing the Job/Project Selection

When a PO Invoice is recorded in Sage, the Job/Project will be populated from the relative PO. Once this invoice is pulled through to WAP for approval, it is not possible to change the Job/Project or the Job Header/Project Item as this would lead to issues with the purchasing commitment not matching correctly to the actual purchasing costs already recorded on the Job/Project. However, if the PO Invoice is linked to the N/A job (Sicon Job Costing), it is then possible to change the Job.

When a PO Invoice is recorded in WAP, you should still be able to change the Job/Project until it’s authorised, depending on User Type permissions (Costing tab).

On the invoice that you are editing, select the Project Analysis tab, Edit a line and this will bring up the option to change the Job/Project as required.

At this point, if the invoice needs to be sent back for approval based on the Job/Project selection, select Reset Line (if only an individual line have been changed) or Reset Lines at bottom of page (to send all lines on the invoice back through for approval) and Save and Submit.

Alternatively, if the Job/Project  is being editing during the Approval process, the approver can Approve Lines.

8.2. Editing the Nominal Selection and Re-routing

On the invoice that you are editing, select the Nominal Analysis tab, Edit a line and select the pencil icon. Note: if the invoice is already linked to a Project/Job other than N/A, it will not be possible to edit the nominal as it has already allocated to a transaction.

This will bring up the option to change the nominal as required.

At this point, if the invoice needs to be sent back for approval based on the new nominal selection, select Reset Line (if only an individual line have been changed) or Reset Lines at bottom of page (to send all lines on the invoice back through for approval) and Save and Submit.

Alternatively, if the nominal is being editing during the Approval process, the approver can Approve Lines.

8.3. Split Lines on an Invoice

On the invoice that you are editing, select the Nominal Analysis tab, Edit a line and select the Split Lines icon. Note: if the invoice is already linked to a Project/Job other than N/A, it will not be possible to split the line as it is already allocated to a transaction.

The line will split out to equal values but at this point it is then possible to edit each line to the appropriate nominal and value as required.

At this point, if the invoice needs to be sent back for approval based on the new nominal selection, Reset Lines at bottom of page (to send all lines on the invoice back through for approval) and Save and Submit.

Alternatively, if the nominal is being editing during the Approval process, the approver can Approve Lines.

8.4. Re-routing an Invoice (Ad-Hoc Approval Route)

On the invoice that you are editing, select the Nominal Analysis tab, Edit a line and select the ‘Edit the Approval Route for this item’ icon.

Note: only users with the User Type Permission to create Ad-Hoc Approval Routes will be able to re-route the Invoice and the route selected will apply to this document only.

The current route will be visible and can then be edited as required. The Invoice will then need to be Saved and Submitted for approval.

8.5. Deleting Invoices

Invoices can be deleted from WAP if a User has the appropriate User Type permissions. However,  this would be mainly applicable to invoices entered directly into WAP incorrectly; be aware that if this was a PO invoice, the PO would already have been marked as invoiced and further invoices could not be recorded against it. If the invoice was entered in Sage 200, deleting the invoice in WAP will only delete the document in WAP (not Sage 200) with that particular reference and the WAP service will pick up that unauthorised invoice again from Sage to push through to WAP for approval but with a new WAP reference. If in any circumstances the Invoice is authorised directly in Sage 200, the query status U would be removed and the WAP service would therefore not pick the invoice up and this should then disappear from the list in WAP. If not, the delete function in WAP can be used.

9. Automatic Invoice Approval

The WAP system has been developed with three settings regarding approving invoices to purchase orders.  Note; only one of the below settings can be enabled.  If any of these settings are changed, please restart the WAP service once saved to ensure the service uses the new configuration.

9.1. Automatically approve invoices that are linked to Purchase Orders

This option allows for the auto approval of an invoice that is linked to a related requisition (irrespective of value and quantity) and we therefore strongly advise that it is used in conjunction with the variance checking option ‘Check for variance when auto approving invoices’ with variance preferences detailed below.  If an invoice fails the variance check it will not be automatically approved but will be pulled through into WAP and will follow the pre-configured invoice approval routes.  The approver will see a post-it note icon against the invoice on the approval screen which will show the variance detail.

• Check the invoiced quantity matches the Goods Received quantity: If three way matching is enabled in Sage POP, the invoiced quantity will be checked against the goods received quantity.
• Check the invoice line values compared to the Purchase Order line: If this setting is enabled the gross value of the invoice line will be checked with the gross value of the requisition line it is being matched to; i.e. if a line has been part goods received and part invoiced, the invoice will still require approval as the invoice line total does not match the original order line total.  Therefore if three way matching and/or part invoicing is used, it would not be recommended to enable this option.  Only use this setting if two way matching or orders are normally invoiced in full.
• Check the invoice line unit prices compared to the purchase order line: This setting will check unit prices on the invoice line against the unit prices on the order line.  If this setting is enabled, a line that has been part received and part invoiced would not require approval unless the invoice unit value was different to the unit value on the purchase order.
• Check invoice variance by percent? Enable to check variance by a percentage and enter an appropriate percentage value; e.g. 2% on ‘Invoice line total value variance percentage with purchase order line’.  The percent and value checks can be used together; i.e. to approve if under 2% and under £10 will be approved but if under £10 but over 2%, the invoice will require approval.
• Check invoice variance by value? Enable to check variance by a value and enter an appropriate value, i.e. £10 on ‘Invoice line total value variance value with purchase order line in WAP base currency’.  The percent and value checks can be used together; i.e. to approve if under 2% and under £10 will be approved but if under 2% but over £10, the invoice will require approval.
• Automatically approve if invoice line is less than the purchase order line: this option can be enabled if it is company policy that if an invoice is received and is less than the purchase order, it won’t require approval.

When an invoice is entered in Sage against a PO, certain information must be recorded on the first Record Purchase Invoice screen.

Enter an invoice date and reference number.  If the values (either the price or the quantity) on the invoice differs from the value on the purchase order, they must be changed on the order line (as highlighted below).  When the invoice is pulled into WAP by the WAP service to be checked against the PO, the data on this screen is analysed, so if there is no invoice reference number or the values match the order and goods received quantities, the invoice will not require approval in WAP.

9.2. Invoices Linked to Requisitions should be Approved by the Requisition Requestor

This option generates a custom approval route for each invoice that is linked to a requisition; the route will contain only the user who raised the requisition in WAP and will not follow the pre-configured standard approval route.  If this option is required, it would be recommended each user who could approve an invoice is given an unlimited approval value otherwise the invoice could get stuck with no approvers.  N.B. this setting is only for invoices entered into Sage 200.

9.3. All Invoices Require Approval

Enable this option if no auto approval is permitted and all invoices entered into Sage 200 and picked up by WAP, or entered directly into WAP, require authorisation through the standard configured approval routes created for invoices.

10. Reports

The Invoice Approval Report (select Reports from the side menu) shows a breakdown per Sage Company for a specified date range, all invoices and values, their approval status, and approval history.

The highly configurable report functionality within WAP provides the Invoice report structure which can be customised to your requirements.  The data can be grouped by dragging column headings to the header bar as well as adding/removing fields by customising the report with the Field Chooser (click the Customise button for the Field Chooser to appear once you have run the report ).  If required, the reports can also be exported to Excel or as a .pdf document.

Note:  as the report is Cookie based you will need to ensure the browser settings allow Cookies from the WAP website to retain any changes you have made to a customised report.

11. Settings

System Settings relating to the Invoice module are accessed in System Setup – System Settings – Invoices.

Allow duplicate Transaction References: if Invoices require editing once they are in the WAP system eg nominal code change, this setting will need to be enabled.

Require Invoices to be recorded by matching to a Goods Received note: applicable to Invoices entered directly into WAP only.

Require Expected Invoice Values to Match Actual values when recording Invoices: applicable to Invoices entered directly into WAP only.

Automatically populate the second reference with the WAP Invoice ID: the WAP document ID will be populated on the second reference for invoices entered into Sage or directly into WAP.

Approve Invoices ‘Select all’ check box selects all items on the current page (off selects all items on all pages):  within User Type permissions (General Tab) there is a permission to ‘Use ‘Approve Selected’ option on approval pages’ which allows users the option to select multiple documents to approve at once, rather than approving each document individually. However, if there is more than one page of Invoices to approve, if this setting is enabled, the Select All will only select all items on the current pages, preventing users from accidently approving all items on all pages without checking the invoices on subsequent pages.

Display Allocated (Paid) Status: the status of the Invoice in Sage (Unpaid/Allocated/Paid) will display in the Status column on the Existing Invoices page in WAP.

Automatically Load Existing Invoices on Page Load: when ticked, all Invoices under all headers will be loaded automatically. If un-ticked, the Search and Quick Links can be used to display  the invoices as required.

Validate a Sage accounting period exists for the Invoice Transaction Date:  when ticked, the system will validate whether the accounting period exists when saving / submitting an invoice.

Restrict Invoice Line Date Entry: applicable to Invoices entered directly into WAP only.

When Placing Invoices on Hold:  notifications can be sent as required to previous approvers/current approvers/future approvers to advise invoice has been placed on hold.

12. User Type Permissions

13. WAP Addons

When WAP is installed, Sicon also install a Sage Add-on module called WAP Addons.  This additional set of features for Sage 200 help provide some additional analysis and processing for invoices and month end routines in Sage 200 when used in conjunction Sicon WAP.

Please refer to the WAP Addons Help and User Guide for further information.

13.1. Authorised Nominals

If certain nominal codes do not require approval in WAP, these can be added under Authorised Nominals.  Invoices are input against Suppliers or POs as normal, the invoice will not be flagged as unauthorised and will not be pulled through to WAP for approval

13.2. WAP Invoice Extra Fields

This setting will allow an alternate approver to be selected when posting the invoice and also allow notes to be added that will be pulled through to WAP.

13.3. Imported Invoices Do Not Require Authorisation

This functionality will set imported invoices to be marked as Unauthorised and will not be pulled through to WAP for approval.

13.4. Stop Unauthorised Invoices Being Unticked

Once the PL setting “Requires Authorisation” is switched on/enabled in Sage 200, all purchase invoices entered of any value will set the ‘requires authorisation’ check box on the purchase invoice entry screen to be checked by default and disabled/greyed out. All invoices will be posted to the balance sheet unauthorised purchase invoice control account and be pulled through to WAP for approval. Configuring this setting in WAP Addons to be True, the ‘Requires Authorisation’ check box will be unticked by default and will need to be checked when an invoice needs to be sent to WAP for approval. Note: it is important that the standard Sage setting in Purchase Ledger for the value that ‘Requires Authorisation’ is set high enough. If an invoice is entered above the value entered the user will not be able to uncheck the box and the invoice will be sent to WAP for approval.
In summary, we recommend this setting is therefore only used when the WAP invoice approval system is first used and only some invoices should be sent to WAP and the rest should not require authorisation but once the system is fully operational and the Company requires all invoices to be approved, disable the setting.

13.5. WAP Connection String

If invoices are input into WAP rather than Sage 200 (i.e. if Sage Commercials has not been installed), enter the WAP Connection string to configure a new tab on PL Supplier Transaction Enquiry to show all Pending Invoices that are awaiting approval in WAP.  This is to show the balances that will be posting through once approved.

13.6. Self-reversing Journal - for Unauthorised Invoices

If Invoices have not been approved by month end,  this can leave a value on the balance sheet that typically needs to be moved to the profit and loss or balance sheet accounts that they were coded to for month end reporting. The self-reversing journal routine picks up all unauthorised invoices up to a specified date and allows them to be posted to the nominal code they were originally coded to.  A self-reversing journal is automatically created for the following period to enable the authorisation process to continue. The self-reversing journal created is put on hold by default so that it can be amended by the Finance team before posting to the nominal ledger.

13.7. POP Order Return Accrual

There are four additional reports in the WAP Addon, two covering disputed invoices and two covering standard purchase order accruals.  These reports allow the accruals to be analysed and grouped by Nominal Code or Purchase Order and provide additional analysis to that already provided within Sage 200.

14. Enable Module

Each year your WAP system will require a new enable string to continue working.  When the new one has been issued, select System Settings – Misc – Licencing.

NB: for your information, the module expiry date is shown along with the modules that have been enabled and the maximum number of users.

15.

16. New Features & Important Information

16.1. Sicon v21.1

16.2. Sicon v21

16.3. Sicon v20.1

16.4. Sicon v20

16.5. Sicon v19.2

16.6. Sicon v19.1

16.7. Sicon v19

16.8. Sicon v18

New Features:

• A Redesigned Default Expense Voucher and Default Categorised Expense Voucher Report to include Pay Code as a
• To view these, you may need to delete your existing report and refresh (if there are no report customisations or you do not need to keep the customisations) or add the field manually in design view.
• Added ability to disable posting of Mileage- or Expense Item Lines on a per user These lines need to be processed separately using the Expense Payroll Posting functionality. This is a User Type permission.
• Added ability to book off jobs on time and attendance screens by scanning a
• Added popup to TA screen for quantity complete (works orders) when booking off a
• Booking off all jobs on TA screen asks if you want to set all the Qty completed to the total amount for any works orders in the
• Logging out of TA screen will warn if there are any works orders that need a Qty set before logging off.
• Initial list of Job costing headers are filtered by a setting on the Job (in)
• Quantity complete and operation ID posting to works
• Added Goods received approval A new entry will be created each time goods are received against an item.
• Added Goods fully received approval A new entry will be created each time an item is fully received. The entry will indicate whether it was part of a final receipt.
• Added Order Goods Fully Received approval A new entry will be created once an entire Order is fully received. o Added a Goods Fully received notification. A new notification will be generated when an Order has been fully received. o Added a Goods Received Amended approval history. A new entry will be created each time a receipt line is amended. o Added Job costing user import page.
• Added new costing popup to rapid timesheet Allow selection of job, variation, item, phases and stages from a single control.
• Allow invoice lines to be split by invoice editors as well as
• Added the ability to split expense lines that were created by Credit Card Statement Once a line is split, it can only be submitted if the total for the statement line still matches up. If a split line is deleted the value will be added back to the original line regardless of changes to the expense line such as expense type or nominal
• Added ability to configure a Nominal per line on Order Setting this nominal will override the default nominal set from the Stock/Warehouse.
• Added ability to export the imported statement result grid of Credit Card Statement
• Added Line Numbers to all document types, reports and approval history
• Added a popup keypad to the book off works order quantity control to allow easier editing of
• Changed standard timesheet entry to allow editing of JC and WO time that has been posted to sage when the timesheet is submitted.
• New user popup to collect initial details and validate before Existing user can be used as a template to create new users.
• Added a new feature to determine whether machine time appears on the Book on job control for operations
• Added a new popup keypad control on TA
• Added the ability to pick the finished works order quantity by
• The operation name will be shown in addition to the operation description on the touch screen terminals
• Works Order transactions posted to sage will now have the start and end date set.
• Added new theme ‘R18Dark’
• Added button to show cleared system messages
• Added Quotes User type settings
• Added Quotes menu
• Added Quote screens and approval
• If default supplier contact doesn’t exist or the contact has no telephone or fax number, it will be populated from the supplier
• Added a column to invoice approval report for Sage user name for invoices generated in
• Added a new approval history type for when items restart an approval route to distinguish from items that are sent for approval the first
• Added User Self Approval Values to User Approval Values
• Added Setting to include Sage Company in The setting is off by default and can be found in the Misc Tab of System Settings under the Notifications section.
• Added “Allow previous approvers” columns to approval route import
• When selecting a stock item on an order line it will now drop down the warehouse comobox if there is not a value selected
• Added the ability to specify the first cut-off rate when adding a rate change for fuel rates
• Added ability to record low level auditing of database field changes to Order and Order Line The setting is enabled by default and can be disabled in the Misc Settings logging section
• Added an Audit History Tab to Order
• Added Line summary text to existing holiday request
• Added ability to record low level auditing of database field changes to Timesheet and Timesheet Line
• Added setting to hide “Remember Me” option on the Log in
• Auditing of new document and document item creation added.
• Added Date filter to Audit History
• Added Audit History to User
• Added Separate Audit Tab to System
• Added the ability to export approval routes to
• Added the ability to export user nominal values on the import user nominals
• Added option to set default tax rate of order line free text and charge item to be set from the Supplier’s default rate on page
• Added option to set default tax rate of sales order line free text and charge item to be set from the Customer’s default rate on page
• Added Audit Log type to record when an order gets a PO Number allocated from
• Added option to nominal allocations import to maintain or delete existing records.
• Added the ability to see stock item images on sales and purchase order stock line
• Added Business Units column to Timesheet Projects
• Changed all instances of report user selection filters to read “My Delegates” and “My Business Unit(s)” rather than “Delegates” and “Business Unit”.
• Moved the job / barcode search text box on the time and attendance dashboard to the top of the page, it’s now used to book on and book off
• Added an additional popup when booking on to a job to show the job / works order / operation
• Added the ability to view the works order finished item image when booking onto a job from the touch screen
• Added a hover over on the description for stock lines on requisition entry to show the amended
• Load thumbnail for attachment and use zoomable image control to view on approve expenses
• Added the ability to reset the route for all lines on Expense
• Added the ability to reset the route for all lines on Sales Order
• Added the ability to reset the route for all lines on Proposed Payment Entry.
• Added the ability to reset the route for all lines on Timesheet
• Added a status flag to the operation details popup to show if the operation is complete or
• Changed the job and item selection control to load the job analysis labels from JC
• Operation Comments are now scrollable on the time and attendance
• Added a warning to the book off job control if the entered quantity is more than the outstanding qty.
• Added a warning to the book off job control if the entered finished item quantity is more than the Works order
• Added the ability to specify the finished item quantity to book into stock on the final
• Changed the TA login screen to not show the keypad if it’s not a touch screen
• Changed the TA dashboard page to not show popup keyboards when not at a touch screen location.
• Order Line entry now supports selecting Confirmation
• Majority of reports will now have a link on the report lines to redirect a user directly to the relevant document entry
• Users will now be given a notification when booking time on the same day as time already approved as holiday on the current timesheet.
• Added ability to include leavers in Search page user
• The Time and attendance dashboard screen will now always focus on the project code / barcode box when the page loads (even after post )
• Changed WAP to check the quantity outstanding in WAP on operations that have not been sent to sage
• Added Job Manager to the job costing selection control.
• Added a banner at the bottom of the settings page as a note the WAP service may need a restart after changing
• Changed the book off job control to focus the cursor on the quantity box when it
• Added Proposed Payments functionality
• (WAP Add-on) Changed the Generate payments screen to check whether there is an unapproved proposed payment in WAP and stop generation if it’s not
• Added the ability in the WAP add-on to use the WAP objects
• Improved the readability of Audit History page by displaying user friendly properly values when auditing only record related IDs, such as costing Header
• Proposed payments generated in sage will now complete the payment in
• Added ability to submit holiday requests from time and attendance o Added ability to submit holiday requests from time and attendance screens. o Added All Sales Order Lines Report.
• Implemented Analysis code support for Sales Analysis codes can now have custom labels and be configured to display or hide in approval reports and Sales Order search page and be searchable in Sales Order page.
• Added Audit History for User Type Edit
• Added ability to add Justification Value bands to This allows specification of a minimum amount of attachments required to submit a requisition based on requisition value. This functionality can be configured by a System Account user through the System Settings page under the Requisitions tab.
• When MRP orders are now picked up by WAP the nominal account will be taken from the job Header if
• Added a file viewer to the view proposed payment
• Added the ability to view DMS attachments from the invoices on the approve proposed payments
• Added Requisition Quote
• Setting added to determine whether to show the Book In finished item quantity box on the book off job control
• Added ability to import Requisitions from User Types need to be granted permission to import Requisitions. Contact your Business Partner/Sicon if you wish to enable this feature
• Sales Order attachments will now be added to DMS if integration is enabled
• Requisition attachments will now be added to DMS if integration is enabled
• Requisition Justification documents will now be added to DMS if integration is enabled
• Added a “Justification” tab to sales order and moved the file attachment control to the tab so users won’t have to enable viewing additional information to perform file attachments
• Made it clearer on Expense Line entry which lines are split from an original line with row highlighting
• Users will no longer be able to select nominal accounts that aren’t posting accounts on order line entry

Important Information

v17.534.0.10

• Added an analysis code to the Expense Meeting Entity for reporting purposes.
• Added the ability to determine whether subsistence can be claimed per user. v17.558.0.126
• Added a setting to determine whether client files are synchronised in the service configuration. v17.571.0.168
• After this upgrade, existing PO reports will have to be deleted and refreshed to get the new call-off orders reports. If there are customisations to original reports, these will be lost through this process so is optional.

v17.588.0.256 Database changes

• SiWorksOrderLineID added to TimesheetLine Table
• SiWorksOrderLineID added to JobActivity Table

v17.601.25.0

• All taken, Submitted and Booked holiday hours will now be calculated dynamically rather than stored in the database, this way it will be impossible to get out of sync with the totals for holiday requests in the database.
• Added SQL server client tools as a pre-requisite on the installer for sites that force TLS 1.2 security due to windows update.

v17.605.28.5

• Latest version of Job Costing will be required to address an issue with changing jobs for lines that already have receipts recorded.

v17.607.30.0

• ‘Rework’ column added to JobActivity table.
• Rework column added to TimesheetLine table. v17.590.0.270
• Changed the WAP service and installers to no longer deploy sage assemblies and instead copy them from the sage server folder when it starts.
• Database change: Added SOPMandatoryAnalysisBehaviour setting.
• The SOP analysis codes and mandatory analysis behaviour need to be configured in WAP system settings to validate the analysis codes as required.

v17.608.31.1

• WOFinishedItemQuantity added to JobActivity table.
• WOFinishedItemQuantity added to TimesheetLineTable table. v17.609.32.1
• Changed the WAP service and installers to no longer deploy sage assemblies and instead copy them from the sage server folder when it starts.

v17.611.33.0

• The SOP analysis codes and mandatory analysis behaviour need to be configured in WAP system settings to validate the analysis codes as required.

v17.613.34.1

• To view the Sales Order Lines report, the user type needs to be allocated the View Sales Order Reports permission.

V17.618.36.0

• InvoiceID Added to ProposedPaymentLine table.

V17.618.37.0

• In order to use Quote Requests, the report needs to be configured for each Sage Connection and the user type needs permission to print quotes.
• Added Columns [QuoteRequestPrinted] and [QuoteRequestEmailed] columns to Order table.
• Added [QuoteRequestReport] column to SageDatabase table.
• Added [CanPrintQuoteRequests] column to UserType table.

V17.590.0.275

• The exchange rate between the two currencies need to be configured in both the base currency database and the document database. Differences between these two could lead to issues with approval value conversion.

[Last Important Information August 20, 2018.]