Hey Steve!

 I know that this is the eConnect forum but I thought you'd be interested in this particular challenge.

 My client had a need for an inventory importing tool (using SerialNums).  I used a combination of SSIS, .Net (wrapper) and eConnect.  It works great.  Well, now they want me to extend the tool to include assembly transactions.  Well, after I told them "sure", I found out that eConnect doesn't do Assembly Transactions!  So, I'm trying to build a SQL script to automate it myself.

After using SQL Trace to see what happens during an assembly transaction insert, I've extracted over 700 lines of t-SQL.  (Dexterity does some pretty weird stuff...)  Have you had any experience with automating assembly transactions?  I'm hoping to boil the trx down to a handful of table inserts and/or updates.

 Let me know.  Thanks!

Joe Cogan
joecogan@adelphia.net

Sorry, Joe, I'm not even sure what an Assembly Transaction is... I Googled it <smiles>, I came up with the IV Tables page in this fourm. What a hoot. Soulds like something that has to do with BOM?

Yes, it is a part of Dynamics GP's Bill Of Materials module.  An assembly transaction reports the act of "building a subassembly" (from BOM) in production.  It's used in manufacturing to prepare subs before actually selling them.

 Well, I got a little farther last night on the SQL trace and I'm building the t-SQL script now.  Maybe I'll forward along the information to you for your blog (if it works of course)!

Talk to you soon!