Feature #9
openAccount Code Setting
Start date:
08/04/2022
Due date:
08/08/2022 (over 2 years late)
% Done:
90%
Estimated time:
20:00 h
Owner(Agency):
Travvise
Time Taken(HH):
30.00
Module:
Account Code Settings
Tested By:
unnikannan S
Code Reviewed By:
Shanto Shaji
Description
Account Code Setting
DELETE FROM accounts.tbl_ac_code_settings;
Insert the Records
INSERT INTO accounts.tbl_ac_code_settings
(vhr_sys_module_name,
sin_type,
sin_allowed_manul_entery,
sin_code_gen_method,
vhr_code_perfix,
sin_start_number,
sin_number_length,
sin_first_chrs_len)
VALUES(
('CUSTOMER_MASTER', 0, 1, 1, 'CUS', 1, 3, 0),
('SUPPLIER_MASTER', 0, 1, 1, 'SUP', 1, 3, 0),
('COMMISSION_AGENT_MASTER', 0, 1, 1, 'SAM', 1, 3, 0),
('EMPLOYEE_MASTER', 0, 1, 1, 'EMP', 1, 3, 0),
('PROFILE_MASTER', 0, 1, 1, 'POF', 1, 3, 0),
('SUB_LEDGER_MASTER', 0, 1, 1, 'SBL', 1, 3, 0),
('CASH_MASTER', 0, 1, 1, 'CAS', 1, 3, 0),
('UPI_MASTER', 0, 1, 1, 'UPI', 1, 3, 0),
('BANK_MASTER', 0, 1, 1, 'BNK', 1, 3, 0),
('CREDIT_CARD_MASTER', 0, 1, 1, 'CRC', 1, 3, 0),
('CORPORATE_CARD_MASTER', 0, 1, 1, 'COC', 1, 3, 0),
('RECEIVED_CHEQUE_MASTER', 0, 1, 1, 'RCH', 1, 3, 0),
('PAID_CHEQUE_MASTER', 0, 1, 1, 'PCH', 1, 3, 0),
('CHART_OF_ACCOUNT', 1, 1, 1, 'AS', 1, 3, 0),
('CHART_OF_ACCOUNT', 2, 1, 1, 'AG', 1, 3, 0),
('CHART_OF_ACCOUNT', 3, 1, 1, 'AM', 1, 3, 0),
('CHART_OF_ACCOUNT', 4, 1, 1, 'AL', 1, 3, 0),
('CHART_OF_ACCOUNT', 5, 1, 1, 'LA', 1, 3, 0),
('CHART_OF_ACCOUNT', 6, 1, 1, 'LG', 1, 3, 0),
('CHART_OF_ACCOUNT', 7, 1, 1, 'LM', 1, 3, 0),
('CHART_OF_ACCOUNT', 8, 1, 1, 'LL', 1, 3, 0),
('CHART_OF_ACCOUNT', 9, 1, 1, 'IN', 1, 3, 0),
('CHART_OF_ACCOUNT', 10, 1, 1, 'IG', 1, 3, 0),
('CHART_OF_ACCOUNT', 11, 1, 1, 'IM', 1, 3, 0),
('CHART_OF_ACCOUNT', 12, 1, 1, 'IL', 1, 3, 0),
('CHART_OF_ACCOUNT', 13, 1, 1, 'EX', 1, 3, 0),
('CHART_OF_ACCOUNT', 14, 1, 1, 'EG', 1, 3, 0),
('CHART_OF_ACCOUNT', 15, 1, 1, 'EM', 1, 3, 0),
('CHART_OF_ACCOUNT', 16, 1, 1, 'EL', 1, 3, 0));Files
Subtasks
Related issues
Actions
#1
Updated by Anil KV over 2 years ago
- File 1-CsModel.txt 1-CsModel.txt added
- File 2-tsModel.txt 2-tsModel.txt added
- File 3-CsFile.txt 3-CsFile.txt added
- File 4-CsControllerFile.txt 4-CsControllerFile.txt added
- File 5-TsFile.txt 5-TsFile.txt added
- File 6-HtmlFile.txt 6-HtmlFile.txt added
- File sql.txt sql.txt added
Updated by Anil KV over 2 years ago
CREATE TABLE accounts.tbl_ac_code_settings (
pk_ac_code_settings_id BIGSERIAL PRIMARY KEY,
vhr_sys_module_name VARCHAR(250) NOT NULL, --*1
sin_type SMALLINT DEFAULT 0,--*2sin_allowed_manul_entery SMALLINT DEFAULT 0,
sin_code_gen_method SMALLINT DEFAULT 0, --*3
vhr_code_perfix VARCHAR(5) NULL,
sin_start_number BIGINT DEFAULT 0,
sin_number_length SMALLINT DEFAULT 0,
sin_first_chrs_len SMALLINT DEFAULT 0
) INHERITS(tbl_action_user_and_date_time);
--*1 > maily Accounts Masteres, Allowed other Masters also
-*2 > 0 - Sub Module Base(Not Chart of account)
- 1 - Assets
-- 2 - Assets Group
-- 3 - Asset Main Ledger
-- 4 - Asset Ledger
-- 5 - Liabilities
-- 6 - Liabilities Group
-- 7 - Liabilities Main Ledger
-- 8 - Liabilities Ledger
-- 9 - Income
-- 10 - Income Group
-- 11 - Income Main Ledger
-- 12 - Income Ledger
-- 13 - Expense
-- 14 - Expense Group
-- 15 - Expense Main Ledger
-- 16 - Expense Ledger
--*3 > 0 = Manual Only
- 1 = Set Perfix Base auto generation
-- 2 = Name Part Base auto generation
-- 3 = Number part only auto generationUpdated by Anil KV over 2 years ago
public lstAcCodeGenMethod: any[] = [
{ "intId": 0, "strLabel": "Manual Only", "blnDisable": false, "blnActive": true, "strRemarks": "" },
{ "intId": 1, "strLabel": "Set Perfix Base auto generation", "blnDisable": false, "blnActive": false, "strRemarks": "" },
{ "intId": 2, "strLabel": "Name Part Base auto generation", "blnDisable": false, "blnActive": false, "strRemarks": "" },
{ "intId": 3, "strLabel": "Number part only auto generation", "blnDisable": false, "blnActive": false, "strRemarks": "" },
];
Updated by Shanto Shaji over 2 years ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
Updated by Shanto Shaji over 2 years ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
- Time Taken(HH) set to 30.00
- Module set to Account Code Settings
Another Work (Ui Editing) done in One Working day
Updated by Shanto Shaji over 2 years ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
Updated by Shanto Shaji over 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Shanto Shaji over 2 years ago
- Status changed from Reopen Bugs Coding Done to Testing Started
- Tested By set to Shanto Shaji
- Code Reviewed By set to Shanto Shaji
Updated by Shanto Shaji over 2 years ago
- Status changed from Testing Started to Reopen Bugs
- % Done changed from 60 to 50
Tab Name Error
Updated by Shanto Shaji over 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Shanto Shaji over 2 years ago
- Status changed from Reopen Bugs Coding Done to Testing Started
Updated by Shanto Shaji over 2 years ago
- Status changed from Testing Started to Reopen Bugs Testing Done
- % Done changed from 60 to 80
Updated by Amal Cyriac about 2 years ago
- Status changed from Reopen Bugs Testing Done to Reopen Bugs
- % Done changed from 80 to 50
- Tested By changed from Shanto Shaji to Amal Cyriac
ISSUE FOUND
*****
1.Fix error on grid- Value - Null
( Chart of Account & Non Chart of Account )
Updated by Shanto Shaji 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.NO VALIDATION WHILE SAVING WITHOUT DATA PEFIX CODE
Updated by Junaid M over 1 year ago
- Assignee changed from Shanto Shaji to Baseem Shan
Updated by Baseem Shan over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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
FIXED - 1.NO CHANGE IN ACCOUNTS WHILE CHANGING START NO/FIRST CHAR NO FIELD
FIXED - 2.ERROR WHILE CHANGING TYPES OF NON/COA ACCOUNTS
P0001: jsnSpOutRes: {"sinSqlCustomStatus" : -1, "strSqlCustomStatusCode" : "ERROR", "strSqlCustomMessage" : "Bank Save Faild", "strSqlCustomErrorType" : "DATABASE_SYSTEM_ERROR",
"strSqlCustomErrorCode" : null, "strSqlSysMessage" : "record \"objfncheckres\" has no field \"sinsqlcustomstatus\"", "strSqlSysExceptionDetail" : "", "strSqlSysExceptionHint" : "PL/pgSQL
assignment \"objFnCheckRes.sinSqlCustomStatus := -1::SMALLINT\"\nPL/pgSQL function sp_insert_or_update_bank(jsonb,jsonb,jsonb,jsonb) line 17 at assignment", "binSqlPk" : 0, "binSqlLogPk" : 0,
"strSqlDocNo" : null, "dctSqlOtherData" : {"binBankId": null, "binCustomerId": null, "strAccountCode": null}}Updated by Baseem Shan about 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
GUI Change
-----------
-Add 'Assets' also
Updated by Junaid M about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
Updated by Baseem Shan about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Junaid M 7 months ago
- Status changed from Reopen Bugs Coding Done to New Changes
- % Done changed from 70 to 50
GUI Change
------------
ADDED -- 1.Rename Tab "Non Chart of Account" to "Accounts"
ADDED -- 2.Add new Tab last "Other Masters"
ADDED -- 3.Move Profile, Hired Shueffer, All Bank, Sub ledger master, Assets master to Other Masters from "Non Chart of Account" to "Other Masters"
Updated by Baseem Shan 7 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Baseem Shan 4 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70