Project

General

Profile

Edit Copy Actions

Feature #123

open

Extra Credit Limit/Payment Days

Added by Anil KV about 2 years ago. Updated 2 months ago.

Status:
New Changes
Priority:
Normal
Assignee:
Target version:
Start date:
01/12/2023
Due date:
% Done:

50%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Credit Limit
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Extra Credit Limit

Resign -> Karthika


Files

1-CsModel.cs (2.78 KB) 1-CsModel.cs Muhasin PU, 01/12/2023 11:39 AM
2-tsModel.ts (1.82 KB) 2-tsModel.ts Muhasin PU, 01/12/2023 11:39 AM
3-CsFile.cs (17.4 KB) 3-CsFile.cs Muhasin PU, 01/12/2023 11:39 AM
4-CsControllerFile.cs (32.8 KB) 4-CsControllerFile.cs Muhasin PU, 01/12/2023 11:39 AM
6-HtmlFile.html (1.93 KB) 6-HtmlFile.html Muhasin PU, 01/12/2023 11:39 AM
5-TsFile.ts (15.9 KB) 5-TsFile.ts Muhasin PU, 01/12/2023 11:39 AM
sql.sql (15.8 KB) sql.sql Muhasin PU, 01/12/2023 11:39 AM

Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M about 2 years ago

  • Assignee changed from Junaid M to Muhasin PU

Updated by Muhasin PU about 2 years ago

Status : GlobalDataService -> lstApprovalStatus

Actions #4

Updated by Muhasin PU about 2 years ago

  • Assignee changed from Muhasin PU to Karthika V Anand
Actions #5

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
Actions #6

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

Actions #8

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)

Actions #10

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 )

Actions #12

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)

Actions #14

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)

Actions #16

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

Actions #18

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

Actions #20

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

TESTING DONE

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.

Actions #23

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

TESTING DONE

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

Actions #26

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
Actions #27

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 Anonymous over 1 year ago

TESTING 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

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'

Actions #35

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 unnikannan S 11 months ago

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

ISSUE FOUNDED

1.Fix Bugs On Print

Updated by Vivekp V 11 months ago

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

ISSUE FIXED

1.Fix Bugs On Print

Updated by unnikannan S 11 months ago

TESTING DONE

Updated by unnikannan S 6 months ago

  • Subject changed from Extra Credit Limit to Extra Credit Limit/Payment Days
  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.Missing Data In Credit Limit Tab

Updated by Vivekp V 5 months ago

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

ISSUE FIXED

1.Missing Data In Credit Limit Tab

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'

Actions #45

Updated by Vivekp V 4 months ago

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

Updated by Arathy PS 3 months ago

  • Status changed from Reopen Bugs Coding Done to New Changes
  • Assignee changed from Vivekp V to Athira KK
  • % Done changed from 70 to 50

NEW CHANGES
--------------------------------------------
1. Add a new field in the drop down - pax profile

Actions #47

Updated by Athira KK 3 months ago

  • Status changed from New Changes to Coding Done
  • % Done changed from 50 to 60

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.

Actions #49

Updated by Athira KK 2 months ago

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

Updated by Arathy PS 2 months ago

  • Status changed from Reopen Bugs Coding Done to New Changes
  • % Done changed from 70 to 50
Edit Copy Actions

Also available in: Atom PDF