Dynamics GP Inventory BOM/Assembly Transaction Entry

September 14 2008

About Frank user181768

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 user181768

Comments

ems2011's picture
On April 12th, 2011 E user144249 said:

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
sledg77's picture
On April 15th, 2011 Frank user121129 said:

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
Joaquin's picture
On July 6th, 2011 Joaquin user145333 said:

I do not see how to assign different sites to different components into an assembly. Can i do that in Inventory BOM?
aldntn's picture
On October 24th, 2011 Andy user146835 said:

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.
sledg77's picture
On October 28th, 2011 Frank user121129 said:

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
Jeanne's picture
On November 2nd, 2011 Jeanne user147036 said:

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.
pqomm's picture
On July 3rd, 2012 Rommy user152020 said:

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?
wigma's picture
On October 6th, 2014 Walter user166744 said:

i need information with GP Version 10. Product assigned in sales transaction. thanks.
jon Ball's picture
On January 15th, 2019 jon user190102 said:

I use GP as per above and i am having a problem finding information
We set up 2 stage assembly's for multiple locations in GP in advance and have them set as "not released", then a month or so later when ever we need to begin processing it we use that original document number and set for "released" to process and push as per normal.
More often than not we have to use a new document number due to partial batches, which leaves the old document number open.
I need to find a way to smart list search for " NOT RELEASED STATUS w/ document numbers" so i can find them and close them out.

Related Articles

Related Solutions