HISTORY OF CHANGES

Sage Pastel Evolution

Release Date: 9/02/2007
Type: Maintenance/Payroll Feature Release

Accounting

SUGGESTIONS IMPLEMENTED

ACCOUNTS RECEIVABLE

AR | Maintenance | Volume Discounts
Foreign currency prices have been implemented into Volume Discounts.

AR | Maintenance | Balance Relink
When running the age analysis on AR or AP and you receive a message stating that there are invalid allocations, you can run the relink and this will recalculate the unallocated amounts correctly. This will not fix a true-invalid allocation.

AR | Reports | Allocations
• Full Credit and Debit amounts as well as the outstanding Debit and Credit amounts have been added for the user to customise the report.
• An option has been added to Show Grand Totals on the last page.

AR | Reports | Statement
An option has been added to show zero transactions on the Statement.

COMMON

Common | EFTS File Layouts | NedInform
A new Nedbank layout has been added. This is the Nedinform layout which is a text file.

CONTACT MANAGEMENT

CM | Maintenance | Contract
The Contract Number field has been increased to 40 characters.

GENERAL LEDGER

GL | Maintenance | Accounts
Additional General Ledger Account Types have been added to allow for more flexibility for reporting purposes.

GL | Transactions | Cashbook/Journal
An option has been added to save the grid on Cashbooks and Journal batches.
A save grid option has also been added within the batch to save the lines of the batch.

GL | Transactions | Cashbooks
When processing a payment to a foreign supplier from the cashbook, the foreign amount displayed as a credit instead of a debit value. This has now been corrected to display the foreign payment as a debit value.

GL | Transactions | Bank Reconciliation
An option has been added to the bank reconciliation to allow the user to reconcile in foreign values.

GL | Transactions | Cashbook Batches
Before posting a cashbook, a validation will be done to check for the Tax Account and Tax Amount.

GL | Reports | Bank Reconciliation Report
An option has been added to print the Subtotal on the Bank Reconciliation Report.

GL | Reports | Income Statement
A checkbox option has been added on Income Statement to print, if there is a budget value.

INVENTORY

IC | Transactions | GRV
When processing a supplier invoice and when the stock has already been received the user will be allowed to add GL/Financial Lines.

IC | Transactions | Documents
• Unit cost of a service item will pull through from a GRV or Purchase Order onto a Job.
• A default option for templates has been added to File | View | Options.

A new feature has been added called ‘Template Pricing’ with the following two options:
1. Update Prices when Invoicing.
2. Use Fixed Prices.

Selecting the relevant option will default the template pricing for each document type.

INSTALL

Pastel Evolution Installation
The installation of Sage Pastel Evolution for workstation and server no longer supports SQL Server Version 7 and now only supports Version 2000 and higher.

MAINTENANCE

ACCOUNTS RECEIVABLE

AR | Maintenance | Customers
When adding a new contact person/s, the button next to the Physical Address allows you to copy from Postal Address etc.

AR | Maintenance | Delivery Address Codes
When a delivery address is deleted the delivery address code is not deleted.

AR | Maintenance | Sales Representatives
If a sales representative in ‘on hold’ transactions will no longer be posted against this sales representative.

AR | Reports | Age Analysis
• The summary report and detail report will print the same.
• The summary report and detail report will now print correctly when using the ‘date of statement’ option.
• The report will print correctly according to your ageing period’s setup in defaults when using the ‘date of statement’ option.
• The age analysis can be customised with the last credit amount and last credit date.
• When setting your periods to the 15th or the 25th of the month instead of the end of the month the report will age correctly.

AR | Reports | Statement
The following has been changed:
From ‘Brought forward from page X’ to ‘Brought Forward from Previous Page’ on statements.

AR | Reports | Volume Discount Contract
• The Group and Item code can be added and viewed on the Volume Discount Contract Report.
• When discount contracts and price contracts have been setup the report will print the contracts correctly to state if it’s a discount or price.

