tag:blogger.com,1999:blog-5285970135510371565.post4127786222791010218..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: Adding more comment lines to POP Purchase OrdersMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-5285970135510371565.post-55603772070458990232018-06-06T15:49:36.341-04:002018-06-06T15:49:36.341-04:00Maria,
I must first direct you to the Report Write...Maria,<br />I must first direct you to the Report Writer manual, Chapter 7: Creating Calculated Fields for more information as I cannot possibly provide all the steps here.<br /><br />Also, I am not sure what you mean by "increasing he character count". Report Writer is limited to 80 characters for string and string calculated fields.<br /><br />I believe your "Suppress when field is empty" will depend on the calculated field first. Please read the chapter on creating calculated fields and if you have further questions I will be happy to assist.<br />Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-33858181833484831072018-06-05T16:23:42.739-04:002018-06-05T16:23:42.739-04:00Mariano,
I forgot to mention that I'm using G...Mariano,<br /><br />I forgot to mention that I'm using GP2016R2. <br />I have a third question, I'm assuming that I need to check the checkbox, "suppress when field is empty" But when I do so, I'm prompted to select a calculated field. And there's where I nee d your assistance to create a calculated field. Anonymoushttps://www.blogger.com/profile/00011362681342014223noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-83321649507077416122018-06-05T16:16:38.247-04:002018-06-05T16:16:38.247-04:00Mariano,
This article has been extremely helpful....Mariano,<br /><br />This article has been extremely helpful. I'm trying to increase the character count in the Purchasing Line Comments. I'm a newbie to Report Writer. Your "How to" Link sends me to SOP which is not relevant for me. So I've a few questions as follows:<br /><br />1) Am I supposed to be using the Report Table: Purchasing Comment?<br />2) How do I create a calculated field? <br />3) Do I click New in the Header or the Footer of the Report Section Options WindowAnonymoushttps://www.blogger.com/profile/00011362681342014223noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-51708890889934813882018-01-24T14:20:35.349-05:002018-01-24T14:20:35.349-05:00David,
Thanks for the kind words. Unfortunately, ...David,<br /><br />Thanks for the kind words. Unfortunately, these fields are only Report Writer calculated fields and are not stored in a table. Technically (and literally) speaking, the fields are stored in the Reports.dic dictionary file, but not the data. In SSRS, you supposed to be able to pull the actual comment field and set the field property to word wrap. <br /><br />Here's a good example on how to do that:<br /><br />http://www.sqlrelease.com/text-wrapping-in-ssrs-reports-in-reportviewer-controlMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-48165954138068540542018-01-08T17:23:51.181-05:002018-01-08T17:23:51.181-05:00Hello Mariano,
This is a great post. Both you and...Hello Mariano,<br />This is a great post. Both you and David have thoroughly covered this topic. I have already been able to deploy this at several customers and internally as well to help with the invoicing.<br /> I am currently working on a Project and we are creating an SSRS report that we would like to be able to pull these extra Calculated fields onto. I am trying to find where SQL stores these newly created Calculated fields from Report Writer. I have been able to find the big Text field CMMTTEXT in the SY04200 and the SOP10202 tables and am wondering IF SQL actaully stores these new fields in separate fields within a table.<br /> Do you have any suggestions on where I may find these or grab them to appear on an SSRS report?<br /><br />Thank you for your time.<br />David Sirois Anonymoushttps://www.blogger.com/profile/16807790540580980722noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-12221227013656748932017-10-16T15:20:10.855-04:002017-10-16T15:20:10.855-04:00Has anyone been able to get this to work with the ...Has anyone been able to get this to work with the Word Templates? I am only getting line 1, 3, 5 and 7 displaying in the template.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-20223699152204432542017-07-06T17:15:55.975-04:002017-07-06T17:15:55.975-04:00Awesome. Could I have hacked it on my own from th...Awesome. Could I have hacked it on my own from the SOP example? Yes. Did I have an extra 3 days to mess with it? No.<br />Thanks!CSMEUTAHhttps://www.blogger.com/profile/07136813705542781706noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-69539522827156959812016-02-15T12:29:53.843-05:002016-02-15T12:29:53.843-05:00I'm trying to fix truncated comments in a Word...I'm trying to fix truncated comments in a Word template Purchase Order. This is the kind of article that makes me dread each and every time I'm asked to make a change to the GP reports/templates.<br /><br />Never mind that I can't make any changes while the system is in use for fear of corrupting the reports database, even minor changes require incredibly arcane tomfoolery such as described in this page. A fine article with very useful information, don't get me wrong, but yikes, what a nightmare of a system.<br /><br />Every time I do something with GP it's like I'm transported back to 1998. I still can't believe this is a real product.Paulnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-88306679686584279502015-12-28T01:34:27.147-05:002015-12-28T01:34:27.147-05:00hi
if i am typing 4 lines in the comment id .its ...hi<br /><br />if i am typing 4 lines in the comment id .its takes first two line (3 rd and 4 th lines are not displaying).when we type 5 line in the comment id .all the lines are displaying .any one come across this . pls help.arunnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-72220227809856974642015-11-13T16:58:40.556-05:002015-11-13T16:58:40.556-05:00Hi Mariano,
How does this set up translate over in...Hi Mariano,<br />How does this set up translate over into a Word Template? I've tried it but what happens is, for example, when there are 8 comment lines only Line 1, 3, 5 and 7 display on the Word Template. Any thoughts?<br /><br />Alex Smyth<br />FMT Consultants, LLCAnonymoushttps://www.blogger.com/profile/09088296356754275171noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-87927672311741171512015-11-13T13:44:13.575-05:002015-11-13T13:44:13.575-05:00This worked great for us until we attempted to mov...This worked great for us until we attempted to move the PO to a template. Now we are getting all kinds of extra white space that we have been unable to resolve. Does anyone have any hints for getting rid of the extra white space while leaving the extra line comments in the template??<br />Anonymoushttps://www.blogger.com/profile/17207368913764715787noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-38774205095795490242015-08-24T11:16:16.839-04:002015-08-24T11:16:16.839-04:00This worked great for us in 2013. I also had the ...This worked great for us in 2013. I also had the same problem with drop ship POs, but changed POP_PO.PO Type to 1 and that solved our issue.Kelli Uphaushttps://www.blogger.com/profile/15460149288525353448noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-86448250965750859022015-03-30T09:35:00.054-04:002015-03-30T09:35:00.054-04:00Mariano,
Thanks for posting this, it helped me so...Mariano,<br /><br />Thanks for posting this, it helped me solve an issue for a client that required a larger comment area per line.<br /><br />ScottAnonymoushttps://www.blogger.com/profile/08586596839169946707noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-2497118920031700302014-12-12T10:19:43.744-05:002014-12-12T10:19:43.744-05:00I'm pretty confident it does.
MG.-I'm pretty confident it does.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-68369631535679892072014-12-11T13:33:11.966-05:002014-12-11T13:33:11.966-05:00Does this work for GP 2013, thxDoes this work for GP 2013, thxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-17287853161397646602014-01-08T14:51:25.062-05:002014-01-08T14:51:25.062-05:00Awesome. Thanks a bunchAwesome. Thanks a bunchAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-72848956210194169082012-11-30T14:52:00.986-05:002012-11-30T14:52:00.986-05:00I was looking for the same info about virtually id...I was looking for the same info about virtually identical & finally i got my answer from your post thanks for sharing this useful info.!<br /><a href="http://jdinflatables.com/%20/%20/" rel="nofollow">point of purchase displays</a>jdinflatableshttp://www.jdinflatables.com/Inflatable_and_Fur_Costumes/noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-41146450908878689052012-06-19T19:41:18.119-04:002012-06-19T19:41:18.119-04:00Mariano:
Great Article - One question. I was doi...Mariano:<br /><br />Great Article - One question. I was doing some testing on this and using both "Standard" and "Drop-Ship" type PO Documents and this was only working for "Standard" types. After digging into the data I realized that the DOCTYPE field in the POP10550 table was not matching the DOCTPYE field in the POP10110 table. The POP10550 always had a DOCTYPE of "1". I edited the various Line Comment calculation fields and hard-coded the "POP_PO.PO Type" to an integer of 1 and that made it work for both Standard and Drop-Ship type documents. Anyone else see this happening?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-60234187220627486082012-05-17T16:10:25.252-04:002012-05-17T16:10:25.252-04:00@Ian:
Much thanks for the kind words. If you clic...@Ian:<br /><br />Much thanks for the kind words. If you click on the image you will get 404. If you click on the caption under the image, it will allow you to download the file... go figure.<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-7512055737188912932012-05-17T06:26:10.421-04:002012-05-17T06:26:10.421-04:00Great Article.
I have added a link from my SOP Do...Great Article.<br /><br />I have added a link from my SOP Document post to this one.<br /><br /><a href="http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/02/02/adding-more-comments-to-sop-documents.aspx" rel="nofollow">http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/02/02/adding-more-comments-to-sop-documents.aspx</a><br /><br />David<br /><a href="http://blogs.msdn.com/DevelopingForDynamicsGP/" rel="nofollow">http://blogs.msdn.com/DevelopingForDynamicsGP/</a>David Musgravehttps://www.blogger.com/profile/15001247843646031525noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-18650495115496237632012-05-17T06:24:49.675-04:002012-05-17T06:24:49.675-04:00Great Article.
I have added a link to my SOP post...Great Article.<br /><br />I have added a link to my SOP post to this post.<br /><br /><a href="http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/02/02/adding-more-comments-to-sop-documents.aspx" rel="nofollow">http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/02/02/adding-more-comments-to-sop-documents.aspx</a><br /><br />David<br /><a href="http://blogs.msdn.com/DevelopingForDynamicsGP/" rel="nofollow">http://blogs.msdn.com/DevelopingForDynamicsGP/</a>David Musgravehttps://www.blogger.com/profile/15001247843646031525noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-6888829483454288372012-05-17T02:12:26.539-04:002012-05-17T02:12:26.539-04:00Hi Mariano,
Great article. I've always looked...Hi Mariano,<br /><br />Great article. I've always looked to VBA for this sort of thing but it's nice to get a guide on how to do it with Report Writer functions.<br /><br />One thing; your download link 404s.<br /><br />IanIan Grievehttp://www.azurecurve.co.uknoreply@blogger.com