Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
Hello,
I am trying to figure out how to create a custom Payroll earnings report to show the Department field, hours, and dollars from Payroll Data Entry. The stock Earnings report does not appear to report this information, only the department defined…
As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all!
I am working with the Open Sales Order Report now and stuck on suppressing some items in the report.
The end goal…
I've recently created some custom versions of reports (AR Aged Invoice Report, for example) and set them as default for all users, but for some users it still defaults to the STANDARD report every time. It is set to the default report via the checkbox…
I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried:
In Crystal Reports designer, I created…
I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit).
The client will have an issue with the Freight amount not saving on the Total tab.
I will go in and recreate the customized…
I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report.
I need to create a summary report that includes data from both tables. I'm hoping that someone has…
In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…
Hi everyone, I'm using Sage 2013
I've added a new tab to the Sales Order module in Main > Invoice Data Entry
I've added fields/UDFs (some are already ones that existed), but I'm unable to add to anything in this tab or figure out how to get some of…
Hello, folks:
In our payroll module, the Employee Masterfile Audit Report doesn't capture changes to employee deductions, direct deposit bank accounts, or paystub emails or passwords. For years, our workaround has been to save screenshots of the change…
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:…
Can anyone tell me where I can find step by step directions on creating a custom check history payroll report? We have 3 departments and within the departments employee work within department numbers. I can print the payroll check history report and break…
We have a parameter in our Sales Order form that changes what is printed based on the parameter. I would like to have it print to a particular printer based on the parameter selected. Actually I want to print from a particular tray in printer based on…
Is there a way to restrict access to standard report settings while allowing employees access to custom settings? We recently upgraded to 2018 and use the Job Cost Module. The Job transaction detail report is something we use frequently but since we upgraded…
Is there a table to create a report that can give you info from the Time Off Register but after a payroll is updated? Looking for accrued hours and accrued hours used by posting date. (PR 2.20)
Updated from Sage 100 Standard to Sage 100 Premium. Need to supply vendor name on job cost invoice. for customer. JC_InvoivoWrk only supplies Vendor id and Division id. How best to link JC_InvoiceWrk to Vendor File to get Vendor name in database
The pension report does not show all information needed. Need to show gross wages for all employees irregardless if they contribute. Employment dates and other permanent info. Help
Is it possible to insert HTML code in the ‘Electronic Delivery Message Maintenance’ window? We would like a nicer landing page for the employee pay stubs.
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)…
Hello, I am having some issues with making a script to change the output setting for paperless office inside of sales order printing. I have some code below that I found searching the forum. The way it is now I do not get an error message and nothing…
Is it possible to automatically email our customers when their invoices become past-due? We are trying reign in our A/R and at 45 days after the invoice is issued, it would be awesome to have our system auto-send a notification/reminder to the debtor…
I am trying to make a custom report in Business Insights Explorer that shows:
Item Code
Item Description
Product Line
Quantity on Sales Order
Total Quantity on Hand
But I cannot link a "Qty. on Sales Order" column to the rest of the report…
We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…
Greetings,
We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco.
The manual for the add-on is here. https://wiki.blythecodev…
