IMLSMST_SQL and IMLSTRX_SQL

[DBergkamp10]

Anyone know off-hand what the nature of these two tables relationship is? When you report production, which gets updated first?

I noticed that when production is reported in POP that the pop-up is in fact an IM form - it gives you the opportunity to enter the MFG Ser Lot code there. Doesn't look like this form is readily modified through Flexibility at all.

Any insight would be appreciated. It does not look like other tables are being hit during this process.

Thx

Ivan

 

[dgillz]

IMLSMST is the lot/serial master, and by definition must be created first before a lot/serial transaction can be recorded (IMLSTRX).

In Progression, nearly all popup forms are modifiable with Flexibility. Open up the POP screen and click the Flexibility icon to open VBA. Then enter a transaction. When you get to the LS screen, hold down the shift key and double right click any field. Flexibility for the LS screen will open up in your VBA editor. You can then go write VBA code for whatever event(s) are available on that screen.

In terms of what tables are affected, check out SQL Delta. Great tool. You can take a copy of a database. Perform a transaction, then compare databases. It will show you table by table and field by field what the transaction did in the underlying SQL database. This is invaluable for me when writing Flex or .NET code. Very affordable too, $330 for a single user license.

http://www.sqldelta.com/

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[DBergkamp10]

Hey Don,

Thx for the input. That's awesome. I was starting to get distraught that we wouldn't be able to get at that screen. So if I write code in C# or VB .NET I can add the form to Progression as well, which could be very handy. We've done some nominal stuff in SharePoint but it really isn't what we need. I have a trial of SQL Delta, so I'll try that.

 

[NEmacGuy]

Don,
There is a way in flex to list each table that is updated on the "Save Event". Do you remember this code ?

 

[dgillz]

Ivan,

Yeah VBA is cool but it has its limitations. We write stuff in .NET and call it from VBA if we need more functionality. That said you can create user forms in VBA as well. Maybe you can give me an idea of what you are trying to do?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

I am unaware of the code in Flex to list each table updated. You can look at the DRMs - developer's reference manuals. They are a little dated but pretty good. I would use SQL delta personally.

If you find code like that I'd love to see it.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html