HQ Detailed Sales Report - Total-Cost<>Profit

Sep 19, 2006 3 Replies
T

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



Vote
Twitter Facebook LinkedIn
J

Hi Tom,

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

Vote
Twitter Facebook LinkedIn
T

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,

Vote
Twitter Facebook LinkedIn
J

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.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required