ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Make Field Sizes match
http://www.istechforum.com/YaBB.pl?num=1141320058

Message started by rmh148 on 03/02/06 at 09:20:58

Title: Make Field Sizes match
Post by rmh148 on 03/02/06 at 09:20:58

One suggestion for an update is to make the field sizes match between BKGLTRAN and BKICMSTR. Currently, the BKIC_PROD_CODE is 15 characters and is written to BKGL_TRN_CODE on the GL transaction as 10 characters. This is a nightmare when trying to match stuff up. If you could expand the BKGL_TRN_CODE to 15 it would provide means to match things and perform relationships mechanically. I know in the real world is not just simply change the table to 15. It requires a where used analysis to ensure programs, screens and reports are all adjusted as well. But, it would be nice.

Title: Re: Make Field Sizes match
Post by cathyh on 03/02/06 at 11:12:09

It would be great to see this happen for the terms table also:

cathyh wrote:

I have been making sure that all my rtm's are the latest versions-- I noticed that the terms are still truncating-- has anyone ever addressed this? I would [glb]REALLY[/glb] like to see this fixed!

Of course separate terms tables for AR and AP is also big on my list of wishful thinking.

Title: Re: Make Field Sizes match
Post by lmk223a on 03/02/06 at 12:29:33

cathyh wrote:

It would be great to see this happen for the terms table also:

Of course separate terms tables for AR and AP is also big on my list of wishful thinking.

Ditto separate term tables. We are maxed out.