Browse By Tags

  • How do I get a report showing Vendor Statistics for a fiscal year in Sage 300 CRE

    I need to pull a report that shows all of the following information for our past fiscal year: Vendor name, address (CSZ) number of checks, total amount paid to vendor, Type of payment (Check, cc, ACH).
  • Receivables

    I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.
  • Adding a note to receivables aging report for individual invoices

    I'm using Sage 50 US. I'm looking for a way to add a comment about an invoice that would show up when I run the aging report. For instance, when a customer communicates to me that the invoice will be paid on a certain date, or if there is an issue with…
  • AR Invoice List

    Hey All, We are still new to Sage 100. I can run a report to see what we invoiced for each month. (3-1-2 Report # 21). However, I was wanting to run a report to show everything thus far this year. January till November. Is there a way to do that? To…
  • AR Tax Group Set up Report

    Does anyone know if there is a AR Tax Group set up report that exists so I can see what tax rates are part the group? Looked in standard reports and KnowledgeBase but have not been able to find anything.
  • How can I tell if I have billed retainage

    1. I m looking to see if there is a report that would show me if i have billed retaiange. 2. I m looking for a report or something that i can run that would show if I billed for my jobs that month.
  • Report - Average days to pay

    Is there a report I can check average payment time for our clients? or do I have to go through every single transaction and count? Thanks!
  • JC summary showing a difference in GL vs JC- how do I find out where the mistake is?

    Hello, I recently ran my JC summary reconciliation report and have a difference of $900 in my GL that is not showing up in my JC on the subcontractor line of the report. What reports do i run to narrow down where the mistake is at? Looks like it was…
  • Running Quote Reports

    Is there a way to run a report in sage that lists all the pending quotes not yet awarded? The only report I can find is the Pending Delivery Orders by customer.
  • 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…
  • I want to print an Accounts Receivable Invoice History report sorted by Customer Type.

    I need to print an Accounts Receivable Invoice History Report sorted by Customer type. I have created the UDF for Customer Type and added to all the work and history files. When I run the report just selecting invoice dates I get my report showing the…
  • Custom Crystal Report printing differently

    We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…
  • A/R Transaction Listings

    Hello - I'm looking to run a report that shows every amount we invoiced our clients for one year as well as what they paid in that same year. Basically invoice amounts and payments for 1 year. The invoice amounts look correct, but the payments that…
  • I need a report to show me any AR that was billed but not paid

    I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …
  • Report error: "Index was out of range. Must be non-negative and less than the size of the collection"

    Reports starting giving the following error: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name:index". This just started happening on the latest update. I've been using these same reports for years…
  • Payments not showing in Aged A/R Balances Report

    I have an issue with Aged A/R Balances that has come up a few times recently. Sometimes, check payments that I entered do not show up when I print an Aged A/R Balance report. I check the client's payment transactions and there are no unapplied payments…
  • AR Balances Report

    Hi, Does X3 have a report that shows what is owed by a customer. This would be any open invoices that have not been paid. FAHAD