Plain Roll
Plain Roll
Microsoft Great Plains 10.0 and 9.0 Upgrade - Technical Notes
At this time (fall of 2007) Microsoft Dynamics GP customers are actively upgrading to GP version 9.0 and initial upgrades are performed to Microsoft Dynamics GP 10.0. Version 10.0 will be in more active upgrade mode, when Microsoft will release GP 10.0 Service Pack 1, as current GP 10.0 upgrade path is limited to 8.0 SP5 and 9.0 SP2. Having reasonable number of GP version updates performed, we would like to share experience. Lets' start with the most popular upgrade to 9.0.
1. As versions 8.0, 7.5, 6.0, and earlier are discontinued for Microsoft Dynamics technical support, you should consider this bell as strong signal to walk away from these older versions. Versions 7.5 and older were available on MS SQL Server as well as on Pervasive SQL 2000 (former Btrieve) and Ctree. In the case when you are on non-MS SQL Server DB - you will have to undergo migration step to SQL Server based version. Assuming that your case is straight forward, let's move on and review known version upgrade issues
2. Purchase Order Processing tables problems. If you are using POP module, then you must check you Purchase Orders and Receipts work and historical tables on the subject of so-called orphan lines. These tables should be verified: POP10110, POP10310, POP30110 and POP30310 - they store purchase orders and receipts lines. Microsoft recommends doing checklinks, prior to upgrade process, however we saw situations, where potentially check links don’t do all the orphans cleaning job. If check links doesn't help, please construct the script which will give you orphans in lines table, similar to the following: select a.* from POP10110 a left join POP10100 b on a.PONUMBER=b.PONUMBER where b.PONUMBER is null. And again, prior to rescuing to scripting, you should try check links approach.
3. If after check links, upgrade failed on POP tables, you will have to restore DYNAMICS and all Companies DB to initial version and try data repair with scripting. Then design delete scripts with your DBA person. Microsoft partner should be able to apply failed company rolling back script, so you do not have to start from initial version for all the databases, however this script is confidential.
4. Other potentially problem tables. We’ve also seen the problem with IV10200 table. In version 9.0 inventory valuation formula was revised and it now relies on IV10200 to higher extent. In some cases this table conversion script fails and upgrading application freezes. The remedy is roll back to initial version, be sure that you did check links
If you like us to help you with GP upgrade, integration, software licenses, reporting, please give us a call
Sousuke demands a plain roll
 72 pcs 1 3 oz 10ml Plain Roll on Glass Bottles w caps  US $24.99
|
 Pack Of 4 Rolls Clear Plain Scotch Tape Alternative Tape 4000 1 2 Wide US $4.25
|
 100 Rolls 44mm x 150ft 1ply Plain White Paper Receipt US $45.99
|
 WOMENS ROLL NECKS SHORT SLEEVE VISCOSE TOPS PLAIN MUSTARD LADIES SIZE 8 10 US $7.93
|
 WOMENS ROLL NECKS LADIES PLAIN TOPS LADIES ROLL NECKS SKI TOPS WHITE SIZE 10 US $6.34
|
 PLAIN LABELS FOR SCALE PRINTERS 1500 LABELS ROLL 3 PK US $49.95
|
 2 different working ZIPPO LIGHTERS KING OF ROCK N ROLL PLAIN US $9.99
|
 36 pcs 1 oz 30ml Plain Roll on Glass Bottles w caps US $29.99
|
 WOMENS ROLL NECKS LADIES LONG SLEEVE PLAIN BASIC TOPS VISCOSE BEIGE SIZE 8 10 US $7.93
|
 PLAIN WHITE FINE COMBED 100 COTTON FABRIC per m EX WIDE off the roll US $7.93
|
 WHITE TUCK ROLL LEATHER BATES STYLE SOLO SEAT BOBBER US $169.99
|
 BROWN TUCK ROLL LEATHER BATES STYLE SOLO SEAT BOBBER US $169.99
|
 12 Calculator Plain Paper Rolls 2 1 4 x 150★FAST FREE SHIP★ US $9.15
|
 WOMENS ROLL NECKS LADIES LONG SLEEVE PLAIN BASIC TOP MINK SALE SIZE 12 14 US $7.93
|
 Henbury Plain BLACK WHITE BLUE Mens Long Sleeve Cotton Roll Polo Turtle Neck Top US $20.63
|
 WOMENS ROLL NECKS LADIES JUMPERS PLAIN TOPS WINTER ROLL NECK TOPS SIZE 10 14 US $12.69
|
 12 pcs 1 oz 30ml Plain Roll on Glass Bottles w caps US $12.99
|
 72 pcs 1 6 oz 4ml Plain Roll on Glass Bottles w caps US $24.99
|
 Plain Linen Look Roll Bread Basket 5 Colours US $4.75
