Description: Starting in LO 7.1.3 Currency Amount columns in all Form displayed amounts are off by -$.01 The forms are all sourced from summed SQL queries in query design. The SQL queries when open have the correct amounts. Steps to Reproduce: 1.Tested queries in design view vs form view 2.Uninstalled LO 7.1 and reinstalled 7.0 3.After reinstallation Forms displayed correct amounts in 7.0 Actual Results: $100.00 in form view $100.01 in query design view Expected Results: $100.00 in form view $100.01 in query design view Reproducible: Always User Profile Reset: No Additional Info: Form view should equal Query design view
Deleted affected forms and created new ones. Forms now show correct balances
Deleted affected forms and created new ones. Forms now show correct balances. Narrowed down the issue. I originally inserted the affected field in the form as a currency field. This currency field was somehow affected by version 7.1 as $.01 less than the actual balance. By creating new forms the affected field was now a formatted field which I formatted as currency and the correct balance is now displayed.