Sage Construction & Real Estate

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

We started experiencing this issue 2 days ago and it seems that we are unable to get past the error. When trying to make a payment in Sage AP, my user gets the following error when trying to submit: This program is about to close. See the journal in the…

All of our jobs have disappeared from Timberscan and we can no longer select for routing. Any advice?

We are trying to move closed jobs in PJ (Project Management) to an archive folder to reduce the size of our database, We have tried multiple times with no success. Things that we have tried. 1- set up a new dummy company to move to 2. tried to move…

I have tested this in completely separate workspaces (different clients, different provinces, different computers) and am getting a similar result. V 25.3.84.0 - Canada In enter credit card receipts; no vendor, but select a job; in the AP lines, enter…

The answer is yes! Let me explain, I followed the year-end guide. I ran the audit, I repaired the errors listed in the audit, I ran the audit again to check for errors. There was zip, zero, zilch errors reported. I proceeded to close 2023 payroll. Everything…

what does pervasive error code 54 mean and what do I need to do?

After our 2022 payroll was archived, we can no longer see Terminated employees (status = 5-Terminated) in the current version. We still can see Laid Off employees and employees that Quit but no Terminated employees. This was not a problem when we archived…

We have at least a couple hundred payroll records where PTO (sick time) was used while we were running the broken version 24.2.103 of Sage. The process for fixing these, listed as the resolution to defect # 39917 is a manual process for each individual…

I issued a CO to an existing PO last week, printed and sent. It was there, I have the proof. This week the PO is not showing in a PO Log but the line items are showing under committed cost. I have no idea what happened. Any help would be appreciated.

I have 2 Cost Codes that have randomly stopped working for 2 users. I am the Admin and it won't let me use them for 1 specific job only. The other 2 users is for any project. Won't allow them to be used when entering a Change Order Request in Project…

If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V

We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…

Work Order details mysteriously moving to an unrelated work order for a different client and deletes the values that were there. Any ideas on how this happens and what we can do to prevent it?

In a custom report showing line numbers for daily payroll data, line 5 shows as line 5,000, line 9 as 9,000, etc. See picture below.

We do almost all Cost-Based invoicing. In the past few cycles, billing has been generating invoices un-prompted! Has anyone else experienced this? Our process is as follows: 1. Generate Work in Progress for ALL jobs 2. Generate Cost Based invoices…

Hello, this has happened on two of the take off templates I have been working on while trying to add bid items. I have attached a screen shot of where I have been adding the bid items in the take off templates also. Is this what could be causing the error…

Sage 300 Construction and Real Estate v20.3 After running “File Doctor” we notice several errors. I found the client record with the unprintable characters error and manually replaced the text without any special characters. A re-run of “File Doctor…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

Accounts Payable Application is missing. Help! I am working on Sage 300 Construction and Real Estate version 18.2.2

GL overvalued vs physical inventory at year end. I believe it's being caused by a lot of Receipt Adjustments that don't have a location showing in them. Is anyone else having/had this problem? What causes Receipt Adjustments and why do they overvalue…

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

We are seeing a strange thing happening and wondering if this has happened to any one else. Occasionally, we are seeing strange entries in our AR Sales Tax District field in AR Jobs. These entries do not match the project location. We are removing them…

Sage300 CRE Version 17.1 Rev6 We had a power issue and the database server shut down unexpectedly during operations. After the server was powered on again, several users complained they were getting errors in the application. We tried restarting the…