ALL >> Computers >> View Article
Sql Scripts For Project Accounting: Microsoft Great Plains S
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
Add Comment
Computers Articles
1. Web Scraping Top Grocery Chains In MichiganAuthor: FoodDataScrape
2. How Refurbished Laptops Help Students Save Money And Study Smarter In 2025
Author: usedstore
3. Why The Ls3002 Barcode Scanner Is Perfect For Retail In 2025
Author: prime pos
4. Does Cleaning Temporary Files Really Improve Laptop Speed? (what To Expect)
Author: Neha Jain
5. Extract Supermarket Data From Walmart & Target In Usa
Author: FoodDataScrape
6. How Odoo Partners Drive Growth: From Implementation To Innovation
Author: Alex Forsyth
7. Leverage Web Scraping Cold Drinks Data On Swiggy Instamart
Author: FoodDataScrape
8. Empowering Universities Through Student Engagement Crm Solutions|e2s
Author: Brenda Joyce
9. Odoo Manufacturing And Lean Practices For Small And Medium Enterprises
Author: Alex Forsyth
10. How Posiflex Pos Machines Enhances Customer Service
Author: pbs
11. Scrape Keeta Food Delivery App Data In Saudi Arabia For Insights
Author: FoodDataScrape
12. Microsoft Office Professional Plus 2021 Vs. Microsoft Office Professional Plus 2024: Which One Should You Choose?
Author: davudobuya55
13. Microsoft Office Professional Plus 2019 Vs. Microsoft Office Professional Plus 2019 Dvd: Which Version Should You Choose?
Author: davudobuya55
14. Microsoft Office Professional 2024 Vs. Microsoft Office Professional Plus 2010: Which One Is Right For You?
Author: davudobuya55
15. Microsoft Office Home Business 2021 For Mac Vs Microsoft Office Home Student 2021 For Mac: Which Is Right For You?
Author: davudobuya55






