Hi Team,
I need to get the Vendor registered or configured Tax Id's (Tax class) to a foreach loop for a particular vendor record (BAccountID = X). Can someone please help me out to give me the BQL query for this?
Thanks
Bhagya
Hi Team,
I need to get the Vendor registered or configured Tax Id's (Tax class) to a foreach loop for a particular vendor record (BAccountID = X). Can someone please help me out to give me the BQL query for this?
Thanks
Bhagya
Hi
If you are asking about this:
The query is based on the Location class
as follow:
...
using PX.Object.AP;
...
var q = new SelectFrom<VendorAttribute.Location>
.Where<Use<VendorAttribute.Location.bAccountID>.AsInt.IsEqual<@P.AsInt>>
.View(graph);
foreach(Vendor v in VendorList)
{
...
if(v.BAccountID == targetBAccountID)
{
...
VendorAttribute.Location loc = q.Select(targetBAccountID).FirstOrDefault();
string taxRegID = loc.TaxRegistrationID;
...
}
...
}
...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.