Browse By Tags

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

I'm looking for assistance on an Inventory Valuation Report. I'd like the report to sort via valuation. The highest values descending to lowest. I can't export to Excel and sort that way because of serial numbers. Does anyone have ideas on how to…

Hi, I am trying to export my sage spreadsheet to excel with the stipulation that all relevant cells populate with the spreadsheet formula as it is set up in the sage spreadsheet (i.e. an item's total amount contains a formula that is the sum of all…

Hello, We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…

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…

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…

Sage 100 - P/R 2.20 After reviewing the Loan Forgiveness Application and Instructions, I am finding I need data which should be in P/R but am unable to locate. It appears all of the Reports are for quarter summaries and I need to access data from…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

Is it possible to get a report of all client emails from Sage?

Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…

Is there a way to do a profit report per customer?

Is there a report that allows me to see the gross sales by customer? Sage 100 2017 Contractor

I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…