Friday, 25 May 2007

Technical upgrade from Navision 4.0 to 4.0 SP2

You can do Technical Upgrade from Navision 4.0 to Navision 4.0 SP2 by simply open Navision 4.0 database with the finsql.exe from Navision 4.0 SP2. When you open the Navision 4.0 database with the SP2 finsql.exe, Navision will first ask you whether want to upgrade to SP2 or not. If answer Yes to all the message to convert the database, Navision 4.0 SP2 will do the technical upgrade for you.

What the technical upgrade will do to your database. It actually update 1 table and 76 triggers in the old database when you do the technical upgrade.

The only table that will be upgraded is $ndo$dbproperty.


76 Triggers upgraded are:
  1. BAS Calc_ Sheet Entry_TG
  2. Company_Name$Action Message Entry_TG
  3. Company_Name$Analysis View Budget Entry_TG
  4. Company_Name$Analysis View Entry_TG
  5. Company_Name$Bank Acc_ Reconciliation Line_TG
  6. Company_Name$Bank Account Ledger Entry_TG
  7. Company_Name$Bank Account Statement Line_TG
  8. Company_Name$BOM Journal Line_TG
  9. Company_Name$Calendar Entry_TG
  10. Company_Name$Capacity Ledger Entry_TG
  11. Company_Name$Contract Gain_Loss Entry_TG
  12. Company_Name$Cust_ Ledger Entry_TG
  13. Company_Name$Detailed Cust_ Ledg_ Entry_TG
  14. Company_Name$Detailed CV Ledg_ Entry Buffer_TG
  15. Company_Name$Detailed Vendor Ledg_ Entry_TG
  16. Company_Name$Employee Absence_TG
  17. Company_Name$FA Allocation_TG
  18. Company_Name$FA Ledger Entry_TG
  19. Company_Name$FA Posting Group Buffer_TG
  20. Company_Name$Finance Charge Memo Line_TG
  21. Company_Name$G_L Budget Entry_TG
  22. Company_Name$G_L Entry_TG
  23. Company_Name$Gen_ Jnl_ Allocation_TG
  24. Company_Name$Gen_ Journal Line_TG
  25. Company_Name$Ins_ Coverage Ledger Entry_TG
  26. Company_Name$Interaction Log Entry_TG
  27. Company_Name$Intrastat Jnl_ Line_TG
  28. Company_Name$Inventory Buffer_TG
  29. Company_Name$Issued Fin_ Charge Memo Line_TG
  30. Company_Name$Issued Reminder Line_TG
  31. Company_Name$Item Analysis View Budg_ Entry_TG
  32. Company_Name$Item Analysis View Entry_TG
  33. Company_Name$Item Budget Entry_TG
  34. Company_Name$Item Ledger Entry_TG
  35. Company_Name$Job Budget Entry_TG
  36. Company_Name$Job Ledger Entry_TG
  37. Company_Name$Maintenance Ledger Entry_TG
  38. Company_Name$Opportunity Entry_TG
  39. Company_Name$Phys_ Inventory Ledger Entry_TG
  40. Company_Name$Planning Component_TG
  41. Company_Name$Planning Routing Line_TG
  42. Company_Name$Post Dated Check Line_TG
  43. Company_Name$Prod_ Order Component_TG
  44. Company_Name$Prod_ Order Line_TG
  45. Company_Name$Prod_ Order Routing Line_TG
  46. Company_Name$Production Forecast Entry_TG
  47. Company_Name$Purchase Line_TG
  48. Company_Name$Purchase Line Archive_TG
  49. Company_Name$Reminder Line_TG
  50. Company_Name$Res_ Capacity Entry_TG
  51. Company_Name$Res_ Ledger Entry_TG
  52. Company_Name$Reverse Auction Header_TG
  53. Company_Name$Sales Line_TG
  54. Company_Name$Sales Line Archive_TG
  55. Company_Name$Sales Shipment Buffer_TG
  56. Company_Name$Segment Line_TG
  57. Company_Name$Serv_ Inv_ Line Price Adjmt__TG
  58. Company_Name$Service Contract Line_TG
  59. Company_NameCompany_Name$Service Invoice Line_TG
  60. Company_Name$Service Ledger Entry_TG
  61. Company_Name$Service Order Allocation_TG
  62. Company_Name$Temp WHT Entry_TG
  63. Company_Name$Temp WHT Entry - EFiling_TG
  64. Company_Name$Unplanned Demand_TG
  65. Company_Name$Value Entry_TG
  66. Company_Name$VAT Entry_TG
  67. Company_Name$Vendor Ledger Entry_TG
  68. Company_Name$Warehouse Activity Line_TG
  69. Company_Name$Warehouse Entry_TG
  70. Company_Name$Warehouse Journal Line_TG
  71. Company_Name$Warehouse Receipt Line_TG
  72. Company_Name$Warehouse Shipment Line_TG
  73. Company_Name$Whse_ Cross-Dock Opportunity_TG
  74. Company_Name$Whse_ Internal Pick Line_TG
  75. Company_Name$Whse_ Internal Put-away Line_TG
  76. Company_Name$WHT Entry_TG

No comments: