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.
I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
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…
Hi all,
I need to add the Sum of 3% Parts ( which seems to be a sum at the Group 2 level) and 3% Freight but I cant seem to get them to add correctly.
Any help is greatly appreciated.
---
Parts Extension IF {AR_InvoiceHistoryDetail.ItemType}=…
I am trying to make an excel sheet (ideally a custom report), which shows the amount we invoiced every day, and the amount that was promoted from quote to sales order every day. Grouped bar graphs is what I'm trying to achieve.
I figure the easiest…
I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…
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…
I'd like to edit the Picking Sheet printing Crystal report to only print orders containing a specific item. So if it contains that item, it prints a picking sheet with that item and any additional items ordered.
Does anyone have a formula for that?…
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 …
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…
I entered AP Payment Processing in Company "A," created a new Form Code, and used Designer to create a new custom Check. I have 10 other companies and would like to copy the custom Check to all of those companies. I think I'm supposed to use Report Manager…
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've created a UDT with 2 fields, ItemNumber (The key) and Description (A multiline text field).
I want to link the ItemNumber to the ItemBillNumber of a work order and display the Description on the Work Order Traveler.
I've added the UDT table in…
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…
Been awhile since I've worked with Crystal and have what should be a simple formula.
The Qty BO Column on the SO Picking Sheet just prints an Underscore.
I'm trying to get it to print the Qty BO if not equal zero and a blank if equal zero.
Keep…
Hello Everyone,
Looking for a little help on how to print the sales order line number on Packing Slips & Invoices.
We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…
I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…
I have a report from v2017 that utilizes the table PR4_EmployeeEarningDeduction. The documentation says that in v2019 the equivalent table name is PR_EmployeeDeduction. The problem is that the new table doesn't seem to include earning information, and…
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.
I know there is an order for installation that will allow HRMS and Sage 100 to peacefully co-exist on the same PC, however I am not sure what the exact order is.
Also when ever we do a quarter update with HRMS, we invariably break Sage 100 (specifically…
When running the Costed Bill of Materials Report some items will print displaying all components. Others do not. Bills are all setup as Standard.
BOM Options: Maximum number of levels is 10, but these are not levels, just components listed in the lines…
I would like to add the $ to the beginning of sales numbers in a custom Crystal Report, however I can't seem to locate a place to add it when in Cyrstal Reports.