SQL scripts for Project Accounting: Microsoft Great Plains series - overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB Admin touches.

? The first script transfers salesperson and sales territory from Customer master file to Project master table

update PA01101set SLPRSNID=b.SLPRSNID,SALSTERR=b.SALSTERRfromPA01101 ajoin RM00101 b on a.CUSTNMBR=b.CUSTNMBRwhere a.SLPRSNIDb.SLPRSNID or a.SALSTERRb.SALSTERR

? The second scripts unlocks Project Accounting user, this rare and funny one - really hard to get it from Microsoft Business Solutions Tech Support site:

delete PA000001 where userid='put user id here'

? The third script is really advanced one - it is for users trying to place billing address with contact info on the PA invoice form at the bottom section - address comes from Contract - not from the project

/*
Updates Primary Bill To Address Code for Billing invoice to be the one from Contract Master table,instead of Primary Billing Address Code from Customer
*/

update PA13100 set PRBTADCD=c.PRBTADCDfrom PA13100 a join PA13200 b on a.PADocnumber20=b.PADocnumber20 join PA01201 c on b.PAPROJNUMBER=c.PAPROJNUMBER

/*update PA13100 set PRBTADCD=c.PRBTADCDfrom PA13100 a join PA13200 b on a.PADocnumber20=b.PADocnumber20 join PA01101 c on b.PACONTNUMBER=c.PACONTNUMBER*//* Fill user defined 1 on the Billing HDR to contact person from the appropriate customer master address rec.*/update PA13100 set PAUD1 = left(b.CNTCPRSN,20) from PA13100 a join RM00102 b on a.CUSTNMBR = b.CUSTNMBR and a.PRBTADCD = b.ADRSCODE

Good luck with customization and support, if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com

Andrew is a Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) - USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Mexico-city, Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in multiple states and internationally

MORE RESOURCES:

Callidus Software Presents at 11th Annual Needham Growth Stock ... - MarketWatch (press release)

Perceptive Software lays off 53 Kansas City Business Journal - Bizjournals.com

PerkinElmer and IDBS Announce Software Collaboration to Improve ... - Reuters

Rainmaker Signs Three-Year Renewal with TIBCO Software for ... - Reuters

Insider Software to Unveil TypeTrax at Macworld Expo: Represents ... - Reuters

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/4-0fd=Rurl=http://www.reuters.com/article/pressRelease/idUS82934%2B05-Jan-2009%2BBW20090105cid=1287205999ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNHij15NIpFM9E-M57ux94Aekp0i7gInsider bSoftware/b to Unveil TypeTrax at Macworld Expo: Represents b.../b/abrfont size=-1font color=#6f6f6fReutersnbsp;-/font nobr17 hours ago/nobr/fontbrfont size=-1New Digital Asset bSoftware/b Tracks Projects, Font Usage and Automatically Preflights InDesign and Illustrator Jobs LOS GATOS, California--(Business Wire)-- b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-1fd=Rurl=http://stuff.techwhack.com/5956-typetraxcid=1287205999ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNFzcPEq7jHShf7Zw0Rf6NJPb-SkTAInsider bSoftware/b launches TypeTrax/a font size=-1 color=#6f6f6fnobrTechWhack/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-2fd=Rurl=http://www.macworld.com/article/137910/2009/01/typetrax.htmlcid=1287205999ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNEI95IEDfKp2ZPlQfBYSh-PJnVVrwExpo: TypeTrax manages Creative Suite projects/a font size=-1 color=#6f6f6fnobrMacworld/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-3fd=Rurl=http://www.macnn.com/articles/09/01/05/insider.releases.typetrax/cid=1287205999ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNEycIPx9BVElU4F_wvD_UJRTpmkkwTypeTrax manages Adobe CS documents, fonts, more/a font size=-1 color=#6f6f6fnobrMacNN/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1287205999hl=ennobrall 21 news articles/nobr/a/font/div/font/td/tr/table

