How are the auto procedures created

(0) Share

Report

Posted on by Community Member

how are the auto procedures generated, specifically the procedures for the gl00100 table. I made changes to the max account format lengths in the Dynamics DB and company DB and need to have the insert auto procedure to update to the new max lengths so account numbers can be inserted as wanted. The drop create maintenance procedure is not updating the auto procedure with the new longer max account lengths. I am missing something, just don't know what.

*This post is locked for comments

All responses (4)

Answers (0)

Derek Albaugh on at

Like (0)

Report

RE: How are the auto procedures created

Michael,

Since you manually changed the SY003001 and SY00302 tables, to get the procedures to use the new account framework setup, you'll want to change the SYNCHRONIZE= line in the Dex.ini to TRUE, save changes and close the file. Launch Utilities which will do a version check and then synchronize the account framework with the dictionary files. These dictionary files hold the scripts that should be used to re-create the stored procedures whether you're using SQL Maintenance within the Dynamics GP application (for the dexterity procedures) or the Database Maintenance Utility to re-create the stored procedures themselves.

The zDP_GL00100SI procedure is a dexterity procedure, thus it'd be re-created via the SQL Maintenance window.

Thank you,
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How are the auto procedures created

I will have to do some testing and get back to you with my findings.
Community Member on at

Like (0)

Report

RE: How are the auto procedures created

Hi,

I did update DYNAMICS..SY00302 and DYNAMICS..SY003001. I increased the max account length to 42 from 8 in sy00301. I increased the segment length to 7 on each of six segments in sy00302. in the company DB I altered the gl0100, and gl00100f1-f4, and gl00105 tables and increased the ACTNUMBR fields to char(7) for each of the six segments. I updated company..sy00300 to show the max segment length of 7 for each segment. So far so good. I am hung up on trying to insert or modify the account numbers going to company..gl00100. It seems to come from the auto procedures for the gl0100 table. Here is a sql snippet from zDP_GL00100SI

PROC [dbo].[zDP_GL00100SI] (@ACTINDX int, @ACTNUMBR_1 char(1), @ACTNUMBR_2 char(1), @ACTNUMBR_3 char(3), @ACTNUMBR_4 char(3), @ACTNUMBR_5 char(3), @ACTNUMBR_6 char(3)

as seen, the auto procedure is coding the old account segment lengths. I have run the drop and create auto procedure routine in maintenance>sql and it is not altering the proc to the new segment lengths.
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: How are the auto procedures created

Hello Michael

Although I have never done this before, but I believe it could be definitely possible if the update statement are properly designed and deployed. I would like to make sure before providing any further assistance.

The auto procedures in Dynamics GP are definitely dynamic, they are called on the run in order to retrieve data as is, there is nothing hard coded in the stored procedure such as the Max.

In this essence, let's review the process and steps which you have gone through:

I would assume you have updated both tables (DYNAMICS..SY00302, and DYNAMICS..SY003001). If you increased the maximum number of segments, you have to add new records accordingly in SY00302

Other related tables which are not part of the update (company..SY00300, company..GL00105 and company..GL00100)

There is a file called the account format , it contains the account format setup as well. See below

Your feedback is highly appreciated,