Recent content by bustercoder

Sorry Robert, don't kill me for all the posts. I found out that all that's needed is the User Class level, so what I need to do is programatically in SQL, be able to display the user classes from the SY40400 that aren't a match to the user classes in the SY40300 for a particular resid or resids...

Thanks Robert. Now, please excuse me while my head explodes. Buster

Hello, Using a security trace tool and the GP resource (Window display and technical names), I have a main GP Window Description table with the Series, Product, window_display_name, window_technical_name, RESID and USRCLASS. I use this with an outer left join on the RESID to the...

Hi Robert, The problem was that the acctamnt and oractamt were not having their totals updated with the freight amount. Thanks, Buster

Hello, My automated process pulls shipment information and updates Great Plains. Via a trigger on my custom import table, the order is updated with the Freight Amount: if exists(SELECT 1 FROM [dbo].[TBZ_Shipments_Import] INNER JOIN [dbo].[SOP10100] ON...

Robert, I thought it might be a scope issue. Funny, I tried doing this: Public Dim bProgControl as boolean But obviously that doesn't work. You're awesome, thank you SOOO much! Wish I could help you out with something sometime. Buster

Sorry guys. Now i'm getting Method or Data member not found on this (bProgControl): Private Sub Window_BeforeOpen(OpenVisible As Boolean) OpenVisible = (SalesTransactionEntry.bProgControl <> True) 'this will prevent the user from seeing the flashing window End Sub

This is great Robert, thanks. By 'clear the boolean variable', does that mean to set it to false? Buster

Hi Rob and David, After my last vacation in Europe I was on a tour with a great couple from Brisbane and another couple from (I think it was Hamilton) New Zealand (funny how the Aussies called them "Kiwis"). Anyway, after hearing all about Austrailia and New Zealand it is one of the top goals...

Hey Robert! Ok, I got it working. had to change this: CustomerZoom.Value = 1 ' press the button to open Sales Customer Detail to: SalesTransactionEntry.ExpansionButton4.Value = 1 ' press the button to open Sales Customer Detail but it's working. Funny how when I insert a record via...

Thanks Robert. you know, I realized after I replied to your last response that the update trigger on the SOP10106 should be updating this. I can see the payment terms in the order record in the SOP10100 table: CREATE trigger dbo.trSOP10106_UpdateUDF on SOP10106 FOR INSERT, UPDATE AS begin...

Hey Robert! Almost there. It works, except the only thing left is for me to grab the Payment Terms from the Sales Customer Detail Entry window and assign that value to the SalesUserDefinedFieldsEntr.UserDefinedTable1.Value. I added that window and the appropriate fields but the...

Thanks Robert! I'll give it a try and let you know. Much obliged. Buster

Hello, I've been trying to handle this on the back end (see post "Duplicate Key Error in SOP10106"). Because I need to always have an initial insert, a VBA solution seems to be what's needed. Basically, I just need to to have the User Defined window open and have a default (static) value...

Robert, Actually, I've tried what you're suggesting with the INSTEAD OF trigger with exists and not exists. It seems that I might hve to go the way of the VBA. A couple other folks I've spoken with have said this might be the only solution, seeing as how an itial insert is required in all...