Project

General

Profile

Edit Copy Actions

Feature #9

open

Account Code Setting

Added by Anil KV over 2 years ago. Updated 3 months ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Target version:
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

2-tsModel.txt (1.04 KB) 2-tsModel.txt Anil KV, 08/04/2022 11:25 AM
1-CsModel.txt (1.53 KB) 1-CsModel.txt Anil KV, 08/04/2022 11:25 AM
4-CsControllerFile.txt (16.9 KB) 4-CsControllerFile.txt Anil KV, 08/04/2022 11:25 AM
3-CsFile.txt (9.25 KB) 3-CsFile.txt Anil KV, 08/04/2022 11:25 AM
5-TsFile.txt (13.6 KB) 5-TsFile.txt Anil KV, 08/04/2022 11:25 AM
6-HtmlFile.txt (1.92 KB) 6-HtmlFile.txt Anil KV, 08/04/2022 11:25 AM
sql.txt (8.41 KB) sql.txt Anil KV, 08/04/2022 11:25 AM

Add

Subtasks


Add

Related issues

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,--*2
sin_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 generation

Updated 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": "" },
];

Actions #4

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

Actions #6

Updated by Shanto Shaji over 2 years ago

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

Updated by Shanto Shaji over 2 years ago

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

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

Actions #10

Updated by Shanto Shaji over 2 years ago

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

Updated by Shanto Shaji over 2 years ago

  • Status changed from Reopen Bugs Coding Done to Testing Started
Actions #12

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 )

Actions #14

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

Actions #16

Updated by Junaid M over 1 year ago

  • Assignee changed from Shanto Shaji to Baseem Shan
Actions #17

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}}
Actions #19

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

Actions #21

Updated by Junaid M about 1 year ago

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

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 unnikannan S about 1 year ago

TESTING DONE

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"

Actions #25

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

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

ISSUE FOUNDED

FIXED -- 1. Show Item All Bank In Other Tab Clear The Item Own Bank

Actions #27

Updated by Baseem Shan 4 months ago

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

Updated by unnikannan S 3 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
Edit Copy Actions

Also available in: Atom PDF