P73GEO not working after Vertex Sales Tax Q V3.3.1 installed

shurtle

Active Member
Has anyone upgraded to V3.3.1 for Sales tax and have P73GEO working correctly?

I have upgraded Vertex sales tax V3.23 to V3.3 on AS/400 and all the Vertex tests run successfully. But, P73GEO in JDE no longer gets records from the GEOCODE file. The Vertex doc mentions that the City name field length has been increased in the Geocode file. We checked with Oracle before installing and they said there were no ESUs needed. I have a case open with Oracle on this and am waiting for Oracle to try and duplicate.
 
I have resolved this issue. The cpyfrmstfm command in the Vertex V3.3 admin manual (pg 6-36) says to copy to the geocode.file\geocode2.mbr and should say geocode2.file\geocode2.mbr. So the vertex upgrade to the geocode database was not finding the right data. It didn't give any errors and the test cases ran successfully. But, I don't think the geocode database was populated correctly and therefore p73geo didn't find records.
 
Back
Top