More on Frinton > Wessex

A bit extra to the previous post , which describes how to change over Frinton mouldings to Wessex.

There is an (initially) perplexing problem where it seems that some Frinton mouldings have been marked as "discontinued" incorrectly.
"Oh dear!" I thought (or something close) when this turned up on my work computer.
As always it's wise to be like Corporal Jones and "Don't Panic".
After little sober reflection I realised that the problem lies with mouldings that were sold by both Wessex and Frinton and had a Wessex reference and a (different) Frinton reference.

So, to clarify - the moulding which showed as "discontinued" for me was (in my moulding records) Frinton M03021. Now Wessex also have this listed, and their reference is "C2105" and this is the reference used in the update file.

How to sort this out? I have come up with 2 scenarios.

The first is if you use the supplier's reference as the moulding ID. Simply change the label on your chevron to the Wessex number.

The second is if you use a different ID from the supplier number (for me that moulding was "117"), then you can edit the record to change the Supplier & Supplier Number.

The good thing about the second method is that all the job records which have used that moulding are changed too. Whereas in the first method they will still have the original ID, so it's probably best to edit the record and put the Wessex reference in the Notes section.

The records that start "WF", "PW" & "POL" are not affected, but if you come across an odd "Discontinued" best to give Wessex a ring just to check.