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.
Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…
With 4k monitors and a lot more screen room we would like to move some information from the "additional" tab to the "main" tab in inventory and accounts receivable so we don't have to flip back and forth between tabs to see everything we need. I was working…
We have different types of picking sheets that we use and print multiple types per sales order. Everyone always forgets to change the form code so we waste a ton of paper. Is there a way to add another button to the Sales Order Entry page to open up a…
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 have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
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…
Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…
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…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
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…
A client asked me to create User Defined fields and add them to their AR Customer Maintenance screen. When I accessed the DMAIN panel this is what I see. I stopped immediately because this looks like corruption to me. I have never seen anything like this…
I figured out how to add images to our picking sheets, but not all items have images and those that don't leave a huge blank space where the image is supposed to be. Is there a way to "collapse" this space if there is no image associated with the product…
I am modifying our picking sheet and want to save a "test" version. When I am in Crystal Reports and I go to "Save As", I create a new folder in the "SO_PICKINGSHEETPRINTING" Folder. It doesn't show up as a form code when we go to print a picking sheet…
I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…
Hello!
I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer.
It would be nice if i could filter a whole list of orders…
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…
Hello,
I'm trying to modify my picking sheet so it shows which Sage user created the sales order. I'm using Sage 100 ERP 2013 and Crystal Reports 2011.
I have "SO_SalesOrderDefaults" added in Crystal Reports under Database Fields, but when I add …
Having added a UDF to the AR Invoice history Called Enhatch order Id. When trying to print a copy of an invoice from this record the UDF does not print and it has been added to the form.
Any ideas as to what link I am missing?
To see the invoice printout…
We're editing our picking form, but now when there is a comment on an item it will add a line of space before the next line item. Is there a way to get rid of this space? Is there a way to get rid of the extra space created when an item doesn't have a…
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…
I added a tab to my Invoice Data Entry panel with UDFs
I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
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…
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…
