Query View PackingSlip and Shipment ID

(0) Share

Report

Posted on by bois0155

260

Hi guys,

I'm trying to create a view which contains only the ShipmentId, and the related PackingSlipID for this shipment.

However, we can cancel the packing slip and post it again meaning that we will have two packing slip for one shipment.

I want to select only the last posted packing slip for the selected shipment, doing it from X++ was easy, but somehow it is not working on the AOT query.

The properties are set to First Only, and I even added a group by ShipmentID (just to test), but it keeps showing both packing slips.

Am I missing something?

Thanks,

I have the same question (0)

All responses (3)

Answers (0)

Sort by

GirishS 27,843 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi bois,

For which table you have added group by of ShipmentId?

Thanks,

Girish S.

Was this reply helpful? Yes No
bois0155 260 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Girish,

Only the WHSShipmentTable contain the ShipmentID there.

Thanks,

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If the LoadId is same for both shipments, then add the group by of WHSLoadTableLoadId field from WHSLoadTableCustPackingSlipJour.

Thanks,

Girish S.

Was this reply helpful? Yes No