AR | Reports | Representative Commission Report
The Sales Representative commission report did not include the credit notes on the detailed report as part of the calculation. This has now been corrected.

AR | Maintenance | Balance Re-link
When running the balance re-link feature for customer accounts that have large payment values allocated against several invoices could cause the allocations to be lost. This would result in the account having to be re-allocated. This has been corrected.

ACCOUNTS PAYABLE
AP | Transactions | Automatic Payments and Remittances

• The automatic payments and remittances have been optimised to work much faster.
• When the lookup field is set to Name, your criteria for Automatic Payments and Remittances will filter correctly.
• Previously when creating an EFTS with more than 1 customer it printed the last line only, now all lines will be printed.
• The Discount Total Amount is printed correctly on the Remittances when running the Automatic Payments and Remittances.

AP | Transactions | Standard
When searching on a supplier drop down, it will return a list of Suppliers only.

AP | Reports | Age Analysis
Changes that were made to the accounts receivable age analysis have been implemented into the Accounts Payable age analysis.

AP | Reports | Remittance Advice
The Suppliers account now displays the correct balance owing and not a running balance.

ADMINISTRATION

Admin | Agents | Security
When an agent has no rights to add a supplier, they won’t be able to add a new supplier on a stock item in the information tab and warehouse tab.

Admin | Copy Company
When doing a Copy Company, the report categories are copied to the new company.

Admin | User Defined Fields
When a User Defined Field is created as a double or float with a default value of zero, the default value will now display correctly.

ANNUITY BILLING

AB | Transactions
Delivery Note fields will be kept on invoice when running an Annuity Billing Run.

AB | Reports | Receivables Transactions Report
When printing the Receivables transactions report it will display the lines on the contract templates.

AB | Maintenance | Receivables Transactions
When selecting the Debit Order feature and creating a transaction which is then processed, the program would report an ‘access violation’ error. This error will no longer appear.

BILL OF MATERIALS

BOM | Transactions | Manufacture Process
• Users will be able to manufacture with lot items as BOM items or components when not registered for Manufacturing.
• The quantity available field now displays the correct value from the BOM recipe.

BOM | Reports | Material Requirements Plan
The Bin location will be displayed on the report for master item and components.

COMMON

Common | Reports | Tax Report
• Transactions prepared via the ‘Importation Splits’ feature will no longer cause the exclusive amount to be incorrect on the Tax Report. An extra field was added to the table to correct the inclusive and exclusive amount on the Tax Report.
• The Tax Report now consolidates the tax correctly for transactions where the same GL account is repeated on a Purchase Order.
• When using a tax type with a 100% value for a GL line, it posts the correct tax to the Tax Report.
• When prompting and splitting the Petty Cash transaction type in the POS module to different GL accounts, the tax is posted correctly to the Tax Report.
• GL lines and Stock lines with different tax types will be consolidated correctly on the Tax Report. The GL lines and Stock lines will be consolidated separately.

Common | Report Writer
A deleted report can be reused from the recycle bin. The user can move the deleted report back to the original folder.

CONTACT MANAGEMENT

CM I Incidents
• Incidents will now escalate to the correct group if more than one agent is listed in the initial group.
• The incident will now escalate past the last agent and will escalate to a workflow group i.e. from Agent to a Group or from a Group to a Group if this is setup accordingly.

CM | Transactions | Sales Opportunity
Users can now reprint a quote that was made for a prospective customer from Archived documents or from opening the actual quote.

CM | Sales Force Automation | Prospective Customer
• When you have converted a prospective customer to a customer, the contact person/s can now be seen in the People tab.
• The Prospective Customer screen will now be refreshed when converting a prospective customer to a customer.

DATA DISTRIBUTION SERVICES

DDS | Price List Prices Import
Price List Prices can be imported when the text file contains warehouse items and non warehouse items. The ‘use default’ option should not be selected on warehouse tab when importing prices for warehouse items.

