I need to get some SOOrder extension values that I don’t have in my POReceipt. Is there a way to code this in C# in my POReceiptEntry graph extension?
Solved
POReceiptEntry graph extension: how do I get the SOOrder related to the POOrder?
Best answer by bpgraves
public PXSelectReadonly<POOrderReceipt, Where<POOrderReceipt.receiptNbr, Equal<Required<POOrderReceipt.receiptNbr>>>> KCPOOrderReceipt;
public PXSelectReadonly<POOrder, Where<POOrder.orderNbr, Equal<Required<POOrder.orderNbr>>>> KCPOOrder;
public PXSelectReadonly<PX.Objects.SO.SOOrder, Where<PX.Objects.SO.SOOrder.orderNbr, Equal<Required<PX.Objects.SO.SOOrder.orderNbr>>>> KCOrderByOrderNbr;
POReceipt receipt = Base.Document.Current;
POOrderReceipt poOrderReceipt = KCPOOrderReceipt.Select((object)receipt.ReceiptNbr);
if (poOrderReceipt != null && !string.IsNullOrEmpty(poOrderReceipt.PONbr))
{
POOrder poOrder = (POOrder)KCPOOrder.Select((object)poOrderReceipt.PONbr);
if (poOrder != null && poOrder.OrderType == "DP")
{
SOOrder order = this.KCOrderByOrderNbr.Select((object)poOrder.SOOrderNbr);
}
}
You need to have an audit trail to follow. Is there any data that you can see on your POReceipt that you can use to go back to the SO? Is your PO a drop ship?
Django wrote:
You need to have an audit trail to follow. Is there any data that you can see on your POReceipt that you can use to go back to the SO? Is your PO a drop ship?
Yes, to both questions. I do have the SOOrderNbr in the POOrder which is a drop ship. How do I get the SOOrder (using C#) in my POReceiptEntry graph extension? I’m assuming I need to get the POOrder first and then find the SOOrder using the SOOrderNbr in POOrder.
I’m assuming I need to get the POOrder first and then find the SOOrder using the SOOrderNbr in POOrder.
You got it!
It would be worth it going through the developer courses as you’ll get a sense of how to look at a screen/graph and figure out what views you can access.
1 person likes this
public PXSelectReadonly<POOrderReceipt, Where<POOrderReceipt.receiptNbr, Equal<Required<POOrderReceipt.receiptNbr>>>> KCPOOrderReceipt;
public PXSelectReadonly<POOrder, Where<POOrder.orderNbr, Equal<Required<POOrder.orderNbr>>>> KCPOOrder;
public PXSelectReadonly<PX.Objects.SO.SOOrder, Where<PX.Objects.SO.SOOrder.orderNbr, Equal<Required<PX.Objects.SO.SOOrder.orderNbr>>>> KCOrderByOrderNbr;
POReceipt receipt = Base.Document.Current;
POOrderReceipt poOrderReceipt = KCPOOrderReceipt.Select((object)receipt.ReceiptNbr);
if (poOrderReceipt != null && !string.IsNullOrEmpty(poOrderReceipt.PONbr))
{
POOrder poOrder = (POOrder)KCPOOrder.Select((object)poOrderReceipt.PONbr);
if (poOrder != null && poOrder.OrderType == "DP")
{
SOOrder order = this.KCOrderByOrderNbr.Select((object)poOrder.SOOrderNbr);
}
}
Django wrote:
I’m assuming I need to get the POOrder first and then find the SOOrder using the SOOrderNbr in POOrder.
You got it!
It would be worth it going through the developer courses as you’ll get a sense of how to look at a screen/graph and figure out what views you can access.
Can you be more specific about what “developer courses” you are referring to? I took the development video training years ago. Did it change or get more specific recently?
+10Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
1 person likes this
If you log on to Acumatica.com and click on “Learn” at the top you’ll be taken to Acumatica’s Litmos site and there is an Application Developer training path. There are seven courses (T200, T210, etc) that cover a good portion of what you’ll encounter when customizing Acumatica. There’s also the Framework Development Guide which is a good reference. They’re kept very up to date.
Edit:
The online help references those training courses as well.
And, to be fair, your specific question isn’t covered in the documentation but once you’ve gone through those you should feel more comfortable with navigating around the data and the graphs to get what you’re looking for.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.