• Crystal and special tsar functions

    In the users guide there are these functions for AR but it does not tell us exactly what they are doing and how it is determining it. In the AR Statement (CR) uses these functions, but i am getting some strange answers. I believe it has to do with the…
  • Client Average Days to Pay Report

    I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,
  • 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.
  • Phases Wip Reports

    We have been setting up phases in Sage 100 Contractor for each small job for a customer instead of setting up several small jobs. We then have been billing each phase. It is my understanding that we can not close the phases in sage 100 contractor. …
  • 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…
  • Inquiry with last invoice date for a job/contract

    I have been searching everywhere to find an inquiry that has the last billing date for a contract. Does anyone know if such a thing exists? I can't even find where this information is stored in contracts, billing, job cost, AR, anywhere. Your help is…
  • 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.
  • Add field to Report Designer AR Aging Detail by Customer

    We run the AR Aging Detail by Customer (RD version) and lately we have had some payments that have come in that don't get applied to an invoice right away. So, they get entered as customer cash receipts and we indicate which project they relate to by…
  • Billing Report

    Is there a billing report that can be run when I've completed billing for the month which shows the customer, the project and the amount billed for the month and the total billed to date?
  • Emailing Invoices from Sage 300

    Can anyone tell me how to email invoices from Sage 300 Construction and Real Estate? We are looking to do everything electronically rather than snail mail with our invoices and statements.
  • How to clean up invoices with zero balances for the same customer on AR aging report?

    Hello, On my AR aging report there are three invoices totaling zero amount. What do I do to clean them up and not showing on my aging report.
  • AR Aging by Customer "Days before Due"

    Has anyone created an AR Aging report that uses the "Days before due" from the AR Customer file as the basis for the Aging. Example: typical aging 30,60,90,120... - if customer has 90 in the days before due then the invoice will be 91 days old before…
  • 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…
  • Different accounts receivable on same job

    We have Targeted Jobs that we invoice to our local union and receive money back from the union. We need to have these bills and payments linked to their jobs, but we need the change the receivable account to the union rather than the contractor. Not being…