Finance Articles

SQL scripts for Project Accounting: Microsoft Great Plains series – overview for developer

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

Other Article Sites

findabook.com  moneycd.info  a-mortgage.info   about-lemon-laws.info  aboutstudentloans.info
all-about-publishing.info  auctions-articles.info  bestcollege-university.com  bestispconnection.com
biblefolder.com  blogger-website.com  books-used.info  brokers-guide.info  buywindows.info  cable-dsl.info
career-miner.com  carpel-tunnel.info  cashinaflash.info  cashloanreviews.info  casinobell.com  chat-house.info
clearmycredit.info  collegeloantips.info  crones.info  depression-articles.info   dirnic.net  dishguides.info
divers-below.com  expodog.info   financewizz.com  fire-insurance.info  getgood.info  handleit.net   it-idea.info
health-supplies.info  hosting-right.com  insidealert.com  insurance-facts.info  jobs-employment.info
justgood.info  lookgold.net   lowcost-travel.info  money-source.info  myhostzone.info  numisblog.com
peoplesearchfinder.info  pr-articles.info  realeas.com   refinancing-guides.info  spyware-remove.info
telelot.info  the-law.info   toppaid.info  travel-deals.info  travelcorrect.com  wedding-guide-site.com
your-blog.info  your-credit.info

Golf in Portugal to get 50 Million Euro Investment; Masters Event Planned for October
Golf opportunities in Portugal are growing at a rapid pace, with the industry expecting a 21 percent increase in the next two to three years, according to ITP-Turismo de Portugal. In early January, tourism officials announced a plan for a 50 million Euro investment of public and private funds in promoting golf throughout Portugal. The expansion is expected to enhance Portugal's growing reputation as a premier golf destination.

Making Assets Finance Costs
Getting a home loan is today far easier than it used to be even a few years back. Home loans are full and plenty. You can find the ideal loan a wide variety of home loans. If you are a homeowner you could look through some secured homeowner loans. Alternatively, home equity loans are also a good bet. But first of all, before you even embark on your journey towards that dirt-cheap loan, make sure you have decided what use you will be putting that money to. You certainly don't need me to tell you that you should not be frittering away borrowed money on pursuits that will give you no returns.

Can You Builid an Online Home Business Without a Monetary Investment?
You see it all the time: Ads such as, "FREE HOME BUSINESS", "MAKE A PROFIT WITH NO COST TO YOU", etc. You see these claims in emails and on websites all over the Internet.

Fantastic Investment Opportunity With Cyprus Property For Sale
Cyprus property for sale is inexpensive compared to most developed European countries Cyprus apartments are now moving fast and Cyprus developers are trying to keep up with demand

International Investment Banking
An International Investment bank is a bank that does not accept deposits but rather provides services to investors and to those who offer securities to investors on a worldwide scale. International investments can provide growth and even poverty reduction which is why the OECD Global Forums on International Investment (GFII) support the services of international investment banks and work to enhance the benefits of investment in developing countries in particular. International investment banks offer similar services to the average local investment bank except that is expanded into the international market. This can be beneficial for investors who wish to expand their portfolios and create a well balanced set of investments. The benefits...

Biweekly Mortgage Programs - Are They Worth the Money?
A number of companies frequently advertise that they can help you pay off your home loan in a lot less time. These programs, which are known by a number of names, including "mortgage accelerator", purport that they can cut as much as 10 years off of your 30 year repayment schedule. All that is necessary to enjoy the rewards of their system is to apply by paying a substantial fee. Is it worth the expense?

Shopping For Bad Credit Mortgage Brokers
You like to shop. You know you do. It's nothing to be ashamed of. You like to get out there bedecked in your fashionable hot pants and flip flops, scout the malls and markets, and find the best deals there are. Shopping takes a great deal of time and effort but you're perfectly happy to do it anyway. If only you put half as much heart in searching for the best mortgage deals there are! You would never end up with an unscrupulous bad credit mortgage broker.

5 Tips For Buying Accounting Software
Whether you are shopping for accounting software to help budget your personal or business expenses, you may find that managing all of your files with a single program helps you to save time and know exactly where your money goes. If you are familiar with the accounting process, you already know how complicated ledgers, account statements, debits and credits can be. In an effort to simplify the accounting process, a number of manufacturers have created software specifically designed to help make your life a little easier.

1st Nations Mexico and 1st Nations Mortgage of Mexico Announce New Financing Guidelines
1st Nations Mexico and 1st Nations Mortgage of Mexico announces new guidelines for US and Canadian residents looking to develop, buy, or refinance property in Mexico. 1st Nations Mortgage of Mexico leverages unique relationships with banking and lending entities in the US and Mexico to provide industry leading loans to consumers and developers.

Mortgage Outfits Challenged On Exit Fees
You might have heard of an exit fee. It is the charge that the mortgage lender makes a person pay if they want to get out of a money borrowing agreement before the end of the term. Another name for it is a redemption penalty.

Should You Pay Off Your Mortgage?
If you have a mortgage on your home, then paying it off early could be option for you to consider especially if the remaining debt is manageable. Conventional financial wisdom could suggest otherwise, but then there is nothing conventional about most debt anyway. Should you pay off your mortgage? Well, that ultimately becomes a personal decision one that you need to explore and decide for yourself.

Property Investment: Spoiled for Choice in Europes Emerging Markets
You could be forgiven for thinking that property is the new dot.com.

Cornerstone Revolutions, LLC, Brings Judith E. Gross, Esq. to Investment Advisor Webinar Series for Talk on Specialized Employee Training Topics
Judith Gross, Esq. of JG Advisory Services will be speaking Tuesday, April 22, 2008, 10am PDT, to investment advisors on employee training issues including discrimination/harassment, insider trading, and anti-money laundering as part of the Cornerstone Revolutions Webinar series.

Quality Mortgage Leads in Real Time
If you are a loan officer or mortgage broker and you are thinking about buying mortgage leads, you may want to consider purchasing ?real time? mortgage leads.