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 currently use Instadocs to attach specific files to SO's and PO'S, etc.. Is it possible to attach a pdf to a specific PO and then print the PO to pdf with that specific attached file in the same pdf file? I would not think it's possible but....
Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?
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…
I'm hoping someone can help me out with an issue we have been having with Sage 100. We have multiple companies but we are only have this issue with one of our companies. When we go to make an Accounts Payable check under Manual check and Payment entry…
I am new to designing reports in Sage 100. Is there a good YouTube video or documents on this? I just need something simple for an audit (employee name, job title, gross wages, and overtime wages).
The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached.
Are we able to add additional standard Sage fields to this list eg; CustomerPO?
Hi...
I'm trying to find a way to add a value from the bill of materials bill number field in bill of materials maintenance to autopopulate the bill number when you run the Single Level Report from the screen. As it works now, the report will appear…
I am looking to print the customer type on the picking sheet. I added the AR_Customer table to the database, used a left outer join. Added the Customer Type to the crystal form (browsed the data-I could see the customer types) BUT when printing it does…
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…
We print large batches of picking sheets a couple times a day, when this process is run the printing prints all of the picking sheets form 1 first, then goes back and prints the second form for the picking sheet. The process is run on 20-100 sales orders…
Morning,
We have Sage 100ERP, I am looking to see if there is a way to create a report by period that shows how much in sales per vendor. So we are a distribution company and we purchase products from several vendors, and then sell those products to…
MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…
We have 170+ rows and they are separated into 4 different groups of rows. First group of rows is 1-54 and behind that one is 108-55 and then 109-138 & 162-139. We could have a order that has an item that's on row 1, row 54 & 108 for example. If they pull…
I am attempting to modify an existing report in Sage 100 to show employees' next anniversary date and birthday starting with the hire date and birth date fields entered on the employee set-up screen. I can't seem to get the addint function to work if…
I need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?
Has anyone ever created an inventory transfer form that can be generated out of MAS that a shipping department can complete. I am looking for a picking sheet type of form but the item is simply being transferred from one warehouse to another (therefore…
There are additional efforts to use Crystal Reports 2020 (@Sage 100 2023) with MS Office or text files. I have Custom Reports that include links to Excel and MS access. Without the native connectors we will have to use downloaded add-ins. Does anyone…
I am trying to import multiple POs into the same Receipt of Goods. I chose Next for the Receipt Number and pointed it to the field I want to use to determine the change, but apparently it ignores that and changes whenever any header field changes, i.e…
Hi there,
I searched and couldn't quite find what I was looking for.
I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…
I am uploading several work ticket templates at one time using visual integrator. I can find the tables/variables where all the field data exists, but am not able to find the extended text. Can you please help and advise the table name where the extended…
I am looking to customize our AR Aged Invoice Report to replace a manually done Past Due Report. The report is fine how it is for the most part, but I am wanting to filter the 30, 60, 90, 120 Days columns to exclude all zero's. The report is way longer…
Have a client who needs to do some reporting for the state and the Check History Report seemed like a good place to start. HOWEVER, I have been unable to add UDFs from the Employee file at all (even non-encrypted fields) (they all show as blank), and…