Browse By Tags

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…

So my attorney charges her clients a retainer fee based on the type of case she is handling (so each client can have a completely difference retainer amount), and on top of that, she is billing AGAINST the retainer. We were generating bills in Word format…

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…

Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…

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…

Trying to figure out how to invoice clients who have flat rate task and hourly task on one bill Example file application- flat $1400 report application as filed $18/ hrly can I invoice a flat rate task and an hourly task? Can I invoice a flat rate…

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…

Hello! Thank you in advance! I am attempting to pull payments received from 01/01/19 - 08/31/19 only for invoices dated 01/01/19 - 08/31/19. Any report I try to create ends up pulling in payments that I've recorded during that time frame, regardless…

Hi, I'm using Sage 50. Could anyone help me on how to run a sales report which can show Item Description from the invoice? Thanks

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…

I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…

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…

I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.

The AP Open Invoice report does not provide GL detail. The AP Invoice G/L Distribution Report does not given an option to run for only Open invoices. I have played around with Exports in both AP and GL but don't see where I can get this data. …

We are having an issue where the latest payment of a customer is not being reflected in a printed invoice. This issue only happens on very rare occasions, and we do not receive any errors or notifications before it happens. Below are a few observations…