• 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…
  • Payroll check not printing.

    I have an employee who's check is processed but will not print. It's a $0 check because it's all going to 401K but it should still complete the payroll process.
  • Auto withdraw expense that goes towards a job.

    I'm doing the bank reconciliation. I have a fee that is withdrawn from our account, but it is for a specific job. How do I go about charging that fee to the job plus being able to clear it from my bank reconciliation. I hope someone can help.
  • Recording bank interest

    I am new to Sage and have been cleaning up a big mess where I am working. Reconciling old bank statement. I know how to record interest in other programs but how do you record interest in Sage?
  • 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.
  • Credit Invoice

    How do I create a credit invoice for a vendor to use on a bill at a later time?
  • 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.
  • Bill Credit for AR Retention

    We have a job that I need to do a bill credit to the retention. This isn't a write off. We elected not to bill the owner for the remaining outstanding retention. I searched and read that Sage doesn't offer the ability to do a bill credit to retention…
  • AR Refund

    We have a customer that we received a deposit payment on a project 2 years ago. They have since shrunk the project and we cut them a check to refund them a majority of their monies. How do I adjust this in JC/AR/Cash management. My thoughts are we…
  • 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…
  • 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…
  • Can I unapply an AR cash receipt that was applied to an invoice in a previous year?

    I have a cash receipt that was applied to an invoice last year that I would like to unapply from teh invoice and void the invoice. Is this possible to perform once I close out the year (i.e. perform the task in the current year) or do I need to unapply…
  • AR

    Wondering if anyone can tell me how to change a date to a reconciled AR item. I was able to change the item in CM to be O(open) from (R)reconciled. I now need to change a date from 2021 to 2022. The bank reconciliation is now out of balance because of…
  • Payables

    Being in the Accounts Payables business for over 20 years, having used at least 4 different types of software, there are so many things I notice are either not doable or take a zillion steps to get to the end result. A/P is universal in application or…
  • 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?
  • Accounts Receivable showing "Not Used" on Aging Report

    My Accounts Receivable person did some adjustments to clean up our aging report. Not exactly sure what was done, or how done, whether it was by AR Credit/Debit, Billing Credit/Debit, etc.but now I have "Not Used" on the aging report listed under the clients…
  • 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…
  • Accounts Receivable

    My A/R person did something with voiding or adjusting payments to an open invoice. Somehow there are now postings to the A/R (reflected in the aging report) that state "Not Used" under the Tran Type, and gives a Non-Job negative amount. Since I cannot…
  • One of our customers owes us 10 cents. How do I get it off of our books?

    We sent a billing out for 1,290.10 well they only paid $1,290.00. Their system rounds as to mine does not.... How can i get that $0.10 off my books???
  • 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…