|
 ROCKABILLY ROCK N ROLL NECK SCARF HEADBAND HAIR TIE PLAIN BLACK COTTON US $5.19
|
 144 pcs 1 3 oz 10ml Plain Roll on Glass Bottles w caps US $44.99
|
 Mens Dissident Plain Shadow Stripe Shirt Gradus Roll Up Sleeve Charcoal White US $26.93
|
 WOMENS ROLL NECKS LADIES JUMPERS PLAIN TOPS SKI ROLL NECK TOPS SIZE 10 14 US $12.69
|
 20 empty 1 3 oz roll on bottles w Black Caps Inserts U Pick Plain or swirl US $11.99
|
 Pack of 1000 Quality Plain Address Labels 89x36mm 4 Rolls of 250 Stickers US $11.10
|
 PINK PETTICOAT 50S ROCK N ROLL ROCKABILLY DRESS PROM UNDERSKIRT GOODWOOD REVIVAL US $34.93
|
 12 rolls 150 feet ft Plain Paper Calculator Roll Office US $8.99
|
 Bulk Lot 24 Rolls Clear Plain Scotch Tape Alternative Tape 24OOO 1 2 Wide US $21.00
|
 36 pcs 1 6 oz 4ml Plain Roll on Glass Bottles w caps US $17.99
|
 33m ROLL BABY BLUE PLAIN BIAS BINDING 100 COTTON 16mm GREAT FOR BUNTING US $11.10
|
 Calculator Plain Paper Rolls FREE SHIP US $6.20
|
 LADIES ROLL NECKS SHORT SLEEVE PLAIN NEW TOPS 12 COLOUR US $9.52
|
 RED LEATHER TUCK N ROLL BATES STYLE SOLO SEAT BOBBER CHOPPER US $149.99
|
 PLAIN LABELS FOR SCALE PRINTERS 1500 LABELS ROLL 12 PK US $159.95
|
 Office Impressions Calculator Plain Paper Roll US $5.51
|
 PLAIN LAZY BOYFRIEND ROLL UP CHINO SHORTS US $63.54
|
 1 Sleeve 24 Rolls Genuine Monarch 1136 Price Gun Labels Plain White 14000 US $23.95
|
 12x Office Impressions Calculator Plain Paper Roll 2 1 4 x 150ft refill US $10.99
|
 3x Office Impressions Calculator Plain Paper Roll 3 Pack Refill Cartridge US $7.49
|
 04mm METRIC SHIM STOCK PLAIN STEEL 6 INCH WIDE ROLL US $15.30
|
 Amish Handmade Reed Dinner Roll Baskets with Leather Handles US $24.00
|
 3 Calculator Plain Paper Rolls New Sealed 2 1 4 x 150 US $5.09
|
 Executive BLACK Plain Roll Up COSMETIC BAG Travel Organizing Makeup Case Tote US $9.95
|
 Mocha Coffee BROWN Plain Roll Up COSMETIC BAG Travel Organizing Makeup Case Tote US $9.95
|
 Cute LIME GREEN Plain Roll Up COSMETIC BAG Travel Organizing Makeup Case Tote US $9.95
|
 Hanging PLAIN PINK Roll Up COSMETIC BAG Travel Organizing Makeup Case Tote US $9.95
|
 Roll Up COSMETIC BAG Travel Organizing Makeup Case Tote Thirty One 31 Variations US $13.95
|
 12 OFFICE IMPRESSIONS CALCULATOR PLAIN PAPER ROLLS US $22.99
|
 XEROX Performance Bond 3R6422 24 x 150ft Plain Paper Roll NEW US $13.00
|
 Office Impressions PLAIN CALCULATOR PAPER ROLL 3pak150 US $5.62
|
 ONE GROSS 144 1 3 oz COLOR PLAIN ROLL ON GLASS BOTTLE US $89.99
|
 ONE GROSS 144pcs 1oz JUMBO PLAIN CLEAR ROLL ON GLASS BOTTLE w BLACK CAP B103 US $89.99
|
 ONE GROSS 144 1 3 oz PLAIN CLEAR ROLL ON GLASS BOTTLE B64 US $79.99
|
 Plain Back Sanding Sandpaper Roll 320 Grit 275 x 82 US $15.94
|
 Calculator Plain Paper Roll 2 1 4w 150l White100 ctn US $61.99
|
 Calculator Plain Paper Roll 2 1 4w 165l White 100 carton US $56.59
|
 Calculator Plain Paper Roll 2 1 4w 150l White12 pk US $7.99
|
 oz 45 plain sleeve trumiph whats another day of rroll US $25.46
|
 PLAIN LABELS FOR SCALE PRINTERS 1500 LABELS ROLL 6 PK US $89.95
|
 Plain Back File Board Sanding Sandpaper Roll 40 Grit US $17.94
|
