Vendors Do Not Display in Searches or List (Internal)

07/16/2025 6:02 pm EDT

Issue:

When clicking Search, Vendors do not show after updating to 6.2.0.19.

A screenshot of a computerDescription automatically generated

Resolution:

There was a change in the release that caused a problem with Vendor Address information.

The scripts below can be used to correct the address information so the Vendor records will display correctly.

--- Selects to determine if this is the problem with Vendor Records

select g4.Table4_Id,v.GE_Table4_Id, *

from AP_Vendor v

left outer join GE_Table4 g4 on g4.Table4_Id =v.GE_Table4_Id

where g4.Table4_Id is null


select g5.Table5_Id,v.GE_Table5_Id, * 

from AP_Vendor v

left outer join GE_Table5 g5 on g5.Table5_Id =v.GE_Table5_Id

where g5.Table5_Id is null

If there are records returned, then use the Update statements below to correct the problem.

--- Update scripts to correct the problem with Vendor Records

update v set v.GE_Table4_Id =1

from AP_Vendor v

left outer join GE_Table4 g4 on g4.Table4_Id =v.GE_Table4_Id

where g4.Table4_Id is null


update v set v.GE_Table5_Id =1

from AP_Vendor v

left outer join GE_Table5 g5 on g5.Table5_Id =v.GE_Table5_Id

where g5.Table5_Id is null

Was this article helpful?