Tuesday, February 9, 2010

By Product Using Dynamics GP Manufacturing


Some manufacturing processes result in by-products—secondary products that are produced when a primary product is produced, usually at a predictable rate. For example, a furniture manufacturing business that cuts wood to specific sizes would have leftover pieces. Those leftover pieces could be scrapped, or they could be sold.

In Dynamics GP Manufacturing, you can account by product by two ways
1-    At Bill Of Material Setups
2-    At Manufacturing Receipt Entry

1-    Bill Of Material:
You can use the Bill of Materials Entry window to account for the by-products produced by your processes. To do this, add the by-product to the bill of materials as if the by-product item were a component of the bill of materials—expressing the amount of by-product produced as a negative number(-1). When finished goods are received for a manufacturing order based on the bill of materials, material transactions are created to add one of by-product to inventory.

-      Cards >> Manufacturing >> Bill Of Material
 

 

-      Select your Finished Good Item.
-      Click Add Item To Bill of material button.
-      Select Item Code, “by-Product Item Code”
-      Enter “Quantity”, it should be in negative.
-      Enter “Site ID”, where you would like to record the receipt of By-product.


2-    Manufacturing Receipt:
If you have not setup by-Product in Bill of Material or Pick-List, You can use the Manufacturing order receipts window to account for the by-products produced. To do this, add the by-product at the time of Manufacturing order receipts as a negative number.

-      Transaction >> Manufacturing >> Manufacturing Order >> MO Receipt Entry


-      Select Your Manufacturing Order
-      Click “Add Component”
-      Enter “By-Product Item Code”.

-      Enter “Quantity”, it should be in negative.
-      Enter “Site ID”, where you would like to record the receipt of By-product.


When you post manufacturing order receipt for a manufacturing order, any byproduct quantities will be added to inventory, rather than removed from inventory when the receipt is posted.

Until Next Post.

Wednesday, February 3, 2010

Filtering Dynamics GP Lookups Using VBA


An excellent article posted by Mohammad R. Daoud –MVP in his blog to filter Dynamics GP lookup using VBA, this is very helpful !

Check the full details in his Post “Filter Lookups By Predefined Smart-list Favorite “Simple data level security method

Tuesday, February 2, 2010

Using SQL Server Reporting Services(SSRS) with Microsoft Dynamics GP


In Dynamics GP we have a cool feature to have SQL server reporting services(SSRS) reports, Microsoft SQL Server Reporting Services (SSRS) offers a very powerful report writing capability for any SQL Server based system. Specifically for Microsoft Dynamics GP, Microsoft has created a library of over 200 pre-built reports to use.

In Order to access and leverage the SSRS Library that is provided by Microsoft and to upload it to your Dynamics GP system you need to perform some simple steps

Step 0 :        Prerequisites

-      SQL Server Reporting Services 2005 With SP2 Or Later

-      SQL Server Reporting Services 2008 With SP3 For SQL Server Reporting Services Wizard

-      IIS 6.0

-      Internet Explorer 7 or 6 with SP2

-      Dynamics GP 10.0 with Service Pack 1 or Later


Step 1 :        Install & Setup IIS

-      For Windows 2003

o    Click Start, point to Control Panel, and then click Add or Remove Programs, The Add or Remove Programs tool starts.
o    Click Add/Remove Windows Components, The Windows Components Wizard appears.
o    In the Windows Components list, click Application Server, but do not select the check box.
o    Click Details, and then click to select the Internet Information Services (IIS) check box.
o    For Further Details Please refer to windows manual.

-      For Windows 2008

o    Click Start -> All Programs -> Administrative Tools -> Server Manager.

o    In Server Manager, scroll down to Roles Summary, and then click on Add Roles. The Add Roles Wizard will start with a Before You Begin page. The wizard asks for verification of the following:
o    Select Web Server (IIS) on the Select Server Roles page. An introductory page will open with links for further information
o    Choose the IIS services to be installed on the Select Role Services page.
o    Click Next

-      For Windows XP

o    Click Start, point to Control Panel, and then click Add or Remove Programs, The Add or Remove Programs tool starts.
o    Click Add/Remove Windows Components, The Windows Components Wizard appears.
o    In the Windows Components list, Select the Internet Information Services (IIS) check box.

o    Click Next.

Step 2 :        Install & Setup SQL Server with Reporting Services

-      Install SQL Server 2005 / 2008 with SQL Reporting Services, refer to SQL server installation help for complete details.

-      After Installation Run SQL Server 2008 reporting service configuration manager. 

 

-      Select Server to connect.

-      Specify/setup/Apply proper Web services URL.

-      Specify/setup/Apply proper Report Manager URL.

Step 3 :        Install SQL Server Reporting Services For Dynamics GP

-      Run the Reporting Services setup wizard from GP CD2

-      Click Next On Welcome Screen.

-      Accept the license agreement.

-      Select Feature “U.S English Version”

-      Complete.

Step 4 :        Run Microsoft SQL Server Reporting Services Wizard

-      Click Start >> Programs >> Microsoft Dynamics >> Business Intelligence >> Microsoft SQL Server Reporting Services Wizard.

-      Click “Next” on welcome screen.

-      Specify “Dynamics GP Server Name” & “SQL User ID & Pass” on Connect to data source screen.

-      Select “Company” and specify Module against which you would like to deploy SRS standard reports on Select Database and module screen.

-      Specify “Target Server URL” , in define location & deploy report screen. This URL is report server URL. ( Refer Step 2 for URL ).


-      Click Finish.

Step 5 :        Setup SQL Reporting Service In Dynamics GP

-      Define the reports and web services path in “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Reporting Tools Setup”:
-      Specify “Report Manager URL”. ( Refer step 2 for URL Details )

-      Specify “Report Server URL”. ( Refer step 2 for URL Details )

Step 6 :        Browse Standard SRS Report in Dynamics GP

-      Go to Administration tab and find “Custom Report List”:










Helping Links:

SSRS With Dynamics GP FAQ ( KB 954242 )

https://mbs.microsoft.com/knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyxupyzqpouxnxspsypwwwwonwumqpnovy&wa=wsignin1.0

Happy Reporting !