Popular,SQL,Queries,for,Micros computer Popular SQL Queries for Microsoft Dynamics GP highlights f
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
As technology advances, computer professional needs balanced level of SQL querying skills to support ERP application, sufficient to be able to produce queries for reporting, minor data repair, transaction auditing. Typical scenarios are: month closing and the need to analyze transactions which need to be corrected via General Ledger offsets. Lets come to examples:The following query will give you transactions which are originated in SOP with SOP number starting with SLS-10, where distribution goes to Cost of Goods Sold accountselect b.ACTNUMBR_1+' ' +b.ACTNUMBR_2+' ' +b.ACTNUMBR_3 as Account,a.JRNENTRY, a.DEBITAMT, a.CRDTAMNT, a.SOURCDOC, a.REFRENCE, a.DSCRIPTN, a.TRXDATEfrom GL20000 ajoin GL00100 b on a.ACTINDX=b.ACTINDXwhere b.ACTNUMBR_1 like '5%'and a.OPENYEAR=2007and a.SOURCDOC='SJ'and a.ORDOCNUM like 'SLS-10%'order by TRXDATE descWell, if you think it is too complex and you really dont have a clue, please lets go to starting point. In order to analyze and research GP tables structure, go to Tools->Resource Description->Tables. If you are familiar with SQL this reference will give you enough info to advance our query above or design your own queryFor MS Dynamics GP beginners we would like to reprint the most popular SQL scripts and fixes:Delete stalled user: delete activity where userid=john run this query against DYNAMICS database, change John to real useridUnlock stalled posting batch. Update SY00500 set BCHSTTUS=0. MKDTOPST=0 where BACHNUMB=MYBATCH run it against company database, replace MYBATCH with real batch nameGetting message this document is edited by another user. In this case analyze SY00801 table, see if the lock is there and unlock. We will not provide the script here, as it is surgery and should be done by professional
Popular,SQL,Queries,for,Micros