While getting assistance with another question, I was given excellent help from Victoria in the form of a view, view_AP_Distributions
. When running it I discovered that about 4% of the total transaction records in that table contain a null vendorName (VendorID was spaces). It was discovered that 99% of the problem records were found in the PM30600 table. Many of these are current records, some even added via the interface today. When I look at these transactions in the G.P. client, they do contain the proper Vendor information. How can I link these records up to a vendorID for my query and how can I prevent more of these records from being created with Null/blank values? I imagine that the user must be doing something, though they claim to be doing all vendor stuff the same way.