HQ Detailed Sales Report - Total-Cost<>Profit

If you can explain this, I would *love* to hear from you:

I have a Custom report called Custom - Detailed Sales with Cost & Profit. I'm not sure where it came from, but I don't think I created it by modifying an existing report. In any case, the Cost & Profit don't add up to the Total.

The formulae involved: Total = TransactionEntry.Price * TransactionEntry.Quantity Cost = TransactionEntry.Cost * TransactionEntry.Quantity Profit = (TransactionEntry.Price * TransactionEntry.Quantity) - (TransactionEntry.Cost * TransactionEntry.Quantity)

How can this not add up?

Does anyone have an *accurate* HQ Detailed Sales report that shows cost & profit data?

Tom

Reply to
Terrible Tom
Loading thread data ...

Hi Tom,

I just tried your email address as supplied in your profile. It failed. Twice.

Reply to
jocelynp

Sorry about the e-mail. I've dropped my signature line, which included the advice 'stop fishing for e-mail'.

No matter. I don't know what the problem was, but by the afternoon the report added up again. I am still baffled as to why if didn't add up first thing in the morning, but the last report I ran did indeed add up.

Thanks, Tom St> Hi Tom,

Reply to
Terrible Tom

I am not sure why it would not add up, but I can tell you that the report you are referring to is a Customer Source one. I have the same set of reports that I remember getting from here.

I have a crazy one that I might post about today, so if you are looking for a good problem, you may want to check it out...All if I have time to get it together and worded correctly for posting.

Reply to
jocelynp

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.