How to get Orders Section in Shipment Form?

Hello @jennifer39 ,

I can’t see what form you are trying to customize because identifying information has been chopped off of the screen shot.  Picking List, Packing Slip, Shipment confirmation??  I will use Shipment Confirmation in this example.

1. Use Customization → Inspect Element to determine what table/DAC  holds the Orders data for the Shipment screen.

2. Shipment confirmation comes with the following tables. Notice, SPOrderShipment is not present, therefore you will need to add SOOrderShipment to the report.

3. To add a table to a report,

• Click File, Schema Builder, Load Schema.
• Find SPOrderShipment in the list of report tables at the left and click on it. Use Arrow in the middle to add table to report.
• Go to Relationships tab and connect the SOOrderShipment table to your report on Order Type and Order Number.

Good luck!

Laura

Hi Laura,

Thank you for the reply. I have created a relationship between SOShipLine and SOOrderShipment. However, the problem now is that it is repeating the SO order number as many times as there are inventory IDs in the shipment. I want only one line there. Please advise.

I am working in shipment confirmation form.

Hi Laura,

Hope you are doing well!

I have joined SOOrder to SOOrderShipment. but still having same issue.

Thank you

Hello Jennifer,

I am well, thank you. How are you?

What similar Acumatica reports did you compare your report’s Relationships to?  What other relationships did you try? 

Please show your new Relationships; seeing relationships and example of the results will help us to answer. Thank you.

Laura

Hi Laura,

Here is my some screenshot :

I wanted to print Orders Tab of shipment in Shipment print form, so I have edited Shipment Confirmation form. If I have two SO number in my Shipment, it is printing two pages, how can I print in one page.

I have attached my report rpx copy for the reference.

Hello Laura,

I want to express my gratitude for all your responses. I truly appreciate your assistance and the time you've dedicated to helping me.

I have attached my final working report.

Thank you

Jennifer

Nice job, Jennifer!  I’m so glad it worked out.

Laura