Feature #123
openExtra Credit Limit/Payment Days
50%
Files
Subtasks
Related issues
Updated by Junaid M about 2 years ago
- Assignee changed from Junaid M to Muhasin PU
Updated by Muhasin PU about 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
Files Added.
Updated by Muhasin PU about 2 years ago
Status : GlobalDataService -> lstApprovalStatus
Updated by Muhasin PU about 2 years ago
- Assignee changed from Muhasin PU to Karthika V Anand
Updated by Karthika V Anand about 2 years ago
- Status changed from New to Coding Started
- Start date changed from 01/10/2023 to 01/12/2023
- % Done changed from 0 to 40
Updated by Karthika V Anand about 2 years ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by Amal Cyriac about 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.USE DD/MM/YYYY FORMAT IN GRID
2.SET VALIDATION OM EXTRA DAYS & EXTRA LIMIT
( IF THESE INPUT BOXES ARE EMPTY GUI CRASHING)
3.FIX ALIGNMENT OF DROP DOWN LABEL TOGGLE
(ASSIGNED USER)
4.SERVER ERROR WHILE SAVING
P0001: jsnSqlRes: {"sinSqlCustomStatus" : 1, "strSqlCustomStatusCode" : "ERROR", "strSqlCustomMessage" : "ExtraCreditLimit Save Failed", "strSqlCustomErrorType" : "DATABASE_SYSTEM_ERROR", "strSqlCustomErrorCode" : null, "strSqlSysMessage" : "insert or update on table \"tbl_extra_limit\" violates foreign key constraint \"tbl_extra_limit_fk_account_id_fkey\"", "strSqlSysExceptionDetail" : "Key (fk_account_id)=(0) is not present in table \"tbl_account\".", "strSqlSysExceptionHint" : "SQL statement \"INSERT INTO creditlimit.tbl_extra_limit (fk_account_id,\n\t\t\t\t\t\tdat_effective_from,\n\t\t\t\t\t\tdat_effective_to,\n\n\t\t\t\t\t\tarb_fk_branch_ids,\n\t\t\t\t\t\tarb_fk_department_ids,\n\t\t\t\t\t\tarb_fk_user_ids,\n\t\t\t\t\t\tdbl_extra_limit,\n\t\t\t\t\t\tsin_extra_days,\n\t\t\t\t\t\ttxt_remarks,\n\n\t\t\t\t\t\tfk_assigned_user_group_id,\n\t\t\t\t\t\tfk_assigned_user_id,\n\t\t\t\t\t\tfk_approve_user_id,\n\t\t\t\t\t\tdtm_approval,\n\t\t\t\t\t\ttxt_approval_remarks,\n\t\t\t\t\t\tsin_approval_status,\n\n\t\t\t\t\t\tsin_record_status,\n\t\t\t\t\t\tsin_order,\n\n\n\t\t\t\t\t\tint_sys_action_id,\n\t\t\t\t\t\tfk_created_user_id,\n\t\t\t\t\t\tdtm_created)\n VALUES(CAST(jsnExtraLimit>>'binAccountId' AS BIGINT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'datEffectiveFrom' AS DATE),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'datEffectiveTo' AS DATE),\n\n\t\t\t\t\t\tSTRING_TO_ARRAY(jsnExtraLimit->>'strDbArlFkBranchIds', ',')::BIGINT[],\n\t\t\t\t\t\tSTRING_TO_ARRAY(jsnExtraLimit->>'strDbArlFkDepartmentIds', ',')::BIGINT[],\n\t\t\t\t\t\tSTRING_TO_ARRAY(jsnExtraLimit->>'strDbArlFkUserIds', ',')::BIGINT[],\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'dblExtraLimit' AS DOUBLE PRECISION),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'sinExtraDays' AS SMALLINT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'strRemarks' AS TEXT),\n\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'binAssignedUserGroupId' AS BIGINT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'binAssignedUserId' AS BIGINT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'binApproveUserId' AS BIGINT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'dtmApproval' AS TIMESTAMP WITH TIME ZONE),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'strApprovalRemarks' AS TEXT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'sinApprovalStatus' AS SMALLINT),\n\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'sinRecordStatus' AS SMALLINT),\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'sinOrder' AS SMALLINT),\n\n\n\t\t\t\t\t\t0,\n\t\t\t\t\t\tCAST(jsnExtraLimit->>'binCreatedUserId' AS BIGINT),\n\t\t\t\t\t\tdtmCurrent) RETURNING pk_extra_limit_id\"\nPL/pgSQL function sp_insert_or_update_extra_limit(jsonb) line 14 at SQL statement", "binSqlPk" : null, "strSqlDocNo" : null, "dctSqlOtherData" : null}
5.USE PROPER COLOR FOR INDICATION STAR
6.SET BRANCH WIDGET RED & REQUIRED
Updated by Karthika V Anand 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.SHOWING ERROR ALERT WHILE SAVE CREDI LIMIT
(42883: procedure sp_insert_or_update_extra_limit(jsonb, unknown) does not exist)
2.FIX BUGS ON SAVE BUTTON
(SAME RAW REPEATEDLY SAVING)
Updated by Karthika V Anand 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.PREVENT DUPLICATION WHILE UPDATION
( EDIT MODE )
Updated by Karthika V Anand 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.CANT ADD NEW CREDIT LIMIT
2.FIX BUGS ON 'MODIFIED BY'
('MODIFIED BY' STATUS MISSING IN EDIT MODE)
Updated by Karthika V Anand 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.Prevent auto completion from other accounts
(Party - Selection box- Set as only Supplier & Customer)
2.Fix bugs on Grid
(Duplication-Edit Mode)
Updated by Karthika V Anand 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.Displaying "updated by another use" alert while update credit limit
(approve / reject credit limit on 'Credit Approve' module )
2.Prevent auto completion - accounts without credit limit
(Customer/Supplier input box)
3.Not allow edit/change credit limit after approve
Updated by Karthika V Anand 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.SHOWING ALL ACT US CUSTOMER ACCOUNTS THAT ARE NOT RELATED WITH CREDIT
Updated by Karthika V Anand over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Seema Mathew over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By changed from unnikannan S to Seema Mathew
ISSUE FOUNDED-
1.SHOWING VALIDATION WHILE ADDING SAME EFFECTIVE DATE.(Please select a valid Period effective date)
2.CORRECT THE PRINT AMOUNT ALIGNMENT LEFT TO RIGHT.
Updated by Karthika V Anand 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
- Tested By changed from Seema Mathew to unnikannan S
ISSUE FOUNDED
1.DATA DISAPPEARING WHILE SAVE AND ADD ASSIGNED USER AND UPDATE
Updated by Karthika V Anand over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Junaid M over 1 year ago
- Assignee changed from Karthika V Anand to Vivekp V
Updated by unnikannan S over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.ISSUE IN ASSIGNED USER DROP DOWN ADDING
2.DONT ALLOW TO ADD ACT US CLIENT/SUPPLIER A/C,S EXCEPT-SUPPLIER,AIRLINE,COA LEDGERS,COMMISSION AGENT,EMPLOYEE,CUSTOMER
Updated by Vivekp V over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE fixed
1.ISSUE IN ASSIGNED USER DROP DOWN ADDING
2.DONT ALLOW TO ADD ACT US CLIENT/SUPPLIER A/C,S EXCEPT-SUPPLIER,AIRLINE,COA LEDGERS,COMMISSION AGENT,EMPLOYEE,CUSTOMER
Updated by Junaid M about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
Gui Changes As per PageDOC001. Ask junaid for changes page
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Gui Changes done
Updated by Junaid M about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
Extra Credit Limit GUI Changes ============================= 1) GUI Heading and Menu Leabel Change to 'Extra Credit Limit/Payment Days' Payment Exceed Report - ================================= Check -> Customer Overdue Report -> Supplier Overdue Report
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Extra Credit Limit GUI Changes Done
=============================
1) GUI Heading and Menu Leabel Change to 'Extra Credit Limit/Payment Days'
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs Coding Done to New Changes
- % Done changed from 70 to 50
Updated by Vivekp V about 1 year ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
new changes coding done
Updated by Arathy PS 4 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
-----------------------------------
1. Data order on credit limit tab
Current Balance Payment Terms Credit Limit Grace Period Days Extra Limit Extra Days Current Extra Limit Current Extra Days Total Limit Total Grace & Extra Days Exceed Limit Due Days 10--*1(15--*2) Doc Due Payment Date(Based on Payment Terms (imp not consider Grace & Extra Days)) --*1 -> ((Payment Date - Bill Period End Days) - Total Grace & Extra Days) --*2 -> ((Payment Date - Bill Period End Days)
2. Missing data on modified by on edit mode.
Updated by Vivekp V 4 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
ISSUE FIXED
-----------------------------------
1. Data order on credit limit tab
Current Balance Payment Terms
Credit Limit Grace Period Days
Extra Limit Extra Days
Current Extra Limit Current Extra Days
Total Limit Total Grace & Extra Days
Exceed Limit Due Days 10--*1(15--*2)
Doc Due Payment Date(Based on Payment Terms (imp not consider Grace & Extra Days))
--*1 > ((Payment Date - Bill Period End Days) - Total Grace & Extra Days)*2 -> ((Payment Date - Bill Period End Days)
-
2. Missing data on modified by on edit mode.
Updated by Arathy PS 4 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
--------------------------------------------------
1. Total days--> total grace and extra days.
2. Wrong data on due date and payment date.
3. Add title on 'based on current date'
Updated by Arathy PS 2 months ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUND
---------------------------------------------
Showing due date and payment date without without having any overdue.
NEW CHANGES
-------------------------------------
1. From current balance to exceed limit should have two columns, 1st column should show the values based on what we selected in admin settings and 2nd column should show debit credit net.
2. Extra Limit and Current Extra Limit values not in bold 'exceed limit' text in bold.