Funny thing happened on the way to the Time Phase

Yahoo Archive
1
We had a similar sort of issue way back after Epicor converted us from DCD-Classic. There was another table that a Part referenced that was missing an entry for the value on the part record and the lookup browsers and trackers ignored records altogether. The browsers are nortorius for dropping things that don't link completely. Perhaps the PO has a status/type/group, etc.... type field that has to validate against other tables that has a value missing? You might be able to verify all of them with a few quick & dirty RB reports. If something comes up ? then create an entry and see of the PO starts showing up.
-Todd C.

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Tuesday, March 22, 2005 10:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Funny thing happened on the way to the Time Phase



That is what I am afraid of, but this is the only part I have found
that has this problem, including other parts on the same legacy
order. I was hoping for a "oh, check this" response.

- Mike R.

--- In vantage@yahoogroups.com, "halm180" <Mis@H...> wrote:
>
> From your description, it sounds like a data conversion/loading
> problem. The Time Phase report uses a database table called
PartDtl
> versus the PO related tables (POHeader,PODetail,PORel). It sounds
> like the corresponding PartDtl records were not loaded/creatd to
> match your open PORel records. I would double check with the
person
> that handled the data loading. Hope this is helpful.
>
> Peter Dunbar
> Halm Industries Co., Inc.





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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129j65jhd/M=298184.6191685.7192823.3001176/D=groups/S=1705007183:HM/EXP=1111594869/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=:HM/A=2593423/rand=945799216>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I have a part on a PO that does not show up on the Time Phase
screen. I can go directly from the line on the PO Tracker to the
Time Phase, but the PO is not listed. There are other parts on the
same PO which work fine and there are receipts of the same part that
show up on the Trans. History. You can also use the Sort By
function on the PO Tracker to find the PO that way.

Is there anything you can think of that would cause this? This is a
legacy PO that was ODBC'ed into Vantage, but I have not seen this
problem during the 4 months since going live.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.
3
From your description, it sounds like a data conversion/loading
problem. The Time Phase report uses a database table called PartDtl
versus the PO related tables (POHeader,PODetail,PORel). It sounds
like the corresponding PartDtl records were not loaded/creatd to
match your open PORel records. I would double check with the person
that handled the data loading. Hope this is helpful.

Peter Dunbar
Halm Industries Co., Inc.
4
That is what I am afraid of, but this is the only part I have found
that has this problem, including other parts on the same legacy
order. I was hoping for a "oh, check this" response.

- Mike R.

--- In vantage@yahoogroups.com, "halm180" <Mis@H...> wrote:
>
> From your description, it sounds like a data conversion/loading
> problem. The Time Phase report uses a database table called
PartDtl
> versus the PO related tables (POHeader,PODetail,PORel). It sounds
> like the corresponding PartDtl records were not loaded/creatd to
> match your open PORel records. I would double check with the
person
> that handled the data loading. Hope this is helpful.
>
> Peter Dunbar
> Halm Industries Co., Inc.