Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
jverrelli 4/10/2013 10:20:01 AM

Changing Currency or Quantity Decimal Places for an Item in Dynamics

In the utilities of Great Plains Dynamics their is the option to change the Currency or Quantity decimal places for an existing item, but it only allows you to do this when no one is in the system working on transactions. I am trying to create a vb application that mimics these functions. Does anyone know what stored procedures those two options call or does anyone have a SQL script that does just that (change the decimal places)?



Version: GP 10
Section: .NET Development, Dexterity, Dynamics GP, eConnect, VBA, Visual Studio Tools for Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables