Mark Polino’s book, titled Microsoft Dynamics GP 2010 Cookbook, is out ahead of schedule! I think that’s the first time I have ever heard of something like that happening. I’ve already got my copy and as soon as I get a few minutes I am going to start reading it. In the meantime, you can read a sample chapter or get your own copy and start cookin’ with GP.
Search this blog:
Join 3,139 other subscribers
GP Reports Viewer Newsletter
Sign up for the GP Reports Viewer Newsletter to get reporting tips via email
articles
awards
Bank Reconciliation
book
Crystal Reports
Dynamics GP
Excel reports
Extender
featured
Fixed Assets
FRx
General Ledger
GP 8.0
GP 9.0
GP 10.0
GP 2010
GP 2013
GP 2015
GP Reports code
GP Reports Viewer
GP SQL stored procedure
GP SQL view
GP table information
Integration Manager
Inventory
Management Reporter
Microsoft
Microsoft MVP
Miscellaneous
MSDynamicsWorld
Payables
Purchase Order Processing
Receivables
Sales Order Processing
security
service pack
SmartList Builder
SQL code
SQL Server
Support Debugging Tool
support lifecycle
version
Vista
Windows 7
year end close
-
Using credit cards to pay vendors in Dynamics GP January 4, 2009
-
SQL view for Payables GL distributions in Dynamics GP November 28, 2008
-
SQL view for all posted GL transactions in Dynamics GP August 11, 2009
-
Sales Transaction Entry GL distributions in Dynamics GP December 8, 2008
-
SQL view to show AP apply information in GP October 22, 2008
-
SQL view for Payables payment apply detail in GP October 22, 2009
-
Year end close in Dynamics GP November 14, 2008
- SQL view with AR apply detail February 15, 2010
-
Granting access to a new SmartList in Dynamics GP October 8, 2008
-
SQL view with all SOP line items in Dynamics GP May 17, 2009
-
SQL view for unposted checks in Dynamics GP August 29, 2017
-
SQL view for rolling 12 months of sales by item by site in Dynamics GP April 20, 2017
-
Dynamics GP sales amounts and quantities for rolling 12 months March 14, 2017
-
Updating Dynamics GP data directly in SQL January 17, 2017
-
Did you know you can change Void dates on Payables transactions? September 20, 2016
-
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP May 25, 2016
-
SQL code to show top X percent of vendor data March 21, 2016
-
Discount from Packt Publishing September 15, 2015
-
Refreshable Excel report for historical GL trial balance in Dynamics GP August 13, 2015
-
Refreshable Excel report for monthly GL budget in Dynamics GP April 28, 2015
-
Victoria Yudin: Hi Stephanie, I just tested setting it up in my G...
-
Stephanie Crawley: Yep, works like a dream when i do that. Our worka...
-
Victoria Yudin: Hi Stephanie, Very strange. Are you able to run i...
-
Stephanie Crawley: Victoria, I did run the grant script. The weirde...
-
Victoria Yudin: Hi Stephanie, Did you make sure to give DYNGRP pe...
-
Stephanie Crawley: Victoria, thank you so much for the quick response...
-
Victoria Yudin: Hi Stephanie, In SmartList Builder you first have...
-
Stephanie Crawley: I created this view to use in Builder. The view i...
-
Lenny: Thank you so much for sharing all this info, espec...
-
Victoria Yudin: Hi Denise, There is nowhere in AP you can see thi...
Links
Blogroll
- Aaron Berquist
- Amber Bell
- Beat Bucher
- Constance Quigley
- David Musgrave
- Developing for Dynamics GP
- Devon Southall
- Dwight Specht
- Dynamics GP Engineering Team
- Dynamics GP Land
- Dynamics GP Support and Services Blog
- DynamicsCare
- eOne Dynamics GP and CRM Blog
- ERP Software Blog
- Frank Hamelly
- Gloria Braunschweig
- GSL Blog
- Ian Grieve
- Ian Stewart
- Jan Harrigan – FRx and MR
- Janakiram M.P.
- Jen Kuntz
- Jim Hummer
- Jivtesh Singh
- John Lowther
- Jonathan P Cox
- Les Wright
- Leslie Vail
- Mariano Gomez
- Mark Polino
- Michael D. Johnson II
- Microsoft MVP Blog
- Microsoft Team Blogs
- Mohammad R. Daoud
- MS Dynamics Partner Blog
- Official Dynamics GP Blog
- Ron Wilson
- Rose Business Solutions
- Shawn Dorward – GP Life Hacks
- Sivakumar Venkataraman
- Steve Endow
- Tim Wappat
- Vaidy Mohan
Most Clicked Links
Recent Blog Comments
Victoria Yudin on SQL view with security resourc… | |
Stephanie Crawley on SQL view with security resourc… | |
Victoria Yudin on SQL view with security resourc… | |
Stephanie Crawley on SQL view with security resourc… | |
Victoria Yudin on SQL view with security resourc… |
Thanks for the kind words Victoria.
Mark
LikeLike
Dear Vicotira,
Thank you alot for your valuble information.
I have one issue regards the account format .I set up from begining the following before creating any company:
(select * from dbo.SY00302) – DYNAMICS DB
SEG LENGTH DEX
1 Segment1 6 0 1
2 Segment2 6 0 2
3 Segment3 10 0 3
4 Segment4 2 0 4
5 Segment5 6 0 5
6 Segment6 6 0 6
7 Segment7 6 0 7
8 Segment8 6 0 8
9 Segment9 6 0 9
10 Segment10 6 0 10
NULL NULL NULL NULL NULL
I already create two company and i used 3 segments with the length of the segment size without any problem.
Now, we want to create new company with 5 segments but the problem is in segment number 4 ( which we want it to be 5 digit ) but unfortunately what we have in DYNAMICS is 2 digit.How can I change that ?
BTW, I tried to change it manually ( the table SY00300 which exist in the company DB itself ) – Segment 4 to have 5 digit , but it takes only 3 digit and other 2 disappears.
Also, I tried to change in Dynamics (Table SY00302) – the segment 4 to 5 digit and I reconciled, and still same problem is exist.
Please help me in that if doable and possible..Thanks a lot again.
LikeLike
Hi Hussain,
Not sure how this pertains to Mark’s new book? 🙂
I would not attempt what you are trying to do on your own.
You can purchase or a tool called Re-Formatter or talk to Microsoft Professional Services about having them do this for you.
-Victoria
LikeLike