FIXED ASSETS

FA | Maintenance | Assets
Adding a new Asset will no longer report an error message if the User Defined Fields have the Force Field option enabled.

FA | Reports | Book Depreciation Report
• The Book Depreciation Report prints the previous year’s depreciations correctly and will no longer print zero.
• The customisation of the Book Depreciation Report will now include with User Defined Fields and print all assets.
• The report will display the correct previous year depreciation amounts in the requested financial year.
• When selecting the option ‘date from’ and ‘date to’ it will no longer report any errors.

FA | Reports | Asset Details Listings Report
After upgrading the database this report will still print and display all assets in the above mentioned report.

GENERAL LEDGER

GL | Transactions | Cashbook
• When having a split line on a cashbook that has not been posted, the bank reconciliation will display the split lines correctly for un-posted transactions.
• Zero transactions are now allowed to be captured in the cashbook.
• When posting a batch with many transaction lines and an error occurs, the error would then be corrected and the batch would need to be reposted. The defect of duplicate lines being posted will no longer occur.
• When processing a payment to a foreign supplier from the cashbook, the foreign amount displayed as a credit instead of a debit value. This has now been corrected to display the foreign payment as a debit value.

GL | Journal Batches | Import
A validation has now been added where there are sub accounts under the master account, the import will warn the user to select the sub account rather than the master account.

GL | Reports | Audit Trail Report
The Audit Trail Report prints the tax correctly when there is an ‘importation split’ on a Purchase Order and there is tax on the stock line.

GL | Reports | Income Statement
When customising the layout and adding a segment description, the report will print all the required accounts correctly.

GL | Reports | Project Profit and Loss Report
The Branch/Department tab has been added to the Project Profit and Loss Report.

INVENTORY

IC | Maintenance | Inventory Items
• When entering an exclusive or inclusive price on a foreign price list the currency symbol will be displayed.
• When linking a supplier to an Item through the Supplier screen the supplier will immediately be displayed on the Inventory item grid.

IC | Transactions | Documents
Immediate drop down feature is now working correctly in all Inventory documents.

IC | Transactions | Adjustments
When adjusting the quantity on a warehouse item with a negative quantity the ‘add’ function works without giving an error.

IC | Transactions | GRV
• When your GRV defaults are set to separate the GRV from the Supplier Invoice the credit entry on the GRV transaction type is set to split the Credit Entry. The transaction amount will also be posted to the Purchases Accrual account.
• When creating a Supplier Invoice only, the Lot Number will no longer be checked for.
• When your GRV is separated from the Supplier Invoice, the error that it can’t find a ledger account does not appear.
• When a BOM item with a Lot item as a component is broken up on a GRV, records are now posted and can be seen in Enquiries.
• When splitting the Credit Entry on GRV and SINV transaction types, the system no longer freezes when adding a GL line to a GRV and selecting the ‘importation split’.
• GL lines posted in a GRV linked to a Job Card will now debit ‘Work in Progress’ and credit the respective GL account.

IC | Transactions | Invoice
• When using a foreign customer with a foreign price list on volume discounts, the price will now display correctly.
• Errors will no longer appear when creating a template and converting it to a quote and then to an invoice.
• Reprinting a foreign currency invoice does not give any error when using the right-click method in Archived Documents.
• If the overall VAT on the invoice is negative the VAT will now be debited.
• Foreign tax values are now reported and posted correctly when doing an Annuity Billing run. GL lines that are linked to a template which do not use the Fixed Price option will now calculate the home value correctly.
• When reprinting a foreign invoice from a print batch it will no longer report any errors.
• When customising your grid by removing the status and type field on the archive documents grid, the reprint and print group options will not be disabled.
• In the Inventory Document screen the option to ‘sort by’ has been added. Within the Inventory Document screen select the ‘line’ option from the menu and the option ‘sort by’ will appear. This now allows the transaction lines on the screen to be sorted by a list of various options as selected by the user.

