Calculate Statement error

(0) Share

Report

Posted on by Steven Cattermole

310

Hi,

Having some trouble trying to calculate a statement in AX 2012 Retail. I get the error message when trying to calculate the statement: "The quantity being returned is greater than what can be covered by the return lot." Anyone have any idea how to clear the error. We are receiving more and more occurrences of the issue. Seems to be return transactions causing the issue.

Any ideas or help would be appreciated.

Thanks,

Steve

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Ian Nuttycombe 484 on at

Like (0)

Report
Copy link

Link copied!

What version of AX are you running?

There is a hotfix available for this mbs2.microsoft.com/.../kbdisplay.aspx

If you google the error message you will see it has been discussed before

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Steven,

Did you get the solution for this issue. Even i am facing the same problem. Can you share the solution.

Thanks,

Shravan

Was this reply helpful? Yes No
Suggested answer

CattermoleS 55 on at

Like (0)

Report
Copy link

Link copied!

Hi Shravan,

Basically the return transaction was trying to return more than was originally sold against the original receiptID. Although I have been unable to replicate this through the POS. As a workaround you can remove the returninventtransorigin from the inventtrans record associated to the original Sale.

Regards,

Steve

Was this reply helpful? Yes No
Mahmood Ali963 20 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I don't know the root cause of this problem as sold & return quantities are same and notice this issue for the returns other than inventory unit.

Workaround is to remove RETURNTRANSACTIONID from RETAILTRANSACTIONSALESTRANS and put back RETURNTRANSACTIONID after sales calculation & posting.

Regards

Mahmood

Was this reply helpful? Yes No