Find original sales line by return sales line

// By return salesLine
returnSalesLine.InventTransIdReturn = originalSalesLine.InventTransId

// By return SalesId
protected SalesId getOriginalSalesId(SalesId _returnSalesId)
{
    SalesId             ret;
    SalesLine           salesLine;
    InventTransOrigin   inventTransOrigin;

    select firstOnly RecId from salesLine
        where salesLine.SalesId             == _returnSalesId
            &&salesLine.InventTransIdReturn != ''
        join RecId, ReferenceId from inventTransOrigin
            where inventTransOrigin.InventTransId       == salesLine.InventTransIdReturn
                &&inventTransOrigin.ReferenceCategory   == InventTransType::Sales;

    if (inventTransOrigin)
    {
        ret = inventTransOrigin.ReferenceId;
    }

    return ret;
}


Support The Author

 If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee

Post a Comment


All Comments


No comments. Be the first one to comment on this post.

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own "buy me a coffee" link.
Join us.

Blog Tags