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?
Was GP used to update the address fields? If via SSMS or Analyzer did you check PM00300 table as well?
Yes, changes were done directly in GP, table PM00200 and PM00300 reflects the changes correctly
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?
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
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
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.
Am on GP 10 SP5
Then I'd go for the RW modification. I know that doesn't answer your question, but it may solve the problem.