Home » TIPS AND TRICKS BY MODULES » Manufacturing
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: Manufacturing
Links Sort by: Hits | References | Alphabetical
Microsoft Dynamics GP Manufacturing Flow Chart
Many times I have been asked for flow chart for…
http://waqasb.blogspot.com/2009/12/microsoft-dynamics-gp-manufacturing_22.html
Many times I have been asked for flow chart for…
Posted by
Manufacturing Simple Workflow
http://mohdaoud.blogspot.com/2009/12/manufacturing-simple-workflow.html
Inventory BOM vs Manufacturing BOM
http://dynamicsgpblogster.blogspot.com/2009/12/inventory-bom-vs-manufacturing-bom.html
I salvaged this post from the Microsoft Dynamics GP Partner Forum comparing the features in Inventory BOM versus those in Manufacturing BOM. The props go out to Microsoft's Jim Shauer for the detailed explanation.
The core Bill of Materials module works closely with the Inventory subledger. You can define bills and assemble the bills in this module. This module works best for companies with a very simple assembly/production process where the finished good production is normally recorded after the fact.
The Manufacturing BOM module stores the definition of the BOMs. It does require the use of the Inventory subledger and you must use this module together with Manufacturing Order Processing. This Order Processing module is used to record the production of the finished goods. The Manufacturing BOM (together with Manufacturing Order Processing) provides more functionality related to the definition of the BOMs and the methods in which those finished goods can be produced. These modules also provide the ability to track labor costs.
Below is a more…
The core Bill of Materials module works closely with the Inventory subledger. You can define bills and assemble the bills in this module. This module works best for companies with a very simple assembly/production process where the finished good production is normally recorded after the fact.
The Manufacturing BOM module stores the definition of the BOMs. It does require the use of the Inventory subledger and you must use this module together with Manufacturing Order Processing. This Order Processing module is used to record the production of the finished goods. The Manufacturing BOM (together with Manufacturing Order Processing) provides more functionality related to the definition of the BOMs and the methods in which those finished goods can be produced. These modules also provide the ability to track labor costs.
Below is a more…
Posted by
Is There a GP BOM Import Tool?
http://www.rosebizinc.com/gpblog/2010/03/is-there-gp-bom-import-tool.html
Microsoft Dynamics GP Manufacturing – Accounting Transactions
http://waqasb.blogspot.com/2009/12/microsoft-dynamics-gp-manufacturing_21.html
In my previous post on Dynamics GP Manufacturing Accounts, I have explained about listing of standard accounts required to setup dynamics GP manufacturing. Extending the same topic here is the details about standard accounting entries generated from Dynamics GP Manufacturing Series.
Background:
The setup option considered for the accounting transactions example consists the followings.
- Machine & Labor Marked Auto Back flush
- Inventory Items Using Average Perpetual
Summary:
There are three Main Transactions from manufacturing
There are three Main Transactions from manufacturing
1. Component Transaction Entry ( Issuance Of Material )
2. MO Receipts ( WIP )
3. MO Receipts ( FG )
And One Additional Transaction
4. MO Closing ( In Case Of Variance )
Details:
Here is the details about the above transaction types with respect to a standard process of MO
Here is the details about the above transaction types with respect to a standard process of MO
Step 1: Bill Of Material Setup
- No Accounting Transaction
Step 2: Manufacturing Order Creation
- No accounting transaction
Step 3: Component Transaction Entry ( Issuance Of Material )
a) Issuance Entry
Account | Debit | …
Posted by
Dynamics GP Manufacturing Integration with GL
http://mohdaoud.blogspot.com/2009/12/dynamics-gp-manufacturing-integration.html
gptip42day - BOM Routing Sequence
http://gp2themax.blogspot.com/2009/12/gptip42day-bom-routing-sequence.html
BOM Maintenance "Record is Locked, View Only?"
http://mohdaoud.blogspot.com/2009/01/bom-maintenance-is-locked-view-only.html
Microsoft Dynamics GP Manufacturing Accounts
http://waqasb.blogspot.com/2009/12/microsoft-dynamics-gp-manufacturing.html
Dynamics GP Manufacturing has series of modules. If you are planning to implement Dynamics GP Manufacturing series you need to add additional accounts in your existing chart of accounts, so here is the detail about these accounts
For Manufacturing you need
All accounts mentioned above will be setup in the following cards/setups
For Manufacturing you need
1) Additional 47 Accounts
2) Five Sets
| No | Type | No Of Accounts | Nature |
| 1 | Applied Accounts | 8 Accounts | Balance Sheet |
| 2 | WIP Accounts | 9 Accounts | Balance Sheet |
| 3 | Inventory Accounts | 9 Accounts | Balance Sheet |
| 4 | Variance Accounts | 9 Accounts | Income Statement |
| 5 | COGS Accounts | 9 Accounts | Income Statement |
3) On Misc Set
| No | Type | No Of Accounts | Nature |
| 1 | Standard Cost Revaluation | 1 Account | Balance Sheet |
| 2 | Floor Stock Expense | 1 Account | Income Statement |
| 3 | Rounding OFF Difference | 1 Account | Income Statement |
1. Inventory Item Card
2. Machine Card
3. Labor Card
4. Manufacturing Setup
Here is the details for each setup/card1. Inventory Item Card ( Cards >> Inventory >> Item >> Accounts [Item Account & Item Costing Accounts] )
Account Number | Details |
Inventory | Normally required accounts (Item Accounts, Front Window) |
Inventory Offset | |
Cost of Goods Sold | |
Sales | |
Markdowns | |
Sales Returns | |
In Use | |
In Service | |
Damaged | |
Variance | |
Drop Ship Items | |
Purchase Price Variance | |
Unrealized Purchase Price Var. | |
Inventory Returns | |
Assembly Variance | |
Standard Cost… | |
Posted by
Item Manufacturing Accounts
http://mohdaoud.blogspot.com/2009/12/item-manufacturing-accounts.html
Microsoft Dynamics GP Manufacturing Costing Implementation for Chemicals Manufacturing In 3 Days!!!
http://mohdaoud.blogspot.com/2009/11/microsoft-dynamics-gp-manufacturing.html
Yes indeed, last week I been in manufacturing implementation with one of my existing clients, they wanted to implement BOM and Manufacturing order processing modules of the GP Manufacturing, they had every thing ready (Bill of materials, Standard Costs, and all other related issues).
Their policies are clear, to use Periodic costing for all material and overheads. First day I did imported the Bill of Materials, virtual routings (as the client is…
Posted by
Microsoft Dynamics GP Manufacturing Checkdata White Paper
http://waqasb.blogspot.com/2009/11/microsoft-dynamics-gp-manufacturing.html
By Product Using Dynamics GP Manufacturing
http://waqasb.blogspot.com/2010/02/by-product-using-dynamics-gp_09.html
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…
Posted by
Microsoft Dynamics GP Manufacturing – Accounting Transactions Part II
In my previous post on Dynamics GP Manufacturing Accounting Transactions, I have explained about standard accounting entries generated from Dynamics GP Manufacturing for Average Perpetual items.
Now I will extend the same exercise by some other setup options
Background/Setups:
The setup option considered for the accounting transactions example consists the followings
There are three Main Transactions from manufacturing
Here is the details about the above transaction types with respect to a standard process of MO
http://waqasb.blogspot.com/2009/12/microsoft-dynamics-gp-manufacturing_27.html
Now I will extend the same exercise by some other setup options
Background/Setups:
The setup option considered for the accounting transactions example consists the followings
1. Machine & Labor Marked Auto Back flush
2. Inventory Items using “Periodic Valuation Method” ( FIFO OR LIFO )
- Standard costing ( Periodic Valuation) values inventory at a cost based on the standard cost assigned to an item, plus eight other factors:
- Inventory – Material Fixed Over Head ( FOH )
- Inventory – Material Variable Over Head ( VOH )
- Labor Cost
- Labor Fixed Over Head ( FOH )
- Labor Variable Over Head ( VOH )
- Machine Cost
- Machine Fixed Over Head (FOH )
- Machine Variable Over Head( VOH )
Summary:There are three Main Transactions from manufacturing
1. Component Transaction Entry ( Issuance Of Material )
2. MO Receipts ( WIP )
3. MO Receipts ( FG )
And One Additional Transaction4. MO Closing ( In Case Of Variance )
Details:Here is the details about the above transaction types with respect to a standard process of MO
Step 1: Bill Of Material Setup
a. No Accounting Transaction
Step 2: Manufacturing Order Creation
b. No accounting transaction
Step 3: Component Transaction Entry ( Issuance Of Material )
a) Issuance Entry
Account | Debit | Credit |
Inventory | -- | |
Inventory- Material FOH | -- | |
Inventory- Material VOH | -- | |
WIP- Material | -- | |
WIP- Material - FOH | -- | |
WIP- Material - VOH | -- |
b) Reverse Issuance
Account | Debit | Credit |
Inventory | -- | |
Inventory- Material FOH | -- | |
Inventory- Material VOH | -- | |
WIP- Material | -- | |
WIP- Material - FOH | -- | |
WIP- Material - VOH | -- |
Step 3: MO Receipt
a) WIP For Machine & Labor
Account | Debit | Credit |
WIP-… |
Posted by
Feature of the Day: Manufacturing Single Item
http://blogs.msdn.com/gp/archive/2010/02/22/feature-of-the-day-manufacturing-single-item.aspx
Manufacturing Single Item
Module: Inventory
Why this feature is cool!
- Costs for an item can be rolled to only the item at a single…
Posted by
GPTip42day - MO Schedule Preferences
http://gp2themax.blogspot.com/2010/06/gptip42day-mo-schedule-preferences.html
I'm going to have to change the name of my tip to 'GPTip4themonth' if I don't get back on the ball here with the tip frequency.
This tip is for all my manufacturing friends out there. Having spent 20-some years in the manufacturing world, I thought I might be giving short shrift to my roots by seldom providing a tip on using GP Manufacturing,…
Posted by
gptip42day - Unable to Perform Cost Rollup
Here's a good one for you, gang. If you're using GP Manufacturing and you ever restore one database over another - for example, if you're setting up a new company, run these scripts on the new company -
http://gp2themax.blogspot.com/2009/10/gptip42day-unable-to-perform-cost.html
Here's a good one for you, gang. If you're using GP Manufacturing and you ever restore one database over another - for example, if you're setting up a new company, run these scripts on the new company -
Select * from COSS0401
Select * from MOPS0100
COSS0401 is the Costing Setup Table. MOPS0100 is the Manufacturing Order Preferences table.…
Posted by
GPTip42day - Where do I enter Manufacturing Registration Keys?
Typically, upon installation of Manufacturing, the Manufacturing Series Registration window opens upon first login to GP. However, if you don't choose to…
http://gp2themax.blogspot.com/2010/03/gptip42day-where-do-i-enter.html
Typically, upon installation of Manufacturing, the Manufacturing Series Registration window opens upon first login to GP. However, if you don't choose to…
Posted by
Dynamics GP Manufacturing Bill Of Material( BOM ) Setup Guidelines
http://waqasb.blogspot.com/2009/12/dynamics-gp-manufacturing-bill-of.html
Just recently one of my friend had query regarding the manufacturing.
” I am trying to add a component to a BOM, but it is not allowing. Is there any perquisites?”
The issue in his case was, The parent item in the BOM was standard cost where as he was trying to add actual cost item as a component, so any one out there planning for Manufacturing implementation just have a look on this guidelines before you finalize the requirements mapping
Remember, not all items…
Posted by
Dynamics GP Manufacturing
http://waqasb.blogspot.com/2009/08/1024x768-normal-0-false-false-false-en.html
Latest links
- The Cloud Easy Offer & The Big Easy Offer 10 End May 31
- Extender 2013 Feature of the Day: Extender Table Changes
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Taking Your Financial Reports to the Next Level with Management Reporter – Statement of Cash Flows (6 of 8)
- Technical Tips for Management Reporter 2012 with Data Mart
- 8 steps to update internal control
- How Maintenance Plans are a Big Plus for SQL Server Administration
- Online Bill Pay + Recurring Invoicing/Payment + Web-Based Order Entry for Microsoft Dynamics® GP | Dynamics Care Services
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.