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 PA01101 set SLPRSNID=b.SLPRSNID, SALSTERR=b.SALSTERR from PA01101 a join RM00101 b on a.CUSTNMBR=b.CUSTNMBR where 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.PRBTADCD from PA13100 a join PA13200 b on a.PADocnumber20=b.PADocnumber20 join PA01201 c on b.PAPROJNUMBER=c.PAPROJNUMBER

/* update PA13100 set PRBTADCD=c.PRBTADCD from 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! [email protected]

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

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Business Wire (press release)

Pivotal IPO: 5 things to know about the cloud software company
MarketWatch
Pivotal Software Inc. PVTL, +0.00% announced early Friday that it would sell at least 37 million shares in its IPO at a price of $15, the midpoint of the expected price range of $14 to $16. That price values the software company at $3.75 billion based ...
Pivotal Software, Inc. Prices Initial Public OfferingBusiness Wire (press release)
Pivotal Software sets price of $15 a share for Friday IPOSan Francisco Chronicle
The IPOs keep on coming: Pivotal Software raises $497M in initial stock offeringSiliconANGLE News (blog)

all 8 news articles »

TechCrunch

Centrify gives states a deal on identity management software to secure midterm elections
TechCrunch
To secure U.S. election systems from the very real threat of targeted cyberattacks, states might need to reframe their security practices to look more like they would in a tightly controlled corporate environment. To that end, Centrify, an enterprise ...

and more »

TechCrunch

Rylo brings some new software tricks to their not-a-360 camera
TechCrunch
Rylo wants people to use 360 cameras to capture everything around them, then use software to determine what exactly they want after the fact. Today, the startup is adding a new feature to the app, a new feature to the camera and a new camera effect to ...

and more »

Motley Fool

Apple Says It's Not Pursuing Universal Software Platform
Motley Fool
The software giant lost all relevance in the smartphone market years ago, so it really just needs to focus on tablets, laptops, and everything in between. Cook's reference to "trade offs and compromises" largely echoes sentiments that the chief ...
Tim Cook says Apple won't merge Mac and iPadAppleInsider

all 37 news articles »

Smithsonian

Would You Trust Drone Software to Pilot Your Flight?
Smithsonian
Chesley “Sully” Sullenberger. But software could change that, equipping every plane with an extremely experienced guidance system that is always learning more. In fact, on many flights, autopilot systems already control the plane for basically all of ...
Your next pilot could be drone softwareThe Conversation US

all 4,248 news articles »

Entrepreneur

Why Tech Companies Need a Code of Ethics for Software Development
Entrepreneur
This mindset is a prime example of why a code of ethics for software delivery is needed among tech companies to make sure their intentions are good willed when delivering products. While one standardized code of ethics (such as the Hippocratic Oath in ...


Investor's Business Daily

Pivotal Software IPO Trades Friday As Big Investors Show Attraction
Investor's Business Daily
Zuora provides a cloud-based, subscription software service that companies use to develop a cloud-based subscription business. Network security company Zscaler raised $192 million, as shares more than doubled on its first day of trading March 16 ...

and more »

Reuters

German minister calls for diesel software upgrades by year-end: Sueddeutsche
Reuters
FRANKFURT (Reuters) - German transport minister Andreas Scheuer is asking carmakers to tell him how they plan to complete by the end of the year outstanding software upgrades on diesel vehicles to reduce emissions, he told a newspaper. FILE PHOTO ...

and more »

The Times

Software firm claims damages from HSE
The Times
A €20 million-plus damages claim brought against the HSE by a company that provided software to dozens of Irish hospitals and medical facilities is due to reach the High Court next week. The action has been brought by Eamon Keogh, trading as Keogh ...


NOLA.com

New Orleans software company to add 35 employees
NOLA.com
Align Technologies Corp. creates software for businesses on the grow, providing them with a cloud-based performance management platform that amounts to a dashboard where they can monitor their employees and progress. The business was founded in 2012 ...

Google News

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

Microsoft Business Solutions Great Plains has substantial market share and... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

Microsoft C# vs. VB.Net

Hi, Guys,I believe a lot of programmers are trying to... Read More

Call Alert Notifications - Free Answering Machine Software for PCs

If you're online using a dialup Internet connection, you'll probably... Read More

History of Java

The java programming language is becoming more and more popular... Read More

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More