Browse By Tags

  • Sage 300 CRE GL system has a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting

    Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?
  • Automated Inventory Reports

    Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…
  • Inventory Summary vs Group Inventory and services

    I am trying to get a download of inventory ready for our Year End. I have categorized and noticed there are discrepancies in value. Through Reports 1) Inventory and services summary approx. $450.00/Inventory icon same 2) Inventory and services list…
  • 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…
  • Is there a way to calculate the commission by item sold?

    Hello, I have a warehouse of items that are are sold by sales reps. I need to compute commission earnings by sales rep; linking customer invoice detail to vendor costs. How can this be done for warehouse items? Thank you in advance. Ellen
  • Inventory Report - Duplicating Items

    I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…
  • Profit and Loss

    Is there a way or method I can run a Profit and Loss for a specific time period - for example, 7/1/2018 through 6/30/2019?
  • Only some job numbers showing on "JC Receivables Aging by Draw as of Accounting Date" report

    When I run the "JC Receivables Aging by Draw as of Accounting Date" report, I can see all of the outstanding draws by job. However, some job numbers/descriptions show up and some don't. It's a standard report, but I've tried to customize it many times…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • What does *!! at the end of a general ledger report mean?

    On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant
  • Item Sales Report Sorting

    I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…