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
Chicago limo Skokie ..IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
Here is some free software tools to help you build... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Imagine something that follows you home and sets itself up... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
I suggest that you do not spend a lot of... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
This article is the fourth of a series of articles... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
Whether you are an experienced web programmer or a complete... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Although statistics often is blamed for various deadly sins --... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
limo O'Hare Bonfield ..Google Inc. has launched a new software package that allows... Read More
Once a business idea is selected, it is highly recommended... Read More
A UNIX Shell is in simplest terms, a command line... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Which Type of Shop Can Rely On A Home Built... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
Domino server is a buffer between the operation system and... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
One of the main reasons business owners and entrepreneurs use... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
Did you ever give a thought to the number of... Read More
There are plenty of articles out there about how to... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Words we choose to describe things and phenomena often show... Read More
If you are to buy a HelpDesk & Asset Management... Read More
C++ Function templates are those functions which can handle different... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
During the years of our consulting practice, which comes back... Read More
The java programming language is becoming more and more popular... Read More
If you are software developer or database administrator - we... Read More
Buying accounting software is a major investment. It's an important... Read More
Software |