TAAS

ISSUE FOUND *****
1.SET MANDATORY FIELD RED
2.'PRIVILAGE TO' MANDATORY

ISSUE FOUND *****
1.SET VALIDATION ON MAXIMUM LIMIT

ISSUE FOUND *****
1.RESIZE GRID COLUMNS
2.SET VALIDATION ON MAXIMUM LIMIT
3.SET BRANCH MANDATORY

ISSUE FOUND *****
1.RESIZE STATUS COLUMN
2.ALLOW UPPER & LOWER CASE ON NAME

ISSUE FOUND *****
1.Main ledger set as mandatory
(Edit Mode --> change type and update)

P0001: jsnSqlRes: {"sinSqlCustomStatus" : 1, "strSqlCustomStatusCode" : "ERROR", "strSqlCustomMessage" : "Paid Cheque Save Faild", "strSqlCustomErrorType" : "DATABASE_SYSTEM_ERROR", "strSqlCustomErrorCode" : null, "strSqlSysMessage" : "insert or update on table \"tbl_account\" violates foreign key constraint \"tbl_account_fk_default_main_ledger_id_fkey\"", "strSqlSysExceptionDetail" : "Key (fk_default_main_ledger_id)=(0) is not present in table \"tbl_chart_of_ac\".", "strSqlSysExceptionHint" : "SQL statement \"UPDATE accounts.tbl_account SET vhr_account_code = jsnAccount>>'strAccountCode',\r\n vhr_mapping_code = jsnAccount->>'strMappingCode',\r\n vhr_reference_no = jsnAccount->>'strReferenceNo',\r\n vhr_account_name = jsnAccount->>'strAccountName',\r\n vhr_display_name = jsnAccount->>'strDisplayName',\r\n\r\n fk_category_id = CAST(jsnAccount->>'binCategoryId' AS BIGINT),\r\n fk_group_id = CAST(jsnAccount->>'binGroupId' AS BIGINT),\r\n fk_type_id = CAST(jsnAccount->>'binTypeId' AS BIGINT),\r\n fk_family_id = CAST(jsnAccount->>'binFamilyId' AS BIGINT),\r\n\r\n fk_default_main_ledger_id = CAST(jsnAccount->>'binDefaultMainLedgerId' AS BIGINT),\r\n fk_customer_main_ledger_id = CAST(jsnAccount->>'binCustomerMainLedgerId' AS BIGINT),\r\n fk_supplier_main_ledger_id = CAST(jsnAccount->>'binSupplierMainLedgerId' AS BIGINT),\r\n fk_commission_agent_main_ledger_id = CAST(jsnAccount->>'binCommissionAgentMainLedgerId' AS BIGINT),\r\n\r\n vhr_default_currency_code = jsnAccount->>'strDefaultCurrencyCode',\r\n art_currency_codes = STRING_TO_ARRAY(jsnAccount->>'strDbArtCurrencyCodes', ','):: VARCHAR[], \r\n\r\n sin_ac_category = CAST(jsnAccount->>'sinAcCategory' AS SMALLINT),\r\n sin_if_customer = CAST(jsnAccount->>'sinIfCustomer' AS SMALLINT),\r\n sin_if_supplier = CAST(jsnAccount->>'sinIfSupplier' AS SMALLINT),\r\n sin_if_commission_agent = CAST(jsnAccount->>'sinIfCommissionAgent' AS SMALLINT),\r\n\r\n sin_if_sys_account = CAST(jsnAccount->>'sinIfSysAccount' AS SMALLINT),\r\n sin_permission_to_all = CAST(jsnAccount->>'sinPermissionToAll' AS SMALLINT),\r\n ari_permitted_user_roles = STRING_TO_ARRAY(jsnAccount->>'strDbAriPermittedUserRoles', ',')::SMALLINT[],\r\n sin_sys_ac_type = CAST(jsnAccount->>'sinSysAcType' AS SMALLINT),\r\n\r\n txt_remarks = jsnAccount->>'strRemarks',\r\n txt_message = jsnAccount->>'strMessage',\r\n\r\n arb_fk_branch_ids = STRING_TO_ARRAY(jsnAccount->>'strDbArlFkBranchIds', ',')::BIGINT[],\r\n arb_fk_service_ids = STRING_TO_ARRAY(jsnAccount->>'strDbArlFkServiceIds', ',')::BIGINT[],\r\n\r\n vhr_phone = jsnAccount->>'strPhone',\r\n vhr_email = jsnAccount->>'strEmail',\r\n vhr_address = jsnAccount->>'strAddress',\r\n vhr_display_address = jsnAccount->>'strDisplayAddress',\r\n\r\n fk_approval_user_id = CAST(jsnAccount->>'binApprovalUserId' AS BIGINT),\r\n sin_approvel_status = CAST(jsnAccount->>'sinApprovelStatus' AS SMALLINT),\r\n\r\n sin_record_status = CAST(jsnAccount->>'sinRecordStatus' AS SMALLINT),\r\n sin_order = CAST(jsnAccount->>'sinOrder' AS SMALLINT),\r\n\r\n\r\n int_sys_action_id = int_sys_action_id + 1,\r\n fk_last_modified_user_id = CAST(jsnAccount->>'binLastModifiedUserId' AS BIGINT),\r\n dtm_last_modified = dtmCurrent\r\n WHERE pk_account_id = CAST(jsnAccount->>'binAccountId' AS BIGINT) RETURNING pk_account_id\"\nPL/pgSQL function sp_insert_or_update_account(jsonb) line 151 at SQL statement\nSQL statement \"CALL sp_insert_or_update_account(jsnAccount, jsnSpOutRes)\"\nPL/pgSQL function sp_insert_or_update_paid_cheque_acs(jsonb,jsonb,jsonb) line 31 at CALL", "binSqlPk" : 0, "binSqlLogPk" : 0, "strSqlDocNo" : null, "dctSqlOtherData" : {"binCustomerId": null, "strAccountCode": "PCH001", "binPaidChequeAcsId": null}}

ISSUE FOUND *****
1.Fix duplication bugs on grid
(Sort--> Update)

ISSUE FOUND *****
1.In Currency Multi Selection Box widget Tick "BASE1 (QAR)" Then Select "BASE1 (QAR)" as default currency

ISSUE FOUND *****
1.fix duplication error while save act as client

ISSUE FOUND *****
1.Set mandatory fields red and required
(Set red star on Status)
2.Set tool tips on GUI

ISSUE FOUNDED

1.CHANGE TO ACTIVE TAB WHILE CHOOSING NEW BUTTON

TESTING DONE

ISSUE FOUNDED

1.DONT ALLOW TO CLEAR THE ACT AS CHECK BOXES IN CASE IF THE ACCOUNT WAS ALREADY USED IN ANY DOCUMENT AS A PARTY
(Discuss With Anil Sir for Changes )

ISSUE FIXED

1.DONT ALLOW TO CLEAR THE ACT AS CHECK BOXES IN CASE IF THE ACCOUNT WAS ALREADY USED IN ANY DOCUMENT AS A PARTY
(Discuss With Anil Sir for Changes )

ISSUE FOUNDED

1.VALIDATION FOR BRANCH MULTY SELECTION
2.ADD BLANK OPTION IN AUTO INV BRANCH SELECT FIELD

ISSUE FIXED

1.VALIDATION FOR BRANCH MULTY SELECTION
2.ADD BLANK OPTION IN AUTO INV BRANCH SELECT FIELD

ISSUE FOUND
---------------
1. Deleted account still showing in the UI after deletion
2. Imported accounts cannot be deleted if approved from account approve

ISSUE FIXED
------------------
Act as client should be default untick.