Skip to main content
Solved

Import Scenario Help - QTY Required

  • Apr 30, 2024 7:36 PM UTC
  • 2 replies
  • 136 views
  • Translate All
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 Dipak Nilkanth

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.

 

View original

2 replies

Dipak Nilkanth
Pro III
Forum|alt.badge.img+14

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.

 

Translate
Dipak Nilkanth || 2X MVP @2025 & 2026 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
    PaulMainard55
    Captain II
    Forum|alt.badge.img+4

    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?

    Translate
    Terms & ConditionsAccessibility 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