This is starter level SQL scripting report for DB Administrator, Programmer, IT Expert
Our and Microsoft Company Solutions target below is to teach databases administrator, programmer, software package developer to permit them help Microsoft Great Plains for their firms. In our view self help is the purpose of Microsoft to aid implementation of its products and solutions: Wonderful Plains, Navision, Solomon, Microsoft CRM. You can do it for your company, becoming knowledgeable on simple info repair service methods and captivating to Microsoft Company Answers Techknowledge databases. This will permit you to prevent costly consultants visits onsite. You only have to have the assist from qualified when you prepare on elaborate customization, interface or integration, then you can attraction to any person who specializes in these duties and can do economical nation-wide remote support for you.
Let us glance at basic details fix tactics.
1. How to delete the person:
If consumer, shuts down laptop or computer, before signing off Great Plains – she/he will get the message that she/he is already signed. Then you need to have to delete the user from the action desk. Operate the question underneath against DYNAMICS database – it will unlock the person:
delete Action where USERID=’MARIE’
2. How to unlock the batch:
From our experience – this is second FAQ we are listening to from Fantastic Plains administrator. Run this script versus enterprise database to unlock hanging batch:
update SY00500 established BCHSTTUS= where by BACHNUMB = ‘BATCH0023’
Often you also have to run this script in opposition to DYNAMICS database (if initial script does not do the occupation)
delete SY00800 the place BACHNUMB = ‘BATCH0023’
3. Some Reporting Queries – In advance of we go there, we would like you to be in a position to find the desk with the knowledge you are searching for. Launch Terrific Plains and go to Resources->Resource Description->Tables. Come across the desk in the proper series. If you are on the lookout for the buyers – it must be RM00101 – client learn file.
Now allows question Purchaser Master desk:
find CUSTNMBR, CUSTNAME from RM00101 the place Condition=’CA’
This question will return Buyer Number, Purchaser Name for all the buyers in California
Up coming question will give you top 10 Stock Items with the best Income Success
select a.ITEMNMBR, a.ITEMDESC, b.SALESNUMBER from IV00101 a join (select top 10 ITEMNMBR, count(ITEMNMBR) as SALESNUMBER from SOP30300 in which SOPTYPE=3 team by ITEMNMBR order by rely(ITEMNMBR) desc) b on a.ITEMNMBR=b.ITEMNMBR
Content querying and supporting! if you want us to do the aid you – give us a connect with 1-866-528-0577! [email protected]
