Sage 100

I would like to see the Job Name, in addition to the Job Number, for each invoice, on my AR Aging Report. Using UDF links and customize the Crystal AR Aging Report.

Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated…

I'm converting some old Crystal reports from Sage 100 v2017 to v2019. The reports from v2017 use the tables: PR_22PerpetChkHistoryHeader and PR_23PerptHistoryDetail These tables don't exist in v2019. What table(s) should I use in their place? I tried…

Sage 100c 2019 Standard. When I print a custom payroll crystal report I receive an error message that reads: Error in File PR BPA CUSTOM 6352-15868-(107A04E2-6BCF-4F92-A9D7-89536928089E).rpt Failed to retrieve data from the database. Details:…

End user need Vendor Code on invoice need to look in JC_JobTransactionDetail. Where can if find a list of what is in that file?

Hi there, Trying to recreate a report from legacy job cost with new job cost and not able to duplicate a formula. Old Legacy formula: if Sum ({JC1_JobMaster.JTDInvoiceBilled})=0 then 0 else (Sum ({@JTD Gross Profit})/Sum ({JC1_JobMaster.JTDInvoiceBilled…

I'm trying to figure out if there's a way to maintain separate Payroll check stubs with the new Payroll. Currently (v2015) the client has the top stub printing 'as is' out-of-the-box, but the bottom stub contains a subreport with the PR7 (data entry)…

Is there any kind of translation between the old job cost tables and new job cost tables? I have a client that has several custom crystal reports that need to be updated with the new tables. Thanks, Suzanne.