New bug - and it features duplicates! 
My understanding is this:
The product reference field in Actinic is limited to 20 characters. I have switched from "auto generated product references" to manual references so I can implement the Quickbooks Link. I then typed in long text product references.
However, after I did this I got a error on startup saying "Data Truncated". It would seem that the 20 characters is fine for parent products but when a duplicate is created Actinic appends a number and an exclamation mark to the front of the product reference field. If the Product reference field length is already 19 or 20 characters long then these extra 2 characters will make the duplicate product reference too long for Actinic to start.
eg.
Parent product ref = Viper Classic Repair (20 characters)
Duplicate = 1!Viper Classic Repair (22 chars)
Result: Actinic cannot start.
Actinic tech support said this is a bug in Actinic.
Solution is to manually open the Product table in Access and make the text field length 20 chars. The data will then load but the duplicates will no longer work and will need deleting and recreating.
Prevention? Well I guess I need to remember not to make the product reference fields longer than 18 characters. I guess you could set the Product Reference Character Count field length in Actinic to 18???
Thought some of you might want to know about this.
My understanding is this:
The product reference field in Actinic is limited to 20 characters. I have switched from "auto generated product references" to manual references so I can implement the Quickbooks Link. I then typed in long text product references.
However, after I did this I got a error on startup saying "Data Truncated". It would seem that the 20 characters is fine for parent products but when a duplicate is created Actinic appends a number and an exclamation mark to the front of the product reference field. If the Product reference field length is already 19 or 20 characters long then these extra 2 characters will make the duplicate product reference too long for Actinic to start.
eg.
Parent product ref = Viper Classic Repair (20 characters)
Duplicate = 1!Viper Classic Repair (22 chars)
Result: Actinic cannot start.
Actinic tech support said this is a bug in Actinic.
Solution is to manually open the Product table in Access and make the text field length 20 chars. The data will then load but the duplicates will no longer work and will need deleting and recreating.
Prevention? Well I guess I need to remember not to make the product reference fields longer than 18 characters. I guess you could set the Product Reference Character Count field length in Actinic to 18???
Thought some of you might want to know about this.
Comment