web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Brad_P 1,549 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,432 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,990

#2

Jainam M. Kothari 1,576 Super User 2025 Season 2

#3

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans