Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

[AX2012] Link between Return order line and Invoice line

Posted on by 200

Dear community,

In AX you can create return order lines by marking lines on an invoice (Find Sales Order). Where does AX store the link between the return order line and the invoice trans line? You can't return the same invoice line twice, so there must be a link.. somewhere..

I thought this link was saved on the inventtrans records, but those aren't created until the return order line is registered.

Anyone knows?

Thanks, yours,

Berthil

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: [AX2012] Link between Return order line and Invoice line

    Hi Berthil,

    The return lot ID is indeed referencing the InventTransID from the original sales. But also good to read there is actually a check in place.

  • Berthil Profile Picture
    Berthil 200 on at
    RE: [AX2012] Link between Return order line and Invoice line

    Hi Ludwig,

    Thank you for your response. We're creating an automated return order creation process and we need to link this to the Original sales order. The lot ID seems to be the field I'm looking for.

    Yours,

    Berthil

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: [AX2012] Link between Return order line and Invoice line

    Hi Berthil,

    As Andre mentioned there is no field other than the lot ID and the RMA number that helps you identifying the linkage between the original and the return order. If you need something else then you have to consider making a system modification.

    Best regards

    Ludwig

  • Berthil Profile Picture
    Berthil 200 on at
    RE: [AX2012] Link between Return order line and Invoice line

    Ah.. I think I understand it now.

    The Return lot id references to the inventtransid from the Original sales order line, am I correct?

    Yours,

    Berthil

  • Berthil Profile Picture
    Berthil 200 on at
    RE: [AX2012] Link between Return order line and Invoice line

    Hi André,

    Thank you for your quick response. But in our setup we can only select invoice lines once, after that AX returns an error 'The quantity being returned is greater than what can be covered by the return lot.' or it disappears from the selection list.

    Yours,

    Berthil

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: [AX2012] Link between Return order line and Invoice line

    Hi Berthil,

    There is no link between an invoice and the return order other than it might fill the return Lot-ID for cost price purposes. So, in fact you can perform the action multiple times. The feature is intended to create new orders or return orders more quickly or with consistent data.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans