[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Phantom vendor table???






There are several reasons that the 1099 does ot appear.

As said below, the address information, mainly the state and zip code.
The payment date must be in the prior year.  If adjustments are added and
the date is in the current year, the adjustment will not create a 1099 until
the current year.
Verify that withholding is turned on for the vendor and that the vendor is
assigned a withholding code.
Verify that the vouchers are marked for withholding.  If withholding was
turned on after the vouchers were entered, the vouchers will not be marked
for withholding.
Also verify that the control id for the run has not been altered to process
only specific vendors. Or rather, verify on the control id that the vendor
desired is going to be included by business unit and/or vendor.
I'm sure there are more, but that is all I can think of at the moment.

Rachael

> -----Original Message-----
> From:   "Sean Fowler" <SFowler@ADVANCEAUTOPARTS.COM>@INTERNET
> Sent:   Thursday, March 21, 2002 10:11 AM
> To:     SQR-USERS@list.iex.net
> Subject:     Re: Phantom vendor table???
>
>
> Allen,
>
> I had similar instances where a 1099 vendor did not get a 1099.  I found
> that if some of the Address info was not populated
> a 1099 would not be generated.
>
>
> -----Original Message-----
> From: Allen Cunningham [mailto:allen.cunningham@SONOMA.EDU]
> Sent: Thursday, March 21, 2002 12:14 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: Phantom vendor table???
>
>
> 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
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
>

(See attached file: C.DTF)

Attachment: C.DTF
Description: Binary data