Company: Link Technologies
Case No: L12921
Logged By: Sanjay (Link Technologies) on 04 Jul 2023 04:08PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 26.00 (Weight: 36.00)
Assigned To: Development
Circulation: Development, Sanjay, Vineet
Resolve By: Friday, 14 July 2023 02:29 PM [620 days since logged date]
Status: Closed
Subject: Arithmetic overflow error converting numeric to data type numeric. when accessing Product Master for all sites
Summary:    

When accessing Product Master for all sites, the below message is given


Audit Notes:Edited by sanjay on 03/03/25 14:48. Edited by sanjay on 07/08/23 15:44. Edited by sanjay on 07/08/23 15:32. Edited by sanjay on 13/07/23 17:28. 
04 Jul 202304:08PM Comment 1 by Sanjay (Link Technologies) Case L12921 added to project 15.00
04 Jul 202304:14PM Comment 2 by Sanjay (Link Technologies) This comment has been removed
10 Jul 202309:49AM Comment 3 by Sanjay (Link Technologies) This comment has been removed
11 Jul 202311:00AM Comment 4 by Sanjay (Link Technologies) This comment has been removed
12 Jul 202310:31AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-07-2023 02:29 PM Time Taken: 22.00 Notes: Edited by sanjay on 07/08/23 15:46. ETC extended from: 13/07/2023 to 14/07/2023
The overflow issue is caused by Stock levels greater than 10 digits. To resolve the issue, run Inventory In-STock Recompute so the system can correct stock levels. 

Also, check UOM conversions to ensure that the conversion from Purchase Quantity to IN-Stock Quantity is correct.


07 Aug 202303:32PM Comment 6 by Sanjay (Link Technologies) Case L12921 added to project 14.90
07 Aug 202303:46PM Comment 7 by Sanjay (Link Technologies) Case L12921 removed from project 14.90
30 Aug 202302:52PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-09-2023 06:50 PM Time Taken: 4.00

Hi Vineet, we found that in OTGL case, there were Kit Items conversions from KG to Grams that were causing large negative numbers. These stock items were not supposed to be Quantity bearing.

I will close thisc ase. Reopen if you feel this issue is not resolved.


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12921 in the subject line of all emails regarding this issue.

Document size: 246.4 KB
For call complaints, please contact the Managing Director of the company using this form