web

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

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)

Suggested answer

YUN ZHU 91,863 Super User 2025 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

Was this reply helpful? Yes No
Brad_P 1,549 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?

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

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

#1

Nimsara Jayathilaka. 3,844

#2

Rishabh Kanaskar 3,010

#3

Sumit Singh 2,815

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans