Re: Phantom vendor table???

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

Thanks Steve, that was a big step just finding where the table was getting
populated.

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Schelske, Steve K.
Sent: Wednesday, March 20, 2002 12:22 PM
To: SQR-USERS@list.iex.net
Subject: Re: Phantom vendor table???


That table is populated in APY8055.SQC which appears to be called from both
apwthd.sqc and apwthdus.sqc

apwthd.sqc is in apy8060.sqr and apwthdus.sqc is in apy1099.sqr.

I think its the apy1099.sqr that you want to look at.

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Allen Cunningham
Sent: Wednesday, March 20, 2002 2:41 PM
To: SQR-USERS@list.iex.net
Subject: Phantom vendor table???


I am working on a problem in which a specific vendor is not getting 1099
info sent to him. I am trying to find out why this vendor does not show up
in the prompt table of a panel, even though he is a valid 1099 vendor. The
panel in question is PS_RUN_COPYB_RPT which contains a prompt table. The
prompt table is populated by a view (PS_VNDR_COPYB_VW). The view selects all
rows from record PS_WTHD_1099_COPYB. When I go into App Designer I find no
references to PS_WTHD_1099_COPYB. I am trying to find what criteria is used
to load PS_WTHD_1099_COPYB and why my vendor is not in it. Looking at vendor
information panels, he appears to be no different than other 1099 vendors
that do get loaded into PS_WTHD_1099_COPYB. Any insights would be
appreciated.

Using:
PeopleSoft Financials version 7.5
SQR version 4.3.4

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*