Browse By Tags

  • 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…
  • A/R Reports for a selected time period, including closed and inactive clients

    Is there a way to generate an accounts receivable report for a time period that includes matters that are closed or inactive?
  • 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!
  • 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.
  • CSV TS importing or other Service - Ask along

    Hi All, I have been using TimeSlips CSV importing for years now. I have have some knowledge of various functions in TS if you need help or need a person to do importing/export time and expense entries via TS import (CSV file) just le me know. Also…
  • 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…
  • Accounts Receivable OPEN BALANCES INVOICE REPORT BY COSTUMERS WITH AN EXCEL SINGLE COLUMN FOR EACH FIELD NEEDED.

    I want to Download in Excel (from Sage 100) an Accounts Receivable Open Invoice Report. The problem is that the reports that I found in the AR module shares excel columns, for example, the AR aging will share the customer name with the invoice number…
  • 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
  • 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.
  • AR Reports

    Question, I need to run a report showing what I billed our customers for the month of December 2016. But I need to choose customers who only purchased certain products. Which report do I need to run? I'm starting to confuse myself. Help!! Thanks.
  • 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 …
  • 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…