Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer > NetSparsh - Viral Content you Love & Share

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! [email protected]

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

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Fortune

Donald Trump Signs Federal Ban on Kaspersky Lab Software
Fortune
President Donald Trump signed into law on Tuesday legislation that bans the use of Kaspersky Lab within the U.S. government, capping a months-long effort to purge the Moscow-based antivirus firm from federal agencies amid concerns it was vulnerable to ...
Trump signs bill banning Kaspersky Lab software from federal useTechCrunch
Trump Signs Ban on Kaspersky Software - GizmodoGizmodo
Text - H.R.2810 - 115th Congress (2017-2018): National Defense Authorization Act for Fiscal Year 2018 | Congress ...Congress.gov

all 9 news articles »

TechCrunch

Clubhouse nets $10m Series A from Battery Ventures to make ...
TechCrunch
People often describe work as a rat race, but for a lot of engineers, that isn't too far off. Take one Jira ticket off the queue, fix the bug or add the feature, mark the ticket as complete and move as quickly as possible to the next ticket ...
| Battery Ventures leads Series A round for Clubhouse SoftwarePE Hub (blog)

all 3 news articles »

Forbes

Generous 401(k) Matches Helped Scott Scherr Build The Ultimate Software Stock
Forbes
Over the past decade, few companies have performed as well as Ultimate Software, a payroll and human resources software seller, and done so with less fanfare. Yielding a 20% annualized return since 2007, Ultimate Software has become the ultimate mid ...


Phys.Org

Beta of Neurodata Without Borders software now available
Phys.Org
In an effort to maximize the return on investment in the creation of neurophysiology data sets and enhance experiment reproducibility, Bouchard notes that the first version of NWB:N made huge strides toward generating a unified data format for cellular ...

and more »

ZDNet

Juniper Networks' OpenContrail software defined network joins The Linux Foundation
ZDNet
It's also the home of many open-source networking projects such as the software-defined network (SDN) OpenDaylight, Open Platform for Network Function Virtualization (OPNFV), and Open Network Automation Program (ONAP). Now, networking power Juniper ...

and more »

PC Gamer

AMD's Radeon Software Adrenalin Edition drivers arrive with a focus on latency
PC Gamer
AMD has released its most comprehensive software release of the year. Dubbed Radeon Software Adrenalin Edition, the new driver package is more than an incremental update, it's AMD's annual overhaul that was first set in motion with Catalyst Omega at ...
AMD Releases Radeon Pro Software Adrenalin Edition 17.12.1: Adrenalin and ProRender UpdatesAnandTech
Meet Radeon Software Adrenalin Edition: AMD Link mobile app, Radeon Overlay, and morePCWorld
AMD Launches Much-Needed Software Revamp, Offers More Control Of Video CardsGameSpot
TechRadar -TrustedReviews -VentureBeat -AMD Support
all 48 news articles »

We Live Security (blog)

It's time to patch your Microsoft and Adobe software again against vulnerabilities
We Live Security (blog)
It's the second Tuesday of the month, and you know what that means… Yep, it's time for another bundle of essential security updates from Microsoft. For its final scheduled batch of updates for 2017, Microsoft has released fixes for over 30 security ...

and more »

Den of Geek US

Dark Souls Developer From Software Teases New Game
Den of Geek US
Given that the teaser in question doesn't contain any real shots of gameplay and that From Software hasn't released any further information regarding what this footage is about, we're left to speculate in regards to what it is that we're looking at. So ...

and more »

TechCrunch

Clubhouse nets $10m Series A from Battery Ventures to make software development fun again
TechCrunch
The company just got a boost to bring that hopeful vision to development teams across the world, securing a $10 million series A investment from Battery Ventures investor Neeraj Agrawal, who will also be joining the company's board. Clubhouse is all ...


Why CyberArk Software Stock Popped 11% in November
Motley Fool
What happened. Shares of CyberArk Software Ltd. (NASDAQ:CYBR) jumped 11.1% in November, according to data provided by S&P Global Market Intelligence, after the cybersecurity company's third-quarter earnings report surpassed analysts' estimates for both ...

and more »
Google News

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Helping Newbies Understand Professional Software

The Windows registry is a huge database that ensures normal... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... Read More

Dreamweaver vs FrontPage

There are two major WYSIWYG(What You See Is What You... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

And kill the best layout software in the process of... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

Five Reasons for Using an O/R Mapping Tool

So, why should you use any O/R mapping tool? I... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Adware, What Is It?

Adware is a type of Spyware program that displays some... Read More

Cisco Certification: Introduction To ISDN, Part IV

In part III of this ISDN primer, we learned that... Read More

Groupware as a Document Manager: Collaboration Series #3

This article is the third of a series of articles... Read More

Artificial Intelligence And Intuition

The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... Read More

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

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

Microsoft Great Plains could be tuned and setup to fit... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More