Different profiles yield different results for Payee on HUD
Posted: Fri Sep 13, 2013 8:58 am
I've come across a strange bug in the UI (this also includes the API) where different profiles give different results for Payees on a HUD. For example, viewing an order through the profile that matches OwningProfileID for the order, I get one set of results, but viewing through that OwningProfileID's parent profile gives another set of results.
I've attempted to attach a couple of screenshots, but something is wrong with the forums and I keep getting this error:
Could not upload attachment to ./files/174_06cb89510f31eb3e1a18df30b21aec33.
Someone please contact me and I'll PM them to you.
If I query the database directly for line 1103, I don't see three payees associated with this line.
Query below:
use SoftProDb
select hl.Number, oc.Code, oc.Name, hlp.*
from [order] o
join HudHeader hh on hh.OrderID = o.ID
join HudLine hl on hl.HudHeaderID = hh.ID
join HudLineAdditionalCharge hlac on hlac.HudLineID = hl.ID
left join HudLinePayee hlp on hlp.HudLineAdditionalChargeID = hlac.ID
left join OrderContact oc on oc.ID = hlp.PayeeID
where o.Number = 'NC-028630' and hl.Number between 1101 and 1199
order by hl.Number
This same problem can be duplicated if reading the payees for a HUD line through the API. Two payees match, but one does not.
I've attempted to attach a couple of screenshots, but something is wrong with the forums and I keep getting this error:
Could not upload attachment to ./files/174_06cb89510f31eb3e1a18df30b21aec33.
Someone please contact me and I'll PM them to you.
If I query the database directly for line 1103, I don't see three payees associated with this line.
Query below:
use SoftProDb
select hl.Number, oc.Code, oc.Name, hlp.*
from [order] o
join HudHeader hh on hh.OrderID = o.ID
join HudLine hl on hl.HudHeaderID = hh.ID
join HudLineAdditionalCharge hlac on hlac.HudLineID = hl.ID
left join HudLinePayee hlp on hlp.HudLineAdditionalChargeID = hlac.ID
left join OrderContact oc on oc.ID = hlp.PayeeID
where o.Number = 'NC-028630' and hl.Number between 1101 and 1199
order by hl.Number
This same problem can be duplicated if reading the payees for a HUD line through the API. Two payees match, but one does not.