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
|
|
|
|
|
|
|
|
Top Questions to Ask Before Buying a Help Desk & Asset Management Software
#5 All your hardware components like Printers, PCs etc come... Read More
Microsoft CRM Implementation for Large Corporation ? overview
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Best Practices In Choosing Network Monitoring Software
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Microsoft Great Plains Customization Tools ? Overview
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
Destination: Desktop for Google
First we had the original Google search that evolved into... Read More
Microsoft Great Plains IV: Inventory Management
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Should I Use Windows Update?
Should one use Windows Update?This topic has good and valid... Read More
Professional Software Icons For Your Standalone Application
User interfaces and accessibility are some of the most important... Read More
Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants
We'll give you non formal view, based on our consulting... Read More
Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Cisco Certification: Introduction To ISDN, Part III
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
IT Department Skills to Support Microsoft Great Plains and Microsoft CRM
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
MCP Market News: Microsoft SQL Server & SQL Reporting Services
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Great Plains Data Conversion ? Overview For Developer
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft CRM Customization - Processing In/Out-Going Email Messages
We would like to give you several situations, when you... Read More
Save Your Resources - Combine Your IM Clients
There are so many different programs that clutter up your... Read More
Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example
IBM Lotus Notes with Domino email server is traditional document... Read More
Making The Decision To Automate Your Software Testing
Not every software testing project can or should be automated.... Read More
Microsoft CRM for Large Corporation ? Security
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Backing Up And Restoring Your MySQL Database
If you've been using MySQL database to store your important... Read More
An Easy Way to Develop JAVA Enterprise Applications
Research bears that less than 70 percent of development projects... Read More
History of Java
The java programming language is becoming more and more popular... Read More
Internet Faxing Service Review
The Internet is reshaping every form of communications medium, and... 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
Great Plains Customization ? Programming Auto-apply in Accounts Receivable
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
Linux ? Keyboard Or Mouse
Just stress testing one of the latest Linux distributions. Been... Read More
Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts
In this small article we will be looking at the... Read More
Instant Messenger Clients
If you have been using the Internet for any amount... Read More
Microsoft CRM Integration & Customization: SharePoint Document Gateway
MS CRM is very close to document workflow automation, including... Read More
Three Steps To Windows Safety Heaven
Now there are Three Steps To Heaven Just listen and... Read More
Reduce Pop-ups and Annoying Ads
There is many things more frustrating than surfing a website... Read More
Do You Know These Facts About Spyware ?
Imagine something that follows you home and sets itself up... Read More
C++ Tutorials: 3, Program Flow (If, Else, While, For)
Program Flow is what you think it is. How the... Read More
Beware of Spyware
One day, you suddenly realize that your computer started to... Read More
How the Firefox: How to... Manual Helped Me
A few months back I really got sick of my... Read More
EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
Three Steps To Windows Safety Heaven
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management
Let's first look at your ERP system selection (without Retail... Read More
Linux for Home Users
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
C++ Tutorial 2, Input and Variables
This is the tutorial where we really get into programming.... Read More
Microsoft Great Plains Integration Manager ? Working With Text File
Microsoft Business Solutions main middle market ERP application - Microsoft... 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: Data Conversion & Migration Scenarios ? Overview for Consultant
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
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... Read More
String in Java
Handling character strings in Java is supported through two final... Read More
Looking for an Alternative to Microsoft Office? You Should Be!
Now is the time to look at an alternative to... Read More
Device Driver Basics
Most people understand that the "hardware" part of their computer... Read More
Microsoft CRM Customization ? Programming Closed Email Activity
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants
We'll give you non formal view, based on our consulting... Read More
Internet Security Threats: Who Can Read Your Email?
Before being able to choose a secure Internet communication system,... Read More
Quick Summary of Basic and Common Linux Commands
There are many commands that are used in linux on... Read More
An Easy Way to Develop JAVA Enterprise Applications
Research bears that less than 70 percent of development projects... Read More
Spyware Statistics -- Whats New in May 2005?
Although statistics often is blamed for various deadly sins --... Read More
Microsoft Great Plains Implementation ? Overview for IT Director/Controller
What is installation in the language of technology? Installation... Read More
Internet Relay Chat - A Basic Introduction
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Spyware Definitions List
The adware and spyware definitions list is very long. But... Read More
Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Microsoft CRM: Data Conversion ? Import from Act!
Best Software Act! is very popular CRM for small and... Read More
Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Who?s Watching What You Type?
If someone entered your home, uninvited and installed numerous cameras... Read More
Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports
Microsoft CRM is new player on the CRM software... Read More
Protect Your Computer...and Your Business!
We all take the computer for granted. I mean, all... Read More
Software |