Some of the transactions does not post and return this error.
Please help
Faizan
*This post is locked for comments
Dear Zeeshan,
Cheers!
Pls. mark the it as suggested answer so that others may be benefited from it as well.
Regards
Fahad
Thanks Fahad Ahmad Farooqi, your solution work for me.
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.
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.
Did you find a solution for your case ?
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 .
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.
Hello Mohammed Faizan
Please share you the screen shot and setup you have for Inventory at Retail store setup as well.
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
Hi ,
Any Solution for this issue?
i am also facing this Error at the time of Calculating Statement in retail modules.
Please suggest
SAJID.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156