Sage 100

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…

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…

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.

Is it possible to modify the name of a report that was added to our AR Custom Reports menu?

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…

Sage 100c 2019 Standard. When I print a custom payroll crystal report I receive an error message that reads: Error in File PR BPA CUSTOM 6352-15868-(107A04E2-6BCF-4F92-A9D7-89536928089E).rpt Failed to retrieve data from the database. Details:…

Hello, I'm trying to create a crystal report so we can generate CA sales and taxes charged. After selecting the data I want populated from the module I'm able to run the report but I only get like 5-6 results. Does anyone know why or how I can have the…

We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…

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…

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?

Hi I am trying to access this database on crystal reports so i can add another table to the PO_AutomaticReorderSelect report. I have full Admin Privileges. I have never seen this company before but the Report i want to change is in there. Any help…

We have products that we purchase from multiple vendors. We have the Vendor codes and descriptions set up as Vendor Alias' in Item maintenance. When we make a PO for a vendor and enter an item that has multiple Alias codes, it will actually print out…

I'm trying to figure out if there's a way to maintain separate Payroll check stubs with the new Payroll. Currently (v2015) the client has the top stub printing 'as is' out-of-the-box, but the bottom stub contains a subreport with the PR7 (data entry)…

When I build a crystal report using the database PO_VendorPriceLevel only, its showing some vendors that don't show up in MAS under item inquire/Vendor at all. How is this possible. I'm not sure if this is related to our price change problems.

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…

Hi... Using multi-part printing in invoicing. There is a criteria if there is a certain salesperson, then print the commission page in multi part printing. I was able to create a formula in crystal that will only print the copy if the condition is met…

I really like the presentation of "Days Delinquent" on the AR Aged Invoice Report and would like to do the same on the AR Statements. My problem is trying to find a good field that equals the "Statement Date" (with cut-off ability). What I've done so…

We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…

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…

I need to be able to consolidate inventory items on the printed purchase order after generating multiple Purchase Orders from multiple Sales Orders. The system can consolidate the vendor POs automatically by selecting it in the PO setup options but it…

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…