Hi, my purpose is to safe space in my server, b'cause logically we don't need our transaction data for example 10 years ago still intact in our production database, right ?
(... if 10 years from now, I still use Axapta.. haha...) It's alright about master data, but we still need outstanding customer invoice, outstanding purchase/sales order.. etc .. so basicaly I just want to delete data such as inventory journal, ledger journal, etc, and all tables related which the transaction date is 5 years backward from now. Thanks, --- In [email protected], "Hardi" <[EMAIL PROTECTED] > wrote: > > Hi Anton > > May I know the reason you want to delete old transactions? > If the purpose is to have a new clean company database with all the > master data and setups from the old one, can't we just do export > import with definition groups pointing to master tables (not include > transaction tables)? > > If the purpose is to have clean database (If I can understand your > purpose correctly), than my suggestion is that > Create a new empty company in the environment > Export the data (master tables only) from old environment > Import again to the new empty company > > After that don't forget to perform Consistency Check > (Basic/periodic/consistency check). This job will take quite lot of > time but to help us identify uncompleteness/inconsistency of the > master data or setups before the new company used for transactions. > > > Thanks & regards > > HArdi T > > --- In [email protected], "Anton Tjiptadi" > <[EMAIL PROTECTED]> wrote: > > > > dear all, > > I wonder if I can delete all data from my axapta database, for > example > > transaction data 2004 backward. > > > > how can i do that ? is there a function in axapta for that ? > > > > thanks in advance, > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
