Sage 100

 View Only
  • 1.  5.1.4 premium - user prints the GL detail report f

    Posted 04-12-2017 12:39
    5.1.4 premium - user prints the GL detail report for accounts 115-00 to 320-00. The detail transactions appear for the accounts 115-00 to 220-00 and the detail lines don't print for accounts 221-00 to 320-00. If I just print the detail report for account 230-00 or any single account it prints fine. Any ideas what is going on?


  • 2.  RE: 5.1.4 premium - user prints the GL detail report f

    Posted 04-12-2017 12:42
    BTW - There is a KB pertaining to a bug in configurations of 13 GL periods and if you print by date range. This company is 12 periods and it happens if printing by date or by period range.


  • 3.  RE: 5.1.4 premium - user prints the GL detail report f

    Posted 04-12-2017 13:46
    There is probably bad data in SQL - we have seen something similar in Inventory... you need to try narrow ranges to try and isolate it, then look in SQL...


  • 4.  RE: 5.1.4 premium - user prints the GL detail report f

    Posted 04-12-2017 14:44
    I was looking at the GL detailposting table and didn't see anything unusual. Discovered the hard drive is out of space!


  • 5.  RE: 5.1.4 premium - user prints the GL detail report f

    Posted 04-12-2017 15:47
    I think you nailed it Doug. I was going to say because the WRK table reports use TEMPDB, the drive on the SQL Server that holds the TEMPDB MDF and LDF files could be low on space.


  • 6.  RE: 5.1.4 premium - user prints the GL detail report f

    Posted 04-12-2017 16:31
    Thanks Jeff and Alnoor.