123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

Sql Scripts For Project Accounting: Microsoft Great Plains S

Profile Picture
By Author: Andrew Karasev
Total Articles: 27
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

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

Total Views: 156Word Count: 335See All articles From Author

Add Comment

Computers Articles

1. React Vs Angular: Which Should You Use To Build Your Startup In 2022?
Author: goodcoders

2. Php Vs Java: Differences & Similarities For Web Development
Author: goodcoders

3. Most Common Mistakes When Developing A Mobile App
Author: goodcoders

4. Hvac Market To Soar To $456.6 Billion By 2032: Growth, Trends & Innovations
Author: Rutuja kadam

5. Sports Analytics Market To Hit $22.2 Billion By 2032: A Game-changer For The Industry!
Author: Rutuja kadam

6. Bluetooth Printer: Efficiency & Portability Combined For Your Business
Author: srikanth

7. Mmoexp Cfb 25 Coins:master The Basics To Build Confidence
Author: kyw

8. Top 5 Marketing Resource Management Software Of 2025
Author: Ben Gross

9. Reliable Logistics Company In Saudi Arabia: Is Your Trusted Supply Chain Partner?
Author: IAP Logistics

10. The Rise Of Digital Marketing In Bangalore: Your Ultimate Guide To Choosing The Right Digital Marketing Agency
Author: Cubikeymedia

11. How To Select The Right Nema Power Cord For Your Needs
Author: Jennifer Truong

12. Top 5 Sales Intelligence Software Of 2025
Author: Ben Gross

13. Seo Company In India Increases The Fame Of This Country
Author: SEO Company Kolkata

14. Top 5 Marketing Intelligence Software Of 2025
Author: Ben Gross

15. Why Web Content Management Software Is Essential For Digital Growth In 2025
Author: dnd teams

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: