MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Microsoft Great Plains Primer – tips for IT / Database Admin

This is a discussion on Microsoft Great Plains Primer – tips for IT / Database Admin within the News and Announcements forums, part of the Map Forums category; Microsoft Business Solutions Great Plains is main ERP application targeted to US mid-size businesses market. We do understand that a ...


Go Back   MapPoint Forums > Map Forums > News and Announcements

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-15-2005
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Microsoft Great Plains Primer – tips for IT / Database Admin

Microsoft Business Solutions Great Plains is main ERP application targeted to US mid-size businesses market. We do understand that a lot of new clients are signing with Microsoft Business Solutions or MBS Partners to purchase and implement Microsoft Great Plains (with potential integration with Microsoft CRM and Microsoft RMS – Retail Management System). In this small article we are trying to help IT specialist to support and resolve basic Great Plains problems, like deleting hanging user, unlock the batch, etc.
1. How to delete the user: If user, shuts down computer, before signing off Great Plains - she/he will get the message that she/he is already signed. Then you need to delete the user from the activity table. Run the query below against DYNAMICS database - it will unlock the user:
delete ACTIVITY where USERID='MARIE'
2. How to unlock the batch: From our experience - this is second FAQ we are hearing from Great Plains administrator. Run this script against company database to unlock hanging batch:
update SY00500 set BCHSTTUS=0 where BACHNUMB = 'BATCH0023'
Sometimes you also have to run this script against DYNAMICS database (if first script doesn't do the job)
delete SY00800 where BACHNUMB = 'BATCH0023'
3. Some Reporting Queries – Before we go there, we would like you to be able to find the table with the data you are looking for. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers – it should be RM00101 – customer master file.
Now lets query Customer Master table:
select CUSTNMBR, CUSTNAME from RM00101 where STATE='CA'
This query will return Customer Number, Customer Name for all the customers in California
Next query will give you top 10 Inventory Items with the best Sales Results
select a.ITEMNMBR, a.ITEMDESC, b.SALESNUMBER from IV00101 a join (select top 10 ITEMNMBR, count(ITEMNMBR) as SALESNUMBER from SOP30300 where SOPTYPE=3 group by ITEMNMBR order by count(ITEMNMBR) desc) b on a.ITEMNMBR=b.ITEMNMBR

You can have such a nice tools as Explorer to imitate Sales or Financial reporting for you and then dump it to Excel with the click of the button as good alternative to FRx, but we would recommend you to stick to FRx for regular financial reporting – this is the tool of the choice for controller.

You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( http://www.albaspectrum.com ) – Microsoft Business Solutions partner, serving clients in Illinois, New York, California, Florida, Georgia, Texas, Arizona, Virginia, Minnesota, Canada, UK, Europe, Australia, Asia, Russia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer. You can reach Andrew: akarasev@albaspectrum.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Microsoft Great Plains worldwide help & support Andrew Karasev News and Announcements 1 09-08-2005 11:02 AM
Microsoft Great Plains Implementation for Large Corporation Anonymous MapPoint 2006/2009 Discussion 0 05-06-2005 06:16 PM
Microsoft Great Plains Distribution, Barcoding, Consignment Anonymous MapPoint 2006/2009 Discussion 0 04-26-2005 06:13 PM
Microsoft Great Plains version 8.5: upgrade, customization Anonymous News and Announcements 0 04-06-2005 07:13 PM
MS Releases Microsoft Business Solutions - Great Plains 8.0 Eric Frost News and Announcements 1 07-27-2004 03:06 PM


All times are GMT -5. The time now is 09:00 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Ski Spain
Ski in Spain to enjoy the rich culture and bustling restaurants and bars. Skiing in Spain is suitable for a range of standards and is great value when you book at Holiday Hypermarket.

Spain Holidays
Find great Spain Holidays with Travel Counsellors. A personal Travel Counsellor can help you plan the perfect holiday to Spain.

Holiday to Thailand
Want to go somewhere new? Book a low cost holiday to Thailand at dealchecker.co.uk. See the stunning national parks and uninhabited islands.

Sri Lanka Holidays
There are some outstanding deals on Sri Lanka holidays at theholidayplace.co.uk. Sri Lanka is renowned for it's exceptional beauty! Book a holiday today!

Portugal
As well as providing some great weather Portugal has much to offer culturally. There are numerous museums, monuments and places of historical interest to explore. Despite the rich history there is a buzzing nightlife and great shopping too.

Bargain Holidays
To plan your holidays at bargain prices, use Travel.co.uk to explore all the possibilities.

Sharm Holidays
See beautiful Egyptian sites! Info on Sharm holidays, only at On The Beach.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51