web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to delete and refi...
Microsoft Dynamics AX (Archived)

How to delete and refill unposted retails transaction in retail HQ

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

Can I delete all not posted retail transaction in HQ, and re-run P-jobs to refill the retail transaction tables again. I tried clear and delete statement, but the retail transactions are still in the database.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Ysrael,

    You should not delete retail transactions from HQ. This is not necessary. When the statements are cleared, the transaction will not have a statementID linked to it. You can then re-calculate and post them.

    What is the issue you are trying to resolve here?

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Emily,

    Recently we had an issue on posting Retail Statement. We cannot post one retail statement because of this issue "The Transactions on Voucher xxx, date 4/6/2015,

    account, transaction currency amount -#,###.00,

    accounting currency amount -#,###.00,
    reporting currency amount -#,###.00,

    currency SAR, text Slip - Trans:Store:Terminal:XXXXXXX". 
    I checked all settings of Retail Store and everything was ok. So I checked each transactions on that statement, and I found one of Income/expense transaction of POS have no entry on the RetailTransactionIncomeExpenseTrans table, that caused the error while posting the statement. I have no idea how this happened, might be with the data synch while running batch job. My first solution is to clear the statement and delete the transactions in the Retail HQ database and then run P-job, 2nd is Data patching, manually insert the retail income/expense transaction records into RetailTransactionIncomeExpenseTrans table. I had a hard time to find references on my first solution and it's quite complicated, so I jump into my 2nd solution which is less risky for me, but first I took and assigned a unique RECID and RECVERSION for that transaction. And the Retail Statement was posted successfully.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans