Skip to main content
Answer

Import Scenario Help - QTY Required

  • April 30, 2024
  • 2 replies
  • 88 views
J
Semi-Pro I
Forum|alt.badge.img

I am importing BOM materials and I am required to convert certain items from LF to EA on import but the QTY Required field keeps giving me the following error “An error occurred during processing of field QTYReq: Specified cast is not valid”.

 

Am I able to perform any math to this field? As soon as I perform any math I get this error.

 

Take this for example: Simply doing 10/5 which should result in 2 on the BOM, but instead I receive the error regarding specified cast ...

 

 

Any help much appreciated.

 

Best answer by DipakNilkanth

Hi @jwarren,

Qty Required field is seems to be decimal and I believe you need to convert this field to decimal will resolves the issue you are facing.

 

2 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi @jwarren,

Qty Required field is seems to be decimal and I believe you need to convert this field to decimal will resolves the issue you are facing.

 

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
dcomerford
PaulMainard55
Captain I
Forum|alt.badge.img+2

I’m actually encountering a similar issue - I’m not even doing math, but am simply importing plain numerals into the field and am receiving “Specified Cast is Not Valid” error.  

Any thoughts as to why this is happening?

Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved