Projects Core > Projects > Customers and Contacts
Hello, we seem to have got ourselves in a pickle with the way our end users have set up Customers and Contacts in PAXPREPR
Basically they have not populated the Contact Type zone
This makes a mess of our RAXINV program as the transactions that do not have Contact Type populated do not get Printed
I could do with writing a BIP report that shows by Project, Customers where the Contact Type is not populated
Can someone help me with some sql that would help us locate Customers with this Setup deficiency?
I have attached a sample of what a malformed Customer looks like in PAXPREPR