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.
Hello everyone,
I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view.
I tested it on a few other lookup windows…
We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…
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…
Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry?
The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…
Has anyone installed the F9 software version 4.5 with Sage 2019? We currently have 2016 and it works fine but we are about to upgrade and before we make a change I thought I would check.
Hello,
We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'.
Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
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…
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…
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…
I have been using MAS90 and Sage 100 for many years. Now I am needing more custom reports, but I do not know that much about creating or modifying crystal reports. I am using Sage 100c Standard 2017 V5.40.1.0 and Cryatal v14.0.3.613 RTM.
Where can I…
Hello,
I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…
I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below:
retVal…
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…
Hello,
I am trying to create a custom report that would show customer details relating to items sold.
I am looking to include:
Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…