Updates on the Palletforce import to make things easier.

Also rewrote the Check for Problem Jobs in Utilities.

Note that there is now a special menu item to look up Irish postcodes

Norman
 

In these exact circumstances :-

1. You set an account to provide individual invoices for individual jobs
2. The first one has an additional charge of some type
3. You auto email the invoices

The totals on the first emailed invoices do not include the additional charge but if you print the invoice it is fine.

This has proven to be quite an odd one as the emailing of invoices and the standard invoice run use exactly the same code. It's as though it was going to print another page.

Norman
 

Over the weekend we have swapped the Lincoln and Northampton computers over to test our resilience in the event of a site failure.

We have also moved our main code server from Windows to Ubuntu Linux to stop the annoyance of unscheduled updating which left the computer needing a reboot to install remaining packages.

Norman
 

A full list of changes can be found by going into the HELP menu and choosing the Whats New option.

Added a Sales Ledger type option on this release.

Norman
 

Recently had fun getting a code signing certificate from Sertigo. You can only download it using either Internet Explorer 8+ on a PC or Firefox ESR on a Mac. Nothing else works at the moment.

I used a Mac with Firefox ESR which went as far as stage 5 where it downloaded a file called CollectCCC onto the Mac but it didn't seem to do anything else. I expected it to load it in the Keystore but no such luck.

In case anyone else has a problem, what I had to do was as follows :-

The downloaded file CollectCCC contained the public certificate signed by the certificate provider.

You have to rename the collected certificate to name.p7s (any name but with a .p7s extension)

I then copied this onto a Windows machine for ease of use.

I pulled the public p7s into the Personal certificate store using the Windows certificate manager.

I right-clicked on the certificate and exported it to the base64 format, saving it as name.cer

I downloaded and installed openssl

I then issued the following command to combine the signed name.cer certificate with my previously saved private key name.key

openssl pkcs12 -export -out NAME.pfx -inkey NAME.key -in NAME.cer

This creates a name.pfx file, which you can install directly in the Personal certificate store on the computer to sign executables and you can use the Windows certificate manager to add a friendly name to the certificate.

Norman
 

Yes. We still support ParcelTrak!

It is DOS based but very advanced for its age. The program will continue to function if you run it under VDOS (free). It even supports Windows printers.

ParcelTrak was written in Retrieve 4GL, a 4GL database system sold by Sage. We were a Sage Sovereign Development Centre for many years.

Norman
 

If using Google for SMTP mail and all of a sudden it says your username or password is wrong then this is down to new enhanced security by Google.

Go into Settings and Enable two-factor authentication. Now find the App Password entry underneath and ask it to create a password.

Use this password in your SMTP settings.

Norman
 

Please note that on the 1st July, 2022 we will be changing our Registered Office address to :-

310 Wellingborough Road, Northampton NN1 4EP

Our contact emails and phone numbers will remain the same as now.

Our banking details will remain the same as well.

Norman