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''
Custom report
Jan 28, 2010
1 Replies
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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required