Sage 100

OK, Crystal Reports people, here's one to sink your teeth into. I've created a custom Sales Report from AR Invoice History Header file.(Needed the invoice specific detail for my various groupings, etc.) Customer has noticed that the totals don't match the Customer Sales History Report. The difference is any invoice line that they used /M charge on. They want my report reduced to match. OK, I can get fancy and use the Invoice History Detail to reduce the invoice total that I am reporting but A) I don't want to and don' t think I should have to. and B) It will slow the report down I'm sure. Am I missing something? Is there a non-saleable amount in the header somewhere?

As far as I know, no, there is nothing specific as to how much is inventory sales vs. misc chg/items in the header. The only breakout is taxable vs. non-taxable which could be either.

Well, yes, those are separate but I'm guessing he is already factoring those in @WayneSchulz . And don't forget discount!

Isn't freight and sales tax separate in the header too?

That's right @ThereseLogeais, It's ticking me off a bit, I just thought I'd throw it out before I changed the report. I'm calculating a ptd $, Ytd $ and even previous Ytd $. So, i'll have to total and subtract all the misc charg $s from each of those formulas. Oh well. Thanks for the reassurance!

Have you explained the reason for the difference and the consequence of trying to reconcile to a DIFFERENT sales report? I hate it when they try and reconcile different reports. They are usually for different purposes and can't always be reconciled penny for penny. I had one customer who said the custom sales report didn't reconcile to the GL sales accounts. Ever heard of changing the GL number on a line? Or having one return account vs. different sales accounts? He was okay with it once I explained it but criminy....

Yes, Their controller and I are on the same page but the Corporate guys(It's a local group of 3 companies owned by a larger out of state corporation) want the numbers closer at least. Not necessarily to the penny but apparently they flush a fair amount of stuff through their misc codes.

How about a subreport from CI_ItemHistoryByPeriod for the misc. amounts at the end of the report?? Might be quicker. Just a thought.

Therese I was thinking along the same lines.