2,990
Hi,
My client just upgraded to GP 18.3 and cannot paste a JE in from Excel.
I saw this info on the new upgrade
and we've double checked their setup. But keep getting the error:
We double checked the currency setup and the multicurrency setup
The client does NOT use multicurrency.
Thanks,
Linda
Thanks Margi!
Hi Linda,
Thank you for your post. This is due to the feature change and will be fixed in the 2020-year end update.
The workaround is to format the cells in the excel spreadsheet to be set to “General”. You can do so on the Ribbon
OR change the cell format by right clicking on the cells on the spreadsheet > click on Format Cells > click on 'General".
Thank you,
Margi Jandro
Microsoft Support
Linda,
I would check the excel sheet is not using calculations with the results that are greater than 2 decimal places, this is typically the cause of the issue.
Just tested on 18.3 and was able to reproduce your error, even though the error report shows as 2 decimal placess, my excel sheet had 3 decimal places.
Mick
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#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
Share
Report
All responses (
Answers (