Error when Clear statement "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

(0) Share

Report

Posted on by Khaled Ahmed

2,475

We made Batch job to calculate statement for some reason we restart AOS while calculate statement was working ,by anyway batch job create a lot of statement we clear and delete almost except 3 then When we try to clear the statement that create by batch then interrupted by stop AOS the error appear "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

Kindly help to solve this issue , We need to clear these statement .

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Albrecht Prieler 857 on at

Like (0)

Report

RE: Error when Clear statement "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

Hello,

check if items where already returned, cause you can only return same quantity as original quantity if you are using original inventtransid for return.

Was this reply helpful? Yes No
Verified answer

w.sallam 2,259 on at

Like (1)

Report

RE: Error when Clear statement "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

Please try the following script on SQL Server:

update RETAILTRANSACTIONSALESTRANS
set INVENTTRANSID = ''
where STATEMENTID in ('XXXXXXX') -- put your statement ID
and qty > 0v
and TRANSACTIONSTATUS = '1'
and inventtransid != ''

after the script you can clear the statement and delete it.

if you calculate the statement again you will get the same error so you can apply this hotfix KB 4013834 “InventTransId is assigned to retail sales transactions with status Voided” to prevent this issue from occurring again .

https://fix.lcs.dynamics.com/Issue/Details?kb=4013834&bugId=3811615

Was this reply helpful? Yes No
Arshad Ahmad 100 on at

Like (0)

Report

RE: Error when Clear statement "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

Hi!

I'm having same issue I ran this script on SQL Server but still I am having the same the issue.

Is there something else to be done?

Regards

Arshad

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Error when Clear statement "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

Hi Ahmed, did you get the solution. Please provide the solution. Thanks in advance.

Was this reply helpful? Yes No
Suggested answer

Khaled Ahmed 2,475 on at

Like (0)

Report

RE: Error when Clear statement "Quantity 1.00 cannot be returned because items have already been returned or marked as open transactions."

Please try the following script on SQL Server:

update RETAILTRANSACTIONSALESTRANS

set INVENTTRANSID = ''

where STATEMENTID in ('XXXXXXX') -- put your statement ID

and qty > 0v

and TRANSACTIONSTATUS = '1'

and inventtransid != ''

after the script you can clear the statement and delete it.

if you calculate the statement again you will get the same error so you can apply this hotfix KB 4013834 “InventTransId is assigned to retail sales transactions with status Voided” to prevent this issue from occurring again .

fix.lcs.dynamics.com/.../Details;bugId=3811615

Was this reply helpful? Yes No