The subject says it all but let me expand on it a bit.
We want to be able to auto receive our parts once an operation is complete. There is a box we can check to tell the system to do this but we haven't been consistent in doing so.
We're looking for an easy way to see if the auto receive on last operation box has been checked. Anyone have any suggestions? My guess is something through SQL but I lack the skills to do so.
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Fri, Jul 31, 2015 at 10:25 AM, jlalonde@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p></p><p><span>The subject says it all but let me expand on it a bit.</span></p><p><span><br></span></p><p><span>We want to be able to auto receive our parts once an operation is complete. There is a box we can check to tell the system to do this but we haven't been consistent in doing so.</span></p><p><span><br></span></p><p><span>We're looking for an easy way to see if the auto receive on last operation box has been checked. Anyone have any suggestions? My guess is something through SQL but I lack the skills to do so.</span></p><p></p> </div> <div style="color:#fff;min-height:0;"></div>
JobAsmble.FinalOpr stores the sequence of the final operation, it’s not a checkbox on the JobOper.
Patrick Winter
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 31, 2015 12:33
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 SQL Help - Need to create query to show whether last operation is set to auto receive
We cannot find where this field is located. According to field help, there is no DB field for the information.
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Fri, Jul 31, 2015 at 1:32 PM, jlalonde@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>We cannot find where this field is located. According to field help, there is no DB field for the information.</p><div><br></div><div><br></div><div><br></div><p></p> </div><span class="ygrps-yiv-1075071063"> <div style="color:#fff;min-height:0;"></div>