The problem that I have is that staff are able to modify the descriptions and while they are supposed to follow a system, people mis type etc. so there is no way of knowing all the non-standard items. How about I manually check for missing mm's or m's before running your routine? There are usually only a handful each month but they could be anything. Regarding the line you have picked - that is a good example of a mis typing - it should have read 250mc GLS 965mm(width) x 25m(length) x 58mm(core) - I have added the (xxx) for explanation.
In theory when there is a full code in the code column the description should be accurate as they should not have altered the description, but when there is a short or no code it is because the system did not have a code for that size and type of film so they have manually entered the description. We have 100 types of film, in theory an infinite number of lengths and and infinite number of widths as the customer specifies what width and length they would like a particular type of film - in reality there are probably about 30 common widths asked for and about 50 common lengths but then there are always the odd ones!




Reply With Quote

Bookmarks