top of page

Standard Cost Revalue Error Arithmetic overflow error converting IDENTITY to data type int – D

DynamicsGPMnfgError

Manufacturing Customer and User of Microsoft Dynamics GP 2015 is getting and error when attempting to run the revaluation procedure to calculate the Standard Cost, based on Components cost in Dynamics GP 2015.

Error Reads: Arithmetic overflow error converting IDENTITY to data type int

Resolution:

  1. BACKUP your DATA FIRST !!!

  2. Go to Microsoft Dynamics GP – Maintenance – SQL

  3. Select your Company Database

  4. Select Product of Manufacturing

  5. Scroll down and Select BOMLEVEL_1 and BOMLEVEL_2

  6. Check all 6 Boxes on the right side and click Process

We provide this information without warranty and guaranty. Please proceed at your own risk and MAKE sure to have a proper and complete backup of your DYNAMICS and Company database. This process should be only executed when no other users are actively using Dynamics GP.

For further help and information, please feel free to contact us at 800-227-0700 or via e-mail at sales@CBRTEchnology.com .

0 views0 comments

Recent Posts

See All

Character Limitations for QuickBooks Data Fields

Each field in your company data file has a maximum number of characters that can be entered. This article lists the maximum number of characters in each field.FieldMaximum charactersAccount Name31Acco

CBR Technology Blog

bottom of page