1099 print for a state

[jimmymac]

Greetings, we have an audit request from the state of California for copies of 1099s for 2012 for suppliers we paid that are in California. There does not appear to be a way to do that in JDE.

We use the AP method and currently the F045143 has the 1099 data from 2012, so we could just reprint the 1099s, or run a proof report, or a facsimile but that would print all 1099s from last year. There is a State field in F045143 but it is blank for all records, and reviewing the logic of R04514FP when it does an insert to F045143 it does not populate the state field.

Has anyone had this request or any suggestions on how to deal with this?

We are on E1 9.0.

Thanks.

 

[CLYONS99]

I'm having the same issue, did you resolve this? Any help is appreciated

 

[singe]

It's been a while since I dealt with this but if I remember correctly we ran a process to populate the F045143 state field so it could be used in the data selection. I don't remember if there was a UBE to do this or if we just did a database update. I do remember that it used a numeric code for the state not the two character abbreviation. I hope this will at least point you in the right direction.

 

[CLYONS99]

That's what I did, I wrote a program to update and it worked fine. Thanks.