Feature #52
openPaid Cheque
Added by Anil KV over 2 years ago. Updated about 1 month ago.
90%
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 |
Subtasks
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
accounts.tbl_account->sin_ac_category =
-- 16 = Current Cheque Issued Accounts
-- 17 = PDC Issued Accounts
Updated by Anil KV over 2 years ago
- File 1-CsModel.cs 1-CsModel.cs added
- File 2-tsModel.ts 2-tsModel.ts added
- File 3-CsFile.cs 3-CsFile.cs added
- File 4-CsControllerFile.cs 4-CsControllerFile.cs added
- File 5-TsFile.ts 5-TsFile.ts added
- File 6-HtmlFile.html 6-HtmlFile.html added
- File sql.sql sql.sql added
Updated by Christy Saint over 2 years ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
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
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
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
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
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}}
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)
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
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
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
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
Updated by Junaid M over 1 year ago
- Assignee changed from Christy Saint to Sibin Babu
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
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 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 )
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 Greeshma S 5 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
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.
Updated by Arathy PS about 1 month ago
- Assignee changed from Greeshma S to Sreeranjini T
Updated by Sreeranjini T about 1 month ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
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