• 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…
  • 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.
  • 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…
  • 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…