Year End Backup in Pastel V17

Pastel Version 17 is upon us and development enhanced some of the regularly used features. One of these changes, affects the backup procedure when processing the year end. Let’s take a look at how this changed:

Backup regularly

Now as we know, making regular backups of your Pastel data is vital for any business. This doesn’t only help yourself when restoring a backup, but also provides your Pastel consultant with more information, should they have to do a data-fix.

Year End Backup V17

The year end procedure hasn’t changed much. The only difference comes in when you decide not to create a new company.

Do not copy company Backup

A backup screen will pop up, prompting for a backup before the year end process starts. Here you can backup like you normally would.

Yearend Backup

Should you exit the backup window you’ll be presented with a notification window of the implications when not creating a backup.

Warning Backup

When clicking yes, you will be taken back to the backup window. Should you click no, an entry will be captured in the System Changes Audit Trail under the Backup Parameter Category.

System Changes Audit Trail Backup

Xpress Start-Up V17

Please note: Xpress Start-Up packages only allows you to create one company. Therefore it is absolutely vital to make a backup before processing a year end, since you won’t be able to create a copy company.

Apart from making a backup at year end, I cannot emphasize how important it is, to make regular backups. Even if you make use of an automatic backup system like Irontree, please still make your own backups at year end. Backups make data fixing so much easier for your Pastel consultant.

Should you have any queries or need assistance with any Pastel related query, you can log a support incident on our website by clicking here.

Looking forward to hear from you

Pastel Partner Forms Designer V17

Editing forms in Sage Pastel has always been tricky, however, now with Pastel Partner Forms Designer V17 following a few of these easy steps your forms can look unique and professional:

Pastel Partner Forms Designer V17 Made Easy

Border Color, Fill Color and Rounded Corners on Boxes

Customize your documents by changing the border colors and the colors of the boxes on the documents. You can change the boxes from square corners to rounded corners to enhance the look of your documents.


Convert all Text and Fields to Individual Font:

Change the header and footer fonts on individual forms. This selection will then ignore the font settings selected in the Pastel Font Setup from the menu bar.

Currently all text fields are predefined (either as Main or Title) you cannot change the font or size, however changing it to individual you can. Selecting convert will change all text fields and you don’t have to select one by one.




Convert to Greyscale:

Convert your document to greyscale to ensure that the document is not printed in color on a color printer.


The form will then look like this:


Color Replacement Tool and Select all Same Color:

Select a color and replace the selected color with a new color throughout the document. This option selects all items in the form that are the same color and you can reformat these selected items.




Inserting a logo is not that difficult however for some reason the logo sometimes disappears, Now with Pastel Partner Forms Designer V17 the Image file is automatically stored in the company folder.


Images are sized according to available space and no longer change their aspect ratio (This can be overwritten by selecting no)

Images automatically resize when added to a document.


The form in short would then look like this:

New Forms Designer V17

If you require any assistance,  please call our call center:
+27 21 447 9565

Alternatively, click here to log a support incident via our website,  and a support consultant will contact you:

Sage Pastel Mobility

Do you know what Sage Pastel Mobility is?  Think of it this way: Desktop Accounting meets Cloud

Have you ever wanted a mobile solution to your Accounting package where you can transact via your smart phone or tablet? Now, you can do just that with “Sage Pastel Mobility”. Pastel introduced this fantastic feature some time ago and underwent a few updates and changes to enhance user experience. Let’s take a look at the features available in this add-on:

Sage Pastel Mobility

With Sage Pastel Mobility, your sales reps will be able to process quotes, sales orders and invoices with this amazing app which interlinks with your desktop accounting software.

Pastel Mobility Quote

You can access your stock levels and pricing at any given time.

Pastel Mobility Stock Level Pastel Mobility Stock Price

Get customer information with a touch of a button, straight on your mobile device.

Pastel Mobility Customer Information

Like when selecting a customer address, it opens up your GPS app (like Google Maps) on your mobile device and locates the address on the map. Now just click on go and your app directs you to the customer.

Pastel Mobility GPS

Or when selecting a contact number, it automatically inputs the number on your dial pad.

Pastel Mobility Dail Screen

Or when you select an email address, it automatically opens up a new email with the selected email address.

Pastel Mobility Email

When processing an invoice, quote or sales order on Sage Pastel Mobility, it creates a document with a W prefix in an open batch on the selected user’s profile. WI for invoice, WW for Sales Order and WQ for Quote.

Have more than one company to transact on? No problem. Simply set up the Sage pastel Mobility users in each company and you will be able to open the different companies on your mobile app once logged in.

Pastel Mobility Company List

If you need any help setting up Sage Pastel Mobility, please log a request on our website by clicking here

Correcting your POS slip printer

As a Pastel Point of Sale (POS) user you may have noticed that your POS slip printer isn’t quite printing your POS slip with all the entries aligned correctly.  Now this might be a small point but if you’re like me, it’s an issue.  Read further below to see how you can do something about it.

As a Point of Sale user,  you may be experiencing issues with text that is not aligned when using a slip printer.  This is due to the Font that is being used.

Here’s an example of what the normal slip layout might be giving you.

Non aligned slip printer

If this is what your slip is looking like, then you might want to do something about it.  Studies have shown that even the smallest of changes to how one interacts with ones clients can have even a subliminal effect on future business.  Now not everyone looks at their POS slips, most of them hit the bin behind the counter, but for those clients that take it away with them it’s a way for you to leave a reminder to the client that your store is a point of convenience that they should return too.  When they look at your slip and it’s messy, it doesn’t really give a good “please return to us” kind of message does it?  Ensure your POS slip printer is printing a neat slip with your basic contact information and even if it makes a 0.01% difference to your annual client returns, it’s something.  Besides, at the very least it’ll look good!

Here are the steps you can follow,  to correct the alignment, when printing your till slip to a slip printer:

1.   Select Shortcut Functions | Printer font Setup
3 Printer Fonts button for slip printer
2.   Set the Main Font and Title Font to Courier New
4 Fonts Settings for slip printer
3.   Click OK
4.   Reprint the slip and you should see that the fields are now aligned as shown below.
5 Aligned Slip Printer


Good Luck!!

Steve Billington

Sage Pastel Partner/Xpress – Status 30

Sage Pastel Partner/Xpress – Status 30 – Files in your Company database cannot be accessed.

With winter around the corner the usual bout of colds and flu viruses can only be expected, computer viruses however tend to take us by surprise.

One particular Ransomware virus known as ‘Cryptowall’ has been doing the rounds as of late, affecting networks both locally and internationally.

This mean bug encrypts your data and holds it to ransom.  Ransom takes the form of payment via bit-coin only and apparently your data is unlocked on receipt of payment.

The only other solution is a restore.

As this is not a Sage Pastel issue, if you have received this error or you find that your software is not working as it previously did, we can only suggest asking your IT Administrator to check the entire network.

Many of my clients have been receiving this particular error when working with Inventory:

Status 30 – (One or more files in your Company database cannot be accessed.  Please contact your local support centre or distributor for assistance) File 45 (Adjust Inventory – accbsj.000(user))

Sage Pastel Partner/Xpress – Status 30 – Files in your Company database cannot be accessed


After much troubleshooting and discussions with the Sage Pastel Technical Team, this is the “cure” I received:

The virus takes the form of a file left in the Sage Pastel folder or a company folder. If you open the folder is says “how to decrypt 3.0”. The errors that they have picked up are random.  

A format of the machine is required to completely get rid of the virus and thereafter one needs to restore a backup from a viable external source that was not affected by the virus.

You can attempt to delete all files with .00* extensions including defaults and controls. And thereafter try again.

Usually, when one deletes the batch file in question, the virus recreates it and it and goes on in an endless loop.

Should the deleting of the .00* files not work, the only other option is to restore a reliable backup.


Like any condition, prevention is better than a cure. One of the recommended applications to use to prevent an attack can be found here:

Before installing this, make sure that it is approved by your IT Administrator.

Please be vigilant and do not open any attachments that you are not certain about.

I sincerely hope you survive the winter without getting bogged down by this bug!

All the best,


Emailing from Pastel on 64 bit Windows OS Machine

When emailing out of Pastel Partner/Xpress, you may receive the following message:
“Please check your setup or ensure that the email address is correct” or, the email is sometimes routed to the incorrect customers/suppliers.

This can happen if you if you are using a 64 bit PC or Laptop.  Fear not,  there is a solution!

Open your Pastel Disk and browse to D:UtilOutlook 64-bit.  You will find a file called NewMail.dll. Copy this file and paste it into C:Program Files (x86)Common FilesSoftline Pastel.  You will be asked if you want to replace the existing file.  Select yes.

