Search results for query: *

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...

Hi Robert, Yes, but the problem is that this trigger assumes a record will always be inserted into the SOP10106 by means of the user actually going into the user defined window and adding a value, which is usually not the case. In this case, I have to make sure there is an insert into the...

Robert, Arrghhh.....when I transfer the order to a back order, then that back order back to an order again, its still giving me that "Violation of PRIMARY KEY constraint 'PKSOP10106'. Cannot insert duplicate key in object 'SOP10106'" error. I don't understand why because the trigger on the...

Thank you so much Geoff!! I really appreciate your help. I didn't know you could pass through params to an embedded subreport. I was able to get what I needed from tweaking the query then applying different groupings, but a subreport is the better way to go for sure. Buster

Thanks Robert! Much obliged. I'll test it out in my dev env. I really appreciate your help. Buster

Hello, I've been researching, and cannot find a way to pass a value from one table as an input parameter into another. So, Table1 has an invoice number, and based on this Table2 would be populated with the items for that invoice. I guess you could call this a cascading parameter, except I would...