Cost for generic item

We use a generic item for special orders, the problem is my cost is always zero and messes up my profit report. is there anyway to set up an item so by entering the selling price at the POS it would assign a cost based on a fixed margin ie 40% that was assigned to the generic item?

Reply to
Shoeman240
Loading thread data ...

It would be easier to modify the report to account for that issue. Here is an example of a profit formula that uses nested case statments. You could add another criteria to account for the item.id or transactionentry.cost=0. Make sure the formula is all on one line and now wrapped.

"Case When Sum(transactionentry.Price * TransactionEntry.Quantity) 0 Then (Case When Sum(transactionentry.Price * TransactionEntry.Quantity) 0 Then (Sum((transactionentry.Price * TransactionEntry.Quantity) - (transactionentry.Cost * TransactionEntry.Quantity)))/Sum(transactionentry.Price * TransactionEntry.Quantity)*SUM(transactionentry.Price * TransactionEntry.Quantity)/ABS(Sum(transactionentry.Price * TransactionEntry.Quantity)) Else 100 End) Else 0 END"

Reply to
Matt Hurst

Matt, I am having the same problem, could you please elaborate on your solution?

-- Thanks! David D. L.S.B.

"Matt Hurst" wrote:

Reply to
David D.

David, since you use POS2009, I'm not sure what the reporting language looks like. I can assume it is the same, but since I use RMS I don't know. The point of this post was to use nested case statements in the profit formula to account for the 'devide by zero' errors of a profit calculation when the cost=0.

Reply to
Matt Hurst

Reply to
Jack of All Bea

Jack,

That is a beautifully simple solution. Who'd uv thunk it?

Craig "Jack of All Beads" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Craig

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.