Well that is a different statement. PartFIFOCost.SourceTranNum should correlate with a PartTran.TranNum…
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 1, 2015 2:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Gaps in PartTran.TranNum
Thanks Stephen.
I probably wouldn’t care too much about the gaps but what brought this to my attentions is that I was reviewing PartFIFOCost and it has a field called SourceTranNum, which I assumed is the source PartTran record, and some of these SourceTranNum values do not
have an associated PartTran record.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, June 30, 2015 8:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Gaps in PartTran.TranNum
It is not an issue there are several race conditions that can cause this to happen but it is not really a problem.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, June 30, 2015 9:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Gaps in PartTran.TranNum
Hello,
Does anyone know if Epicor would intentionally have gaps in PartTran.TranNum?
I’ve been chasing an inventory issue that looks to stem back to when we were on 9.04.
It looks like there might be missing PartTran records.
For example, if I run a query to show PartTran records where TranNum is between 210280 and 210300, the expectation is that I would have 21 records.
But I only have 12.
210280 to 210283 and 210296 to 210300 are missing but I don’t know for sure if this is an issue.
[cid:66e8f5.png@7ef8e5b2.4881fa21]
Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax
[http://matsinc.com/images/e-mail-signatures/tagline.jpg]
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png]<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png] <http://twitter.com/Mats_Inc>
[http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png] <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png] <http://www.youtube.com/user/MatsIncTV>
[http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png] <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png] <http://matsinc.com/blog>
[Non-text portions of this message have been removed]
Stephen Edginton (Beng) | Solutions & Technical Director
Mobile:
+44 7734 858415
DDI:
+44 121 314 1179
Main:
+44 (0) 121 314 1170
Web:
www.dotnetit.co.uk<http://www.dotnetit.co.uk>
Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.
[Image removed by sender. DotNetIT]
[Image removed by sender. Epicor Platinum Partner]
[Image removed by sender. Epicor Alliance Partner]
[Non-text portions of this message have been removed]
|
Stephen Edginton (Beng) | Solutions & Technical Director |
||||||||
|
|
||||||||
|
Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.
|
