Skip to main content

INTEGRATION OF QUICKBOOKS WITH CENTRAHUB HCM

 

Application integration is the merging and optimization of data and workflows between two disparate software applications.

Our application integration services enable the sharing of processes and business data among a wide range of applications in an organization. This means seamlessly connecting all variety of on-premise and cloud apps to transform and orchestrate the data required for business workflows.

Steps to integrate Central hub HCM with QuickBooks:

Step 1:

·         Login into QuickBooks using the below URL if you don’t have QuickBooks logins, please create a login in   https://developer.intuit.com 

·         Click on Create an app button


·         Provide the name and select the scope and click on create app

·         Enter the redirect URL as http://localhost/Focus.Web.Focus8/QBService

·         Copy the client id and client secret key and navigate to Global preferences >> ERP integration and enter the same under client key & secret fields.

·         After entering all the details click on ‘Connect to QuickBooks’ application would ask for quick book credentials, please provide details and authenticate.

Step 2: Integration of Employee details with QuickBooks.

·         In the workflow configure the employee master and account master to sync

·         Select Employee Master on Execute on 

·         Select Update on Evaluate on field so that after every employee master record update records would be transferred to quick books

·         Select ERP type as QuickBooks.

Below screenshots resembles the same.


Step 3:

·         Click on Actions and select Create module

·         Define Source fields & Destination fields (QuickBooks fields) which needs to be integrated with QuickBooks.

Step 4: Integration of Account details with QuickBooks.

·         In the workflow configure the employee master and account master to sync

·         Select Account on Execute on 

·         Select Create Evaluate on 

·         Select ERP type as QuickBooks.

Below screenshots resembles the same.

·         Create module and map source and Destination fields.

Step 4:

·         Navigate to Hcm >> Payroll single/Multiple employee pay and run the payroll for the month.

·         Navigate to post payroll entries and select the required Paybatch, Pay frequency & type, and save.

·         We can now check the employee master details in the quick books @ API Docs and Tools à Sandbox Company àWorkersà Employees.

Check the FA posting entries @ Reports à Journal






















Labels:

Comments

Post a Comment

Popular posts from this blog

TDS details in Payslip

TDS variables are added in the payslip to display the tax details for employees. These variables will give a clear idea to the employee of what is the taxable income, total tax per year to be deducted, tax deducted till date and the balance tax which he needs to pay. Follow the steps below. 1. Create the payroll components as mentioned below under Deductions. TDS_TotalTaxableIncome TDS_TotalTax TDS_PrevEmployerTDS TDS_TaxDeductedYTD TDS_BalanceTax 2. Go to deduction preferences, and add the TDS variable exactly with the same name under formula. Below is the screen shot for reference. 3. The values of TDS variables will be displayed in the payroll preview screen. The same will be displayed in the payslip, once these variables are mapped to the payslip. Note: 1. Priority Order: TDS variables should be placed after TDS component. Sample Payslip with TDS variable:
3 comments
Read more

Advance Leave Encashment

This option is for leave encashment for advance leaves. There are two scenarios here: 1. If payment type is selected as continuous in leave encashment screen, then the leave encashment salary will be credited through the payroll. 2. If payment type is selected as advance in leave encashment screen, then the leave encashment salary will not be credited through payroll but in the print layout, encash amount can be viewed. Settings>>Customization>>Leaves>>Leave Encashment>>Print layout Note: Employee Account and Salary Account should be mapped in the Employee master Follow the below steps for FA posting: 1. Create two account master fields in leave encashment screen as shown in the below screen. In the above two screens, two accounts are created. One is Company account in the first screen and Emp account in the second screen. Employee account is created to credit the encash amount and add these two fields in page layout of leave encashment. 2. Run below stored pro...
Post a Comment
Read more

Using Stored Procedure in the Earning/Deduction Formulas

Naming Convention : Stored Procedure Name : pPay_GetData1 Variable to use above stored procedure : fPay1 Advantages: we can assign multiple earning/deduction values using single stored procedure Eg : CREATE PROCEDURE pPay_GetData1 (      @xmlIn AS XML = NULL      ,@xmlOut AS XML = NULL OUT      ,@Result AS DECIMAL(18, 4) OUT      ) AS BEGIN      SET NOCOUNT ON;      SET @xmlOut = @xmlIn     DECLARE @EmpId AS VARCHAR(max),@PayrollRefType AS VARCHAR(100)      declare @ToDate as int=0     declare @BonusFromDate as int=0,@BonusToDate as int=0     --Retriving Employee Id      SELECT @EmpId = v.value('iEmpId[1]', 'varchar(max)')      FROM @xmlIn.nodes('/PayrollData') x(v)     --Retriving Payroll Date      SELECT @ToDate = v.value('...
Post a Comment
Read more