Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

delete item from retail

Posted on by 5

At certain time after creation of Items,

 The table with name RETAILINVENTTABLE has been deleted (THERE is NO Data) , and RETAILASSORTMENTLOOKUP has been deleted (there is NO data Inside) as well

Customer send Jobs to update stores with the newly defined items,

Then the Synchronized Job is deleting all products from stores, and all stores can’t sell any products as no single product is still defined in the store

*This post is locked for comments

  • RE: delete item from retail

    Hi

    It' Deleted automatically from back office 1st

    Then when send jobs it deleted from retail pos database

    Thanks

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: delete item from retail

    Hi.. One thing that still not clear is - Is this delete happening automatically Or someone deleted data? Check settings on retail sub-jobs that push data for integration to retail.

  • RE: delete item from retail

    Thanks for your time and effort

    Can you tell  me is it a bug in R3 CU13 .

    And how can I know which tables is effecting to cause such delete or item disappeared.

    Thanks  and waiting

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: delete item from retail

    Great. Remove access to AOT & SQL for unauthorized users and for those who can create such type of issues.

    Make a policy - No data deletion from tables directly and enforce this.

  • RE: delete item from retail

    Hi Satish,

    Thank you for your reply

    We restored data already but we want to know how to avoid it to be repeated again as its very danger matter

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: delete item from retail

    Hi mervat,

    There are significant issues when data is deleted from tables. The retail tables are used to push data to stores.

    Based on your description above and in absence of any questions asked, assuming you want to get data back. Either you can restore the data in tables OR run AX jobs to populate the retail tables again which will add again the products to stores

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans