Browse By Tags

  • 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…
  • Applying payments for AR Invoices that were applied in the wrong order

    Firstly, We have 3 invoices 11113355, 11113356, 11113357. Invoice 11113357 was created to hold retainage for the previous two invoices after we received payment and realized retainage should have been held but was not originally. Therefore when…
  • Switching Billing/Cash Receipts to the AR Module from Job Cost

    We currently bill and enter cash receipts in Job Cost, but I want to transition it over to the AR Module. How would I go about setting this up?
  • AR Adjust Receivables Summary entries in Revenue accounts

    My company has many entries hitting our Revenue accounts with the description "AR Adjust Receivables Summary". These entries are reducing our Revenue account balances. I do not see any offsetting entries in AR. Any ideas on what these entries are?
  • 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.
  • Billed Retention Entry

    When retention is billed at the end of a project, our AR module makes an entry to move the rentention out of "retention receivable" and into "current contracts receivable" and moves the amount to our "current" column on our AR Aging Report. Our auditor…
  • Job Income

    We wrote a check to our client to return their share of cost savings on the completed project. How do we decrease the income on the job to reflect this? I charged the check to a misc GL account until I could figure how to this this correctly.
  • AR Aging Reports by Division

    We have several operating divisions and we would like to be able to run AR Aging Reports by division so that each office could run their own aging report that only contains their outstanding AR and retainage items. We have the added problem of receiving…