Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Quickbooks Connector Bug

Chandra Gogineni User

Please enter hours for an employee in timesheets in decimal format like 8.5, 10.5..etc.

Run the following SQL

SELECT TOP (1000) [id]
      ,[name_of]
      ,[description]
      ,[hours]  
  FROM [quickbooks].[time_activity];

This will fetch only the integer part of the hours. Can you check and fix this bug? We are having lot of issues with this bug.

Thank you

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Elan User

    Hey Chandra, happy to help here! The TIME_ACTIVITY table also has a column called `minutes` which will give you the additional amount of time on top of the hour. Adding the hours and minutes together should get you the total time! 

    Hope that answers your question and let us know if you have any more!