You now need to register this file,  both on the Server and the workstations.  You do so as follows:

click on START  Run,  and type in the following:   regsvr32  “C:Program Files (x86)Common FilesSoftline PastelNewMail.dll”

If you get a message indicating the registration has failed, please ensure that you are logged in as a Windows administrator.

Until next time,


Our suite of Sage Pastel Accounting related Professional Services include:

Business Consulting
Sage Pastel Partner Payroll Sales & Support
Sage Pastel Partner Payroll SARS Submission assistance
Sage Pastel Partner Payroll Outsourcing
Sage Pastel Accounting Software Sales & Support
Sage Pastel Accounting Software Implementation & Project Management
Sage Pastel Accounting Troubleshooting & Data fixing
Excel Reporting Onsite End User and Advanced Training
3rd Party Application Development

End 2 End Business Solutions

Sage Pastel Partner/Xpress – Windows 8.1 Update

Windows 8 users,  are you experiencing problems with Pastel since running the latest Windows Update (Windows 8.1 Update)?

I’m sure a lot of you are.  After speaking with the Sage Pastel Technical Support Team, they informed me that a lot of users are complaining about their mapped drives no longer being available, after running the Windows 8.1 Update.  I was provided with 2 possible solutions,  and would like to share 1 of them with you.  (The second solution involves creating a new key in the registry,  and I would recommend that your IT support contact Pastel Support,  or myself for this solution).

Windows 8.1 Update Fix Procedure

Go to C:Pastel12 (or respective Pastel Drive and folder).

Right click on PastelV12.exe (or respective program version) >Properties.

pastel exe properties

Select the ‘Properties’ tab.

Tick ‘Run this Program as an administrator’ under the Privilege level (illustrated below)

run as administrator

Click Apply > OK

Once that has been done, please try opening Pastel and adding / activating the companies again.

Should this not work,  as mentioned,  Please get your IT consultant to contact Pastel Support,  or myself,  so that we can configure the registry as required.

I have also been informed that this Windows update has been retracted,  so let’s hope the next one doesn’t give us too many headaches!!!

until next time,


Our suite of Sage Pastel Accounting related Professional Services include:
Business Consulting
Sage Pastel Partner Payroll Sales & Support
Sage Pastel Partner Payroll SARS Submission assistance
Sage Pastel Partner Payroll Outsourcing
Sage Pastel Accounting Software Sales & Support
Sage Pastel Accounting Software Implementation & Project Management
Sage Pastel Accounting Troubleshooting & Data fixing
Excel Reporting
Onsite End User and Advanced Training
3rd Party Application Development

End 2 End Business Solutions



Copying Inventory Items

Finally it is here!!!  The ability to copy inventory items.


This new feature is my personal favourite.  Creating multiple (similar) Inventory items has never been easier.  Once an item has been created,  you are able to copy that inventory item,  in order to create a new inventory item.  All you have to do is give the new inventory item a different code,  and change whatever it is you want to change on the new inventory item.  This is a FANTASTIC feature.

Copy Inventory Item

Copy Inventory Item 2


I hope you find this,  and the previous new features that I posted, useful.




Xpress/Partner – On Hold Assistant

I would like to continue from last week’s post regarding the new features in Xpress/Partner V12.1.4. This week, I will talk about putting documents “On Hold”


Placing documents “On Hold” serves many purposes. One in particular, is enabling you to run a Year End Rollover with open batches. Another being the ability to “save” the invoice, and allow a supervisor to double check the invoice, before updating, thereby avoiding the need to process a credit note to rectify any mistakes made.

This feature has been around for a long time, but one of the downfalls of the past, is that in order to place a document “On Hold”, or take a document “Off Hold”, the user would need to open each document individually, and make the relevant change. A time consuming exercise I’m sure you’ll agree!!!

The On Hold Assistant allows the user to select multiple documents, and apply a global change, just with a couple of clicks. For example:

You can choose to view all customer invoices, for all users, and place each document on hold at once.


You could choose to view all invoices for a particular customer, created by a particular user, and take them all “Off Hold”. All of this, with three or four clicks. Isn’t that GREAT!!!

This feature can be found on the “Process” menu option.

Process Menu

On Hold1

On Hold2

On Hold3

Now all you need to do is figure out what you’re going to do with all the time you have have saved.


Have a Great Week!!