• Is there a PO Return of Goods History Report

    Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…
  • AP invoice and the AP Trial Balance Report compared to the GL

    Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Sage Intelligence Excel Protected mode

    In upgrading office from 2010 to Office 365 reports generated in Sage Intelligence I can only see the data when the document is opened in protected mode. If the document is opened not in protected mode I get a NAME reference error on all the formulas…
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
  • Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
  • SQL Table for batch history? AKA Batches not located in GL_CompanyActiveBatch?

    Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…
  • Sage Intelligence Data Limit Reached in Excel

    I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
  • Sage Intelligence and Microsoft Excel Tips and Tricks

    Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…