Hi All,
Facing the following error while uploading fixed assets Model and Make fields through excel add in (AX2012 CU10 and Excel 2013)
Using "assettable"
"Exception rate (denominator) must be greater than zero"
Thanks In advance
*This post is locked for comments
Did you remove the Exception rate field from the template already? Use only the fields that contains values for your import. All others will trigger field validations.
Hi all,
I now discovered that any field of assettable gives the same error
"Exception rate (denominator) must be greater than zero"
i try to change search name for example from excel add in
Hi André Arnaud de Calavon
I dont get the same error when I fill the Model and Make fields manually
if i remove the column with this field how i can import this data ?
Hi Ludwig Reinhard
not customized
the database name :
Model :
Model_Model
AssetTable(AssetTable).Model
Make :
Model_Make
AssetTable(AssetTable).Make
Thank you
Hi Mena,
The field is related to the Japanese localization. Do you get the same error when you fill the Model and Make fields manually? If not, then try removing the column with this field from your Excel file. Then it might skip the validation on this field.
Hi,
Is this exception rate field that you should fill a customized field? Do you know the database name of that field?
Best regards
Ludwig
thank you
I would like to fill two fields in the definition of fixed asset in "technical information"
1- Model
2- Make
using Excel Add in by choose add table "assettable"
when add data in two fields and Published
err : "Exception rate (denominator) must be greater than zero"
Hi Mena,
Can you tell in more details what you have done so far? Which fields were filled and how?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156