Thanks @David Overholt
What I ended up doing was creating a couple of extra records by saying NO to the delete old key? prompt, editing them, and deleting the garbled records.
------------------------------
Phil McIntosh
Friendly Systems, Inc.
------------------------------
Original Message:
Sent: 03-18-2024 09:18
From: David Overholt
Subject: Strange character ascii(126), hex(E1) is screwing up record key in IM_ItemCost flie
Phil,
look at field #1 and the Key that is displayed above it; those two should always be the exactly the same. I would make a backup of that and also copy a test company. Then in that test company, try changing field #1 to match what is in the key field. I don't think I have ever seen the exact error message before, but you should be able to make that change still by clicking on the edit button. .
------------------------------
David Overholt
DWD Technology Group
------------------------------
Original Message:
Sent: 03-15-2024 15:33
From: Phil McIntosh
Subject: Strange character ascii(126), hex(E1) is screwing up record key in IM_ItemCost flie
What I found was that if I type over the old data and pad out with spaces, it works. However, before coming to that I had just clicked in at the end of the existing data and types several spaces, and ended up with a mess - see attached. Any ideas on recovering these records?
------------------------------
Phil McIntosh
Friendly Systems, Inc.
Original Message:
Sent: 03-15-2024 15:11
From: David Overholt
Subject: Strange character ascii(126), hex(E1) is screwing up record key in IM_ItemCost flie
Lee,
It looks like you are using DFDM on an older version of Sage 100. On the newer versions you can actually see control characters like that in the edit screen and they are easier to get rid of.
You can still change that in DFDM in the older versions, you might need to backspace out one or two characters and make a change to that field click on "OK" and answer YES when prompted with "Remove Old Key" then change the data back to what it should be without the special characters and again click on "OK" answer YES when prompted with "Remove Old Key" that should effectively remove those extra characters, which by the way were probably copy/pasted from a document that included a carriage return or something similar.
Don't miss out on the 2024 Basic Crystal Reports for Sage 100 Online Training: View the details
Don't miss out on the 2024 Intermediate Crystal Reports for Sage 100 Online Training: View the details
David Overholt
DWD Technology Group, Inc.
9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825
260.423.2414 main
260.399.8655 Direct
800.232.8913 toll free
sagesupport@dwdtechgroup.com
www.dwdtechgroup.com
