Converting UPC-E to UPC-A

Does anyone know if there is a way for RMS to convert the UPC-E (zero compressed) to UPC-A codes. I have the bar code scanner at each register set to convert the codes, but when building an item or manually entering an item it would be great to be able to have RMS decode the UPC code. Thanks

Jay

Reply to
Jay
Loading thread data ...

RMS will not do the conversion for you but what if you filled in all the information about the item then scanned the item into the ItemLookupCode field? The scanner should then place the expanded UPC into that field.

The only other way is if you take the formula for converting a UPC-E to a UPC-A and stick that in a SQL Trigger that fires on the INSERT of a new item, but of course you will want to have some way of determining which items need to be converted and which do not.

Rob

Reply to
Rob

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.