tag:blogger.com,1999:blog-5285970135510371565.comments2024-03-16T05:10:45.222-04:00The Dynamics GP BlogsterMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger1829125tag:blogger.com,1999:blog-5285970135510371565.post-35597897730556598162022-06-30T22:01:14.374-04:002022-06-30T22:01:14.374-04:00Hi Mariano, i need split sop orders in GP, you can...Hi Mariano, i need split sop orders in GP, you can help me.Erickhttps://www.blogger.com/profile/08265910669282163761noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-27089237688332779452021-12-10T20:08:29.059-05:002021-12-10T20:08:29.059-05:00Hi Mariano,
Can yousend me the xlsx and pbix file...Hi Mariano,<br /><br />Can yousend me the xlsx and pbix files as well?<br />manxiwu42@gmail.com<br /><br />Thanks,<br /><br />MaxMaxhttps://www.blogger.com/profile/06245940530856882635noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-70900050809893688182021-12-10T10:19:02.460-05:002021-12-10T10:19:02.460-05:00Hi Mariano,
Can you send me a copy of the files a...Hi Mariano,<br /><br />Can you send me a copy of the files as well?<br /><br />Thanks,<br /><br />MaxMaxhttps://www.blogger.com/profile/06245940530856882635noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-81487876786194019052021-10-19T13:45:52.685-04:002021-10-19T13:45:52.685-04:00PLM,
Unfortunately, the amount of work it would t...PLM,<br /><br />Unfortunately, the amount of work it would take to do something like this in SQL, it would probably be just faster to print the edit lists. Keep in mind the drop-down list values are not stored in SQL, just the position of the error messages selected.Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-41716124486955507612021-08-13T11:22:16.073-04:002021-08-13T11:22:16.073-04:00Mariano, know this is an old post. Are you aware...Mariano, know this is an old post. Are you aware of a way to run a sql script pull out the actual message for example on the pm10000 table? Instead of having to print an edit list to display an error message like "fiscal period is closed". Want to query the unposted batches to display an error without having to run the edit list. Is that a hexadecimal conversion?<br /><br />Thanks.PLMhttps://www.blogger.com/profile/07482709206537152602noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-61316246588361780352021-08-12T16:30:15.274-04:002021-08-12T16:30:15.274-04:00Las funciones escalares de SQL no se muestran en R...Las funciones escalares de SQL no se muestran en Report Writer, pero puedes usar VBA para invocar la funcion. Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-52005556241831729332021-08-12T16:16:46.695-04:002021-08-12T16:16:46.695-04:00@Romeyn,
The SY01400 table is a part of the syste...@Romeyn,<br /><br />The SY01400 table is a part of the system database, i.e., DYNAMICS. That UPDATE statement should be executed against it.Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-54130870940484495342021-07-30T13:20:13.795-04:002021-07-30T13:20:13.795-04:00Hello,
I was very happy to find such a thorough p...Hello,<br /><br />I was very happy to find such a thorough post. When we attempt your last UPDATE statement we receive an error telling us that the object SY01400 doesn't exist. If that's something specific to your environment, how would I map that to the equivalent in ours?<br /><br />Thanks!Romeynhttps://www.blogger.com/profile/13733454568844928487noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-35737143602430436662021-06-21T05:39:38.049-04:002021-06-21T05:39:38.049-04:00Very informative article. Thank you for sharing.
Very informative article. Thank you for sharing.<br />Microsoft Dynamics 365https://www.erbrains.com/en-ae/microsoft-dynamics-365.htmlnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-35288230715814466132021-05-20T09:53:25.729-04:002021-05-20T09:53:25.729-04:00Nice feature.
But it doesnt work for tables other...Nice feature. <br />But it doesnt work for tables other than master tables.<br />For example I added a GP on premise table GL00100 in Custom migration tables and migration fails for GL00100.<br />I was wondering if you know what might be needed to bring data in for this table.cicihttps://www.blogger.com/profile/02870279856557552338noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-40159174489279685002021-05-20T09:51:35.390-04:002021-05-20T09:51:35.390-04:00Hi Mario
The Cloud migration works fine for maste...Hi Mario<br /><br />The Cloud migration works fine for master data.<br />But there is an action in Cloud Migration Management named "Managed Custom Tables".<br />I added one table GL00100 from GP but the migration reports a key violation when the IR is trying to insert a second record with the pk = 0.<br />Definitely, more stuff to do to make migration work for tables other then master data. I wonder if you know what is needed to bring other tables in BC.cicihttps://www.blogger.com/profile/02870279856557552338noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-33621517260035590832021-03-24T01:40:10.807-04:002021-03-24T01:40:10.807-04:00Hola Mariano, precisamente estoy luchando con esto...Hola Mariano, precisamente estoy luchando con esto. debo agregar un texto almacenado en una tabla extender al reporte de orden de compra. <br />Np logro usar la función que indicas en tu blog. por mi parte yo he creado una función escalar que devuelve cadena de 3 caracteres, tenia la esperanza de poder verla desde el editor de reportes. <br />esta es la función que cree, podrías ayudarme con esto? el ambiente es GP2018<br /><br />CREATE FUNCTION getTipoOC (@OCNumber as varchar(15))<br /> RETURNS VARCHAR(3)<br /> BEGIN<br /> DECLARE @TIPO AS VARCHAR(3)<br /> SELECT @TIPO = RTRIM(C.STRNG132) FROM TSTST.DBO.EXT01100 A INNER JOIN TSTST.DBO.EXT01103 B<br /> ON A.Extender_RECORD_ID = B.Extender_RECORD_ID <br /> INNER JOIN TSTST.DBO.EXT20021 C ON B.TOTAL = C.LNITMSEQ<br /> WHERE A.Extender_WINDOW_ID = 'OP_COMPRAS'<br /> AND C.EXTENDER_LIST_ID = 29<br /> AND A.Extender_key_Values_1 = @OCNumber<br /> RETURN @TIPO<br /> ENDAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-62106475985449540882021-03-11T13:40:02.969-05:002021-03-11T13:40:02.969-05:00Hi Mariano,
would You be so kind to send me also ...Hi Mariano,<br /><br />would You be so kind to send me also the xlsx and pbix files?<br />bidata3@gmail.com<br /><br />Thank You in advance,<br />Dmitrybidatahttps://www.blogger.com/profile/13508534589636039596noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-29973306373020996112021-02-09T04:00:03.624-05:002021-02-09T04:00:03.624-05:00What do the zDP_ Auto Generated Stored Procedures ...What do the zDP_ Auto Generated Stored Procedures do?<br />https://winthropdc.wordpress.com/2008/10/06/what-do-the-zdp_-auto-generated-stored-procedures-do/#:~:text=They%20are%20often%20referred%20to,the%20records%20within%20each%20table.<br /><br />What is Column desSPRkmhBBCreh?<br />https://winthropdc.wordpress.com/2008/10/15/what-is-column-dessprkmhbbcreh/#:~:text=Answer%3A,the%20table%20does%20not%20exist.Hussain Ali Al Yousefhttps://www.blogger.com/profile/07478312179692385240noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-34087328689586850112021-02-01T15:36:09.492-05:002021-02-01T15:36:09.492-05:00Very cool and thank you very muchVery cool and thank you very muchAnonymoushttps://www.blogger.com/profile/09989728255288544939noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-49334974821239141162021-02-01T15:35:40.128-05:002021-02-01T15:35:40.128-05:00Very cool and thank you very muchVery cool and thank you very muchAnonymoushttps://www.blogger.com/profile/09989728255288544939noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-33217044278126236372021-01-25T04:28:04.560-05:002021-01-25T04:28:04.560-05:00This was very helpful.This was <b>very</b> helpful.Jim Fieserhttps://www.blogger.com/profile/12763244452762960211noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-6528884177821024002020-12-03T03:31:37.955-05:002020-12-03T03:31:37.955-05:00You should add ItemNumber in the screen to VBA
Op...You should add ItemNumber in the screen to VBA<br /><br />Open Item Inquiry window, Then go for Tools -> Customize -> Add Fields to Visual Basic, then press into the field : Item number - which is the textbox where you write the item on Itme Inquiry window.Hussain Ali Al Yousefhttps://www.blogger.com/profile/07478312179692385240noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-59835791868752069112020-10-30T15:02:05.755-04:002020-10-30T15:02:05.755-04:00HI Mariano,
This is quite an old post, but the bit...HI Mariano,<br />This is quite an old post, but the bit question that remains to me with the Word Templates, is how can you control and limit the size of the default logo witout pasting a "permanent" logo onto each template ? The benefits of the Word Templates vs. GP Reports is to not have to hard-code the logo on the template and remain flexible.. however, depending on the size of the original source file (JPG or PNG), the report can get a complete different layout when it is printed out.. Beat BUCHERhttps://www.blogger.com/profile/07394259942485626115noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-5494621127843724502020-10-28T11:11:51.146-04:002020-10-28T11:11:51.146-04:00Hi, I have the same query as 'Anonymous' f...Hi, I have the same query as 'Anonymous' for adding a T&C by itself on the last page but on Word Templates for POP Blank Form. Mystiquehttps://www.blogger.com/profile/10864995546344996410noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-51978334842044789332020-09-30T17:45:32.219-04:002020-09-30T17:45:32.219-04:00Mariano,
Thank you for this method and thank you ...Mariano,<br /><br />Thank you for this method and thank you to the others who've commented that pointed out the @@ERROR anomaly.<br /><br />Works like a champ.<br /><br />Regards,<br /><br />Steve Erbach<br />Green Bay, WI<br />Steve Erbachhttps://www.blogger.com/profile/05065643506800242801noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-66318595507777930342020-09-30T14:47:35.718-04:002020-09-30T14:47:35.718-04:00Mariano
I have created templates based on NEW rep...Mariano<br /><br />I have created templates based on NEW reports (not modified GP reports). If I import them manually using template maint, no problem. If I use the dex commands, I get the error you describe above when I try to run them.<br /><br />Any thoughts?<br /><br />Thanks<br />SteveStevenoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-46402489229292801532020-09-28T04:19:47.048-04:002020-09-28T04:19:47.048-04:00niceniceVishal Sharmahttps://www.blogger.com/profile/08861709834808119636noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-66127994309875203202020-09-26T17:15:38.976-04:002020-09-26T17:15:38.976-04:00Would it be possible to create a GP 2016 Developme...Would it be possible to create a GP 2016 Development environment with Docker?ZinZinhttps://www.blogger.com/profile/04204016482371278799noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-15010865966455041742020-09-17T12:09:04.485-04:002020-09-17T12:09:04.485-04:00Thank you Almas! Appreciate the kind words.Thank you Almas! Appreciate the kind words.Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.com