Microsoft Dynamics AX (Archived)

Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

(0) Share

Report

Posted on by Faizee

Some of the transactions does not post and return this error.

Please help

Faizan

*This post is locked for comments

All responses (19)

Answers (0)

Fahad Ahmad Farooqi 60 on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Dear Zeeshan,

Cheers!

Pls. mark the it as suggested answer so that others may be benefited from it as well.

Regards

Fahad
Suggested answer

Zeeshan Adeel 335 on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Thanks Fahad Ahmad Farooqi, your solution work for me.
Suggested answer

Fahad Ahmad Farooqi 60 on at

Like (1)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

We had this issue a little while ago.

Following step were used to fix it.

1. Clear the statement if any.

2. Identify the return transactions using following query:

SELECT RETURNTRANSACTIONID,RECID,* FROM RETAILTRANSACTIONSALESTRANS

WHERE STORE = 'abc' AND TRANSDATE = '2018-12-31' AND TRANSACTIONSTATUS NOT IN ('1','2') AND RETURNTRANSACTIONID != ''

3. Save all the records along with their recid in excel file.

4. Update returntransactionid field for all the records obtained using aforementioned query:

update RETAILTRANSACTIONSALESTRANS SET RETURNTRANSACTIONID = ''

WHERE STORE = 'abc' AND TRANSDATE = '2018-12-31' AND TRANSACTIONSTATUS NOT IN ('1','2') AND RETURNTRANSACTIONID != ''

5. Calculate and post the statement.

6. Now, update back the original returntransactionids one by one according to the recids obtained in step 3.

I hope that this will help you out.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Hi All,

i need your guidance on the retail posting issue

scenario : one shop sell the item and

Customer return the item on another shop.

is there any way to post the statements in D365.
mseddek 206 on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Did you find a solution for your case ?
Suggested answer

Sheikh Mydheen 77 on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Hi

This issue can be appeared due to set of reason

1. Your system might have configured with more than one POS systems and the Retail Transaction may be partially posted or it has assigned with statement Id .
Suggested answer

Sheikh Mydheen 77 on at

Like (1)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Hi

This issue can be appeared due to set of reason

1. Your system might have configured with more than one POS systems and the Retail Transaction may be partially posted or it has assigned with statement Id .

2. Please analyse and reverse posted vouchers for inconsistent retail transactions

You may run this SQL query to find which Sales orders ,

Create for them Credit notes and post them.

Please verify if there was posted any Payment journal for any of this sales invoice.

select STATEMENTID, SALESORDERID, INVOICEID, TRANSDATE, CUSTACCOUNT, sum(GROSSAMOUNT), count(*)

from RETAILTRANSACTIONTABLE

where SALESORDERID != ''

and ENTRYSTATUS = 0

group by STATEMENTID, SALESORDERID, INVOICEID, TRANSDATE, CUSTACCOUNT

order by 4,1

Check the result .If yes, reverse also these vouchers by posting manual Payment journals reversing original ones.
Sheikh Mydheen 77 on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Hello Mohammed Faizan

Please share you the screen shot and setup you have for Inventory at Retail store setup as well.
Oksana Kovaliova 3,597 on at

Like (1)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Hi Faizan,

Looks like POS return transaction has quantity greater than original sale or another return is already linked to original sale.

Most probably the error is thrown from the method insertReturnTransOrigin of table InventTrans - ask your developers to set breakpoint there and check item Id or temporary modify the code to show Item Id + maybe some additional data before throwing the error (p.3 on the picture) - having this info you will be able to find return retail transaction that causes the error and make deeper analysis what went wrong.

Regards,

Oksana
Syed Muhammad Sajid 360 on at

Like (0)

Report

RE: Error on Posting " The quantity being returned is greater than what can be covered by the return lot."

Hi ,

Any Solution for this issue?

i am also facing this Error at the time of Calculating Statement in retail modules.

Please suggest

SAJID.