IC | Transactions | Inventory Count
• When doing an inventory count on the Input screen the Apply button is highlighted.
• Inventory count will ignore items with a Work in Progress quantity when ‘Include WIP’ and ‘Ignore items with Zero on hand’ is selected.

IC | Transactions | Warehouse Transfer Journal
The Warehouse Transfer Journal now displays the correct values for the ‘To Warehouse’ variables.

IC | Enquiries | Transaction History
• When enquiring on an item and viewing the Purchase Order tab, exclusive and inclusive prices can be shown.
• The Incident History tab in Transaction History is now updated immediately.

IC | Reports | Sales Analysis Report
• The Sales Analysis Report now allows for grouping of transactions by Sales Representatives.
• The correct grouping per warehouse per transaction is now displayed correctly.

IC | Transactions | Return to Supplier (RTS)
When processing an RTS with an additional cost that is split proportionately over all the lines, the program would report an access violation error. This would only occur with more than one stock line that has different quantities. This has now been corrected.

JOB COSTING

JC | Transactions | Job Card
• When a Purchase Order is linked to a Job Card and the Job Card is then completed, it now posts the correct Invoice Number and Delivery Note Number instead of displaying ‘Automatic’.
• Sales Representatives will be posted correctly when linking a GRV to a Job Card and the Sales Representatives report will also print this information correctly.
• When processing a Job Card on a customer whose credit limit has been exceeded, the user can now change the credit limit and it will be refreshed for the Job Card to be processed.
• After making a Job Card which includes Lot Items into an Inventory Item the Lot quantity and total quantity on hand are now correct.
• Purchase Order lines will no longer be added to a Job Card when the Job Card is completed.
• When changing from the Inventory tab to the Ledger tab and back to the Inventory tab on the Job Card the budget and totals now display correctly.
• When copying a line in a Job Card with a line that was invoiced out, it will now not remove the original line.
• When a Job Card is open and an incident is created while the Job Card is open it will no longer report an error.
• Item codes that have selling prices per warehouse did not display in Job Cards. This has been corrected to display the selling prices correctly.

JC | Reports
Job Card Reports can be customised to include User Defined Fields created.

ORDER ENTRY

OE | Maintenance | Purge Orders
Partially processed Purchase Orders can now be purged.

OE | Transactions | Purchase Order
• Rounding has been corrected when entering foreign amounts in Importation Splits.
• Only when a Supplier Invoice is being processed it will not prompt to print a Purchase Order.
• A partially processed order will be made complete when an unprocessed line has been deleted and the other lines have been confirmed.
• Adding additional cost to a partially processed Purchase Order will not duplicate the additional cost on processed lines.
• The home tax amount is now calculated correctly when entering foreign values on an ‘importation split’.
• When you are on the archived documents screen and you customise your grid to show the agent, the agent will be displayed on all the record lines.
• When two stock lines are entered on a Purchase Order and linked to two different jobs, you couldn’t process the Purchase Order any further when a job was complete. This has been corrected to allow the user to complete the Purchase Order.

OE | Transactions | Sales Order
After adding a Sales Representative to the various transaction lines within an inventory document and thereafter selecting the ‘exit and save’ option the Sales Representative will now be saved.

OE | Transactions | Automatic Purchase Orders
The latest cost is used when doing an automatic Purchase Order even if your inventory defaults are set to an average costing method.

OE | Reports | Purchase Order Report
The Purchase Order Report prints unconfirmed Purchase Orders and partially confirmed Purchase Orders correctly.

POINT OF SALE

POS | Transactions | Transactions
After posting a receipt to a sub account the allocation screen will be brought up for the Master Account and not the Sub Account.

POS | Transactions | Reports
The Till Cashup Report will print the correct transaction count if printing for a particular till or cashier.

