Latest Axapta / Dynamics AX FAQ Pages

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

This post has

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu Posted: 2013-10-29 5:12
Male
291 Posts
6,904 Points
Joined: 2012-2-8
Last Online:
2014-7-21 13:37
Location: Nancy France
Thomas Post replied on 2013-10-29 9:23

Hi,

You can restore table records in the menu /Administration/Search/Database log, filter on your tableId (345 for Purchtable) then filter on type of modification, delete in your case, search the record you want to restore, go to to the history tab, select it and click on the reinsert button.It will regenerate your purchase order. This works in AX 2009.

Hope it helps, please verify solution if it solves your problem.

Regards,

Thomas

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-10-29 14:19

Thanks Thomas for the solution . Is it Administration -->Inquiries --> Databaselog? But the table was completely empty. There was no records.

 

Male
291 Posts
6,904 Points
Joined: 2012-2-8
Last Online:
2014-7-21 13:37
Location: Nancy France
Thomas Post replied on 2013-10-29 14:54

Yes the path is correct,if you have ne records, it's because you have no logged table, to check if it's enabled on your table: go to \Administration\Setup\Database log and create a record for your table with the type of modification(insert, delete or update) you want to trace.

 you won't be able to restore anything before logging activation, so in your case, you won't be able to restore your purchtable record, database logging is a preventive process

Regards,

Thomas

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-10-29 15:10

Thanks Thomas. Ya we haven't done the set up for the database log.

 

Male
10,982 Posts
176,532 Points
Joined: 2000-11-3
Last Online:
2014-9-1 7:55
Location: UK
DynamicsNAVMVP
Moderator
AdamRoue replied on 2013-10-29 20:41

Then there is no way to get it back, it has gone.

“Any fool can know. The point is to understand.”
Albert Einstein

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-10-30 5:33

Hi, Please let me know if it takes lots of space when we set up the database log set up? Also how about the performance? Will the performance gets reduced for the users due to enabling the database log set up?

Thanks

Male
75 Posts
780 Points
Joined: 2011-11-3
Last Online:
2014-9-1 9:28
Location: INDIA
Deepak Agarwal replied on 2013-10-30 5:51

Hey Sindhu,

try this link

http://theaxapta.blogspot.in/2012_09_01_archive.html

Deepak Agarwal [AX-MVP] [MCTS]

Share your expertise on Facebook also


 

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-10-30 6:16

Ya i already worked on with this class. But i was bit scared to  proceed further because of the LPO which has delivery note and sales invoice.Thanks deepak for the response.

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-10-30 11:55

Hi, Please let me know if it takes lots of space when we set up the database log set up? Also how about the performance? Will the performance gets reduced for the users due to enabling the database log set up?

Thanks

Male
291 Posts
6,904 Points
Joined: 2012-2-8
Last Online:
2014-7-21 13:37
Location: Nancy France
Thomas Post replied on 2013-10-30 13:08

Hi,

I didn't noticed a performance reduction, it will increase a little your database size with filling log table but nothing serious

Regards,

Thomas

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-10-31 5:27

Thanks Thomas.Let me try with the given solution for the future LPO.

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-11-4 6:15

Hi Thomas,

Could you please tell me the steps for setting up the database log?

 

Thanks

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-11-4 6:59

Hi Thomas ,

I made the set up.I just tried in test server. It restored the purchase order header but it didnt restore the purchase lines. Please let me know if i need to set up something else for purchase line.

Thanks

138 Posts
1,280 Points
Joined: 2012-5-2
Last Online:
2014-9-1 9:21
Location: Abudhabi,UAE
Sindhu replied on 2013-11-4 7:14

Hi,

I tried to restore the LPo with lines but it changed the status as Cancelled. Is it possible to do some set up for changing the status as Open order?

Thanks

|
Page 1 of 1 (15 items) | Bookmark and Share