Rounding issue on Labor Ticket Detail Report

We use the Labor Ticket Detail Report to process payroll (and avoid having a duplicate scan/swipe system in addition to Visual for payroll). I noticed last week that both the labor ticket view and the labor ticket detail report round hours for .XX. The report then summarizes the ROUNDED hours to give total hours, which can either over or underpay your employees based on rounding (and it's more of a "pride" issue, as someone who works 40 hours may only get paid for 39.98 hours and feel like they missed time). I did find the report under GUPTA, but I cannot figure out how to add a decimal to the report.

Has anyone else encountered this? I'm also going to submit a ticket to Infor.

Thanks,

Jarrod

com_2010feb_proactive.pdf

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

nancy-miller

did you try changing the precision on the fields? in a different report (PO), I had to change precision (format = #,##0.000) on the detail, then total worked out.

Legacy Contributor

I did try that, but it does not allow me to change? My dropdowns do not include more than two decimal places, and I can manually add the final decimal to show #,##0.000, but when I save, it reverts back to #,##0.00. Did you have to change rights somewhere to save? I'm logged into the server as the admin.

Jarrod

Legacy Contributor

check the DB table, see how many decimals it is set to. You may have to change it.

SC_DQSub_May182020.pptx

Copyright © 2025 Infor. All rights reserved.