• Paid customer and job remain on AR Aging Detail reports (not crystal)

    Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
  • Aged Payables Report - Functional Currency Issue

    I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…
  • ALL AR/AP INVOICES

    Hello Team, Our client who uses sage 300 ERP requested for a report of all AP invoices and AR invoices for a vendor and customer respectively. Specifically, the invoices that have been paid for in the past and yet to paid. What report can we spool…
  • Sage 300 Financial Reporter - Income statement

    Sage 300 Financial Reporter - Income statement is not populating but balance sheet does. Has anyone else seen this and how do we fix?
  • A/P Payment Inquiry comes up blank regardless of input parameters 2017 PU5

    A/P Payment Inquiry comes up blank regardless of input parameters Sage 300 2017 PU5 Running as ADMIN
  • Excel 2016 with Sage 300 2012?

    Client moving to new software per new owners in a couple of months, so do not wish to upgrade Sage 300. Sage 300 v 2012 local install, data on server. Workstation crashed, wiped and reinstalled. External IT firm installed Office 365 with 32 bit Excel…
  • AR Subledger Balance by Month

    How can I get the balance of the AR Subledger by month for an entire year or date range? The only way I know is to create an AR Aged Trial Balance Report manually for each month... but I just need the balance.
  • Sage 300 ERP - A/R Invoice Summary

    Hi All How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016). something that looks like: Thanks! Vendor A $50,000 Vendor B $100,000 …
  • Optional Fields and FR

    Does anyone know if I can pull in Optional Field Value 'Descriptions' into an FR report? I know I can pull in the Values. Thanks.
  • Reports very slow on in Sage 300

    My client is running Sage 300 2014 and when they run reports from their workstation they are very slow, but when someone from another office runs a report via their terminal server it runs very fast. Any ideas?
  • AP Reports requesting Parameters following upgrade to Sage 300 2016

    Client was upgraded from version 6.0a to 2016 yesterday. Since the upgrade none of the Accounts Payable reports will print. When we try to run any reports a screen comes up requesting a number of parameters be entered. All other modules (GL/AR/PO/CP)…
  • Sales Tax on a Cash Basis

    How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.
  • Non AR Cash Receipt

    How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…