New Sage 50 Construction Features
What’s new guide – Sage 50 & 200 Construction v2011
Sage 50 & 200 Construction 2011 (v15) are scheduled to launch in August 2011. The latest version has been revamped to improve usability of the product and enhance the look and feel, so it’s easier to use. This follows the update to the Client Billing User Interface in recent years and in this version we have improved the processing of purchase documents to follow suit. These updates tie in with our core strategy and link in with the key themes of improving usability and information management.
Enhancements to individual purchase areas
All Purchase forms now have buttons and transaction entry is made via tabbed dialogue boxes. New buttons have been added and some menu items have been removed and added to the input screens. New document messages are shown and highlighted in orange or red at various levels of the transaction entry screens.
Status indicators include:
• Account on hold
• Cannot modify checked invoices
• Certificate printed
• CIS verification required
• Contract complete
• Document posted
• Document status = complete
• Max retention exceeded
• P/order status = complete
This means a much more flexible and user friendly system, which provides:
• Simplified processing
• Improved menu structure (easier to find what you need)
• Status indicators provide important information to the user about Contracts, Documents, Users, Suppliers or Subcontractors.
Purchase orders:
• Copy button: allows the user to copy another document of the same type
• Reverse button: allows the user to create a reversing document from one selected, e.g. this button will create a Return note from a selected Purchase order.
• Complete button: allows the user to easily set and unset the Complete status at document level
• Print button at detail level: allows the user to print the document when creating detail lines
• Auto generate check box: available by Contract at header level. This will enable the user to easily generate a document for all variation items against the supplier selected. Selecting this will also activate an Auto tab where the user can select various options to generate the document
• Stock tab at detail level (when linked to Sage 200 but not the Sage 50 Accounts range): shows the user the location of a stock item
• Summary tab at detail level: summarises information of the complete transaction
Deliveries:
• Reverse button: allowing the user to create a reversing document of a selected one
• Auto generate check box: available by Purchase order at header level. This will enable the user to generate a document for undelivered items against the order selected, please note you do not need the PO functionality from Sage 50 Accounts Professional to use them in Sager 50 Construction.
• Print button at detail level: allowing the user to print the document when creating detail lines
• Stock tab at detail level (when linked to Sage 200 but not Sage 50 Accounts): shows the user the location of a stock item
• Summary tab at detail level: summarises information of the complete transaction
Work orders:
• Auto generate check box: available by Contract at header level. This will enable the user to easily generate a document for all variation items against the supplier selected. Selecting this will also activate an Auto tab where the user can select various options to generate the document
• Print button at detail level: allows the user to print the document when creating detail lines
• Stock tab (when linked to Sage 200 but not Sage 50): shows the user the location of a stock item
• Summary tab at detail level: summarises information of the complete transaction
Purchase invoices:
• Copy button: allows the user to copy another document of the same type
• Reverse button: available for Invoices & Credit notes – allows the user to create a reversing document from one selected, e.g. this button will create a Credit Note from a selected Invoice.
• Check button: enables the user with the required status to easily check or uncheck the document to allow posting
• Auto generate check box: available by Purchase order at header level. This will enable the user to generate a document for items against the Purchase order selected
• Release button at detail level: allows the user to release retention on posted Invoices on items with outstanding retention
• Print button at detail level: allows the user to print the document when creating detail lines
• Deductions tab: shows information
• Stock tab at detail level (when linked to Sage 200): shows the user the location of a stock item
• Summary tab at detail level: summarises information of the complete transaction
Nominal transactions:
• Copy button: allows the user to copy another document of the same type
• Reverse button: available for Bank transactions (when linked to Sage 200) – allows the user to create a reversing document from one selected, e.g. this button will create a Payment from a selected Receipt.
• Print button at detail level: allows the user to print the document when creating detail lines
• Stock tab at detail level (when linked to Sage 200): shows the user the location of a stock item
• Summary tab at detail level: summarises information of the complete transaction
Timesheets:
• Copy button: allows the user to copy another document of the same type
• Hold button: allows the user to place the timesheet on hold to prevent posting
• Print button at detail level: allows the user to print the document when creating detail lines
• Stock tab at detail level (when linked to Sage 200): shows the user the location of a stock item
• Summary tab at detail level: summarises information of the complete transaction
Over three hundred fields have been increased in size to allow input of more characters.
Main areas affected are address and contact fields and posting reference fields which are now bought in line with the accounting systems.
Reports and layouts have been altered to reflect the new field sizes.
Other key fields are:
• Line type – now 10 characters
• Item reference - now 30 characters
• Unit of measure – now 10 characters
Therefore contact and posting reference fields: Data passed between Construction and the accounting system will no longer risk being truncated due to smaller field sizes in Construction. Line type, item reference and unit of measure fields: The increase in these field sizes means the references can be more detailed to aid clarity and improve reporting.
In January 2012, the Irish RCT scheme will change to include a new tax rate of 20% in addition to the existing rate of 35%. New fields on the HMRC/RCT tab (within Accounts parameters) have been introduced to allow the entry of the new tax rate. Within S/C Data, a new CIS type “R” has been added to represent the reduced tax rate. The calculation of tax on a purchase document will be based on these two fields being changed accordingly.
Compliance with the new RCT tax scheme being introduced by the Revenue from January 2012.
Valuation detail line totals are now calculated by applying the percentage uplift to the quantity field and then multiplying the new quantity by the estimated rate to get the line total. Previously Construction applied the percentage uplift to the line total and then divided this by the estimated rate to get a new quantity, resulting
in rounding errors in the quantity field because the line total is only stored to two decimal places. When a valuation has been calculated Construction will identify all top level printable composites where rate * quantity does not
equal the line total. For these composites it will apply a rounding adjustment to items within the composite in order to make the composite total equal rate * quantity. This means that the rounding adjustment applied at document
or sub-valuation level has to exclude items contained within any composite (not just top level printable composites) to prevent the introduction of more rounding errors in top level printable composites. If there are no items outside of a composite then Construction will not be able to perform document/sub-valuation level rounding If the user has made an amendment at section or composite level then this rounding adjustment will only be performed on items
contained within the section or composite. A top level printable composite is defined a composite not contained within another composite that has its print flag set. Note that composite rounding is only performed if the contract
option flags have been set so that recharge composite total = rate * quantity. If composite rounding is disabled then rounding adjustments applied at document and/or sub-valuation level can be applied to any item on the document which includes items contained within a top level printable composite.
Quantity Rounding: When applying percentage uplifts to client billing documents the quantity will now show a more sensible rounded number i.e. adding a 10% uplift to a line with quantity of 5 will produce 5.5 rather than, for example, 4.9999.
Composite Rounding: Composite line totals will now be rounded to the expected value of unit rate multiplied by quantity.
When generating a new sales document or amending an existing one, the VAT total for the document is calculated by summing the VAT of all the individual detail lines. This can cause rounding errors as the line total for VAT is stored to 2 decimal places. To solve this Construction now sums the VAT on all the detail lines and compares this to the net total x VAT rate on the document header. If the two differ then the difference will be applied as a rounding adjustment in the same way as the document gets adjusted for net, discount and retention.To utilise VAT rounding a new flag has been introduced within System Parameters>Job Costing “Include VAT in rounding” which must be checked. Note that rounding can also be disabled when creating or amending a sales document by selecting the “Don’t apply rounding adjustments” flag in the advanced screen. The rounding will occur when creating or amending documents headers or when amending the details or sections of a document. If a single variation, VAT rounding will be performed when the user returns to the document list, if a multi variation then it will occur when returning to the sub-valuations list.
Rounding will only be applied if there is just one VAT code in use. Note that if creating a sub valuation then the one VAT code restriction will apply just to the sub-valuation being created or amended.
Sales documents will print with the expected VAT total without rounding errors. Previously a sales document with lots of items on it that had a total of £600 might have had a VAT value of £119.99 Now the VAT will be rounded to £120.00
A new Clients workspace has been created that will work on the Sage 200 Mobile solution. This workspace can be used as a starting point for anyone wishing to create their own Construction mobile workspaces and utilises two new queries that return a smaller amount of data, in order to be compatible with the mobile solution The existing content parts have also been modified so that they will work on the mobile solution. Please refer to the Sage 200 Mobile Setup Guide, located on the Sage 200 DVD on steps required to install the Sage 200 mobile solution. In line with improvements that have been made in the Sage 200 client, we have increased the speed of our existing workspaces.
Various improvements have been made to the way the Construction features and targets are seen from within
the Sage 200 SA tool; the Construction workspaces are now accessed through their own feature group. Also the “by document” orphaned workspace only features are now available within the appropriate documents type feature group. Finally, if no Day Works features are enabled for a role within the SA tool, the appropriate users will no longer
see an empty Day Works stack bar item from within the Sage 200 Client.
Enables you to set up your own personalised Construction workspace and access critical business information on the move. Smarter, faster access to information anywhere, anytime. Allows easier analysis of data.

