Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jeff Ralph]

??Hi all,

We are having trouble creating Asset ID’s with hyphens “-“. This is strange as we have many previous created?

Please see screen shot.

Any ideas?

Thanks,

Jeff

——————————
Jeff Ralph
Financial Accountant II
City of St. John’s
St. John’s
——————————

[Gerald Buenafe]

Hi Jeff,

This ‘change’ was already in place since GP2013 R2… it might have something to do with the Auto Generate Next Asset ID feature.

At any rate, here are a couple of workarounds (i.e.the error stays…):

1. use a different character (instead of a hyphen)

2. use PSTL (Asset Modifier) to rename the asset

3. update the ASSETID value across the different Fixed Assets tables via SQL

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Blair Christensen]

In general, it’s a good idea to treat ID’s very carefully and avoid non alphanumeric characters because of the ways those get handled on the database end.  Remember, to a computer, there is no difference between a hyphen and a minus sign, which can cause problems depending on the situation.  Best policy is to use only numbers and letters in ID fields.  Other characters specifically to avoid in ID fields: *, &, %, #, @, !, ‘, “, and the comma itself.  If you want to use a separator character, use the underscore “_” instead, as it has no alternative use and is always treated as a printable character.??

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-