QTY is out of range for SKU 10008524
Question:
Upon confirming the Picking QTY which 25, the personnel encountered an error message “QTY is out of range” for the Wave Number W2408310125 with the SKU 10008524.
Answer:
Investigation:
Upon confirming the Picking QTY which 25, the personnel encountered an error message “QTY is out of range” for the Wave Number W2408310125 with the SKU 10008524.
Answer:
Investigation:
Base Bug.
When RF coding detected a long number, it consider it as a string.
the qty 1040000.00000000 ，its length is 16 ，so it's recognized as String and because of that the below becomes TRUE but it should be FALSE.
The resolution is to change the SELECT query to round it to integer before passing it over as variable to RF (js).
Both of that SUM change it to ROUND(SUM(TSK_TASKLISTS.fmQty_Each)) AS @HIDE_FMQTYEACH@
DataImage25.png
DataImage55[1].png
DataImage55.png
Incident Report - QTY is out of range for SKU 10008524.docx
| Files | ||
|---|---|---|
|
|
DataImage25.png
68 KB
|
|
|
|
DataImage55[1].png
404 KB
|
|
|
|
DataImage55.png
34 KB
|
|
|
|