Computers & Technology

Some Microsoft Great Plains, Microsoft muscles behind it because it looks like is becoming more and more popular. Now the whole spectrum of horizontal and vertical market customers are targeted. (Based on the same technology - Great Plains Dexterity dictionary and runtime), a small company for our clients using the standard media plains to MSDE Manager SME, large enterprise market, the rest of the Great Plains offers. There are several reporting tools available and you definitely used for other types of reports, one needs to know.

Be a clue for you to see the location Read more - if you are a company different from the Great Plains or repair or copy the data part of the data, the database administrator, you can have them.

1. Microsoft Great Plains tables structure - a great start to move to the Tools-> Resource Description-> Tables peulreinreul. You can find the appropriate setting of the table. If you are looking for the customers - it should be RM00101 - customer master file.

Two. DEX_ROW_ID. ID column of each Great Plains table - this technology is Great Plains Dexterity. This column is not used as a key field - so do not try to link a table to DEX_ROW_ID. In one company, if you use a query you must transfer the case to another table:

Select * from TWO.dbo.GL00100 GL00100_BAK
Go
GL00100_BAK changing table drop column DEX_ROW_ID
Go
Insert into GL00100 select * from GL00100_BAK
Go
Table GL00100_BAK drop

The query above two companies, the Company set GL00100 (Account Master tables) will be sent. Checklinks you need to run the rest of the table to a host in order to reproduce the GP-related, see the documentation for the account.

Three. As IV00101 - Do not modify the table a few more times it will be explained why not add a few more things you look better in stock can be added to the master file is added to the table column. If you do this - Great Plains Dexterity engine fails read all the entries - the DYNAMICS.DIC (Great Plains Dictionary file share) due to the accurate description of a particular table for reading and writing, with all the tables and agility to use it In fact,

Four. SQL view or stored procedure, feel free to write. Internal If you are creating Crystal Reports developer - good SQL views will actually help them. Let me give you an example, the following example, the work and history shows SOP invoice - just because you can use it to determine

Create View SOP_WORK_HIST
With
SOPTYPE = 3 VOIDSTTS = 0 SOP30200 of the DOCAMNT SOPNUMBE, CUSTNMBR, CUSTNAME to choose from
Union
SOPTYPE = 3 VOIDSTTS = 0 SOP10100 of the DOCAMNT SOPNUMBE, CUSTNMBR, CUSTNAME to choose from

The history of non-reactive tasks and all invoices (SOP invoice, type = 3, B) is represented by the

Five. Some repair / unlock tips:

You run the above query to the database, gay - it's a mistake, to unlock the Great Plains users without logging off, shut down the computer:

USERID = 'JOHN' activities will delete

One of the following to unlock hanging batch:

SY00500 set BCHSTTUS = 0 BACHNUMB = 'JULYINVOICES04' Update