Project

General

Profile

Edit Copy Actions

Feature #52

open

Paid Cheque

Added by Anil KV over 2 years ago. Updated about 1 month ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Target version:
Start date:
09/23/2022
Due date:
09/27/2022 (over 2 years late)
% Done:

90%

Estimated time:
32:00 h
Spent time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Paid Cheque
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Paid Cheque


Files

2-tsModel.ts (993 Bytes) 2-tsModel.ts Anil KV, 10/08/2022 04:13 PM
1-CsModel.cs (1.19 KB) 1-CsModel.cs Anil KV, 10/08/2022 04:13 PM
3-CsFile.cs (10.7 KB) 3-CsFile.cs Anil KV, 10/08/2022 04:13 PM
4-CsControllerFile.cs (24.3 KB) 4-CsControllerFile.cs Anil KV, 10/08/2022 04:13 PM
5-TsFile.ts (13.4 KB) 5-TsFile.ts Anil KV, 10/08/2022 04:13 PM
sql.sql (10.1 KB) sql.sql Anil KV, 10/08/2022 04:13 PM
6-HtmlFile.html (1.9 KB) 6-HtmlFile.html Anil KV, 10/08/2022 04:13 PM

Add

Subtasks


Add

Related issues

Updated by Anil KV over 2 years ago

Deletetion SP
sp_delete_account(binAccountId::BIGINT, intSysActionI::INT, binDeletedUserId::BIGINT, objSpOutRes);

Updated by Anil KV over 2 years ago

Ref: Customer #60

Updated by Anil KV over 2 years ago

accounts.tbl_account->sin_ac_category =
-- 16 = Current Cheque Issued Accounts
-- 17 = PDC Issued Accounts

Actions #5

Updated by Christy Saint over 2 years ago

  • Status changed from New to Coding Started
  • % Done changed from 0 to 40
Actions #6

Updated by Christy Saint over 2 years ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 40 to 60

Updated by Amal Cyriac over 2 years ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Amal Cyriac

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

Actions #8

Updated by Christy Saint over 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac over 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Updated by Amal Cyriac over 2 years ago

ISSUE FOUND *****
1.SET MANDATORY FIELDS REQUIRED AND RED
2.SET DEFAULT CURRENCY MANDATORY

Actions #11

Updated by Christy Saint over 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac over 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Actions #13

Updated by Christy Saint about 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac about 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Actions #15

Updated by Christy Saint about 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac about 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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}}
Actions #17

Updated by Christy Saint about 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac about 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Actions #19

Updated by Christy Saint about 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac almost 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Actions #21

Updated by Christy Saint almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac almost 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Actions #23

Updated by Christy Saint almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by Amal Cyriac almost 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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

Actions #25

Updated by Christy Saint almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by unnikannan S over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By changed from Amal Cyriac to unnikannan S

ISSUE FOUNDED

1.CHANGE TO ACTIVE TAB WHILE CHOOSING NEW BUTTON

Actions #27

Updated by Junaid M over 1 year ago

  • Assignee changed from Christy Saint to Sibin Babu
Actions #28

Updated by Sibin Babu over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by unnikannan S over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

TESTING DONE

Actions #30

Updated by Sibin Babu over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
Actions #31

Updated by Junaid M about 1 year ago

  • Assignee changed from Sibin Babu to Baseem Shan

Updated by unnikannan S about 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

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 )

Actions #33

Updated by Junaid M about 1 year ago

  • Assignee changed from Baseem Shan to Vivekp V

Updated by Vivekp V about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

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 )

Updated by unnikannan S 12 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

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

Updated by Vivekp V 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

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

Updated by unnikannan S 12 months ago

TESTING DONE

Updated by Arathy PS 5 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

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

Actions #39

Updated by Arathy PS 5 months ago

  • Assignee changed from Vivekp V to Greeshma S
Actions #40

Updated by Greeshma S 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions #41

Updated by Theja Ponon 4 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90

Updated by Arathy PS about 1 month ago

  • Status changed from Reopen Bugs Testing Done to Reopen Bugs
  • % Done changed from 90 to 50

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

Actions #43

Updated by Arathy PS about 1 month ago

  • Assignee changed from Greeshma S to Sreeranjini T
Actions #44

Updated by Sreeranjini T about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions #45

Updated by Arathy PS about 1 month ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
Edit Copy Actions

Also available in: Atom PDF