Feature #60
openCustomer
Added by Anil KV over 2 years ago. Updated 11 days ago.
70%
Files
1-CsModel.cs (3.12 KB) 1-CsModel.cs | Anil KV, 09/27/2022 07:21 PM | ||
2-tsModel.ts (2.38 KB) 2-tsModel.ts | Anil KV, 09/27/2022 07:21 PM | ||
3-CsFile.cs (9.96 KB) 3-CsFile.cs | Anil KV, 09/27/2022 07:21 PM | ||
4-CsControllerFile.cs (25.3 KB) 4-CsControllerFile.cs | Anil KV, 09/27/2022 07:21 PM | ||
sql.sql (16.2 KB) sql.sql | Anil KV, 09/27/2022 07:21 PM | ||
5-TsFile.ts (14.3 KB) 5-TsFile.ts | Anil KV, 09/27/2022 07:21 PM | ||
SqlContract.sql (4.58 KB) SqlContract.sql | Anil KV, 09/27/2022 07:21 PM | ||
SqlAllAccounts.sql (151 KB) SqlAllAccounts.sql | Anil KV, 09/27/2022 07:21 PM | ||
SqlPersonal.sql (10.1 KB) SqlPersonal.sql | Anil KV, 09/27/2022 07:21 PM | ||
SqlSupplier.sql (16.6 KB) SqlSupplier.sql | Anil KV, 09/27/2022 07:21 PM | ||
clipboard-202501201424-gklge.png (139 KB) clipboard-202501201424-gklge.png | Arathy PS, 01/20/2025 02:24 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
- 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 sql.sql sql.sql added
- File SqlAllAccounts.sql SqlAllAccounts.sql added
- File SqlContract.sql SqlContract.sql added
- File SqlPersonal.sql SqlPersonal.sql added
- File SqlSupplier.sql SqlSupplier.sql added
Updated by Muhasin PU over 2 years ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
Updated by Anil KV over 2 years ago
accounts.tbl_account->sin_ac_category = 18
Updated by Muhasin PU over 2 years ago
- Status changed from Coding Started to Particialy Coding Done
- % Done changed from 40 to 30
Counter Staff & Commission Agent Binding Pending..
Defalut Selected Items --> Pending..
Updated by Muhasin PU over 2 years ago
- Status changed from Particialy Coding Done to Coding Done
- % Done changed from 40 to 60
RECO TYPE PENDING..
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 FOUNDED
*****
1.SET MAIN LEDGER MANDATORY
2.ALLOW DUPLICATION ON NAME
3.ADDITIONAL INFO--> COUNTER STAFF ADD ERROR
4.CONTRACT --> SET VALIDATION ON DATE
DONT ALLOW UPDATE WITHOUT PROPER DATA
Updated by Muhasin PU over 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
FIXED.
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 DATE PICKER
2.SET VALIDATION ON CREDIT LIMIT & GRACE PERIOD
3.SET ALIGNMENT ON JOIN DATE,TRN,PHONE NO., & EMAIL
Updated by Muhasin PU over 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Junaid M about 2 years ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
UI CHANGES
In Additional tab
1) After Counter Staff Field, Add New Field Follow Staff (Employee Entry Completion-Code-Name Splitted)
2) Add New Field Reco Staff (Employee Entry Completion-Code-Name Splitted)
Validation -> Not Mandatory
Updated by Muhasin PU about 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
All CHANGES UPDATED.
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.Update region - Act as supplier
Updated by Amal Cyriac about 2 years ago
ISSUE FOUND
*****
1.Update region - Act as supplier
2.Fix bugs on selection box - drop down button missing
(Receipt Mode)
Updated by Muhasin PU 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.In Currency Multi Selection Box widget Tick "BASE1 (QAR)" Then Select "BASE1 (QAR)" as default currency
Updated by Muhasin PU almost 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Resolved.*
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.Error on console while focus out from auto completion fields
Updated by Muhasin PU almost 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
FIXED.
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.Error on console while create contract
Updated by Muhasin PU almost 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Fixed.
Console Error Solved.
Precisions Based on Currencies & settings(%) Added.
key press number only added.
Updated by Amal Cyriac almost 2 years ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- Assignee changed from Muhasin PU to Junaid M
- % 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 - Date Picker
3.Fix bugs on GUI while switching tabs
(Set similar height for all tabs)
4.Use proper labels on Receipt Mode multi selection box
Updated by Amal Cyriac over 1 year ago
ISSUE FOUND
*****
1.Set mandatory fields red and required
(Set red star on Status)
2.Set tool tips on GUI - Date Picker
3.Connect module with Set Main Ledger GUI
Updated by unnikannan S over 1 year ago
1.CONNECT MODULE WITH SET MAIN LEDGER
Updated by Junaid M 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 Amal Cyriac to unnikannan S
ISSUE FOUNDED
1.CORRECT TOOL TIP SPELLING (DEFAULT CURRENCY)
2.REMOVE BLANK OPTION FROM APPROVAL STATUS
3.ADD MANDATORY FIELD FOR STATUS AND APPROVAL STATUS
4.ADD CODES FOR AUTO INVOICE BRANCH
5.DONT ALLOW ISSUED BY TAB TO ADD RATHER THAN COUNTRY NAME
Updated by unnikannan S over 1 year ago
unnikannan S wrote in #note-27:
ISSUE FOUNDED
1.CORRECT TOOL TIP SPELLING (DEFAULT CURRENCY)
2.REMOVE BLANK OPTION FROM APPROVAL STATUS
3.ADD MANDATORY FIELD FOR STATUS AND APPROVAL STATUS
4.ADD CODES FOR AUTO INVOICE BRANCH
5.DONT ALLOW ISSUED BY TAB TO ADD RATHER THAN COUNTRY NAME
6.DATES GOING TO PAST
Updated by unnikannan S over 1 year ago
unnikannan S wrote in #note-28:
unnikannan S wrote in #note-27:
ISSUE FOUNDED
1.CORRECT TOOL TIP SPELLING (DEFAULT CURRENCY)
2.REMOVE BLANK OPTION FROM APPROVAL STATUS
3.ADD MANDATORY FIELD FOR STATUS AND APPROVAL STATUS
4.ADD CODES FOR AUTO INVOICE BRANCH
5.DONT ALLOW ISSUED BY TAB TO ADD RATHER THAN COUNTRY NAME
6.DATES GOING TO PAST
7.CONNECT MODULE WITH PRINT
Updated by unnikannan S over 1 year ago
unnikannan S wrote in #note-29:
unnikannan S wrote in #note-28:
unnikannan S wrote in #note-27:
ISSUE FOUNDED
1.CORRECT TOOL TIP SPELLING (DEFAULT CURRENCY)
2.REMOVE BLANK OPTION FROM APPROVAL STATUS
3.ADD MANDATORY FIELD FOR STATUS AND APPROVAL STATUS
4.ADD CODES FOR AUTO INVOICE BRANCH
5.DONT ALLOW ISSUED BY TAB TO ADD RATHER THAN COUNTRY NAME
6.DATES GOING TO PAST - (EXPIRY DATES,CONTRACT EXPIRY DATES, JOINNING DATE)
7.CONNECT MODULE WITH PRINT
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.CORRECT TOOL TIP SPELLING (DEFAULT CURRENCY)
2.REMOVE BLANK OPTION FROM APPROVAL STATUS
3.ADD MANDATORY FIELD FOR STATUS AND APPROVAL STATUS
4.ADD CODES FOR AUTO INVOICE BRANCH
5.DONT ALLOW ISSUED BY TAB TO ADD RATHER THAN COUNTRY NAME
6.DATES GOING TO PAST - (EXPIRY DATES,CONTRACT EXPIRY DATES, JOINNING DATE)
7.CONNECT MODULE WITH PRINT
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.ADD BLANK OPTION FOR NON MANDATORY FIELDS (INSIDE DATA DROP DOWN FILTERS)
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.ADD BLANK OPTION FOR NON MANDATORY FIELDS (INSIDE DATA DROP DOWN FILTERS)
2.CHANGE APPROVED BY TO BY:
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.ERROR WHILE CLEARING SAVED ACCOUNTS CURRENCY DATAS AND TRY TO UPDATE
2.ERROR WHILE TRY TO ADD BLANK OPTIONS IN DROP DOWN FIELD AND UPDATE (SYSTEM,ACT ASFIELDS)
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.ERROR WHILE CLEARING SAVED ACCOUNTS CURRENCY DATAS AND TRY TO UPDATE
2.ERROR WHILE TRY TO ADD BLANK OPTIONS IN DROP DOWN FIELD AND UPDATE (SYSTEM,ACT ASFIELDS)
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 Change-> Add Security Tab [GUI Given]
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 unnikannan S about 1 year ago
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 SUPPLIER/AGENT
(Discuss With Anil Sir for Changes )
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
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 SUPPLIER/AGENT
(Discuss With Anil Sir for Changes )
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 Anil KV about 1 year ago
Changes
1) Corporate Booking Rules -> Load The customer and all customer booking rules -> Default tick The customer booking rules[Add Set Corporate Booking Rules with Customer then update customer table also, So automatic tick]
Updated by unnikannan S about 1 year ago
- Status changed from New Changes to Reopen Bugs
ISSUE FOUNDED
1.CONSIDER MAIN LEDGER CHANGES IN UI AS PER THE SELECTIONS IN SET MAIN LEDGER MODULE
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Particialy Coding Done
- % Done changed from 50 to 40
ISSUE FIXED
1.CONSIDER MAIN LEDGER CHANGES IN UI AS PER THE SELECTIONS IN SET MAIN LEDGER MODULE
2.customer security tab coding done
Updated by unnikannan S about 1 year ago
- Status changed from Particialy Coding Done to Reopen Bugs
- % Done changed from 40 to 50
ISSUE FOUNDED
1.FIX CURRRENCY CODE BUG WHILE CHANGING CURRENCY IN SECURITY TAB
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
ISSUE FIXED
1.FIX CURRRENCY CODE BUG WHILE CHANGING CURRENCY IN SECURITY TAB
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs Coding Done to Particialy Coding Done
- % Done changed from 70 to 40
Updated by Avinash MS 8 months ago
GUI Changes
------------------------------------------------------------------------------------------------
System Tab -> Bill Submission -> Change Rename Monthly to Monthly/Month (min 1 max 6)-Default 1
System Tab -> Add Blue Star and Title to Bill Submission.
Apply this changes to Supplier tab while checking Act As Supplier Checkbox
Updated by Vivekp V 8 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
GUI Changes DONE
--------------------------------Up On Checking Act As Client & Act As Supplier----------------------------------------------------------------
Customer & Supplier Tab -> Bill Submission -> Change Rename Monthly to Monthly/Month (min 1 max 6)-Default 1
Customer & Supplier Tab -> Add Blue Star and Title to Bill Submission.
Updated by Avinash MS 7 months ago
- Status changed from New Changes Coding Done to New Changes
- % Done changed from 70 to 50
GUI Change
--------------------------------------------------------------------------
System Tab -> Change in Bill Submission While Change in Payment Terms (Refer Payment Terms)
Apply this change in Supplier Tab while checking "Act As Supplier"
Updated by Junaid M 7 months ago
- Status changed from Reopen Bugs Coding Done to New Changes
- Assignee changed from Vivekp V to travvise Admin
- % Done changed from 70 to 50
GUI Changes - For Whatsapp phone number --------------- Personal Tab -> Phone -> Split phone Entry box to two entry box. *greenstar before whatsapp no entrybox -> Need db field in personal data table vhr_whatsapp_no VARCHAR , ask junaid After this change done, In Account search sql query perform phone number search on both
Updated by Augustin Jose 6 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS 6 months ago
- Status changed from New Changes Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE Fixed
---------------------
1) Can't delete an account if it is approved via account approve (also check other accounts)- (Use skip table feature).
2) Block letters entry in phone number and WhatsApp no: field.
New Changes
---------------------
1) DONE - Add Cost Center Tab - Changes GUI page ask junaid
Updated by Junaid M 5 months ago
New Changes
---------------------
In Cost Center Tab
1) Add these widgets in pop-up
Show in SOA Selectbox. options are "Custom Field 1", "Custom Field 2", "Custom Field 3", "Custom Field 4", "Custom Field 5". value CUSTOM_FIELD_1,...etc
Show in Invoice Print options. same as above
Show in Refund Print . options same as above
2) Save Cost Center data as JSON in "accounts.tbl_customer->arj_corporate_cost_centre JSON ARRAY"
Updated by Greeshma S 5 months ago
- Status changed from New Changes to Coding Started
- % Done changed from 50 to 30
Updated by Greeshma S 5 months ago
- Status changed from Coding Started to New Changes Coding Done
- % Done changed from 30 to 70
Updated by Junaid M 4 months ago
- Status changed from New Changes Coding Done to New Changes
- Assignee changed from Greeshma S to Sreeranjini T
- % Done changed from 70 to 50
New Changes
------------------
In System Tab
1. After Invoice Format, Add "Cash Invoice Format, Refund Format, Cash Refund Format" (Widget: Select box). Add title.
Updated by Sreeranjini T 4 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS 4 months ago
- Status changed from New Changes Coding Done to Reopen Bugs
- Assignee changed from Sreeranjini T to Greeshma S
- % Done changed from 70 to 50
ISSUE FOUND
---------------------------------------
1. In cost center tab can add with empty fields.
2. If checkbox near mandatory field is ticked then click the add button the tick mark is removed.
3. Head cost center should be mandatory with red star.
4. Add a check box in head cost center with title --> group name/cost center header.
5. Give blue star to parent cost center with title.
6. Add grouping to the cost center list.
7. Data on loading when the saving the data mandatory tick box ticked.
Updated by Greeshma S 4 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 4 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 4 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
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. On adding a cost center with parent at first then ticking the checkbox and making it the parent then it is becoming parent and also showing the selected parent
Updated by Greeshma S 4 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 3 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Updated by Arathy PS 2 months ago
- Status changed from Reopen Bugs Testing Done to New Changes
- % Done changed from 90 to 50
NEW CHANGES
-------------------------------------------------
1. In the system tab add a new field below corporate booking rule with drop down : customer card(default), agency card, pax card
--blue star
title: if choosen here then this will by default load in all issue modules
--> Need Db field ask Anil
Updated by Sreeranjini T 2 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS about 2 months ago
- File clipboard-202501201424-gklge.png clipboard-202501201424-gklge.png added
- Status changed from New Changes Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FIXED
------------------
1. Upon adding two child to a parent cost centre and another parent cost centre the previous parent cost centres given to the child disappears.
Updated by Sreeranjini T about 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 2 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Issue Fixed
------------
1)Cost center tab values is not clearing on New button click.
2)If parent cost center and child cost center name is same Parent name is disapearing.
Updated by Sreeranjini T about 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 2 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 2 months ago
- Status changed from Reopen Bugs Testing Done to New Changes
- % Done changed from 90 to 50
NEW CHANGES DONE
--------------------------
1.In the System Tab-> after 'Customer Card'-- Card No*B -->Masking | Expiry Date.
Title --> BTA Account Number(Eg:- 15 digit American Express Card Number. Always start with 37).
Updated by Sreeranjini T about 2 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 1 month ago
- Status changed from New Changes Coding Done to New Changes Testing Done
- % Done changed from 70 to 90
Updated by Arathy PS about 1 month ago
NEW CHANGES
-------------------------
Cardmember Name // title->Corporation Name
AEME Approval Code // title->6 Digits Unique number
Updated by Theja Ponon about 1 month ago
- Status changed from New Changes Testing Done to Reopen Bugs
- % Done changed from 90 to 50
Issue FIXED
---------------
1)Error on taking edit mode after updation - issue on costcentre tab
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 Theja Ponon about 1 month ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Updated by Theja Ponon 25 days ago
- Status changed from Reopen Bugs Testing Done to Reopen Bugs
- % Done changed from 90 to 50
Issue Fixed
------------
1)After clicking new corporate booking rule set for previous customer is not clearing
Updated by Sreeranjini T 25 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS 12 days ago
- Status changed from Reopen Bugs Testing Done to New Changes
- % Done changed from 90 to 50
NEW CHANGES DONE
----------------------------
--> Add `CR Number` in right side of TRN Number
--> Move Join Date to below
--> Db field `Personal Data --> vhr_cr_no`
--> Add ts, c# model field and update SP
Updated by Sreeranjini T 11 days ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70