Skip to main content

Dynamics GP Inventory BOM/Assembly Transaction Entry

by Frank Hamelly
Senior Consultant, I.B.I.S., Inc.,

For those companies that do light manufacturing or assembly and don’t want or need the complexities inherent with full-blown GP Manufacturing, there is a rather little-known feature that works in conjunction with GP Inventory (currently only available with the Business Ready Licensing Advance Management pricing model) called ‘Inventory Bill of Materials’.  Inventory BOM, along with the Assembly Entry transaction, provides a simple method for converting components into an assembled product.  The Assembly transaction also decrements the components and increments the ‘Finished Good’ and performs the accounting entries, including variances.

The basis for the Assembly Transaction Entry is the Item Bill of Materials (BOM).  The BOM is like a recipe for the product – it specifies what ingredients and how much of each ingredient are necessary to make the product – in this example – a fictitious, lot tracked product called ‘RTU’.   The product could just as well be serial tracked, or have no tracking.

Here’s a picture of the BOM -

Cards>Inventory>Bill of Materials 

Cards>Inventory>Bill of Materials

As you can see, the Bill Number is RTU (considered the ‘Parent’ Item Number) and the Components are:

  1. B5028 with a per unit quantity of 0.0672 Kilo
  2. One Trigger
  3. One FFP-RTU process

The screen above also indicates the Effective Date of the BOM, Standard Cost and other attributes.

...

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Frank Hamelly

Frank Hamelly, Sr. Dynamics Consultant with I.B.I.S., Inc., in Charlotte, NC,  is a business and technology professional with over 25 years experience implementing and supporting various ERP systems and business process re-engineering initiatives across all organizational areas and across various industries, for small, mid-sized, and Fortune 500 companies.  He has held numerous positions in Accounting, Finance, Customer Service and Information Systems.  His application experience includes SAP R/3, Baan, Fourth Shift, Peachtree, MAS 90/200, Quickbooks and Microsoft Dynamics ERP.  His industry experience includes manufacturing, , distribution, telecom, aerospace, life sciences, utilities and media.  Frank studied Business Administration with an Accounting concentration at the University of Pittsburgh.  He is a Microsoft Certified Professional (MCP), Microsoft Certified IT Professional (MCITP), a Microsoft Certified Trainer (MCT), and has been named a Microsoft Most Valuable Professional (MVP) each year since 2008.  He writes articles for Dynamics-related web sites and is a regular speaker at Microsoft Dynamics Convergence, GPUG Summit, MSDynamicsWorld's Decisions Virtual Conference, a trainer and presenter for the Great Plains Users Group (GPUG) and has been a reviewer for various books written by fellow MVPs.  Frank is author of the blog GP2themax with 5,000 visits per month.

More about Frank Hamelly