ZyLAB Receives Highest Rating in Research Firm`s E-Discovery ... - Reuters

Expo: ModelBaker rapid app development software debuts - Macworld

TX Announces AutoSave(TM) CD/DVD Recordable Media Lineup With ... - Reuters

Smith Micro Mobile WiMAX Management Software for Clearwire - TMCnet

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/8-0fd=Rurl=http://wimax.tmcnet.com/topics/wimax/articles/48021-smith-micro-mobile-wimax-management-software-clearwire.htmcid=1286850288ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNFlvUS09wWDgf_acCNKZQ6hTpqrNwSmith Micro Mobile WiMAX Management bSoftware/b for Clearwire/abrfont size=-1font color=#6f6f6fTMCnetnbsp;-/font nobr14 hours ago/nobr/fontbrfont size=-1And now, Smith Micro bSoftware/b, Inc., a developer and marketer of mobility solutions and services for the wireless market, has announced it has been selected b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/8-1fd=Rurl=http://newsticker.welt.de/%3Fmodule%3Dsmarthouse%26id%3D828433cid=1286850288ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNFr-8zHOskIxRZQQ0Spb0osmHs8jASmith Micro’s Connection Management bSoftware/b Tapped for Clear b.../b/a font size=-1 color=#6f6f6fnobrWELT ONLINE/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/8-2fd=Rurl=http://www.xchangemag.com/hotnews/clearwire-mobile-broadband-usability.htmlcid=1286850288ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNGERrUNQqImRTIoRccxBkLrqNSqqAClearwire Simplifies Mobile Broadband Usability/a font size=-1 color=#6f6f6fnobrxchange Magazine/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/8-3fd=Rurl=http://www.reuters.com/article/pressRelease/idUS82928%2B05-Jan-2009%2BBW20090105cid=1286850288ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNEcNKQ3oTwtSoGDNxnusHjC87rQcQSmith Micro`s Connection Management bSoftware/b Tapped for Clear b.../b/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/8-4fd=Rurl=http://www.pcworld.com/businesscenter/article/156392/clearwire_set_to_launch_its_first_wimax_city.htmlcid=1286850288ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNGNJXjp2NA6N_xWXZyJ1MwBVBLEYwnobrPC World/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/8-5fd=Rurl=http://www.forbes.com/wireless/2009/01/05/wimax-clearwire-portland-tech-wire-cz_rb_0105clearwire.htmlcid=1286850288ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNGfiCPTlCfraql_ANN3ykIPpug14gnobrForbes/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1286850288hl=ennobrall 38 news articles/nobr/a/font/div/font/td/tr/table

MasterCard acquires software provider Orbiscom - Reuters

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/9i-0fd=Rurl=http://www.dividend.com/blog/%3Fp%3D4595cid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNF5vKX_vHReQ-W9UNXQQcxCwbn3LQimg src=http://nt0.ggpht.com/news?imgefp=oEjN6kenIpUJimgurl=www.dividend.com/blog/wp-content/uploads/storypics/mastercard.jpg width=80 height=64 alt= border=1brfont size=-2Dividend.com/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/9-0fd=Rurl=http://www.reuters.com/article/euMergersNews/idUSN0536893220090105cid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNFebh9qRBjOOAjQ4ZbQE2Qe15EDIgMasterCard acquires bsoftware/b provider Orbiscom/abrfont size=-1font color=#6f6f6fReutersnbsp;-/font nobr13 hours ago/nobr/fontbrfont size=-1N) said on Monday it has acquired bsoftware/b provider Orbiscom Ltd for $100 million to enhance its payments processing system. Part of the purchase price for b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/9-1fd=Rurl=http://www.marketwatch.com/news/story/MasterCard-buys-payment-software-firm/story.aspx%3Fguid%3D%257BF9433138-E6FB-4DF7-877D-0DCD92EAB8E3%257Dcid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNF3jE8fFoQAHFMplow-A3gRLiAZZgMasterCard buys payment bsoftware/b firm Orbiscom/a font size=-1 color=#6f6f6fnobrMarketWatch/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/9-2fd=Rurl=http://www.irishtimes.com/newspaper/breaking/2009/0105/breaking53.htmcid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNENtiMM0OUvrnkNCSpn1BhtJJunAgIrish bsoftware/b firm sold to Mastercard for $100m/a font size=-1 color=#6f6f6fnobrIrish Times/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/9-3fd=Rurl=http://www.bizjournals.com/stlouis/stories/2009/01/05/daily1.htmlcid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNHQ6wLfq079OdMSu_-0qiKFUQXFXwMasterCard buys Orbiscom for $100M/a font size=-1 color=#6f6f6fnobrBizjournals.com/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/9-4fd=Rurl=http://www.siliconrepublic.com/news/article/12025/comms/pbx-goes-virtualcid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNHL6v8G70yAuYRDRWAlPxrHBSO7UQnobrSiliconrepublic.com/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/9-5fd=Rurl=http://www.businessweek.com/ap/financialnews/D95H1ETO0.htmcid=1287219423ei=VutiSfHnOpjI9ATak7CZBAusg=AFQjCNFWceCdAWFYw_iozG6tjmRzAzG_CwnobrBusinessWeek/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1287219423hl=ennobrall 56 news articles/nobr/a/font/div/font/td/tr/table

