Sage 100

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…

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 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…

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…

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 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.

In Crystal Report I'm trying to Record Sort Export a formula that I made but that formula doesn't show up like the other formulas that I built. Does Crystal have a problem sorting formulas that uses the OR statement or a formula that refers to other formulas…

Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once? either for a single order of for multiple orders?

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…

I am passing a value from a subreport to main report and in the main report this is the formula: WhilePrintingRecords; shared numbervar Cafe; Cafe If there is not a match between the main report and subreport, Then it prints the value from the previous…

Need to use Pre-printed invoices on my dot matrix printer. Form size is 8-1/2 x 7. When I change the form size in Crystal Reports, I get an error that says "footer longer than page size". Don't now what to do. Any suggestions? Maybe delete some detail…

Hi... I have 50 individual check box udfs in customer maintenance for each of the 50 states. For each customer there could be many of the fields enabled. I want to write a report showing each customer and which states are checked. But I don't want to…

Recently updated to 2019, trying to create a custom report however the datafields have changed names, anyone know what PR_1EmployeeMaster or PR_4EMployeeEarningDeduction are now called? Shows earning amounts/deductions?

Hello New to Sage. Creating a Job Cost report. I want to key the listing on JC_JobBillingHistory to pull all the open and closed records. Using JC_Job for Open and JC_JobBilling for Closed. I can't get both of the tables to link to key table. It will…