Todd we have the same issue, we run a report buider report to look for
JobMtl records with Operation field = 0 and fix them. Makes life a lot
simpler in report builder.
Patrick Winter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, February 19, 2003 4:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Material Related to Operation
Doug Williams at Epicor responded off-list with the following:
----------
If a material is not specifically related to an operation then they are
"automatically" or "virtually" attached to the first operation because they
are due when the assembly starts (which is the first operation).
In other words, if the related material is zero(0) then it is assumed to be
the first operation - usually 10, but if an operation 5 was added later the
material would shift to that one since it was not specifically assigned to
10. If the related operation field was set to 10 then it would stay at 10
when operation 5 was added.
------------
But this does not help much if trying to link JobMtl to JobOper in a RB. My
feeling is the DB should be consistent with the rest of the screen behaviors
and RealatedOper in JobMtl should be updated with the then current "virtual"
attachment. Of course this would then freeze that attachment so adding
earlier operations would not longer have the material shift to them. I
don't know how to do a virtual, floating, link in RB.
-Todd C.
-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Wednesday, February 19, 2003 2:57 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Material Related to Operation
It's the same on Version 5.0. I'm not 100% certain but I think
in version 5.2 you just drag and drop the material on the operation.
Fredy Venczel
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/FpY02D/vN2EAA/xGHJAA/PhFolB/TM
---------------------------------------------------------------------~->
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
JobMtl records with Operation field = 0 and fix them. Makes life a lot
simpler in report builder.
Patrick Winter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, February 19, 2003 4:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Material Related to Operation
Doug Williams at Epicor responded off-list with the following:
----------
If a material is not specifically related to an operation then they are
"automatically" or "virtually" attached to the first operation because they
are due when the assembly starts (which is the first operation).
In other words, if the related material is zero(0) then it is assumed to be
the first operation - usually 10, but if an operation 5 was added later the
material would shift to that one since it was not specifically assigned to
10. If the related operation field was set to 10 then it would stay at 10
when operation 5 was added.
------------
But this does not help much if trying to link JobMtl to JobOper in a RB. My
feeling is the DB should be consistent with the rest of the screen behaviors
and RealatedOper in JobMtl should be updated with the then current "virtual"
attachment. Of course this would then freeze that attachment so adding
earlier operations would not longer have the material shift to them. I
don't know how to do a virtual, floating, link in RB.
-Todd C.
-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Wednesday, February 19, 2003 2:57 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Material Related to Operation
It's the same on Version 5.0. I'm not 100% certain but I think
in version 5.2 you just drag and drop the material on the operation.
Fredy Venczel
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/FpY02D/vN2EAA/xGHJAA/PhFolB/TM
---------------------------------------------------------------------~->
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/