Sage Construction & Real Estate

There is a field in a Job Cost Report that I want in my Custom Report. Does any one know the name of this field "Jobcst^pytpnm"

I have been trying to determine how to print a "Billed by Cost Code" report in Sage 100 on a T&M Project. This would be highly beneficial for budget update and client inquiries by cost code and would eliminate the need to derive the totals manually in…

Hey All, We are still new to Sage 100. I can run a report to see what we invoiced for each month. (3-1-2 Report # 21). However, I was wanting to run a report to show everything thus far this year. January till November. Is there a way to do that? To…

Hello, What is the best way to produce a report that shows the job costs that have been paid on a job? I would think you could produce a Job Cost Journal (6-1-2) and filter by the job and by status ("paid"), but it does not allow me to choose a status…

Hi, can someone tell me how to generate a report for pending prime invoices?

Running 13-6-21 is a listing of all reports in Sage. Some reports are showing "Apex Format". Never seen that before. What is this?

The purchase order audit report does not include the sales tax in the received columns, even though it has been inputted during accounts payable data entry against the PO. Can this be corrected?

I am trying to write a report, i have a if then and select syntax. Does anybody know the correct code for the tmcdln.crtfid table/column I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column. …

What determines the order of printing the vendor ACH remittance emails in hard copy? There are not options and its definitely not vendor number.

Does anyone know how to print report 6-1-4-81 per phase?

Is anybody else having problems with the Aatrix payroll tax forms (5-4-1, 5-4-2) not populating after the latest software and forms updates? Last Friday the forms worked fine for me. Today I updated to the latest version of Sage and the latest (required…

How do I find out what invoice is not posting when I am getting Rejected Invoice on my posting report?

looking for some help on editing and creating reports.... for our direct deposit pay stubs it lists paygroup, hours, type (overtime or straight time) and total. we have several paygroup amounts which i would like to also show the $ amount per hour for…

Is there a way to run a final lien waiver after final payment has been made to a vendor?

I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.

Can anyone advise on what the "*" means next to the date on the Check Register Report 2-6-0-21 ? Thanks for your help in advance!

When I run report 4-1-3-21 as of June 30, 2023 the balances do not agree with my ap gl acct. When I run the report as of today it does. What would cause the "as of" report to be off?

Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…

For example, I am trying to get an account up to date on reconciliation and need to view the very latest rec report that was saved. But I'm not sure how to view that. Help please.

I want to use a standard purchase order template for an Assembly. When a client requests a different item, I Cancel the item on the Standard Purchase Order and replace it with the substituted item. This is the Purchase Order showing the cancelled…

Line 5D Taxable wages & tips to Additional Medicare Tax Withholding populates with a number and it should not. What would cause this ?

I am receiving "The procedure entry point could not be located in the dynamic link library" message when trying to run quarterly tax reports. We recently updated to 25.1.319.0. Is there a fix for this? Thank you.

Is there a way to run a "not billable" report by Job? I cannot seem to find a report that allows me to select a status of "not billable" to be run.

I can't find anywhere to report a bug in the new Fraud Manager feature in R25.1. A check that was paid when reconciling a Credit Card does not show up in the Fraud Manager report no matter which boxes I check. This needs to be fixed ASAP. Besides submitting…

Is there a way to show available and accrued vacation on the payroll check stub?