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:


TechCrunch

Disputed DNA analysis software's code open for inspection after ...
TechCrunch
If you're going to convict or acquit based on evidence provided by a piece of software, you'd better be damn sure that software is reliable. One such program,..
Federal judge releases DNA software source code that was used by ...ABA Journal

all 3 news articles »

Employer, parental software may be blocking website
Seattle Times
If the problem persists when connected to a different network, it likely stems from software on that computer — a software firewall, a virtual private network or parental software. If the problem goes away — and especially if the other computer has ...


ProPublica

Federal Judge Unseals New York Crime Lab's Software for Analyzing DNA Evidence
ProPublica
A federal judge this week unsealed the source code for a software program developed by New York City's crime lab, exposing to public scrutiny a disputed technique for analyzing complex DNA evidence. Judge Valerie Caproni of the Southern District of New ...


BGR

Google will now pay $1000 for critical software bugs found in popular third-party apps
BGR
With malware creators becoming more aggressive and sophisticated, a number of tech companies in recent years have instituted “bug bounty” programs that provide monetary rewards to any individual or group that uncovers critical vulnerabilities in software.
Google Play Security Reward Program: Bug Bounty Program - Get Rewards through HackerOneHackerOne
Android malware on Google Play adds devices to botnet | Symantec Connect CommunitySymantec
Android Developers Blog: Playtime 2017: Find success on Google Play and grow your business with new Play Console ...Android Developers Blog
Symantec
all 216 news articles »

Mac Rumors

Eltima Software's Elmedia Player and Folx Infected With Malware
Mac Rumors
The compromised software was discovered on October 19, and customers who downloaded software from Eltima on that date before 3:15 p.m. Eastern Time may be affected by the malware. The following files will be found on an infected system:
Mac OSX Trojan malware spread via compromised software downloadsZDNet
Hackers Distribute Malware-Infected Media Player to Hundreds of Mac UsersMotherboard

all 14 news articles »

Bloomberg

Tesla-Like Software Updates Put Dealers' Profit Center at Risk
Bloomberg
The over-the-air software updates Musk pioneered to add features or fix flaws in his electric vehicles are being embraced by more automakers, a potentially grim development for dealers who typically rely on parts and service for as much as half of ...

and more »

Quartz

Facebook treats its ethical failures like software bugs, and that's why they keep happening
Quartz
As the story of Russia, Facebook, and the 2016 US election drags on, Facebook's been quick to open its wallet. It took out full-page ads in both the New York Times and the Washington Post earlier this month to tell the world how it's going to protect ...


Bibb schools bought $3.2 million in software. No sign of it 5 years later
The Telegraph
The company that allegedly sold $3.2 million in nonexistent software to the Bibb County school district five years ago has 30 days to either produce the software or explain why it cannot, a judge ordered Friday. Isaac Culver, 47, of Lizella; Dave Carty ...


FierceBiotech

Johnson & Johnson buys surgical software specialist | FierceBiotech
FierceBiotech
Johnson & Johnson has bought Surgical Process Institute (SPI). The takeover gives J&J control of SPI's Surgical Procedure Manager, software designed to ...

and more »

Engadget

Google and Microsoft troll each other over software vulnerabilities
Engadget
Google has a history of not playing nicely with Microsoft. The company has previously posted publicly about their competitor's software vulnerabilities, and understandably, Microsoft hasn't been very happy about it. But now, the company has turned the ...
Browser security beyond sandboxing – Windows Security blog - TechNet Blogs - MicrosoftTechNet Blogs - Microsoft

all 45 news articles »
Google News

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Groupware and Version History: Collaboration Series #1

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

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

Computer Based Language Development and Spell-checking

Language development computer: Computer-based method for aiding language development seems... Read More

Professional XP Style Icons in Software and Website Development

Using professional icons in your application or website can bring... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

A Symons Mark II Function Point Counting Example

I provide, here clear explanations and a count of function... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

In the new era of internet marketing the problem of... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

My Experience - Making a Vision into Reality

Disclaimer: All the thoughts expressed are my views only! Your... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More