Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Retrieving all GL accounts from GP?
The GL Master table is GL00100. Each segment is stored in a separate column. For example, the test company (TWO) uses ACTNUMBR_1, ACTNUMBR_2 and ACTNUMBR_3. You'll need to trim each to remove spaces and concatenate them. Also know that Great Plains does not use the account number, it uses...- bklenzman
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Set up many custom items
If I understand your problem correctly, the configurator options mentioned above will not work because your process is engineer to order, and you wouldn't be able to specify up front all possible options that are available to select from to "configure" a finished good. You might want to look...- bklenzman
- Post #6
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Updating test company data
Be careful when doing this. There are several tables that store a value called Company ID. Some modules use this to figure out where (as in to which database) to post a transaction. If you don't update these tables it is possible to have transactions from your TEST company affect the live...- bklenzman
- Post #6
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Audit Trail
There are also 2 3rd party audit trail products for Great Plains. One from www.MeritSolutions.com and the other from www.RocktonSoftware.com- bklenzman
- Post #3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Location of HR Lookup Values
Those are enumerated values. They are stored in the database as integers, but shown in the user interface with text. Those values are part of the application code and cannot be seen in the database. They can be viewed (usually) in Resource Descriptions. (version 8) Go to Tools >> Resource...- bklenzman
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
-
AP for Dairy
A company called FeedSys in Minnesota has a 3rd party module that might work. If you give me more details about what is difficult about calculating the price of milk, I might be able to provide some guidance on how you can do it in Great Plains.- bklenzman
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
