Sales and Sales Analysis Reports - Expression Errors
SME Accounting package, General Ledger, Debtors, Creditors, Stock
Brought to you by:
philipdc
Menu
▾
▴
#472 Sales and Sales Analysis Reports - Expression Errors
Invoices in Sales and Sales Analysis Reports - Expression Errors “ Division by zero:Expression TrpExpression12”, etc.
These errors are not replicated in all Sets of Books.
The errors with the errors on Expressions “ Division by zero:Expression TrpExpression12”, etc. have been resolved – This will be included in the next release (build 412 onwards):
Changed the SQL of all the applicable expressions in all sales reports from
“ 100 +( - DOCUMENTLINE.FUNITCOST * DOCUMENTLINE.QtyShipped / DOCUMENTLINE.TOTALEXC * 100) “ to
“ IIF(DOCUMENTLINE.TOTALEXC=0,0, 100 +( - DOCUMENTLINE.FUNITCOST * DOCUMENTLINE.QtyShipped / DOCUMENTLINE.TOTALEXC * 100)) “
Fixed in http://sourceforge.net/projects/turbocash/files/TurboCASH5/Development-Beta/TurboCASH-500412-setup.exe/download.