Go to A/R |  Explore | Open Invoice View  or  Customer History Invoices View.

Right click at the top of any column in the upper grid and select column settings.

Click the add button.  (assuming you are in AR_OpenInvoice)  Select CostofSalesAmt.

Thank you for replying, Tom. I have played with Explore, but not enough, apparently. I even figured out how to look at just one invoice, and see a chart for just that one, although for some reason. only the pie chart actually lists the totals. It would be more helpful if I could print it all out on one page, instead of a row of tiny font across the top of three pages. Seriously, SAGE, what's your deal with conserving paper while wasting it at the same time?

I'm a little closer to getting the data that I want. My next goal is to find some way to print out a report/invoice for internal use only, showing cost and price per item, amount/percentage of profit per item, and grand totals. It's frustrating because our last software package could give us precisely that in an invoice history detail report, and we used it quite often.

Melinda,

You can get totals in the explorer by selecting a column to group by.   Then right click on any one of the group headers that appear and select group summary footer.  Boxes will appear under columns that you might summarize and then you can specify whether to sum the columns (max, min, etc.).

It's all there,  you just need the knowledge/experience to take advantage of what is there.  Sage 100 has some very powerful customizing tools but as with anything,  if you don't know how to use them, they do you no good but they do give you the ability to tailor to your specific needs.   There are many ways to do various things, some of which are better suited to a specific task.   You can use Crystal Reports to create whole new reports,  you use crystal reports to tailor canned reports.   You can use the business insights reporter to help you create custom crystal reports.  The insights explorer is just one of many tools available.

You might want to talk with your Sage partner to give you some training.  I spend a lot of time with my clients helping them understand the power of the program to make your life easier.   Many a time I will pick up new clients that are highly dissatisfied because they have not learned how to use the program.  Once they have become educated,  they usually won't consider using another program.   That's not to say that Sage 100 will meet everyone's needs,  but it can go a long ways with all the tools available to you.

Thanks again, Tom. We will all have to play a bit with some of the features to become better acquainted with them--it's been kind of a "seat of the pants" mode to learn what we need to for basic operations. The three of us who use Sage plan to go to the summit this summer. By then we might actually feel familiar enough with the program to understand the things that we're being told. ;)

I started a customized Invoice History Report in Crystal to see if I can get the columns added that I want. Of course, it will only be as useful as the information put into the program, which we determined may not be as accurate as we thought or were hoping. Our Sage reseller has not been as proactive as we'd hoped in the past as far as keeping us apprised of training opportunities.

One thing to note on doing a customized Invoice History Report,  don't start it from scratch.   Use the existing one and add the info you need.   If that information is not present in the work file,  most of the time you can use custom office to add it to the work file.   It will be much easier and will probably run faster.

Hope I see you at Summit! 

I'm modifying the current one, but am stuck on a formula for a sum for the extended costs of the items. I probably need to actually read the Crystal manual doc that our reseller sent.

Edit: I had a breakthrough and got the formula for the sum figured out. Now I may work on a report that just gives totals rather than itemizes each invoice.