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
Culver prom limo ..Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Following tips help you to learn a software in lesser... Read More
Research bears that less than 70 percent of development projects... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
XML Server can be a Web Server that stores the... Read More
When making a decision to buy any piece of software... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
This article is the first of a series of articles... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
XML parser is a software module to read documents and... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
If you have Microsoft Great Plains and support it... Read More
Around the same time Microsoft made its move with .Net... Read More
The first topic we are going to discuss... Read More
Finding the best spyware removers to detect and remove spyware... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
A few months back I really got sick of my... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Looking at all the ads which promise to get rid... Read More
Wood Dale limo ..Bill of Lading is required report for Logistics and Freight... Read More
What is installation in the language of technology? Installation... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Well, even if the combination might look very unusual, we... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
How do you run a program on a remote server... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Before being able to choose a secure Internet communication system,... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
XML Server can be a Web Server that stores the... Read More
In the previous ISDN article, we looked at how and... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Software |