web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Transaction does not have any item that can be returned.

(0) ShareShare
ReportReport
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

I have the same question (0)
  • B.W Profile Picture
    505 on at

    Hi Muhammad.

    Hope you are well.

    Did you ever find a solution for this?

    i am having the similar issue.

  • Community Member Profile Picture
    on at

    hi B.A

    hope you are well

    Did you find the solution for this ????

  • B.W Profile Picture
    505 on at

    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
    on at

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

  • nmaenpaa Profile Picture
    101,166 Moderator on at

    Please don't write in capital letters.

  • B.W Profile Picture
    505 on at

    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.

  • Suggested answer
    Razal Profile Picture
    200 on at

    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. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans