removed salestable record

(0) Share

Report

Posted on by Colin Lee

i have facing strange situation.

i found a sale order that has sales line but no sales order's header(salestable) record.

there are records from inventtransorigin, inventtrans, custpackingsliptrans. salesline and so on. but no record only in salestable.

i guess it was deleted on sql by something.

furthermore, same cases are found different customer each.

so,

could you let me know why and solution?

is there any job for re-creating salestable record from the other record?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Hi,

There is no functionality to recreate Sales orders, You need restore data base again. Please check the log. How salesTable will delete, can you explain more!

Thanks

Suresh

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

Hi Colin Lee,

The only option to restore header deleted directly in SQL only restore of DB backup, as Suresh mentioned. However, if order is fully invoiced you may ignore it.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

And, for future reference you better create log for SalesTable and related tables. then you can tract how the record is deleted, updated and track on new transactions.

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

I disagree with Suresh, you should avoid database logging of any worksheet/transactional tables which may produce high volume for a long term.

However, you may use it for a short period of time to track the deleted records to find the call stack which causes your issue, if you notice that sales order headers are still getting lost.

What I can recommend is take a look at access rights for your database, and remove administrative permissions from everyone except the Databas Administrator and the Service accounts. Consider giving read-only permission to special accounts as well. This way you reduce the chance that data is getting modified/deleted accidentally or on purpose.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Dear Vilmos Kintera,

-------------------------------------------------------------------

What I can recommend is take a look at access rights for your database, and remove administrative permissions from everyone except the Databas Administrator and the Service accounts. Consider giving read-only permission to special accounts as well. This way you reduce the chance that data is getting modified/deleted accidentally or on purpose.

----------------------------------------

I don't know why he will give admin rights for everyone?, he didn't mentioned anywhere in the post. and if you want to suggest, you can suggest the solution for the question not tread replies!

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

I am sure Suresh that you do agree that records do not magically disappear on their own, it can only be removed by an account that has enough permissions granted. That is why the suggestion is there to verify account security permissions - I have seen it happening when a junior has admin rights over a DB and does harm to Production, thus the suggested answer is applicable in this situation as well (even if you are not on my opinion for applicability). Remove elevated access from whoever does not need it as a preventive measure of not losing any more data than he already lost.

On top of that, check all security permissions in AX as well and see who has security roles that may delete sales orders.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I agree with you now but, In sales order there will be multiple table information included. as he told only header records deleted which is related to SalesTable. But however a company wont give admin rights for everyone. Deleting Sales order is very simple the below setup is not set by the expert and which is very Basic setup for deleting Sales order.

And if we set privilege with Sales table effective access with create! This is very basic setup and customization for everyone. it they don't this, simply by clicking Alt+F9 we can delete the SalesTable records.

I accept removing the admins rights to all except administrator and the service accounts, still he must need to restore the previous database. If I'm wrong correct me.

Thanks

Suresh

Was this reply helpful? Yes No
Verified answer

Colin Lee 60 on at

Like (0)

Report

Once again,

All the data in the sales order except salestable records existed.

In this situation I solved this issue in the following way.

It was not a fancy way, but I was able to post an invoice in the receipt status.

I created a new sales order containing information that I considered to be the same as the sales order. And changed the new sales order number to the number of the sales order.

It was a trick, but this method enabled invoicing.

Was this reply helpful? Yes No