Hi there. New user with MiniMrP on sql server. Trying to run report with list of Assemblies with the rows that are in the "Indented Parts List/BOM". I see some items are in the tblallocdetail table, but not all POStockID's? I'd love to see a database table diagram, but if not could you please let me know the related tables to query for this info.
Thank you. So glad there is a forum!
Posted on: Aug 28 2023 at 06:38:44 AM
I want to begin by saying that anyone else reading this - you do not need to know this stuff to use MiniMRP. It's just because the original poster wants to go rooting around in the database outside of the MiniMRP program.
tblAllocDetail only contains ItemID's of items that are currently in allocated work orders
tblstockitems contains the part numbers. Each Part has an 'ItemID'. Find the ItemID of the top level assembly.
Then look in tblusedin. This table has a column 'ParentID'. Filter the assembly's ItemID in that column. The children directly below the parent will be shown in the ChildID column. Some of these child parts may be sub assemblies. Repeat the above for each sub assembly.
Posted on: Aug 30 2023 at 06:30:58 PM
Thank you! Big help, all good.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.