Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

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

Posted on by 45

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

Please help

Faizan

*This post is locked for comments

  • 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 Profile Picture
    Zeeshan Adeel 335 on at
    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
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

    444532.Capture.PNG

  • mseddek Profile Picture
    mseddek 206 on at
    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 Profile Picture
    Sheikh Mydheen 77 on at
    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 Profile Picture
    Sheikh Mydheen 77 on at
    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 Profile Picture
    Sheikh Mydheen 77 on at
    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 Profile Picture
    Oksana Kovaliova 3,595 on at
    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.

    invent-trans-return.png

    Regards,

    Oksana

  • 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.

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,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans