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 Business Solutions is now in process of creating so... Read More
Spyware and malware are large problems for Internet users today... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
While I was in college, if you would have asked... Read More
(1) Avoid using the same variable again and again for... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Did you ever want to erase everything on your computer?... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
This article is the first of a series of articles... Read More
The major reason I recommend getting your hands on real... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Following tips help you to learn a software in lesser... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
If you are in the market for new staffing software,... Read More
In the previous ISDN article, we looked at how and... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Many Webmasters have never bothered to view their website's server... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
This article illustrates the best practices to improve the performance... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
The Windows registry is a huge database that ensures normal... Read More
Microsoft CRM is new player on the CRM software... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Imagine something that follows you home and sets itself up... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Best Software Act! is very popular CRM for small and... Read More
Looking at all the ads which promise to get rid... Read More
Let's say that you have a software project that's under... Read More
In the new era of internet marketing the problem of... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
The first topic we are going to discuss... Read More
Just when you thought you were Web savvy, one more... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
If you are software developer or database administrator - we... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
The vast majority of us will have, at some point,... Read More
Most people understand that the "hardware" part of their computer... Read More
This article illustrates the best practices to improve the performance... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
So let's begin crunching down these 300 images using Adobe... Read More
I have recently created my first Php program. I wanted... Read More
It's not very often I get excited about a software... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
The cornerstone of successful automated office systems is the ability... Read More
Software |