Looks close to Microsoft Great Plains becomes more and more popular, somewhat because of Microsoft muscles trailing it. Now it is targeted to the full-length array of horizontal and perpendicular marketplace people. Small companies use Small Business Manager (which is supported on the self profession - Great Plains Dexterity wordbook and runtime), Great Plains Standard on MSDE is for littlest to midsize clients, and then Great Plains serves the component part of the open market up to big corporations. There are individual writing tools acquirable and you emphatically want to cognise which one to use for disparate types of reports.
If you are information chief who is asked to importation numerous data to Great Plains or mend or use illegally information from one institution to other - publication this and you will have the clues on wherever to expression more.
1. Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the straightlaced string. If you are sounding for the trade - it should be RM00101 - client master record.
2. DEX_ROW_ID. This is personal identity file and all Great Plains tabular array has it - this is due to the Great Plains Dexterity engineering. This indian file is never utilized as a key area - so don't try to nexus your tables on DEX_ROW_ID. In defence if you requirement to transportation the array from one camaraderie to other you should use these queries:
Select * into GL00100_BAK from TWO.dbo.GL00100
alter array GL00100_BAK descend indian file DEX_ROW_ID
insert into GL00100 select * from GL00100_BAK
drop array GL00100_BAK
The set of queries preceding will moving GL00100 (Account Master array) from TWO ensemble into your newsworthy people. Then you necessitate to run Checklinks - mean to GP Manual - in charge to animate the time out of the story artist similar tables.
3. Do not change the array - sometimes it seems to be nice if you purely attach two of a kind of complementary columns to the table - like-minded in IV00101 - stock list maestro profile why wouldn't you merely add duo of additional descriptions. If you do this - Great Plains Dexterity motor will come to nothing linguistic process all your items - due to the certainty that DYNAMICS.DIC (main Great Plains Dictionary record) has accurate definition of all the tables and Dexterity uses it for reading and script into the particularised table
4. Feel unconstrained to originate SQL views or keep procs. If you are small indefinite quantity your intrinsic developers to concoct Crystal Reports - good SQL views are sincere serve to them. Let me donate you example, the picture below will make clear slog and humanities SOP Invoices - then Crystal can newly use it
Create orientation SOP_WORK_HIST
select SOPNUMBE, CUSTNMBR, CUSTNAME, DOCAMNT from SOP30200 wherever SOPTYPE=3 and VOIDSTTS=0
select SOPNUMBE, CUSTNMBR, CUSTNAME, DOCAMNT from SOP10100 wherever SOPTYPE=3 and VOIDSTTS=0
The above prospect will performance all the sweat and arts non-voided invoices (SOP Type = 3 corset for invoice)
5. Some mend / unlocking tips:
If you run questioning above in opposition DYNAMICS database - it will undo the user, who accidentally closed lint the computing machine minus work off Great Plains:
delete ACTIVITY where USERID='JOHN'
Next one will open up floppy batch:
update SY00500 set BCHSTTUS=0 wherever BACHNUMB = 'JULYINVOICES04'
Happy querying! If you poorness us to do the job - give us a phone up 1-866-528-0577!