POS | Transactions | Sales
• When manufacturing on the fly between two users of the same item at the same time this will not generate any errors.
• When processing cash sales against a Sub Account the payment portion will now update the relevant Master Account.

Payroll

SUGGESTIONS IMPLEMENTED

  Payroll | Maintenance | Employee Maintenance
 •  A note option has been added to the Loans and Savings information on the employee maintenance screen. The user can now enter any relevant information such as garnishee details, garnishee banking information, attorney information etc.
•  The functionality to enter the working hours, shifts and YTD shifts now appears as a parameter on the employee maintenance screen. This will enable the setup of employee specific working information. Sage Pastel Evolution will default to the global parameters as setup under Payroll | Maintenance | Parameters. This can be changed per employee at any time.
•  The employee maintenance screen has been enhanced by disabling the use of the Tab key and will now utilise Explorer Navigation.
•      A validation has been added to the Total Cost to Company function on the pay details of the employee maintenance screen. The description of the label will change to Cash Component where transactions influencing the Total Cost to Company are linked to the employee.

 

Payroll | Maintenance | Pension / Provident Fund
 The Pension and Provident fund setup has been enhanced allowing the setup of percentages of transactions that should be included in the calculation of Retirement Funding Income (RFI) and Non-Retirement Funding Income (NRFI). This will enable the user to specify a percentage of 10% for travel allowance whilst normal hours can be specified as 90%.

Additionally gross remuneration now caters for percentages other than 100%. The Tax Certificates have been enhanced including the pension and provident fund reporting to cater for these changes. The various pension or provident funds should be linked to the respective transaction types and the transaction types should have a percentage of RFI setup in order for the fund to calculate correctly.

Payroll | Maintenance | Payroll Relink
The user will not be allowed to process a payroll relink if there are employees with processed payslips. All employees’ payslips need to be un-processed before the relink can be executed.

Payroll | Transactions | Leave Year End
The Leave Year End has been enhanced and additional functionality has been added in order to make the Leave Year End more specific. The user now has the option to process the Leave Year End on specific leave transaction types and on a specific pay type. In addition, the user can also select the percentage of leave entitlement to be carried over to the next leave year cycle and has the option to only run for employees with a ‘to’ and ‘from’ cycle start date.

The Leave Year End can run automatically after a period close depending on the setup of the leave transaction type by the user as per the parameters, alternatively, the Leave Year End can be processed regardless of the employee start date cycle.

Payroll | Reports | Transactions | Tax Calculations Report
Previously, when a non-director type employee was selected to report on, Sage Pastel Evolution Payroll reported the relevant fields for directors on the tax calculations report with zero values. This information has been removed from the report should the employee not be a director.

Metal Industries Benefit Fund Administrators (MIBFA)
A new module that manages all MIBFA council requirements has been added. This module has been implemented into Pastel Evolution Payroll and has to be registered, in order to activate the MIBFA council module. Alternatively a demo company may be created and Sage Pastel Evolution Payroll will activate the module automatically.

Skills and Equity
A new module managing all Skills and Equity Reporting requirements has been added. 
This has been implemented into the Sage Pastel Evolution Payroll module which has to be registered. Alternatively a demo company may be created to activate the Skills and Equity module. All information is completed on the company details and employee maintenance. Numerical Goal Plans have to be setup for the company.

In addition, a variance report has been added to enable the user to determine on which employee the required skills and equity information is still lacking.

Transaction Types
The transaction types will now enable the user to specify that a transaction should be processed only once a month. The user will be able to setup default values for the specific transaction type and update existing records.

Should the MIBFA council module be registered, the user will be allowed to create and link transaction types to councils and specify whether the transaction type is mandatory or not. Should the skills and equity module be registered, the user is allowed to select the transaction type to be included in equity remuneration or not.

Payroll | Maintenance | Tax Scales
The latest Namibian Tax Tables have been added to Sage Pastel Evolution Payroll