E10 SQL Help - Need to create query to show whether last operati

After a conversation with Epicor support, it appears something is not working properly in our database. Fun....

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.

Can't you do a BAQ?


Jose C Gomez
Software Engineer


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&#39;t been consistent in doing so.</span></p><p><span><br></span></p><p><span>We&#39;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>

We cannot find where this field is located. According to field help, there is no DB field for the information.



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.

 

 

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
  ­­  
PartRev.FinalOpr


Jose C Gomez
Software Engineer


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>