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
 144 pcs 1 3 oz 10ml Plain Roll on Glass Bottles w caps  US $44.99
|
 Vintage Coin Wrap Wrappers Tube Rolls Assorted 3 4 lb Total Plain Striped Flat US $5.00
|
 WOMENS ROLL NECKS STRETCH PLAIN TOPS WINTER LADIES ROLL NECK TOPS SIZE 8 14 US $9.27
|
 Universal Calculator Plain Paper Roll 2 1 4 x 150 ft 100 Rolls Carton US $54.20
|
 PLAIN LABELS FOR SCALE PRINTERS 1500 LABELS ROLL 3 PK US $49.95
|
 Pack Of 4 Rolls Clear Plain Scotch Tape Alternative Tape 4000 1 2 Wide US $3.80
|
 WOMENS ROLL NECKS SHORT SLEEVE VISCOSE TOPS PLAIN MINK LADIES SIZE 8 10 US $6.17
|
 Plain Back File Board Sanding Sandpaper Roll 120 Grit US $15.94
|
 YASUTOMO PLAIN KOZO RICE PAPER ROLL 11x 60 FT US $15.86
|
 Plain Back File Board Sanding Sandpaper Roll 80 Grit US $15.94
|
 36 pcs 1 3 oz 10ml Plain Roll on Glass Bottles w Caps US $17.99
|
 Plain Back Sanding Sandpaper Roll 320 Grit 275 x 82 US $15.94
|
 RED Uncirculated 1958 Plain Lincoln Wheat Penny Roll 50 pennies 56D US $6.50
|
 ROCKABILLY ROCK N ROLL NECK SCARF HEADBAND HAIR TIE PLAIN BLACK COTTON US $5.21
|
 100 Yards Roll 1 4 Solid Plain Grosgrain Ribbon White US $9.04
|
 Mens Dissident Plain Shadow Stripe Shirt Gradus Roll Up Sleeve Charcoal White US $26.22
|
 IVORY CREAM NET PETTICOAT 50S BRIDE ROCK N ROLL WEDDING DRESS UNDERSKIRT 10 16 US $43.30
|
 LARGE WHITE FAUX LEATHER Party Bustier Micro Rock Roll Plain Mini Dress US $29.99
|
 BLACK PETTICOAT 50S CIRCLE SKIRT ROCK N ROLL ROCKABILLY DRESS UNDERSKIRT 10 16 US $43.30
|
 BABY PINK NET PETTICOAT RETRO 50S ROCK N ROLL ROCKABILLY DRESS UNDERSKIRT 10 16 US $43.30
|
 3 Calculator Plain Paper Rolls New Sealed 2 1 4 x 150 US $5.09
|
 Dissident Mens Gradus Shadow Stripe Plain Shirt Roll Up Sleeve Charcoal US $29.32
|
 Plain Back File Board Sanding Sandpaper Roll 220 Grit US $15.94
|
 Plain back Sanding Sandpaper Roll 400 Grit 275 x 82 US $15.94
|
 Calculator Add Rolls 2 1 4x200 5 PK Plain White PMC08811 US $15.89
|
 GMC Sierra 1999 2006 Roll Pan Stepside Plain US $101.10
|
 Office Impressions Calculator Plain Paper Roll US $10.19
|
 2000 ea 1 4 x 1 Roll Pins Spring Pins Plain Finish US $60.00
|
 Brand New Office Impressions Calculator Plain Paper Roll US $5.89
|
 Model A Pickup Bed Rear Roll Pan Plain 28293031 US $339.99
|
 NEW KX FA92 2 ROLLS GENUINE OEM PANASONIC PLAIN PAPER INK FILM US $9.99
|
 PERSONALIZED PLAIN WEDDING FAVOR RIBBON ROLL FOR BOX US $42.48
|
 065mm METRIC SHIM STOCK PLAIN STEEL 6 INCH WIDE ROLL US $18.40
|
 7 INCH SINGLE 45 promo righteous brothers rock roll heaven plain sleeve 74 oz US $63.54
|
 Plain Back File Board Sanding Sandpaper Roll 40 Grit US $17.94
|
 oz 7 rolling stones its only rock roll lower plain sl US $20.78
|
 PLAIN LAZY ROCK AND ROLL S SLEEVE ENVELOPE T SHIRT US $20.11
|
 PLAIN LAZY ROCK AND ROLL PLAIN LAZY MUG US $11.60
|
 PLAIN LAZY ROCK ROLL T SHIRT US $30.94
|
 PLAIN LAZY BOYFRIEND ROLL UP CHINO SHORTS US $61.88
|
 04mm METRIC SHIM STOCK PLAIN STEEL 6 INCH WIDE ROLL US $15.30
|
 Nukote International Plain Paper Thermal Print Fax Ribbon Refill Rolls for US $52.82
|
 Amish Handmade Reed Dinner Roll Baskets with Leather Handles US $24.00
|
 Office Impressions Calculator Plain Paper Roll US $5.51
|
 100 Rolls 44mm x 150ft 1ply Plain White Paper Receipt US $45.99
|
 12 OFFICE IMPRESSIONS CALCULATOR PLAIN PAPER ROLLS US $22.99
|
 XEROX Performance Bond 3R6422 24 x 150ft Plain Paper Roll NEW US $19.79
|
 Towa GX 3 Line Plain White Labels 10 Rolls 7500 labels Free shipping US $28.95
|
 10ml CLEAR GLASS ROLL ON BOTTLES swirl plain LOT of 2 US $4.70
|
 PM Company Calculator Rolls Add 2 1 4 x 150 Plain 100 PACK ROLLS US $75.00
|
 36 pcs 1 oz 30ml Plain Roll on Glass Bottles w caps US $29.99
|
 12 Calculator Plain Paper Rolls 2 1 4 x 150 US $8.79
|
 oz 45 plain sleeve trumiph whats another day of rroll US $25.57
|
 Panasonic plain paper film 2 Replacement rolls Fit US $33.99
|
 Norton 14 16 18 Type C Plain Roll Hi Swing Manual US $42.00
|
 Vtg Vogue 5096 Roll or Plain Collar Blouse Pattern 12 32 Cut Complete US $5.99
|
 Universal Calculator Plain Paper Roll 2 1 4 x 150 ft 3 Rolls Pack US $9.99
|
 Where The Prairie Rolls Along To Meet The Plain 1903 REESE PROSSER Sheet Music US $4.99
|
 HEAVY GRAINED VISOR JEEP BEANIE CAP ROLL UP PLAIN SKULL SKI SKATE HAT CHOPPERS US $4.50
|
 12 pcs 1 3 oz 10ml Plain Roll on Glass Bottles w caps US $8.99
|
