Sage Construction & Real Estate

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…

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?

We recieved a refund check from the state in the amount of 1,977.25 and I need to record the check that has already been deposited into our cash account for bank reconciliation. I entered the deposit under Deposits/Interest and only entered the amount…

How do we void or edit a credit to an invoice? The wrong account was used when the credit was input and when we go to void the credit Sage says "unable to locate ledger transaction for this record". Thank you for your help

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…

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…

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…

We are using Sage 100con. We purchase items from a vendor and receive an invoice that is then paid for by the GC and we are given a deductive change order on the progress billing. How do we show the open invoice in AP paid for against the progress billing…

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…

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?

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…

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?

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.

I'd love to hear how others enter job deposits? We use Progress billing as well as Time & Material billing as the Invoice Detail for each Progress Invoice. Thanks!

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…

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…

Can a Job # be changed for an invoice in A/R, Billing or Job cost once an invoice has been created and paid?

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???

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.

new to Sage 100 C. What is the best way to enter CC transaction details into AP? Create CC setup (for each user) and then enter a payable for each transaction with a payment method of CC? You then reconcile the CC statement and select to pay the CC? Or…

My line item the scheduled of value is $14,500.00. Well i billed $15,840.00 so now there is a negative about on balance to finish. Anyway i can correct it? The billing happen in 2018 it is on on going job. Im ready to bill again....

We sometimes have multi page AR invoices. Prior to my joining the company, reports for specific number of pages were created so our terms and total print on the last page.I'm making some changes that will result in having different invoices for different…

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…

I am trying to add detail retainage by invoice to an AR inquiry. The inquiry is based on the AR - Status table. I selected this table because it allowed me to see the AR information by customer by invoice and includes cash receipts that were posted to…

We have typically only had sales tax in one state. With the Wayfair decision we are needing to file in multiple states. Some states make you track by state, city and county. Some states make you track exempt sales tax by those same categories. This creates…