Sage Construction & Real Estate

Good Morning We are layering in additional internal control measures for our AP/credit card procedure using Timberscan/Sage 300. Does anyone have a procedure they can share when these responsibilities are split between two people? One person…

Hello, I have a few subscriptions that are charged to the credit card monthly and a few that come out via debit card, that require a manual check. Since the invoices always stay the same, is there a way to get these specific invoice to enter on their…

What process do you use for lien waivers when you are issuing an ACH payment? Will the system email the lien waiver also? We hold checks until the signed lien waiver comes back but are switching over to ACH and was wondering what other companies do

Dear Team , We have a scenario where for some vendors, some invoices appearing in open invoice register which is fully paid , Attaching screenshot for one vendor for your reference , similarly we have few vendors as well . Thanking in…

We have a separate GL set up for cash on account (it's not related to any specific customer, it's just a generic GL) that our cash applications people put funds to when they can't find an invoice to apply it to. If an invoice exists (but they had difficulty…

Dear Team, We have noticed a strange issue in treatment of VAT. The VAT is calculated in AP correctly and reflected in VAT report as well. However, while posting in GL it has been split into two base accounts named 1601 and 1690. Below is an example…

We are new to Sage and yesterday I tried my hand at putting in quite a number of recurring invoices. This did not work out so well due to various payment dates setup in the vendor masters, which I corrected. Now I have a bunch showing as being due. …

The Open Invoice Register w/ cut off date for 12-31 is more than my Balance Sheet account. So it would seem that something is in the AP detail and not the GL. I do not have any unposted invoices. Is there a report I can run to identify this?

We have historically conditioned checks to print based on different authorization IDs for different bank account. We are trying to use a condition to select specific vendors to pay that have been selected to pay based on a CUSTOM FIELD in the VENDOR master…

Hello, we have had a couple of situations where AP has terminated with: "This program has quit. Incompatible Macro Option [TS 4426]" The first time it occurred we were posting invoices and it popped when generating the report after the posting…

i have followed the instructions exactly and the system will not regenerate the electronic payment. I selected the original file and was asked do I want to overright it, clicked yes. Verified the Run number. When I click start, the sytem does nothing…

Probably an odd question but does anyone know how to correctly adjust the A/P Ledger for Year-End Closing? Accountant and Bank are looking for a correct A/P Ledger with the proper adjustments tied in. I know the GL doesn't filter down to the Subsidiary…

Hi everyone, I just noticed today for one of my Jobs (ABC-XYZ-1234), when selecting that Job in AP Distribution when creating an invoice, the "Draw" field is automatically populated with a number "2". I would like to understand how to automate the…

I’m processing my first new employee under the 2020 W-4 form, and I cannot reconcile using the IRS tables to verify Sage’s calculation. Anyone see where I am going wrong? Single, $2000 for dependent, $860 taxable this week, state is NH (no income tax…

Is there a way to post an invoice to multiple post dates when the invoice spans over more than one month? For example, I have an invoice that covers October 25 to November 5. I want to post the charges relating to Oct 25-31 in October and post the charges…

Is there a way to create a sales tax liability after the fact? We have a vendor that we have made progress payments to and still owe some money to. It is an out of state (out of country actually) vendor who did not include state sales tax in their proposal…

Has anyone figured out how to get AP Lien Waivers in Sage 300 to include credit memo amounts? As far as I can tell, the Lien Waiver forms are all written based on the Job Lien Waiver file, and for some reason, credits (or negative invoices) do not show…

We have a commitment entered. The vendor and job are tied to the commitment. We’ve been told by the help desk that there are no edits in an AP entry to prompt to add the commitment. SAGE suggested sticky notes or leaving the insurance out of the system…

When I go in AP to set invoices up for payment ... AP - Tasks - Select Invoices to Pay - On Screen List. Is there a way to show subtotals for each of the vendors / suppliers I am paying? I do see that I can go in and view the total (by going into…

We placed an order with a vendor. The vendor asked us to pre-pay for the merchandise. So, an invoice was created for the quoted amount and paid. We then cancelled the order and asked for our money back. The vendor kept a portion as a cancellation fee…

Anybody else having issues with their 1099 Processing using Aatrix? I keep getting an error message that it could not create the Aatrix data file. The process cannot access the file and some form is being used by another process.

I have three old invoices showing negative retainage balances. I've tried several things over the years to clear them, and nothing has worked so far. They are on now closed jobs, and I'd like to finally get them off our AP list. Here are how a couple…

Our clerk entered the wrong invoice number in Purchasing when receipting the invoice. He posted invoices to AP, and that is when he realized he used the wrong invoice number. Instead of deleting the invoice in AP, unposting it in PO, and rerecieving it…

For the majority of this year we used Credit Card Management without have the Credit Cards Payable account set. Because of this, our AP totals in General Ledger are higher by the amount of the CCP transactions. What is my best bet to correct this mishap…

When an invoice is entered in AP, the text file (Notes) created drops the last digit of the invoice. This happens with certain vendors, but not all.