Find latest Posted Sales Order Confirmation in X++

 you can easily find the latest Posted sales order confirmation with X++. To do this you need to extend the CustConfirmJour Table class and create a new method.

Here is an example

[ExtensionOf(tablestr(CustConfirmJour))]
final class CustConfirmJour_Table_Extension
{
    static CustConfirmJour findLatest(SalesId _id, boolean _update = false)
    {
        CustConfirmJour custConfirmJour;
        custConfirmJour.selectForUpdate(_update);

        select firstonly CustConfirmJour
            order by CustConfirmJour.ConfirmDate desc
            where CustConfirmJour.SalesId == _id;

        return CustConfirmJour;
    }
}