Hello,For our stock count we pull the part ID using the below code: var metrixRowId = getValueFromListDataRow(row, "stock_count", "metrix_row_id");var partId = getDBValue(stringFormat("Select part_id from stock_count where metrix_row_id = {0}", metrixRowId)); The problem with this is our Part IDs recently have been rounding off trailing zeroes for examplePart ID 13003.70 becomes 13003.71452.00 becomes 1452 In some cases if 1452 is a valid part, it will pull information from that other part ID.It doesn’t seem to affect items with a leading zero so00308.50 is not affected.We have notes saying that the below code does not work because of an IFS bug, so this was fixed previously but is now broken again.var partId = getValueFromListDataRow(row, "stock_count", "part_id"); //this returns the wrong value for varchars that end with '.00' due to IFS bugI have tested the above and confirmed it has the same issue. I am looking for workaround solutions such as converting the result to a varchar or
Our system has a large number of stock records for items that when they reach a count of 0, aren’t likely to be used again for months or years. We have an SQL statement to find these records and remove them from our stock table to clean it up so we don’t have thousands of empty rows to search through when running other queries. Rather than directly modifying a crucial table like ‘stock’ we opted to add them in a T-Table called ‘t_stock’ with the delete modifier. We then run a T-Import to delete these rows as a safer alternative, and also to trigger any business rules when they are modified. We are able to schedule the SQL query to run on a set schedule say, every night at 11pm.Is it possible to schedule a T-Import for this table to run at a similar time so it doesn’t have to be manually run? What other solutions might be possible when working with such a critical table?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.