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?
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"
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.
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.