I have a POOrder object which contains both the ShipContactID and ShipAddressID. How do I obtain POShipContact and POShipAddress using either BQL or PXSelect?
Solved
POReceiptEntry graph extension: how do I get the POShipContact and POAddress using a POOrder?
Best answer by Django
So one way to figure that out is to look at the code of POOrderEntry graph. A quick search on “address” finds this view within the graph:
[PXViewName(Messages.POShipAddress)]
public PXSelect<POShipAddress, Where<POShipAddress.addressID, Equal<Current<POOrder.shipAddressID>>>> Shipping_Address;
You can see that the POOrder.shipAddressID links to a POShipAddress record.
You should work through the training documentation. It will help you to figure this stuff out and understand it.
So one way to figure that out is to look at the code of POOrderEntry graph. A quick search on “address” finds this view within the graph:
[PXViewName(Messages.POShipAddress)]
public PXSelect<POShipAddress, Where<POShipAddress.addressID, Equal<Current<POOrder.shipAddressID>>>> Shipping_Address;
You can see that the POOrder.shipAddressID links to a POShipAddress record.
You should work through the training documentation. It will help you to figure this stuff out and understand it.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.