General Consultant Discussion

Since a few people have asked, here are the slides/queries I showed during the SQL presentation that @JohnnyPabian and I performed at @MeetingoftheMinds. Hope everyone enjoyed it as much as we did!

You guys did really good! I enjoyed it very much. Thanks for sharing these.

Thank you Steve. I enjoyed the class.

Thanks for sharing Steve and Johnny. Very helpful.

One of my favorite sessions at MoTM! Thanks for sharing this stuff.

Steve, thanks for sharing. Unfortunately, I missed your session. I looked through the Powerpoint and found the Scheduled BOM which caught my attention. Could you please elaborate on the solution? Is there a spec sheet? I have a client who could benefit from it. I assume this only works for make to stock environments? Email or call if easier. ahagenbach@mbsg.net 805-285-2640 Thanks again!

Thanks @SteveIwanowski and @JohnnyPabian for taking the time to attend and share your knowledge. This is the second year in a row that scheduling conflicts have prevented me from attending the technical class that Johnny has presented. It will NOT happen again!

@Stevelwanoski, I enjoyed your presentation very much. This kind of stuff is hard to put down in writing and the interactive presentation in Management Studio was what I didn't know I was waiting for.

@SteveIwanowski, this is good stuff. I really appreciate you sharing it since I was unable to attend the session. I have used SQL Server extensively for several years, but I still learned more. Excellent!

Thank you so much!

SBOM is an ACS solution I had them create in the last few years. It was to immediately fill the void for premium users because JobOps(at the time) and WO were not SQL compatible. It can be used for Make for stock, or make to order. I have a client that has no BOM and every SBOM is completely custom for the order. It can prompt in sales order entry asking you if you want to make it - like PO prompts at the end if you want to purchase it. It does work with ACS Multi-bin. I have more clients on non-sql using it because it is so simple to use. So it is just like a BOM Production entry but with much more capabilities. ACS has built routines to create many SBOMs based off inventory levels. So in 5 min 200 SBOMs could be made and handed off to MFG. We track the change of status and each time the SBOM is printed and who. Another cool feature I believe that we have in there is dealing with BOM Options - so if you chose to paint red. We pass that red option to the inventory module so you can see what colors are in stock. It does not track labor or outside processing at this point - many have expressed interest in this. The status update I did was just using SQL to write to the database directly and using a USB scanner to update the status. Through custom office you can create some UDFs to simulate work centers and operations and additional instructions. @AndrewHagenbach