PartMtl Table, QtyPer Field

Yahoo Archive
1
Thanks for the info, i was not sure how this worked. I guess I will wait
until epicor fixes this or create an VBFORM fild and try to calculate
requirments with a report builder report. Yech!

Patrick

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Wednesday, March 21, 2001 2:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Patrick,
Yes, you can change the display mask to show more decimal places and when
Progress stores the value it will round it to the number of places listed in
the data dictionary. Of course, when you read that variable from the
database, it will display the rounded value with trailing zeroes.
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Since the entry screen field is linked to the database could I change the
data entry screen to store to a variable with 8 decimal places then save
it
in the database under qty per. Then displaying with report builder could
show all 8 but vantage would not. Or am I way over my head? I do have the
source code.

Patrick

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Wednesday, March 21, 2001 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Patrick,
If you modify the Data Dictionary to allow 8 decimal places, then any
program that refers to that table must be recompiled. This is more
complicated than it looks because of Epicor's extensive use of include and
library files; its not always apparent that a program touches a certain
table unless you trace through every include file. The last time I tried
something like this I missed about 40 files. Of course, in my case I was
silly enough to make a change to XASyst. Talk about learning the hard
way!!
Hopefully, I understood the question correctly. If not, then.... never
mind. :)
\Steve

NOTE for general list users: This answer presumes that you have the source
code and the ability to compile the programs.

================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:05 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] PartMtl Table, QtyPer Field


I need more than the allowed 5 decimal places. If I modify my database
field
to 8 decimal places and expand my entry screen under BOM for Qty Per.
What
undoable damage will this create?

<snip>

Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone: 815.969.4147
pjw@...


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I need more than the allowed 5 decimal places. If I modify my database field
to 8 decimal places and expand my entry screen under BOM for Qty Per. What
undoable damage will this create?

I'm not worried about standard Vantage Reports either rounding to 5 because
we tend to use report builder anyway.

I'm not worried about vantage screens rounding or truncating the display
back to 5 decimal places. I will modify the Tracker to display properly if
needed.

The database should upgrade unless vantage modifies the field.

I have to maintain the entry screen as a mod for patches and upgrades, I
maintain 50 of them now, no big deal.

Any comments or suggestions would be appreciated.

Any consultants on the list want to email me direct to aid or quote please
feel free.

Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone: 815.969.4147
pjw@...
3
Patrick,
If you modify the Data Dictionary to allow 8 decimal places, then any
program that refers to that table must be recompiled. This is more
complicated than it looks because of Epicor's extensive use of include and
library files; its not always apparent that a program touches a certain
table unless you trace through every include file. The last time I tried
something like this I missed about 40 files. Of course, in my case I was
silly enough to make a change to XASyst. Talk about learning the hard way!!
Hopefully, I understood the question correctly. If not, then.... never
mind. :)
\Steve

NOTE for general list users: This answer presumes that you have the source
code and the ability to compile the programs.

================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:05 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] PartMtl Table, QtyPer Field


I need more than the allowed 5 decimal places. If I modify my database
field
to 8 decimal places and expand my entry screen under BOM for Qty Per. What
undoable damage will this create?

<snip>

Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone: 815.969.4147
pjw@...


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
Since the entry screen field is linked to the database could I change the
data entry screen to store to a variable with 8 decimal places then save it
in the database under qty per. Then displaying with report builder could
show all 8 but vantage would not. Or am I way over my head? I do have the
source code.

Patrick

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Wednesday, March 21, 2001 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Patrick,
If you modify the Data Dictionary to allow 8 decimal places, then any
program that refers to that table must be recompiled. This is more
complicated than it looks because of Epicor's extensive use of include and
library files; its not always apparent that a program touches a certain
table unless you trace through every include file. The last time I tried
something like this I missed about 40 files. Of course, in my case I was
silly enough to make a change to XASyst. Talk about learning the hard way!!
Hopefully, I understood the question correctly. If not, then.... never
mind. :)
\Steve

NOTE for general list users: This answer presumes that you have the source
code and the ability to compile the programs.

================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:05 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] PartMtl Table, QtyPer Field


I need more than the allowed 5 decimal places. If I modify my database
field
to 8 decimal places and expand my entry screen under BOM for Qty Per. What
undoable damage will this create?

<snip>

Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone: 815.969.4147
pjw@...


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
If you add the qty per as a field to a database table you are going to have
to recompile everything that touches that table just like Steve was talking
about. It can get a little messy, but it is doable.
Mark Kohring
Delta Centrifugal

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Since the entry screen field is linked to the database could I change the
data entry screen to store to a variable with 8 decimal places then save it
in the database under qty per. Then displaying with report builder could
show all 8 but vantage would not. Or am I way over my head? I do have the
source code.

Patrick

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Wednesday, March 21, 2001 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Patrick,
If you modify the Data Dictionary to allow 8 decimal places, then any
program that refers to that table must be recompiled. This is more
complicated than it looks because of Epicor's extensive use of include and
library files; its not always apparent that a program touches a certain
table unless you trace through every include file. The last time I tried
something like this I missed about 40 files. Of course, in my case I was
silly enough to make a change to XASyst. Talk about learning the hard way!!
Hopefully, I understood the question correctly. If not, then.... never
mind. :)
\Steve

NOTE for general list users: This answer presumes that you have the source
code and the ability to compile the programs.

================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:05 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] PartMtl Table, QtyPer Field


I need more than the allowed 5 decimal places. If I modify my database
field
to 8 decimal places and expand my entry screen under BOM for Qty Per. What
undoable damage will this create?

<snip>

Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone: 815.969.4147
pjw@...


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
Patrick,
Yes, you can change the display mask to show more decimal places and when
Progress stores the value it will round it to the number of places listed in
the data dictionary. Of course, when you read that variable from the
database, it will display the rounded value with trailing zeroes.
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Since the entry screen field is linked to the database could I change the
data entry screen to store to a variable with 8 decimal places then save
it
in the database under qty per. Then displaying with report builder could
show all 8 but vantage would not. Or am I way over my head? I do have the
source code.

Patrick

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Wednesday, March 21, 2001 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PartMtl Table, QtyPer Field


Patrick,
If you modify the Data Dictionary to allow 8 decimal places, then any
program that refers to that table must be recompiled. This is more
complicated than it looks because of Epicor's extensive use of include and
library files; its not always apparent that a program touches a certain
table unless you trace through every include file. The last time I tried
something like this I missed about 40 files. Of course, in my case I was
silly enough to make a change to XASyst. Talk about learning the hard
way!!
Hopefully, I understood the question correctly. If not, then.... never
mind. :)
\Steve

NOTE for general list users: This answer presumes that you have the source
code and the ability to compile the programs.

================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 21, 2001 1:05 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] PartMtl Table, QtyPer Field


I need more than the allowed 5 decimal places. If I modify my database
field
to 8 decimal places and expand my entry screen under BOM for Qty Per.
What
undoable damage will this create?

<snip>

Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone: 815.969.4147
pjw@...


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]