Table of Contents

Weekly Hours is set to zero when importing Employee IIF in Reckon Accounts

REFERENCE: RAD-1631

ISSUE

When importing an Employee IIF file to your Reckon Accounts Company File, the Weekly Hours are updated to 0:00 (Time format: Minutes) or 0.00 (Time format: Decimal).

This may also affect the Leave Details fields such as- Hours available, Hours Used, and Hours Accrued.



CAUSE

The IIF file was opened in a spreadsheet application such as Microsoft Excel and the value i.e. 38:00:00 is automatically converted into a Date format.



WORKAROUND

Use General Format with a Decimal value.

Example where the format is <hours:minutes:seconds>:

  1. 40:00:00 = 40
  2. 37:30:00 = 37.5






How did we do?

Reckon Accounts Desktop: The date is in the wrong format, the correct format is MM/DD/YY

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)