Sage 100

 View Only
Expand all | Collapse all

Client upgraded to 4.5 without warning and now I h

Deb Thomas

Deb Thomas01-09-2013 18:31

Therese Logeais

Therese Logeais01-09-2013 19:16

Therese Logeais

Therese Logeais01-09-2013 19:39

  • 1.  Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 17:43
      |   view attached
    Client upgraded to 4.5 without warning and now I have to reinvent some of their Crystal reports. I have one that should be a no brainer, but it locks up with each attempt to run it. Anybody have any idea why? Have attached it for your viewing pleasure.

    Attachment(s)



  • 2.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 17:49
    Click on Report/Selection Formula/Record. First line says ItemType = 4 - need to change it to 1. Type 4 is now comments. If they don't use comments it shouldn't lock up, but it also won't find anything.


  • 3.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 17:51
    I had it at ""1"" when I started, but then looked at their old report and it noted ""4"". Will give that a try and see if things progress. Not sure if that's enough to lock it up. Do you see any issues with the parameters? And thanks Beth for taking a look!


  • 4.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 17:59
    No - and it did print for me (in ABC company) once I changed it to ""1"".


  • 5.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:01
    This may be of some help as well: Problem / Description: Is there a tool to show what fields may have been added to a customer's forms prior to upgrading their system? This would allow for easier upgrading of modified forms. Resolution: To access the help file and the Crystal Form Comparison Report, perform the following: Install the Version 4.10 Program Fix Collection. (Only if on v4.10 - all other versions should have this utility already) Browse to ..\MAS90\Help, and double-click CRUtility.chm. From the MAS 90 and 200 File menu, click Run. Enter SYWFCU. NOTE: Unsure if this has been updated past v4.10 as the help files show info specific to 4.10 but no later versions. Use Crystal Form Comparison Utility to generate a report that lists table/column name additions and deletions from the Sage 100 ERP forms. This report prints the form name, folder, report file name, form code, and any fields (including user defined fields) that were added or removed from the standard forms shipped with the software. Use this report as a reference to modify the default Crystal Forms. Only identifies table/column additions and deletions - does NOT identify; - Field position change - Field property change (ex - font size) - Picture objects (ex - logos) - Format changes (ex - lines or boxes)


  • 6.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:01
    I've only put a date into the selection criteria and it's still thinking, been thinking for about 10 minutes now.


  • 7.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:03
    Also tested with item type = 4 or item type = 1 and it ran, in case you need the comment lines.


  • 8.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:12
    Deb, that is one weeny of a program. The linkage is fine, the parameters are fine... the only issue is if they have absolutely humongous AR Invoice History files. You could try File/Report Options and uncheck Use Indexes or Server for Speed. At least that way if you have it brought up in Crystal you can at least see it counting records. And sometimes that speeds it up.


  • 9.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:16
    Sounds like a pass-through-query would speed things up too.


  • 10.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:19
    No idea how to do a pass-through query Moira. Will make the noted change Beth. They do have a hefty AR file Beth.


  • 11.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:22
    @JeffSchwenk is a master at these but am happy to lend my assistance to you too @DebThomas if you'd like.


  • 12.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:31
    What exactly is a pass-through-query?


  • 13.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:31
    Jeff is the master of pass-throughs and pivot tables.


  • 14.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:32
    Just a way to make the Crystal report run 10X faster!


  • 15.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 18:32
    @DebThomas - If you can write a Crystal report, you can easily write a Crystal report using Access PTQ's. It is even easier than popping a cork on a fine bottle of wine!!!!!!


  • 16.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:02
      |   view attached
    Try this one. Replacing the selection to formulas SHOULD help significantly. Plus changing the link should also help since your selection criteria is based on the header data.

    Attachment(s)



  • 17.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:04
    It may not be as fast as @JeffSchwenk 's method but, hey, it's worth a shot!!


  • 18.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:14
    Nope, resulted in no data @ThereseLogeais and I know there's data in the selection date range.


  • 19.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:16
      |   view attached
    One more change....

    Attachment(s)



  • 20.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:20
    If this doesn't work let me know. I have one other thought.


  • 21.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:39
      |   view attached
    THIS one should work Deb! Let me know....

    Attachment(s)



  • 22.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-09-2013 19:51
    I'm not sure why your report had the selection criteria set to the ""BillToCustomerNumber"" since that wasn't even in play prior to 4.5 but the report in the previous post should resolve things since it is based on just the AR_InvoiceHistoryHeader.CustomerNo. (It should STILL be much faster, BTW!)


  • 23.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-10-2013 14:10
    Thanks Therese - it worked. I need to figure out what you did that changed the process. Might we talk one of these days?


  • 24.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-10-2013 14:20
    I'm glad it worked! Certainly we can talk, maybe next week when I come up for air?


  • 25.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-10-2013 14:35
    You and me both (coming up for air that is...). Whenever, just want to figure out what I did silly. I usually am pretty good with Crystal...


  • 26.  RE: Client upgraded to 4.5 without warning and now I h

    Posted 01-10-2013 15:08
    Did you recreate this report or simply convert it? The problem was in the customer number selection. You had the BillToCustomerNo, which is for the national account feature added to 4.5, not the regular ol' CustomerNo. The BillToCust field didn't exist in prior versions. I also changed the item type to ""1"" as both Beth and Moira mentioned above. And of course, I had to tweak it a little. Even with reports I've written in the past, I usually find things not quite the way I would like. Bad habit.