Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Trying to modify an invoice form in MAS 90 Standar

  • 1.  Trying to modify an invoice form in MAS 90 Standar

    Posted 08-04-2014 15:39
    Trying to modify an invoice form in MAS 90 Standard version 4.50.4.0 using Crystal Reports vs 11.5.8.826 on a Windows 2008 R2 (64 bit) server. The Comment Text value brought into the Invoice_Wrk table from the AR_InvoiceDetail table is truncating the text string to the first 49 characters. The entry screen allows for the entry of up-to 2,048 characters. Why isn't the data included in the output? In the AR_InvoiceDetail table, the data type is text (2048). Same for the AR_InvoiceWrk. When I look at the Field Type in Crystal, it reports ""Memo"", not string(2048). Thoughts on how I rescue my missing text from the Crystal Reports monster?


  • 2.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-04-2014 15:41
    Right click, choose Format field and make sure the Can Grow is checked on the first tab. Also make sure Print Comments FULL Is selected when you print.


  • 3.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-04-2014 20:27
    Beth Bowers, I checked the can grow property several times. That was my first guess. However, I am sitting here with egg on my face guessing that the Print Comments setting is not set properly. How many times to I have to say ""Doh!


  • 4.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 05:25
    @ShawnSlavin - after I made my post, I KNEW that is what it was because I'd done it before.


  • 5.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 05:34
    I believe that fix is on the list for 2015 or 2016. Send a note to Diane.coffman@sage.com to encourage her to put it in an upcoming release...... I can't keep track of the amount of time spent chasing my tail on this one. I think @JohnBroadfoot posted the DFDM tweak a while back, but there should be a better way...


  • 6.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 05:52
    Not sure we're talking about the same thing - this isn't actually a file issue, it's just that the Print option wasn't selected correctly when printing. What fix are you talking about? Or are we talking about making the default Full instead of Partial (which is SUCH a stupid default)?


  • 7.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 06:38
    I am talking about the default Partial, Full, none STUPID OPTION. Someone (I believe John) posted the location of the flag to change via DFDM.....


  • 8.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 07:55
    @JeffSchwenk, I don't believe that post was from me, at least I couldn't find it (nothing new). FWIW, it is our habit to always make a named formcode/report setting to use in place of STANDARD so the options hold. I believe the options are buried in the OptionsString field of the SY_ReportOption.M4T file, but I have never had to go there. That string is probably different for every ReportID in the system.


  • 9.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 08:11
    @JohnBroadfoot - I hate getting old........


  • 10.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 08:20
    John B is correct. It was actually @GeneUlrich who posted the original one. https://90minds-com.socialcast.com/messages/14096712


  • 11.  RE: Trying to modify an invoice form in MAS 90 Standar

    Posted 08-05-2014 10:46
    The only thing I can really take credit for is remembering one of Alnoors posts from August of 2009 where he shared the steps to set the flag to ""full"", as well as some history regarding the internal thought process (or lack thereof) at Sage when the default was established.


Related Content