Standard Cost Revalue Error Arithmetic overflow error converting IDENTITY to data type int – Dynamics GP 2015

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:

  • BACKUP your DATA FIRST !!!
  • Go to Microsoft Dynamics GP – Maintenance – SQL
  • Select your Company Database
  • Select Product of Manufacturing
  • Scroll down and Select BOMLEVEL_1 and BOMLEVEL_2
  • 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 .

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: