Question Status

Suggested Answer
Cynthia Owusu asked a question on 9 Feb 2015 1:03 PM

I am experiencing something very strange. A vendor's address have been updated to reflect changes in  printing 1099's in GP. Every part of the vendor's address have been updated but the state. I verified the vendor table PM00200 and the change are reflected there. Any ideas please?

Thanks 

 

Reply
26P2ER responded on 9 Feb 2015 1:17 PM

Was GP used to update the address fields? If via SSMS or Analyzer did you check PM00300 table as well?

Reply
Cynthia Owusu responded on 9 Feb 2015 1:33 PM

Yes, changes were done directly in GP, table PM00200 and PM00300 reflects the changes correctly

Reply
Leslie Vail responded on 9 Feb 2015 1:41 PM

Have you looked at the report in Report Writer to make sure no changes have been made to where that field pulls its data? Also, as for the address you changed, is that the address that is on the face of the vendor card?

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Cynthia Owusu responded on 9 Feb 2015 4:29 PM

Yes the address is on the face of the vendor card in GP correctly. We have made many changes to vendor addresses to reflect changes in 1099's. I have made changes to the 1099 miscellaneous report in GP and any address change have been done successfully. The vendor whole address was changed and everything changed except for the state will not change

Reply
Suggested Answer
Leslie Vail responded on 9 Feb 2015 4:54 PM

If you're using GP2013, there's a new field in the lower left-hand corner address ID block that says '1099'. This is the address that the system will use to print 1099s. Is this ID set to the desired address ID (with the right state?)

You can modify the RW 1099 report and drag over the State field from the Vendor Master instead of the state field from the temp file they use.

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Cynthia Owusu responded on 9 Feb 2015 5:04 PM

Am on GP 10 SP5

Reply
Leslie Vail responded on 9 Feb 2015 5:07 PM

Then I'd go for the RW modification. I know that doesn't answer your question, but it may solve the problem.

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Suggested Answer
Leslie Vail responded on 9 Feb 2015 4:54 PM

If you're using GP2013, there's a new field in the lower left-hand corner address ID block that says '1099'. This is the address that the system will use to print 1099s. Is this ID set to the desired address ID (with the right state?)

You can modify the RW 1099 report and drag over the State field from the Vendor Master instead of the state field from the temp file they use.

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply