NonConf TranID Blank Title 132661

Well, after much digging and testing, it does look like the TranID IS tracked and incremented in the NonConf table.There could  have been a bug in the way we initially tested how it was incremented so I had to search all of the tables.   Vantage sometimes has it's secrets and you are never sure where things come from. So, when we run our new program now, it looks like we will use the nonconf.tranid. 

Thanks to everyone who responded!!

Kurt
Hi All,

We're on 8.03.405.  We are trying to do a little mod  having to do with the Non Conformance.  Most of it looks good, however, we need to be able to increment the TranID. We've searched high and low, but we can't see where the next tranid in line comes from. We thought it was just add one to the highest one in the NonConf table, but this isn't the case. We've searched through several SQL tables where we thought it might be stored, but again, no luck.  Does anyone know where this would be kept (or maybe even how it determines this if not stored in a table) ?

Thanks in advance for your help!!

Kurt


Nonconf.TranID



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2390*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 1 octobre 2014 11:27
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] NonConf TranID





Hi All,

We're on 8.03.405. We are trying to do a little mod having to do with the
Non Conformance. Most of it looks good, however, we need to be able to
increment the TranID. We've searched high and low, but we can't see where
the next tranid in line comes from. We thought it was just add one to the
highest one in the NonConf table, but this isn't the case. We've searched
through several SQL tables where we thought it might be stored, but again,
no luck. Does anyone know where this would be kept (or maybe even how it
determines this if not stored in a table) ?

Thanks in advance for your help!!

Kurt






[Non-text portions of this message have been removed]
Hi Amélie,

Thanks for the reply, but what we are looking for is how the next TranID is determined. Ex., TranID 12345, the next should be 12346.  We need to find out what keeps track of this number. If we changed the highest TranID in the nonconf.tranid field to 12348 from 12345 (saved the record) and created a new nonconf, the next number would come up as 12346 (one up from 12345), not 12349 as we would expect.  It didn't recognize the largest TranID that we changed as 12348.  So, it looks like this number is stored externally from the nonconf table. We just can't see where. Maybe some system table, but we can't find if.

Thanks again!

Kurt
On our side, the non conformance system was so full of mistake when used,
that we decided to create a new and complete one.



The tranid was one of the last part of the code we used to assign, and even
then, the Epicor source code was able to override by .p program to create a
new RNC...



But they, don’t lose it. If you ever succeed in changing the tranid just
tell me! I can tell you it’s in the update method of nonconf table.



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2390*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 1 octobre 2014 11:41
*À :* vantage@yahoogroups.com
*Objet :* RE: [Vantage] NonConf TranID





Hi Amélie,

Thanks for the reply, but what we are looking for is how the next TranID is
determined. Ex., TranID 12345, the next *should *be 12346. We need to find
out what keeps track of this number. If we changed the highest TranID in
the nonconf.tranid field to 12348 from 12345 (saved the record) and created
a new nonconf, the next number would come up as 12346 (one up from 12345),
not 12349 as we would expect. It didn't recognize the largest TranID that
we changed as 12348. So, it looks like this number is stored externally
from the nonconf table. We just can't see where. Maybe some system table,
but we can't find if.

Thanks again!

Kurt




[Non-text portions of this message have been removed]
Thanks Amélie,

Yes, we're doing something similar.  If I can find something definite out on this, I'll let you know!

Kurt

Kurt,

 

Were you asking what transactions triggers this number to increment?  Or just how you can do it yourself without necessarily creating a transaction in the system?

 

Manasa

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, October 01, 2014 1:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: NonConf TranID

 

 

Thanks Amélie,

Yes, we're doing something similar.  If I can find something definite out on this, I'll let you know!

Kurt

Hi Manasa,

Thanks for your reply.  We are actually looking to do it ourselves and not involve Vantage.  That's where our problem comes in.  We can't see what the next TranID would be if it was run through Vantage. If we ran the external app, assigned a TranID (based on the highest current tranid in the nonconf table +1), then for some reason if we did run the nonconformance through Vantage, we would like to have the numbers still work out in order. I don't know if there is a table that keeps track of used TranID's because it didn't recognize when we manually changed one in the nonconf table. That leads us to kind of figure that it might look elsewhere for the next sequential ID number.  Like I mentioned earlier, we manually plugged a larger TranID in the nonconf table to see if it would increment using this number, but when we ran Vantage after that, it assigned what would have been the next sequential ID using the ID number before we fudged the ID ourselves. It snubbed it's Vantage nose at the number we put in. That's why we think it tracks these numbers somewhere we can't find.  Sound confusing?

Thanks again Manasa!

Kurt

It makes more sense now….I think you are going to have issues with it because the numbers are generated from several places, not just one screen.

 

Anything that hits the Quality module gets the next nonconforming number.  So whether I receive a part from a PO that has inspection required checked to actually going to Non-Conformance and creating a transaction there.

 

This number is incremented from several different places.

 

I don’t know if that will help, but good luck and sorry I could add more than that!

 

Manasa

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, October 01, 2014 3:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: NonConf TranID

 

 

Hi Manasa,

Thanks for your reply.  We are actually looking to do it ourselves and not involve Vantage.  That's where our problem comes in.  We can't see what the next TranID would be if it was run through Vantage. If we ran the external app, assigned a TranID (based on the highest current tranid in the nonconf table +1), then for some reason if we did run the nonconformance through Vantage, we would like to have the numbers still work out in order. I don't know if there is a table that keeps track of used TranID's because it didn't recognize when we manually changed one in the nonconf table. That leads us to kind of figure that it might look elsewhere for the next sequential ID number.  Like I mentioned earlier, we manually plugged a larger TranID in the nonconf table to see if it would increment using this number, but when we ran Vantage after that, it assigned what would have been the next sequential ID using the I D number before we fudged the ID ourselves. It snubbed it's Vantage nose at the number we put in. That's why we think it tracks these numbers somewhere we can't find.  Sound confusing?

Thanks again Manasa!

Kurt

Manasa,

I appreciate your help!  I guess I really need to dig more.  There has to be some way I can get this . I think sometimes this stuff is buried deep in the bowels of Vantage where no mortal is meant to venture (but I don't give up easily).  If you or anyone else thinks of anything, please let me know!

Thanks again for your help!!

Kurt