4Site
Support Request System
View Patch #60.101.024
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03798 -
Error copying Value base requisition to PO
Symptoms:
The error was a result of a Value Based Purchase Requisition Header with Quantity Based Service Line: 1,545,900 X 1.00 which it naturally didn’t like. I moved the PR back to Price Estimating and changed the line to Value Based Services and it accepted the amount of 1,545,900 and the Purchase Order generated without any problems. The error produced by the copy was, 'Arithmetic overflow for type varchar...'
Solution:
The problem would have occurred with any Qty Based or Goods line for any time of requisition or purchase order. A change was made to use the SQL Convert function to convert the line quantity to a string for display in the tree. This shows decimal points only if necessary. Unfortunately the value was converted into a varchar too small, causing the error. Using a larger varchar works but shows any number greater than 6 digits in scientific notation. So, now the STR function is used, showing 2 decimal places for all quantities.
Browse Patches
Find a Patch
Return to Request System Menu
