| ||
| ||
|
Audio Streaming Information | |
|
Powered by SaNiTaRaC.CoM - DERATIZACIJA DEZINSEKCIJA DEZINFEKCIJA
|
|
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 /* 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
MORE RESOURCES: » » » » |
|
|
|
RELATED ARTICLES
The Truth about Colossus: Are You Just A Magnetic Image? What is Colossus?Colossus is software licensed to about twenty-five insurance companies to aid in predicting the settlement value of claims. The insurance industry maintains it is a useful tool because it considers a great many factors, and the settlement values are just a range for use in any way the insurer wishes. S is for Spying, Surveillance -- and for Software as Well Words we choose to describe things and phenomena often show our attitude towards what we say. They imperceptibly reflect our opinions and judgments, prejudices and preferences, moral convictions and beliefs. Five Reasons for Using an O/R Mapping Tool So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really is. The Top 5 Wrong Reasons For Not Hiring Testers Considering whether or not your software company should hire a dedicated team of testers? Here are the Top 5 Wrong Reasons why you shouldn't.We Have a Beta ProgramSome people feel that the best way to debug a system is to ship it to your customers and wait for trouble tickets. How to Choose the BEST Charting Software I suggest that you do not spend a lot of money on charting software as most perform very similar functions. Often the price is inflated to capitalize on the mentality that expensive is better. Review of TikiWiki Content Management System TikiWiki is open source software - it is written in PHP, uses phpAdmin for mySQL database administration, and uses the Smarty Template Engine.Installation - Since our host installed the TikiWiki, I cannot comment on ease of installation. Microsoft Blues With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum.Every forum on computer problems is replete with complaints that since downloading and installing 'SP2', many 'third party' applications don't work. RSS: Get Notified When Your Favorite Websites Are Updated RSS (Really Simple Syndication) is a way for a site to publish it's updates. RSS readers can read these notifications and display a listing of the updates to you, the user. Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example Microsoft Great Plains fits to majority of horizontals and retail business is good fit as well. We'll consider the system, consisting from Microsoft Great Plains as Accounting, Inventory Pricing and Microsoft Retail Management System (RMS) Headquarters and Store Operations Manager. Document Templates Give You The Perfect Framework For Your Documents When it comes to running an office, the SOHO entrepreneur has enough on his or her plate as it is. So if you find yourself in the unenviable position of regularly having to set aside your core competencies to handle tedious, repetitive administrative duties such as creating your business documents from scratch, then you need to consider the potential benefits offered by document templates. Intro to UNIX Shells A UNIX Shell is in simplest terms, a command line interpreter, that takes the users input and gives it to the Kernel. If you are familiar with DOS, you will remember the 'command. Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'. 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Ž. Microsoft Great Plains Payroll Module Customization Scenarios It is now common thing when large corporation selects mid-market ERP or so-called standard functionality MRP solution as its corporate accounting system. Microsoft Business Solutions Great Plains is very good candidate. Create ASP in Minutes DBxtra goes ASPGetting to the information hidden within corporate databases has always been a problem for all levels of an organization.IT shops are constantly being pushed to produce more while having little time to accommodate reporting requirements. Microsoft Great Plains Implementation - Overview for IT Director/Controller What is installation in the language of technology? Installation has server and client sides. Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. Unwanted Files A LOT OF UNWANTED FILES.When you uninstall an item of software, there are generally a number of redundant files left behind to clutter up your hard drive. Open Source Concepts: Dual Licensing Explained We were recently faced with a decision: either to let a program that took us one year to code die, simply because we do not have enough time to maintain it, or make it open source.Open source looked like a good idea for while, but there was one problem. Microsoft Great Plains Nationwide Remote Support ERP Consulting industry is on the way to serve clients nationwide and even worldwide, when the client is multinational corporation. There are several reasons to specialize in remote support. IT Department Skills to Support Microsoft Great Plains and Microsoft CRM Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support.
|