Software - Google News

RELATED ARTICLES

Understanding XML Server
XML Server can be a Web Server that stores the XML files in it and serves them on demand. The XML Server would have processing capabilities with an XML engine and to transform the XML document to other forms.

Spyware, What is it?
Spyware, what it is and what it does. Basically, spyware is a program put on your computer usually after you have downloaded some kind of program or went to a certain site.

Save Your Resources - Combine Your IM Clients
There are so many different programs that clutter up your desktop and icon bar, every program using up your precious resources! How much faster would your PC if you could run one single program as opposed to three or more instant messenger clients?Let me give you an example of how much resources are eaten up by using a couple of instant messenger (IM) clients.On a normal day I have two instant messenger clients running at any given time, both of these programs use up hard drive storage space, memory resources and cpu processes.

Theres Gold in Your Websites Server Log
Many Webmasters have never bothered to view their website's server log. Ignoring your server log is like flying with a blind pilot.

Anti-Spyware Protection - Holes in the Shining Armor
Looking at all the ads which promise to get rid of all spy programs, one may wonder why there is still plenty of them everywhere and the situation is by no means getting better. So let me spoil the advertisers' mood and show some of the "holes" in the majority of software products we expect to protect our data.

Microsoft Great Plains on Ctree or Pervasive SQL - What to Do - Tips for IT Manager
As you probably know, when Microsoft purchased Great Plains Software - the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence - via it's C-written engine Dexterity, based on the believe that C programming language is platform independent.

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP
Enabling Chinese input is quick and easy, there are only a few steps you need go through to install the Chinese Language support and input method before you can type Chinese in your word processor or other program.We have broken the steps to 3 different sections for your easier to read and follow.

The Bluebird Project
The objective for Zandi Digital is to make available clever programs to end-users that want and need something more diverse. Bluebird is the current application being developed by Zandi Digital.

Screenplay and Script Writing Software
When it comes to screenplay software each screenwriter needs to determine what they need from the program they purchase and pick one that fits their specific needs. Screenwriting software doesn't write the screenplay for you.

OSI Layers Model
IntroductionDuring the early years of our modern computer era, very few standards and protocols existed between various manufacturers. However, as time went on and computer technology continued to improve and become more widespread, it became apparent that standards would be necessary to ensure compatibility.

Microsoft Great Plains Upgrade - Things to Consider and FAQ
If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.What is upgrade in the language of technology? Upgrade has server and client sides.

Things You Can Do With Windows XP!
Did you ever give a thought to the number of things you can do with Windows XP? Take your own time and think..

How To Identify, Cure and Prevent Spyware/Adware Infections
Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use.

Do You Want Your Own Fully Programmable ERP? - Part 1
We are in a transition phase in the Managerial Administration models of any company or Government, because three factors are summing for that:The new powerful business Information Technologies and its more and more smaller costs, like ERP, CRM, BI, etc.,The creativity of the new MBA to generate value and its corresponding engineering - for example, Feedback Control System - in the administrative and managerial fields,Several different layers in the companies in what refers to its managerial and administrative automation levels.

Microsoft Great Plains Payroll Module Customization Scenarios
It is now common thing when large corporation selects mid-market ERP or so-called standard functionality MRP solution as its corporate accounting system. Microsoft Business Solutions Great Plains is very good candidate.

Crystal Reports for Microsoft Great Plains - Overview for Developer
Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market.� It serves the whole of vertical and horizontal market: most of the industries and company sizes.

Spyware: What It Is and How to Combat It
Spyware is software or hardware installed on a computer without the user's knowledge which gathers information about that user for later retrieval by whomever controls the spyware.Spyware can be broken down into two different categories, surveillance spyware and advertising spyware.

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?
And kill the best layout software in the process of gaining market share?***Heard about the Quark "killer"?Adobe InDesign CS2. Will it really "kill" Quark? Adobe has been saying "it will" for the last six years or so, but it hasn't happened.

Cisco Certification: Introduction To ISDN, Part IV
In part III of this ISDN primer, we learned that PPP has two main methods of authentication that Cisco certification candidates need to know how to configure: PAP and CHAP.PAP has very few advantages over CHAP.

Introducing GRML
Creating a new markup language.Introduction.