I am still getting below error '' error reading report file c:/programefiles/microsoft retail management system/storeoprations/report/custom-detail sales with tax collected.grp at line #244(transaction.saletax/(transaction entry.price*transaction entry.qty))end''
Gill - the syntax is not right. On your error message, there's syntax that doesn't apply to the tables, such as "transaction.saletax" and "transactionentry.qty"
The formula should read like this (as a single line) "CASE WHEN TransactionEntry.Price = 0 THEN 0 ELSE (TransactionEntry.SalesTax/(TransactionEntry.Price*TransactionEntry.Quantity)) END"
Remember to turn off the word wrap on the notepad. Hope this resolves the error.
"Gill" wrote:
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.