tag:blogger.com,1999:blog-5285970135510371565.post444464225762338124..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: How to search for a text within a SQL Server trigger, stored procedure, or UDFMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5285970135510371565.post-84602404418126321262010-11-24T11:54:05.150-05:002010-11-24T11:54:05.150-05:00Thanks Mariano!
Well said. Surely running it firs...Thanks Mariano!<br /><br />Well said. Surely running it first on test is always best.<br /><br />Thank you for your suggestion.<br /><br />--JennyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-89905743123456088302010-11-24T11:40:04.815-05:002010-11-24T11:40:04.815-05:00Jenny,
I see no issues with what you are doing, ho...Jenny,<br />I see no issues with what you are doing, however, and like with all suggestions, make sure you test in a test environment first, evaluate the results, then run against your production environment.<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-79207417085822636672010-11-24T11:40:04.396-05:002010-11-24T11:40:04.396-05:00Jenny,
I see no issues with what you are doing, ho...Jenny,<br />I see no issues with what you are doing, however, and like with all suggestions, make sure you test in a test environment first, evaluate the results, then run against your production environment.<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-17486764595786370442010-11-24T10:58:59.826-05:002010-11-24T10:58:59.826-05:00hello, i came upon this thread and have a similar ...hello, i came upon this thread and have a similar question. i hope u can assist me.<br /><br />our company wanted to delete customers/vendors/items in GP however we<br />realized that we cannot delete them as there is history against these<br />records.<br /><br />We decided to create a temp/dummy record for each (i.e. dummy<br />customer, vendor, item) and combine those records per module we wanted<br />to initially deleted into these dummy records using the combiner<br />tools. Has anyone done this before and is there any issues with doing<br />it this way?<br /><br />as with Item combiner, yes i found also that some conditions are required before items can be combined. Any ideas if this whole approach is fine?<br /><br />--JennyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-52741723942414643052010-11-24T08:00:56.670-05:002010-11-24T08:00:56.670-05:00Hi,
Unfortunately, I don't have a list, but yo...Hi,<br />Unfortunately, I don't have a list, but you may want to open a support case to get this list of things.<br /><br />However, it would sound from what you have found so far, that anything setting that is in contraposition with another setting would prevent the item combiner from doing its job.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-52944170204527405142010-11-23T11:32:42.707-05:002010-11-23T11:32:42.707-05:00hi there,
do u happen to have any information wha...hi there,<br /><br />do u happen to have any information what are the restrictions/validations needed to be met when combining items using the item combiner tool? it does not seem to be documented anywhere. so far i know you cannot combine items with different item types, quantity decimal places, unit of measure or if one item is tracking serial/lot and the other is not.<br /><br />would appreciate any info.<br /><br />Thanks!Anonymousnoreply@blogger.com