News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Get this error message...

Small and medium business | Business Central, N...

Suggested answer

Get this error message "The value " " can't be evaluated into type Decimal"

(0) Share

Report

Report

Posted on by michaelq

95

when I import an excel file into a General Journal using Excel import by Chase

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (0)

Report

RE: Get this error message "The value " " can't be evaluated into type Decimal"

Hi, Is this a customization?

This is because of System.Evaluate(var Any, Text [, Integer]) Method.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/system/system-evaluate-method

The system is trying to convert a null value to Decimal, so an error is occurred.

You can follow Brad_P's suggestion and fill in the empty information in the import file.
But I still recommend updating the source code. If it is empty, it is better not to execute System.Evaluate.

Hope this will help.

Thanks.

ZHU
Brad_P 1,542 on at

Like (0)

Report

RE: Get this error message "The value " " can't be evaluated into type Decimal"

Does your Excel sheet have empty rows and did you confirm that the rows have numeric values in the appropriate columns?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans