Or if you are using an Excel file with DMT, then probably something like Greg suggested.
For some reason Excel will sometimes retains hidden formatting and resists your cell changes.
Here another way to try resetting the format(s):
-Select all the cells in a column.
-Apply formatting (number in this case)
-Press ALT + 11 to bring up VBA
-Paste the following in the immediate window and press the enter key:
For Each cl In Selection:cl.Formula=cl.Formula:Next cl
-Close VBA and return to Excel
For some reason Excel will sometimes retains hidden formatting and resists your cell changes.
Here another way to try resetting the format(s):
-Select all the cells in a column.
-Apply formatting (number in this case)
-Press ALT + 11 to bring up VBA
-Paste the following in the immediate window and press the enter key:
For Each cl In Selection:cl.Formula=cl.Formula:Next cl
-Close VBA and return to Excel
--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> try setting the column format to number with decimal places and I have had luck with making a new column and then copy paste values into it to make DMT work.
>
> One of the things that I found useful from DMT training was that to troubleshoot an error, try doing the same operation in the application.
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dina Hieber
> Sent: Thursday, November 22, 2012 9:28 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] E9 - Importing Error
>
>
>
> Hello and Happy Thanksgiving,
>
> I am trying to import a BOM from excel into Epicor 9. I receive an error that says PerQty is expected to be decimal. I changed the values to 1.00 (and 1.0 and 1.00000000) but nothing worked, I am still receiving the error. Does anyone have an idea what that actually means?
>
> Thank you!
> Dina
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>