published September 15, 2008
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
...
Requires FREE Membership to View
Login
Become a Member
Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
Frank Hamelly writes on leveraging the capabilities inherent in GP to maximize organizational efficiency and profitability. As a senior GP consultant at I.B.I.S., Inc, Frank is a Microsoft Certified Business Professional - GP, Microsoft Certified Trainer and Microsoft MVP. Hamelly holds certifications in Financials, Distribution, Report Writer and FRx and has over 10 years experience in Financials, Distribution, Sales Order Processing, Manufacturing, Project Accounting, Field Service and the Payroll and Human Resources series of GP. He also has project management and implementation experience with SAP, Baan, Fourth Shift, and MAS90/200.
Prior to his entry into software consulting, Hamelly held a broad range of accounting and finance positions from cost accountant to CFO in a variety of industries.
A graduate of the University of Pittsburgh with a degree in Business Administration with Accounting concentration, his 20+ years industry experience includes manufacturing, aerospace, telecommunications, utilities, and professional services organizations.
Read full bio...
Assembly entry, item transactions and item quantities
Hello:
Our company uses BOMs/Assembly Entry for light manufacturing. When an assembly is saved as "released," is that recorded as an Item Transaction (Inventory: Inquiry: Item Transaction) even if the assembly is not posted? What if the status is changed from "released" to "not released" and then deleted?
I'm wondering because when I look up individual components in Item Transaction, assemblies are often listed more than once, which I can see because of the way we number the assemblies. I'm also wondering if these duplicate item transactions directly impact the item quantities. If the multiple item transactions aren't caused by the assembly entry process, what else could cause the duplicates?
Thank you,
EMS
Assembly entry, item transactions and item quantities
EMS, could you send me a screenshot of what you're seeing in the system to fhamelly@intellpartners.com? That will help me visualize the issue you're describing. Thanks, Frank
Multiple Sites
I do not see how to assign different sites to different components into an assembly.
Can i do that in Inventory BOM?
"where used" inquiry
I work principally with the BOM/Kit portion of GP. I would like to query the database for where an item is used in BOMs and Kits.
Where used Query
Have a look at BM00101 and BM00111 and design your query based on the relevant fields in these two tables.
Good luck!
Frank E. Hamelly | Dynamics GP MCP, MCITP, MCT, MVP
East Coast Dynamics
4819 Emperor Blvd., Suite 400
Durham, NC 27703
United States of America
919.928.4521 (c)
fhamelly@eastcoast-dynamics.com
Assembly Window
We do light manufacturing and do not have the Manufacturing Module.
When I am in the "Bill and Items" lookup window of the assembly window I see that my view is "Active Bills, by Bill number" when I click the arrow I see "Active Bills" as my only option, everything else is grayed out. Is it possible to activate the other options somewhere in the set up? Is there a book that deals in detail with assembling items in Dynamics GP. I know how to do the basics, but am looking for what creative things others have done when they ran up against brick walls.
Macros to Assembly Entries with and without inventory shortage
I have to use the assembly window in order to registir some items in inventory module, and I want to use a macro to do this task in an automatic way, the problem is that according with the operation of my company sometimes there is not enough raw materiales quantities in stock to do it, in that case we omit the inventory shortage, but we cannot identify when the window with the alert about the message of shortage will be open or not. There is any way to program this event and the way the macro should process this event to continue charging the information?