TAAS

Files Added.

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

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)

ISSUE FOUND *****
1.PREVENT DUPLICATION WHILE UPDATION
( EDIT MODE )

ISSUE FOUND *****
1.CANT ADD NEW CREDIT LIMIT
2.FIX BUGS ON 'MODIFIED BY'
('MODIFIED BY' STATUS MISSING IN EDIT MODE)

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)

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

ISSUE FOUNDED

1.SHOWING ALL ACT US CUSTOMER ACCOUNTS THAT ARE NOT RELATED WITH CREDIT

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.

ISSUE FOUNDED

1.DATA DISAPPEARING WHILE SAVE AND ADD ASSIGNED USER AND UPDATE

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

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

Gui Changes As per PageDOC001. Ask junaid for changes page

Gui Changes done

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

Extra Credit Limit GUI Changes Done =============================
1) GUI Heading and Menu Leabel Change to 'Extra Credit Limit/Payment Days'

new changes coding done

ISSUE FOUNDED

1.Fix Bugs On Print

ISSUE FIXED

1.Fix Bugs On Print

ISSUE FOUNDED

1.Missing Data In Credit Limit Tab

ISSUE FIXED

1.Missing Data In Credit Limit Tab

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.

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.

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'

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

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.