Computer and Technology Web

Microsoft Business Portal for Dynamics GP Custom Reporting
By Andrew Karasev

In this small article we will try to orient you on how to create cross-product reports, based on SQL view or stored procedure, where data is pulled from Microsoft Great Plains as well as Microsoft Business Portal tables. This query architecture should open for you report designer or programmer the way to create cross-product report. Good example would be the following - life cycle of purchase request, which originates in Business Portal Requisition Management module and then, when approved is moved to Purchase Order in Microsoft Dynamics GP purchase order processing module. The reporting tool selection in our opinion is the secondary question - both popular tools: Crystal Reports and Microsoft SQL Server Reporting Services (SRS) will do the job as soon as you could trust your view or stored procedure. Let s try to create cross-product query in Requisition Management linking to GP Purchase Order Processing

- ReqMgmtDocument table. This table stores all your purchase requests created, submitted and approved in BP Requisition Management module, also you should be aware that this table resides in DYNAMICS database and so it has CompanyID field. You should compare company ID with GP SY01500 table, which also resides in Dynamics database, but it is Microsoft Dexterity table and it is within GP architecture realm.

- POP tables. In Microsoft Dynamics GP you should know the posting workflow. For the most of transaction types GP is batch processing system, however Purchase Order is an exception - it has statuses and PO lifecycle is the change of statuses. However when you receive against purchase orde - purchase receipt transaction is batch oriented and you can post either individual transaction (in this case the batch number will be your user id) or the whole butch upon the approval. Tools->Resource Description->Tables in GOP workstation will give you the names of the tables in POP, if you switch series to Purchasing. More likely you will need to research the following tables: POP10100 - Purchase Order Work, POP30100 - Purchase Order History (it goes to history when all the lines are received), POP10300 - Purchase Receipt Work, POP30300 - Purchase Receipt History

- SQL View or Stored Procs creation.

Microsoft Great Plains Dynamics GP Implementation and Support Business Portal and Dexterity
...

Microsoft Dynamics GP Development
...

Business Portal For Microsoft Dynamics GP Installation & Support Overview For Consultant
...

Microsoft Dynamics GP Chicago - Customization, Integration, Data Conversion Review
...

Microsoft Business Portal for Great Plains Dynamics - Architecture Notes
...

This makes view or sp creation and easy task, as you don t really need to create something like linked server and pass it as a parameter to the query.

Andrew Karasev, Alba Spectrum Group,
http://www.albaspectrum.com
help@albaspectrum.com
1-866-528-0577, 1-630-961-5918,
serving Microsoft Dynamics GP USA and Canada nationwide: Toronto, Montreal, Vancouver, Calgary, Windsor, New York, San Francisco, Los Angeles, Miami, Orlando, Pittsburg, Toledo, Indianapolis, Detroit, Philadelphia, Boston, Washington, Seattle, San Diego, Phoenix, Austin. Local service is available in Chicago and Houston metros: Rosenberg, Katy, Richmond, Dallas, Galveston, Sugar Land, Naperville, Wheaton, Plainfield, Aurora, Wheaton, Downers Grove, Lisle, Oakbrook, Morris, Marseilles, Joliet, Montgomery, Oswego, DeKalb. With reasonable travel we serve Springfield, Bloomington, Normal, Peoria, LaSalle, Ottawa, Dixon

Article Source: http://EzineArticles.com/?expert=Andrew_Karasev
http://EzineArticles.com/?Microsoft-Business-Portal-for-Dynamics-GP-Custom-Reporting&id=607154

.

Computer Training - Choosing The Right Operating System
By Michael Russell

Choosing an operating system for a personal computer can be a difficult decision considering the wide variety available today. Nobody wants to purchase expensive software and then find out that they dislike the software and realize they have made a mistake. There are some free operating systems available now, but those have faults just like most other operating systems. Another factor in choosing the right “OS” is whether or not the user is experienced or not. You must always consider the specifications on your computer as well. When you purchase a retail computer from a store such as Best Buy, they all come with Microsoft products and you really don t have much of a choice. Some versions of Linux are popular enough to be purchased at stores such as Best Buy, but are never included with a purchased PC. To obtain the operating system you want, you will probably have to visit another computer store or to go online and search for it. Although Microsoft supports other operating systems besides Windows XP, they are not readily accessible to buy at a lot of stores.

If someone is considering using a free operating system, then just understand that there might be limited support and the interface might be for the advanced user. Free software might have little or no security updates on a regular basis. When choosing what “OS” is right for you, you must decide if you are looking for something with open source-code. The open source operating system would usually be for programmers looking to change the “OS” to fit their liking. If you are using an old computer with low-end specifications, you might want to try a free “OS”, Unix, or perhaps even some variations of Linux. Someone with a high-end computer doesn t need to worry about this problem.

Microsoft currently offers a couple of supported operating systems, which include Windows 2000 and Windows XP.

Choosing an Alternative Operating System
...

OS 101: Suggestions for Choosing an Operating System
...

The Value of A+ Certification Training
...

How to Choose Right PC Diagnostic Software
...

The Basic Requirements for MCSE Certification
...

This would be a good decision for those that are new to operating a PC and want the experience to be easier for them. Some do not enjoy the user-friendly interface and would like to have more advanced control over their “OS”. Windows XP has security updates quite often as well as Windows 2000. Windows 2000 is possibly a mix between Windows 98 and Windows XP. Windows 2000 offers the user more advanced control over the operating system and has an interface similar to Windows 98 or Millennium. While Microsoft offers a friendly interface, most Linux operating systems offer a more advanced approach. Some versions of Linux are open source and can be modified if you are knowledgeable in programming.

Keeping all of this in mind, one should be able to choose which road they wish to go down. If you are more interested in a graphical interface than anything else, it is suggested you choose Windows XP like the majority of PC users today. Windows XP is most commonly used because Microsoft is pretty much forcing everyone to. If you are in the mood to try something else, go to the store and purchase Red Hat Linux.

Michael Russell

Your Independent guide to Computer Training

Article Source: http://EzineArticles.com/?expert=Michael_Russell
http://EzineArticles.com/?Computer-Training—Choosing-The-Right-Operating-System&id=219781

.