|
SQL scripts for Project Accounting: Microsoft Great Plains series - overview for developer
By Andrew Karasev
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 About the Author 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
Article Source: http://www.simplysearch4it.com/article/2466.html
If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/2466.html" as shown above and make it hyperlinked. |
Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like ...
SAP Business One in Illinois: implementation, upgrade, customization, integration Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, ...
Microsoft Dynamics GP Office Stack Integration advances – Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is still a ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you should know where one customization realm exists ...
Microsoft Dynamics GP Dexterity Customization Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual ...
|
|
| |