Sage 100

 View Only
Expand all | Collapse all

Just created a Crystal Report which prints out the

Chuck Peddy

Chuck Peddy03-04-2013 07:39

John Hoyt

John Hoyt03-04-2013 07:43

Robert Wood

Robert Wood03-04-2013 08:18

Lisa Dion

Lisa Dion03-04-2013 08:19

Beth Bowers

Beth Bowers03-04-2013 09:01

Diane Ruth

Diane Ruth03-04-2013 09:07

Barbara Goldstein

Barbara Goldstein03-04-2013 09:13

Robert Wood

Robert Wood03-04-2013 09:15

John Hoyt

John Hoyt03-04-2013 09:51

Shawn Slavin

Shawn Slavin03-04-2013 11:59

  • 1.  Just created a Crystal Report which prints out the

    Posted 03-04-2013 07:31
    Just created a Crystal Report which prints out the number of entries currently in data entry files for AP (invoice entry, manual check entry, check entry), AR (cash receipts, invoice entry), PR (data entry), IM (data entry), BM (production, disassembly), PO (ROG/ROI/Returns), WO (trans entry), SO (invoice data entry), Job Cost (Posting Entry), RMA (receipts entry) and the GL Daily Transaction Register file. Client is using to verify quickly before attempting a period close or Del/Ren/Merge, etc, instead of checking every module manually. If anyone is interested, I have it in 4.3 and 4.5. All you have to do is suppress the report section for those modules your client does not have.


  • 2.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 07:39
    Definitely interested, Beth!


  • 3.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 07:43
    Yes, I'm interested.


  • 4.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 08:12
    I'll take one please. Should also be helpful during updates/upgrades.


  • 5.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 08:18
    Yes. Sweet!


  • 6.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 08:19
    Yes, very interested.


  • 7.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 08:24
    I will definately use it in a 4.30 to 4.50 upgrade I'm planning right now. Client has multiple companies, should save me some time!


  • 8.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 08:51
    This sounds like the perfect premigration tool. I'm interested too. On another topic, a long time ago, i modified the UDF Maintenance Listing to sort by UDF reather than by Table. This was very helpful to me in analyzing a system that had a bunch of UDFs created by someone else. I got the report to the point where I could get what I wanted but never got it polished up enough to be useable for others. I need to dust it off and try again. Perhaps someone has already done a better job of this.


  • 9.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:00
      |   view attached
    I'm going to try to attach the files - last time I tried an attachment, no go. First here's the 4.30.

    Attachment(s)

    rpt
    CheckUnpostedCUSTOM.rpt   135 KB 1 version


  • 10.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:01
      |   view attached
    Hey, I'm on a roll. Here's the 4.5.

    Attachment(s)

    rpt
    CheckUnposted450CUSTOM.rpt   145 KB 1 version


  • 11.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:07
    Thanks Beth!!


  • 12.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:09
      |   view attached
    Here's the 4.5 one again - I added the current period for the modules AP, GL, AR, IM, SO, and PO on a line above the other info (along with the company code). Helpful to make sure period end is being run...

    Attachment(s)

    rpt
    CheckUnposted450CUSTOM.rpt   145 KB 1 version


  • 13.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:13
    Thank You!


  • 14.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:15
    Thank you @BethBowers!


  • 15.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:21
    You're the best @bethbowers - even from the beach!


  • 16.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:45
    I just check GL renumber, AP renumber, IM Renumber, and AR renumber utilities to tell me any outstanding entries anywhere. But definitely a time saver with one report.


  • 17.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:51
    Thanks, @BethBowers !


  • 18.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 09:53
    Just making sure I'm pulling my weight around here...


  • 19.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 10:31
    Thank you @BethBowers - I have always hated going module by module on upgrades to make sure everything is posted....


  • 20.  RE: Just created a Crystal Report which prints out the

    Posted 03-04-2013 11:59
    @BethBowers , thank you for sharing.