Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Transaction does not have any item that can be returned.

Posted on by 45

Hello Every one,

I am getting an error at Retail POS.

when I return any transaction on retail POS it shows error "Transaction does not have any item that can be returned". I have also checked "retailtransactiontable" table its field transaction type is 2 and other tables are also showing proper data at client end database. I also checked user rights.

what else I would check and why this error appearing again and again .

please help.

Thanks in advance.

Regards

Faizan

*This post is locked for comments

  • Suggested answer
    Razal Profile Picture
    Razal 200 on at
    RE: Transaction does not have any item that can be returned.

    Hello Faizan,

    Check RetailTransactionSalesTrans table where ReturnTransactionId='SaleTransactionId'  and also check RetailTransactionSalesTrans table where TransactionId='SaleTransactionId'  if both are matching, then return transaction is completed no more items pending to return.

    if not, then issue comes when the return transaction is not completed successfully. Check the sale transaction in RetailTransactionSalesTrans table and see RETURNQTY is -1 for any of the line items. if yes, then mark it as 0 and try returning. 

  • B.W Profile Picture
    B.W 505 on at
    RE: Transaction does not have any item that can be returned.

    Hi Kemo.

    apologies for the late response. where did you find the transaction? did you look in the sql database table for the return qty field for the lines you are looking for?

    also, if you are using real-time time service POS will check if the items have been returned on AX as well.

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Transaction does not have any item that can be returned.

    Please don't write in capital letters.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction does not have any item that can be returned.

    I DID FIND THE TRANSACTION BUT  AM HAVING A PROBLEM IN FINDING THE ITEM IN THE RETURNABLE ITEM LIST, WHAT CAN I DO ?

  • B.W Profile Picture
    B.W 505 on at
    RE: Transaction does not have any item that can be returned.

    Good day Kemo.

    i cannot remember exactly what my problem was previously. but i think you should check the transaction lines, check if there is a returned transaction ID or return qty field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transaction does not have any item that can be returned.

    hi B.A

    hope you are well

    Did you find the solution for this ????

  • B.W Profile Picture
    B.W 505 on at
    RE: Transaction does not have any item that can be returned.

    Hi Muhammad.

    Hope you are well.

    Did you ever find a solution for this?

    i am having the similar issue.

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans