Langsung ke konten utama

Data Cleanup Utilities in Microsoft Dynamics AX

Standard Microsoft Dynamics AX 2012 includes a number of utilities used for "cleaning up" unneeded data.  Using these utilities will help keep data from building up in the database, which can improve system response times. 
General Ledger:
General ledger> Periodic> Clean up > Clean up ledger journals
Inventory and Warehouse Management:
Inventory and warehouse management> Periodic> Clean up> Inventory journals cleanup
Inventory and warehouse management> Periodic> Clean up> Inventory settlements cleanup
Inventory and warehouse management> Periodic> Clean up> Inventory dimensions cleanup
Inventory and warehouse management> Periodic> Clean up> Dimension inconsistency cleanup
Organization Administration:
Organization administration> Common> Number sequences> Number sequences
​Action pane> Administration> Manual cleanup
Organization administration> Periodic> Calendar cleanup
Organization administration> Periodic> Delete inactivated addresses

Procurement and Sourcing:
Procurement and sourcing> Periodic> Clean up> Purchase update history cleanup​
Production control> Periodic> Clean up> Production journals cleanup
Production control> Periodic> Clean up> Production orders cleanup

Sales and Marketing:
Sales and marketing> Periodic> Clean up> Sales update history cleanup

System Administration:
System administration> Periodic> Notification cleanup
System administration> Inquiries> Users> User log
Action pane> Clean up
System administration> Inquiries> Database> Database log
A​ction pane> Clean up log
System administration> Inquiries> Batch jobs> Batch job history
Action pane> Delete

Label:

Komentar

Posting Komentar

Postingan populer dari blog ini

Use X++ wildcard (LIKE and NOT LIKE) in X++ select statement

For x++ select statements:  select firstOnly batchHistory      where batchHistory.Caption  LIKE  "*Test*"  For x++ queries:  queryBuildRange.value(*Test*); Note the LIKE instead of a '==' and the wildcards inside of the quotations. All other combinations of wildcard usage will work here. This is the same functionality as what the users would put in the grid filtering(eg. '*TEST*' in the caption field filter on the batch tasks form).  However, if you want to find all Captions that do not have the word Test in them (NOT LIKE, !LIKE), you will have to modify the above example slightly.  For x++ select statements:  select firstOnly batchHistory      where  !( batchHistory.Caption LIKE "*TEST*" ) ;  For x++ queries:  queryBuildRange.value(!*Test*);
Posting Komentar
Baca selengkapnya

Format Label Tom Jerry (MS Word)

Setelah beberapa lama aku tidak membuat label undangan, tiba-tiba kemarin aku diminta untuk membuat label undangan Wisuda dengan menggunakan label merek Tom & Jerry (TJ). Harusnya sih menjadi tugas sekretaris panitia tapi karena yang bersangkutan ada tugas di luar kantor maka aku yang membereskannya. Mula-mula aku membuat format labelnya dengan cara manual, tapi untung ada pak Mulyadi (staf tata usaha) yang menyarankan aku untuk mengunduh format label yang telah ada di Internet. Mulailah aku browsing di google dan menemukan format label berbagai ukuran dari website Tom & Jerry di alamat berikut  http://tjlabels.com/en/download.html  (yang link ini agak rempong krn pake masukin nomor captcha-captcha-an). Sedangkan kalau yang link ini langsung pilih file ga pake nomor captcha-captcha-an ( http://tjlabels.com/assets/download/ ). Ternyata juga ada banyak berbagai blog yang menyediakan  link download seperti ini, tapi aku mem- posting  artikel ini ...
Posting Komentar
Baca selengkapnya

Solved : Update on a valid time state table is not allowed without specifying a ValidTimeStateUpdateMode

How To Solve Error :  Cannot edit a record in Position hierarchies (xyz). Update on a valid time state table is not allowed without specifying a ValidTimeStateUpdateMode. select forUpdate * from xyz where xyz.recid== _RecId ; try { ttsBegin; _Value= “Abcd”; xyz.Name = _Value; xyz.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction); xyz.ValidFrom =today(); xyz.ValidTo=dateMax(); xyz.update(); ttsCommit; } catch { ttsAbort; }
Posting Komentar
Baca selengkapnya