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 PA01101set SLPRSNID=b.SLPRSNID,SALSTERR=b.SALSTERRfromPA01101 ajoin RM00101 b on a.CUSTNMBR=b.CUSTNMBRwhere 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.PRBTADCDfrom PA13100 a join PA13200 b on a.PADocnumber20=b.PADocnumber20 join PA01201 c on b.PAPROJNUMBER=c.PAPROJNUMBER
/*update PA13100 set PRBTADCD=c.PRBTADCDfrom 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
|
|
|
Secure File Transfer Using Ssh Plus Additional Audit & Automation - Fsa Reporting
In order to meet regulatory and corporate compliance requirements reporting members will require a cost effective solution that may be installed at one side of the data transfer without being tied to any proprietary protocol.Considerations inc...(related: Software)
Four Desktop Tools To Drastically Increase Your Productivity
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes on your desktop or send them instantly over the Internet.StickyNote also enables you to adhere notes to documents or windows AND to attach documents to your note.StickyNote eliminates the clutter and confusion of keeping up with the reminders and phone num...(related: Software)
Most Common Ways To Accumulate Spyware (where It Is Downloaded To Your Pc)
It is possible that if one avoided all sources of spyware, ad-ware and virus infection that infection would be at minimal levels. Although I don't recommend using only this method as a form of fighting spyware, it can be a potentially effective mean. Used in conjunction with a virus scanning program (I recommend Avast), abstaining from visiting these web sites or using these programs will help your PC to fight off infections, infestations and slower speeds due to unneeded running processes.The most common places where your PC will pick up spyware, ad-ware and viruses will be adult websites or websites related to security. By security, I mean websites related to computer hacking and the like. If you partake in software piracy, you will notice that many of these websites that are piracy download zones have javascripts and cookies ...(related: Software)
Microsoft Great Plains Implementation For Midsize & Large Corporation: Lockbox Processing
Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features: Lockbox Processing for Accounts Receivables, Customer/Vendor Consolidation, Multicurrency etc. We'll try to cover these features in the series of small articles to help decision maker and end user understand the feature and how does it work to make a decision to purchase additional nice modules. In our opinion large corporation, which had to use ERP with rich functionality in the past, doesn't have to do it in our new time. There are few reasons to switch to cheaper ERP, the most important are: database platform reliability improvement ? nowadays MS SQL Server does excellent job and has most of the former instability and maintenance issues resolved. The second reason ? MS Windows ser...(related: Software)
Programming Environments And The Software Production Process
Introduction:The creating of a computer program involves a number of stages which can be made easier with several separate software utilities. There are now integrated set of support programs which combine all the necessary utilities to provide a complete program development environment. These are known as programming languages, which include:BASIC: Beginner's All-purpose Symbolic Instruction Code originally designed for Dartmouth's experimental timesharing system in the early 1960s, which has since become the leading cause of brain damage in proto-hackers & programmer becouse it encourages bad habits that will make it harder to use more powerful languages well.PASCAL: A language designed in 1967 and released in 1968 as an instructional tool for elementary programming. This language was design...(related: Software)
Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant
When you first think about multicurrency ? you probably have in mind the revaluation question. Currency triangulation ? which was the need when European currencies were fixed to Euro is not an issue any more.1. Sales and Purchasing multicurrency ? when you are selecting accounting package with multicurrency, you need first understand if it has multicurrency on the Sales and Purchasing modules level, not just in GL. The problem behind is like this. When you have sales in foreign currency ? you will probably get the payment later...(related: Software)
About Microsoft Sysprep (system Preparation) Utility (windows 2000)
The Microsoft system preparation utility for Windows 2000 is a very handy tool for network support shops that deploy PC images as a means of reformatting PC's with problems. Sysprep basically strips out all the hardware information and unique information from that specific PC, which allows you to deploy the image created from that PC on to many other PC's with different hardware configurations.Not only does this program remove the unique information from each PC, but it allows you to do many configuration options automatically. For instance you can setup the workgroup or domain, organization name, computer name, default display size, and a whole lot more.The Sysprep utility finds all it's configuration information in one relatively simple .inf file. Which for the most part follows the below example in terms of...(related: Software)
Great Plains Dos Support ? Notes For Consultant
Great Plains Accounting, accounting package for mid-size and small companies was in its peak of popularity back in earlier 1990th. It first had DOS interface, later on migrated to classic Windows version (remember earlier event driven Windows and its strange and at the same time revolutionary programming model ? guys who remember Borland C++ and Microsoft C++). As each product has its life time ? it is ...(related: Software)
Tools For Customizing Great Plains
Microsoft Business Solutions ? Great Plains has captured the US market with its integrated business applications for small and mid-size organizations. Its comprehensive accounting and business management capabilities provide businesses with tools to customize various modules of the Great Plains software. These tools have been proven to have contributed to business growth and tighter control over its processes.There are several ways in which customization and integration can be applied to Great Plains applications because of its open architecture characteristic. Integrity of data and performance of processes can also be validated using one of the many tools as listed ...(related: Software)
New Web-based Hr Tool Is Max From Nas, Hannibal, And Infolink
Three highly respected names in Human Resources have joined forces to provide companies with a revolutionary blend of services that make the hiring process more efficient a...(related: Software)
Fleet Maintenance Software Reviews
Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance ProŽ. According to the website and fleet maintenance software reviews, this product offers automatic calculations of maintenance, assists in tracking PM and repair maintenance, helps you analyze fleet costs over time and much more. This product is recommended for maintaining vehicles that are tracked by date, mileage, hours and etc. Prices range from...(related: Software)
Running A Program On A Remote Server Using Ssh
How do you run a program on a remote server using ssh?For this example we'll have two servers, one named Johnny and another named Cash. Both are running openssh. Our goal is to have a program on Johnny login to Cash and run a program on Cash. To make the task a little more complex we'll be using different users on each machine.The first thing we'll need to do is generate public and private keys on Johnny. So, logged into Johnny as user 'boy' we create public and private keys by creating them in the .ssh directory as follows:Johnny$> pwd/home/boy/.sshJohnny$> ssh-keygen -t rsa -f sueGenerating public/private rsa key pair.Enter passphrase (empty for no passphrase):...(related: Software)
Cisco Certification: Introduction To Isdn, Part Iii
Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that mig...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software