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! 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

---

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Best Spyware Removers

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

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... 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

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... 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

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

Spyware Statistics -- Whats New in May 2005?

Although statistics often is blamed for various deadly sins --... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

Microsoft Great Plains Reporting ? Overview for Developer

Looks like Microsoft Great Plains becomes more and more... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

C++ Tutorial 2, Input and Variables

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