Description |
After importing vendors during AP conversion, we noticed that when looking up vendors, the Printed Name and freight terms field is blank in the main entity screen and the location printed name screen.
Requirements:
1. Data fix: Script to update all vendors printed name.
begin tran
update tblEMEntityLocation
set strCheckPayeeName = strLocationName,
intFreightTermId = 3
from tblEMEntityLocation A
inner join tblAPVendor B on A.intEntityId = B.intEntityId
--where B.intEntityId = 4155
commit tran
rollback tran
2. Program fix
!pastedImage_d106817_0.png!
|