Feature #27: Chart Of Account - TAAS - Redmine

Actions

Copy link

#1

Updated by Anil KV over 2 years ago

File 1-CsModel.cs added
File 2-tsModel.ts added
File 3-CsFile.cs added
File 4-CsControllerFile.cs added
File 5-TsFile.ts added
File 6-HtmlFile.html added
File sql.sql added
Assignee changed from Jinu KT to Anil KV

QuoteActions

Copy link

#2

Updated by Anil KV over 2 years ago

Assignee changed from Anil KV to Muhasin PU

CREATE TABLE accounts.tbl_chart_of_ac(
           pk_chart_of_ac_id BIGSERIAL PRIMARY KEY,

           fk_account_id BIGINT NULL REFERENCES accounts.tbl_account(pk_account_id),

        vhr_code VARCHAR(30) NOT NULL,
        vhr_mapping_code VARCHAR(100) NULL,
        vhr_reference_no VARCHAR(100) NULL,
        vhr_name VARCHAR(150) NOT NULL,
        vhr_display_name VARCHAR(150) NULL,

        txt_remarks TEXT DEFAULT '',

        sin_chart_of_ac_category SMALLINT DEFAULT 0,--*1
        sin_chart_of_ac_type SMALLINT DEFAULT 0,--*2
        sin_main_ledger_category SMALLINT DEFAULT -1,--*3
        sin_default_main_ledger SMALLINT DEFAULT 0,

        fk_parent_chart_of_ac_id BIGINT NULL,
        sin_record_status SMALLINT DEFAULT 1,
        sin_order SMALLINT DEFAULT 0

) INHERITS(tbl_action_user_and_date_time);

--ALTER TABLE accounts.tbl_account ADD CONSTRAINT tbl_account_fk_parent_chart_of_ac_id_fkey FOREIGN KEY(fk_parent_chart_of_ac_id) REFERENCES accounts.tbl_chart_of_ac(pk_chart_of_ac_id);
--*1 -> 1 = Assets
--      2 = Liabilities
--      3 = Revenues(Income)
--      4 = Expenses
--*2 -> 0 = Category
--        1 = Group
--        2 = Main ledger
--      3 = Ledger/Leaf => NOT COME HERE because its keep in account table
--*3 -> -1 = No Main Ledger
--      0 = Other
--      1 = Cash
--      2 = Petty Cash
--      3 = UPI Accounts
--      4 = Virtual Card
--      5 = Agency Credit Card
--      6 = Customer Credit Card
--      7 = Agency Corprate Card
--      8 = Customer Corprate Card
--      9 = Bank Account
--      10 = Received Current Cheques
--      11 = Received PD Cheques 
--      12 = Payable Current Cheques
--      13 = Payable PD Cheques
--      14 = Customer
--      15 = Supplier
--      16 = Employee
--      17 = Commission Agent
--      18 = Airline
--      19 = Assets

QuoteActions

Copy link

#3

Updated by Anil KV over 2 years ago

accounts.tbl_account

QuoteActions

Copy link

#4

Updated by Anil KV over 2 years ago

CREATE TABLE accounts.tbl_account (
        pk_account_id BIGSERIAL PRIMARY KEY,

        vhr_account_code VARCHAR(30) NOT NULL,
        vhr_mapping_code VARCHAR(100) NULL,
        vhr_reference_no VARCHAR(100) NULL,
        vhr_account_name VARCHAR(150) NOT NULL,
        vhr_display_name VARCHAR(150) NULL,

        fk_category_id BIGINT NULL REFERENCES accounts.tbl_grouping(pk_grouping_id),
        fk_group_id BIGINT NULL REFERENCES accounts.tbl_grouping(pk_grouping_id),
        fk_type_id BIGINT NULL REFERENCES accounts.tbl_grouping(pk_grouping_id),
        fk_family_id BIGINT NULL REFERENCES accounts.tbl_grouping(pk_grouping_id),

        fk_default_main_ledger_id BIGINT NULL,
        fk_customer_main_ledger_id BIGINT NULL,
        fk_supplier_main_ledger_id BIGINT NULL,
        fk_commission_agent_main_ledger_id BIGINT NULL,

        vhr_default_currency_code VARCHAR(3),
        art_currency_codes VARCHAR(3) ARRAY,

        sin_ac_category SMALLINT DEFAULT 0, --*1
        sin_if_customer SMALLINT DEFAULT 0,
        sin_if_supplier SMALLINT DEFAULT 0,
        sin_if_commission_agent SMALLINT DEFAULT 0,

        sin_if_sys_account SMALLINT DEFAULT 0, --*4
        sin_permission_to_all SMALLINT DEFAULT 1, --*5
        ari_permitted_user_roles SMALLINT ARRAY,--6
        sin_sys_ac_type SMALLINT DEFAULT 1, --*7

        txt_remarks TEXT DEFAULT '',
        txt_message TEXT DEFAULT '', --*3

        arb_fk_branch_ids BIGINT ARRAY,
        arb_fk_service_ids BIGINT ARRAY, --*9

        vhr_phone VARCHAR(100) DEFAULT '',
        vhr_email VARCHAR(100) DEFAULT '',
        vhr_address VARCHAR(300) DEFAULT '',
        vhr_display_address VARCHAR(300) DEFAULT '',

        fk_approval_user_id BIGINT REFERENCES authentication.tbl_user(pk_user_id),
        dtm_approval TIMESTAMP WITH TIME ZONE NULL,
        sin_approvel_status SMALLINT DEFAULT 1, --DBHelp0_9

        sin_record_status SMALLINT DEFAULT 1, --DBHelp0_4
        sin_order SMALLINT DEFAULT 0

    --CHECK (fk_parent_chart_of_ac_id IS NOT NULL AND (sin_ac_type = 1 OR sin_ac_type = 2 OR sin_ac_type = 3 OR sin_ac_type = 4)),
    --CHECK (fk_parent_chart_of_ac_id IS NULL AND (sin_ac_type != 1 OR sin_ac_type != 2 OR sin_ac_type != 3 OR sin_ac_type != 4))

) INHERITS(tbl_action_user_and_date_time);
--*1 -> 0 = Other
--        1 = Assets->Ledger/Leaf(Chart of AC)
--        2 = Liabilities->Ledger/Leaf(Chart of AC)
--        3 = Revenues(Income)->Ledger/Leaf(Chart of AC)
--        4 = Expense->Ledger/Leaf(Chart of AC)
--      5 = Cash Accounts
--      6 = Petty Cash Accounts
--      7 = UPI Accounts
--      8 = Virtual Card
--        9 = Agency Credit Card Accounts
--        10 = Customer Credit Card Accounts
--        11 = Agency Corp. Card Accounts
--        12 = Customer Corp. Card Accounts
--      13 = Bank Accounts
--      14 = Current Cheque Received Accounts
--      15 = PDC Received Accounts
--      16 = Current Cheque Issued Accounts
--      17 = PDC Issued Accounts
--        18 = Client/Debtor Accounts
--        19 = Supplier/Creditor Accounts
--        20 = Employee Accounts
--        21 = Commission Agent Accounts
--        22 = Airline Accounts
--        23 = Asset Master Accounts
--*3 -> The message showing in Sales and RefundGUI - choose the client then
--*4 -> Date Control Account, Branch Control Account etc...
--*5 -> *6 all ON(ari_permitted_user_roles) then 1 Other wise 0 then use based on User wise permission
--*6 -> This data based Tick or Untick USER GROUP and USER GUI ACCOUNT tab
--*7 ->  1=Individual
--       2=Corporate
--       3=Other Agency (B2B)
--       4=General Accounts
--*8 -> *1 = 1,2,3 & 4 case the filed is mandatory
--*9 -> Supplier Only

Actions

Copy link

#5

Updated by Anil KV over 2 years ago

File deleted (~~1-CsModel.cs~~)

Actions

Copy link

#6

Updated by Anil KV over 2 years ago

File deleted (~~2-tsModel.ts~~)

Actions

Copy link

#7

Updated by Anil KV over 2 years ago

File deleted (~~3-CsFile.cs~~)

Actions

Copy link

#8

Updated by Anil KV over 2 years ago

File deleted (~~4-CsControllerFile.cs~~)

Actions

Copy link

#9

Updated by Anil KV over 2 years ago

File deleted (~~6-HtmlFile.html~~)

Actions

Copy link

#10

Updated by Anil KV over 2 years ago

File deleted (~~5-TsFile.ts~~)

Actions

Copy link

#11

Updated by Anil KV over 2 years ago

File deleted (~~sql.sql~~)

Actions

Copy link Download all files

#12

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 6-HtmlFile.html 6-HtmlFile.html added
File sql.sql added

QuoteActions

Copy link

#13

Updated by Anil KV over 2 years ago

 public lstAccountStatus: any[] = [
    { "intAcStatusId": -1, "strAcStatus": "Rejected(Not Active)", "blnDisable": false, "blnActive": false, "strRemarks": "Rerquest or Delete" },
    { "intAcStatusId": 0, "strAcStatus": "Not Active(Need Approval)", "blnDisable": false, "blnActive": false, "strRemarks": "Need Approval" },
    { "intAcStatusId": 1, "strAcStatus": "Active", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intAcStatusId": 2, "strAcStatus": "Active(Via Approval)", "blnDisable": false, "blnActive": true, "strRemarks": ""},
    { "intAcStatusId": 3, "strAcStatus": "Blocked", "blnDisable": false, "blnActive": false, "strRemarks": "Already used then connot delete, So use BLOCK option -> Allowed ACTIVE"},
    { "intAcStatusId": 4, "strAcStatus": " Closed", "blnDisable": false, "blnActive": false, "strRemarks": "Already used then connot delete, So use CLOSE option -> Not allowed ACTIVE" },
    { "intAcStatusId": 5, "strAcStatus": "Debit Side Blocked", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intAcStatusId": 6, "strAcStatus": " Credit Side Blocked", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

  public lstAccountGroupingTypes: any[] = [{ "intId": 0, "strLabel": "Category", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 1, "strLabel": "Group", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "Type", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "Family", "blnDisable": false, "blnActive": false, "strRemarks": "" }];

  public lstAcOwnCategory: any[] = [
    { "intId": 0, "strLabel": "Other", "blnDisable": true, "blnActive": false, "strRemarks": "" },
    { "intId": 1, "strLabel": "Ledger(Assets)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "Ledger(Liabilities)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "Ledger(Revenues)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 4, "strLabel": "Ledger(Expense)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 5, "strLabel": "Cash Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 6, "strLabel": "Petty Cash Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 7, "strLabel": "UPI Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 8, "strLabel": "Virtual Card", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 9, "strLabel": "Agency Credit Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 10, "strLabel": "Customer Credit Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 11, "strLabel": "Agency Corp.Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 12, "strLabel": "Customer Corp.Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 13, "strLabel": "Bank Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 14, "strLabel": "Current Cheque Received Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 15, "strLabel": "PDC Received Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 16, "strLabel": "Current Cheque Issued Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 17, "strLabel": "PDC Issued Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 18, "strLabel": "Client/Debtor Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 19, "strLabel": "Supplier/Creditor Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 20, "strLabel": "Employee Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 21, "strLabel": "Commission Agent Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 22, "strLabel": "Airline Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 23, "strLabel": "Asset Master Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

  public lstAcOwnType: any[] = [
    { "intId": 1, "strLabel": "Individual", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "Corporate", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "Other Agency(B2B)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 4, "strLabel": "General Accounts", "blnDisable": false, "blnActive": true, "strRemarks": "" },
  ];

  public lstChartOfAcOwnCategory: any[] = [
    { "intId": 1, "strLabel": "Ledger(Assets)", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 2, "strLabel": "Ledger(Liabilities)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "Ledger(Revenues)", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 4, "strLabel": "Ledger(Expense)", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

  public lstChartOfAcOwnType: any[] = [
    { "intId": 0, "strLabel": "Category", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 1, "strLabel": "Group", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "Main Ledger", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "Ledger", "blnDisable": false, "blnActive": true, "strRemarks": "" }
  ];

  public lstMlOwnCategory: any[] = [
    { "intId": -1, "strLabel": "No Main Ledger", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 0, "strLabel": "Other", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 5, "strLabel": "Cash Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 6, "strLabel": "Petty Cash Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 7, "strLabel": "UPI Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 8, "strLabel": "Virtual Card", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 9, "strLabel": "Agency Credit Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 10, "strLabel": "Customer Credit Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 11, "strLabel": "Agency Corp.Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 12, "strLabel": "Customer Corp.Card Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 13, "strLabel": "Bank Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 14, "strLabel": "Current Cheque Received Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 15, "strLabel": "PDC Received Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 16, "strLabel": "Current Cheque Issued Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 17, "strLabel": "PDC Issued Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 18, "strLabel": "Client/Debtor Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 19, "strLabel": "Supplier/Creditor Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 20, "strLabel": "Employee Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 21, "strLabel": "Commission Agent Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 22, "strLabel": "Airline Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 23, "strLabel": "Asset Master Accounts", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

Actions

Copy link

#14

Updated by Anil KV over 2 years ago

Estimated time changed from 48:00 h to 40:00 h

Actions

Copy link

#15

Updated by Anil KV over 2 years ago

File deleted (~~sql.sql~~)

Actions

Copy link

#16

Updated by Anil KV over 2 years ago

File sql.sql sql.sql added

Actions

Copy link

#17

Updated by Muhasin PU over 2 years ago

Status changed from New to Coding Started
% Done changed from 0 to 40

Actions

Copy link

#18

Updated by Anil KV over 2 years ago

File account.sql.txt account.sql.txt added

Actions

Copy link

#19

Updated by Muhasin PU over 2 years ago

Status changed from Coding Started to Coding Done
% Done changed from 40 to 60

QuoteActions

Copy link

#20

Updated by Muhasin PU over 2 years ago

Status changed from Coding Done to Particialy Coding Done
% Done changed from 60 to 30

Chart of Account Delete --> Completed

QuoteActions

Copy link

#21

Updated by Muhasin PU over 2 years ago

Default Ledger id updation in Account table pending...
After insertion of Chart of account --> update ChartOfAccountID in account table--> DefaultLedger (only for New insertion) ---> Completed

QuoteActions

Copy link

#22

Updated by Muhasin PU over 2 years ago

Customer & Supplier Tab Pending

Actions

Copy link

#23

Updated by Muhasin PU over 2 years ago

Status changed from Particialy Coding Done to Coding Done
% Done changed from 40 to 60

QuoteActions

Copy link

#24

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 FOUND *****
1.FIX BUGS ON EXPAND BUTTON
2.FIX ERROR ON AUTO GENERATION OF CODE

QuoteActions

Copy link

#25

Updated by Muhasin PU over 2 years ago

FIXED..

Actions

Copy link

#26

Updated by Muhasin PU over 2 years ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

QuoteActions

Copy link

#27

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 BRANCH RED AND REQUIRED
2.SET AN ORDER IN SAVING PROCESS
( ADD/EDIT-->NAME)

QuoteActions

Copy link

#28

Updated by Muhasin PU over 2 years ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

Modified.

New Category cannot select. (Disabled Category)
By Adding a new Item (type = Main Ledger)
Branch Validation
Add/Edit First show

QuoteActions

Copy link

#29

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.Main ledgers not allowed to move between Asset / Liabilities accounts To
Revenue /Expense accounts

QuoteActions

Copy link

#30

Updated by Muhasin PU almost 2 years ago

UPDATED.

Parent Validation & Reordering Fixed.

Actions

Copy link

#31

Updated by Muhasin PU almost 2 years ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

QuoteActions

Copy link

#32

Updated by unnikannan S over 1 year 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
Tested By changed from Amal Cyriac to unnikannan S

1.On Mail ledger type the tick mark is not working 2.while selecting act as customer and supplier no info in the table

Actions

Copy link

#33

Updated by Junaid M over 1 year ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

QuoteActions

Copy link

#34

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 CODE WISE SEARCHING IN ACCOUNTS
2.DATA GOING OUT FROM THE FILES

QuoteActions

Copy link

#35

Updated by unnikannan S over 1 year ago

unnikannan S wrote in #note-34:

ISSUE FOUNDED

1.ADD CODE WISE SEARCHING IN ACCOUNTS
2.DATA GOING OUT FROM THE FILES
3.ERROR WHILE DELETING LEDGER SHOWING US- Unable to cast object of type 'System.DBNull' to type 'System.String'.

Actions

Copy link

#36

Updated by Junaid M over 1 year ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

QuoteActions

Copy link

#37

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

FIXED 1.ERROR WHILE CHANGING A/C S LEDGER TO MAIN LEDGER AND UPDATE (Unable to cast object of type 'System.DBNull' to type 'System.String'.).
FIXED 2.CANT EDIT SUB GROUPS (DEPRECIATION).
FIXED 3.DATA NOT CLEARING WHILE SELECTING ADDRESS TO NEW.
FIXED 4.UI OVER LAPPING WHILE CHOOSE ACT US CLIENT AND CHOOSE NEW.

Actions

Copy link

#38

Updated by Anil KV over 1 year ago

Assignee changed from Junaid M to Vivekp V

QuoteActions

Copy link

#39

Updated by Seema Mathew over 1 year ago

Tested By changed from unnikannan S to Seema Mathew

ISSUE FOUNDED****

1.MISSING ASSET

QuoteActions

Copy link

#40

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

FIXED 1.ERROR WHILE CHANGING A/C S LEDGER TO MAIN LEDGER AND UPDATE (Unable to cast object of type 'System.DBNull' to type 'System.String'.).
FIXED 2.CANT EDIT SUB GROUPS (DEPRECIATION).
FIXED 3.DATA NOT CLEARING WHILE SELECTING ADDRESS TO NEW.
FIXED 4.UI OVER LAPPING WHILE CHOOSE ACT US CLIENT AND CHOOSE NEW.

QuoteActions

Copy link

#41

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.CANT EDIT/ADD/UPDATE DETAILS IN (CATEGORY,LEDGER,MAIN LEDGER)
2.CANT ADD BRANCH DETAILS AFTER CHANGING A ITEM TO MAIN LEDGER TO LEDGER OR GROUP
3.MISSING DATA WHILE ADDING COUNTRY IN LEDGER ADRESS TAB AND REFRESH

QuoteActions

Copy link

#42

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.CANT EDIT/ADD/UPDATE DETAILS IN (CATEGORY,LEDGER,MAIN LEDGER)
2.CANT ADD BRANCH DETAILS AFTER CHANGING A ITEM TO MAIN LEDGER TO LEDGER OR GROUP
3.MISSING DATA WHILE ADDING COUNTRY IN LEDGER ADDRESS TAB AND REFRESH

QuoteActions

Copy link

#43

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions

Copy link

#44

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

1.RESTRICT DELETE IF GROUP HAS A CHILD

QuoteActions

Copy link

#45

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.RESTRICT DELETE IF GROUP HAS A CHILD cant restrict as one may need to delete a group so done validation where we ask as to are they sure to delete that account as it may contain child accounts

QuoteActions

Copy link

#46

Updated by unnikannan S about 1 year ago

ISSUE FOUNDED

1.CANT DELETE DEFAULT LEDGERS/MAINLEDGERS

Actions

Copy link

#47

Updated by unnikannan S about 1 year ago

Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 60 to 50

QuoteActions

Copy link

#48

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.CANT DELETE DEFAULT LEDGERS/MAINLEDGERS

QuoteActions

Copy link

#49

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions

Copy link

#50

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

1.HIDE MAIN LEDGER TYPE FIELD FROM CATEGORY,GROUP,LEDGER

QuoteActions

Copy link

#51

Updated by Vivekp V about 1 year ago

ISSUE FIXED

1.HIDE MAIN LEDGER TYPE FIELD FROM CATEGORY,GROUP,LEDGER

QuoteActions

Copy link

#52

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.HIDE MAIN LEDGER TYPE FIELD FROM CATEGORY,GROUP,LEDGER

QuoteActions

Copy link

#53

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions

Copy link

#54

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

1.DONT ALLOW TO CLEAR THE ACT AS CHECK BOXES IN CASE IF THE ACCOUNT WAS ALREADY USED IN ANY DOCUMENT AS A PARTY
(Discuss With Anil Sir for Changes )

QuoteActions

Copy link

#55

Updated by Junaid M about 1 year ago

GUI CHANGES
-------------
-> Add 'Assets Main Ledger' in Main ledger Selectbox

QuoteActions

Copy link

#56

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.DONT ALLOW TO CLEAR THE ACT AS CHECK BOXES IN CASE IF THE ACCOUNT WAS ALREADY USED IN ANY DOCUMENT AS A PARTY
(Discuss With Anil Sir for Changes )

QuoteActions

Copy link

#57

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions

Copy link

#58

Updated by Junaid M about 1 year ago

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

GUI CHANGES
------------

1) Add Account Group Widgets after Main ledger (Only Visible if Type=Ledger)
2) Ask junaid for add db fields

QuoteActions

Copy link

#59

Updated by Vivekp V about 1 year ago

Status changed from New Changes to New Changes Coding Done
% Done changed from 50 to 70

GUI CHANGES Done
------------

1) Add Account Group Widgets after Main ledger (Only Visible if Type=Ledger)

QuoteActions

Copy link

#60

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.Block Main Ledger Type Change And Update In Case The Saved Main Ledger Is Associated With Any Master Acounts
FIXED 2.Error While Clearing Precision,Grace Period And Update On Act As Client Customer Tab

QuoteActions

Copy link

#61

Updated by Vivekp V 10 months ago

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

ISSUE FIXED

1.Block Main Ledger Type Change And Update In Case The Saved Main Ledger Is Associated With Any Master Acounts
FIXED 2.Error While Clearing Precision,Grace Period And Update On Act As Client Customer Tab

QuoteActions

Copy link

#62

Updated by unnikannan S 10 months ago

TESTING DONE

QuoteActions

Copy link

#63

Updated by unnikannan S 10 months ago

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

ISSUE FOUNDED

1.Fix Missing Of Default Currency In Ledgers

QuoteActions

Copy link

#64

Updated by Vivekp V 10 months ago

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

ISSUE FIXED

1.Fix Missing Of Default Currency In Ledgers

QuoteActions

Copy link

#65

Updated by unnikannan S 10 months ago

TESTING DONE

QuoteActions

Copy link

#66

Updated by unnikannan S 9 months ago

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

ISSUE FOUNDED

1.Block Deletion Of Main Ledger In Case Any Account Saved With The Main Ledger

QuoteActions

Copy link

#67

Updated by Vivekp V 9 months ago

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

ISSUE FIXED

1.Block Deletion Of Main Ledger In Case Any Account Saved With The Main Ledger

QuoteActions

Copy link

#68

Updated by unnikannan S 9 months ago

TESTING DONE

QuoteActions

Copy link

#69

Updated by unnikannan S 9 months ago

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

ISSUE FOUNDED

1.Fix Error While Adding Blank Option in Reco Type

QuoteActions

Copy link

#70

Updated by Vivekp V 9 months ago

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

ISSUE FIXED

1.Fix Error While Adding Blank Option in Reco Type

QuoteActions

Copy link

#71

Updated by unnikannan S 9 months ago

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

ISSUE FOUNDED

1.Error On Deletion

QuoteActions

Copy link

#72

Updated by Vivekp V 8 months ago

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

ISSUE FIXED

1.Error On Deletion ADDED SP IN GROUP

QuoteActions

Copy link

#73

Updated by unnikannan S 8 months ago

TESTING DONE

QuoteActions

Copy link

#74

Updated by unnikannan S 8 months ago

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

ISSUE FOUNDED

1.Fix Edit Bugs On Group Category

QuoteActions

Copy link

#75

Updated by Vivekp V 8 months ago

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

ISSUE FIXED

1.Fix Edit Bugs On Group Category

QuoteActions

Copy link

#76

Updated by unnikannan S 8 months ago

TESTING DONE

QuoteActions

Copy link

#77

Updated by Avinash MS 8 months ago

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

GUI Changes
--------------------------------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.

QuoteActions

Copy link

#78

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.

QuoteActions

Copy link

#79

Updated by unnikannan S 8 months ago

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

ISSUE FOUNDED

1.Allow Deletion Of Accounts Its Not Used In Any Documents As A Act As Supplier/Customer

QuoteActions

Copy link

#80

Updated by Vivekp V 8 months ago

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

ISSUE FIXED

1.Allow Deletion Of Accounts Its Not Used In Any Documents As A Act As Supplier/Customer

QuoteActions

Copy link

#81

Updated by unnikannan S 8 months ago

TESTING DONE

QuoteActions

Copy link

#82

Updated by Avinash MS 7 months ago

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

GUI Change
--------------------------------------------------------------------------
Customer Tab and Supplier Tab (While checking "Act As Client and Supplier") -> Change in Bill Submission While Change in Payment Terms (Refer Payment Terms)

QuoteActions

Copy link

#83

Updated by Junaid M 7 months ago

Coa Print DONE
--------------
Columns=> Chart of account | Code(Hide) | Name(Hide) | Type(Hide) | Category(Hide)

Chart of account: Code::Name
Type: Category, Group, Main ledger, Ledger
Category: Asset, Liabilty, Income, Expense
*Refer trial balance print [using ---- symbol for tree style]

QuoteActions

Copy link

#84

Updated by unnikannan S 6 months ago

Status changed from New Changes to Reopen Bugs

ISSUE FOUND
---------------

1.Add Attachment Button For Ledger Accounts
2.Should be on edit mode when redirected from Account search

QuoteActions

Copy link

#85

Updated by Vivekp V 6 months ago

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

ISSUE FIXED
---------------

1.Add Attachment Button For Ledger Accounts
2.Should be on edit mode when redirected from Account search

Actions

Copy link

#86

Updated by unnikannan S 4 months ago

Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
% Done changed from 70 to 90

QuoteActions

Copy link

#87

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. Add a + button on the top left after save order button. Title: Add new category.
2. When click this the data entry field should be same as an edit mod of an already saved category.
3. In that after type add another field, Mapping Category: --(this field should appear only if the type is category)
-- select box - Asset, Liability, Revenues, Expense
nb: mapping category and parent shouldn't be same.
4. Note: Add according changes in the trial balance, profit and loss report and balance sheet.

5. Add title for Act as customer, Act as supplier checkbox fields.

Fields in Db
------------------------------------
sin_chart_of_ac_sub_category SMALLINT DEFAULT 0,--*1.1
sin_is_dynamic_category SMALLINT DEFAULT 0,-- Add via Chart of Account GUI 1=Dynamic

QuoteActions

Copy link

#88

Updated by Arathy PS 12 days ago

Status changed from New Changes to Reopen Bugs

ISSUE FIXED
----------------------------------------
1. THE TYPE SHOULD BE ABLE TO CHANGE FROM LEDGER TO MAIN LEDGER AND VICE VERSA: ASK A CONFIRMATION MESSAGE, VALIDATE THE CHANGE WE HAVE USED THE ACCOUNT IN TRANSACTION MODULES.

Actions

Copy link

#89

Updated by Vivekp V 11 days ago

Status changed from Reopen Bugs to New Changes

QuoteActions

Copy link

#90

Updated by Arathy PS 11 days ago

Status changed from New Changes to Reopen Bugs

ISSUE FIXED
-----------------------
1. Can't change the type from main ledger to ledger even though the associated records are deleted.--same issue in reverse case also (ledger changed to main ledger after deleting the document)
2. A main ledger which is changed to ledger is not loading in account fields.

Actions

Copy link

#91

Updated by Vivekp V 11 days ago

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

Actions

Copy link

#92

Updated by Vivekp V 11 days ago

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

QuoteActions

Copy link

#93

Updated by Arathy PS 8 days ago

Status changed from New Changes to Reopen Bugs

ISSUE FIXED
-----------------------------
1. Can't delete a ledger that is converted (from main ledger to ledger) --viceversa

Actions

Copy link

#94

Updated by Vivekp V 8 days ago

Status changed from Reopen Bugs to New Changes

1-CsModel.cs (2.17 KB) 1-CsModel.cs		Anil KV, 08/29/2022 05:58 PM
2-tsModel.ts (1.51 KB) 2-tsModel.ts		Anil KV, 08/29/2022 05:58 PM
3-CsFile.cs (15 KB) 3-CsFile.cs		Anil KV, 08/29/2022 05:58 PM
4-CsControllerFile.cs (24.8 KB) 4-CsControllerFile.cs		Anil KV, 08/29/2022 05:58 PM
5-TsFile.ts (14.1 KB) 5-TsFile.ts		Anil KV, 08/29/2022 05:58 PM
6-HtmlFile.html (1.92 KB) 6-HtmlFile.html		Anil KV, 08/29/2022 05:58 PM
sql.sql (17.5 KB) sql.sql		Anil KV, 08/30/2022 03:00 PM
account.sql.txt (14.5 KB) account.sql.txt		Anil KV, 09/13/2022 01:46 PM

Project

General

Profile

TAAS

Custom queries

Watchers (8)

Feature #27

Chart Of Account

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Anil KV over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Amal Cyriac over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Amal Cyriac over 2 years ago

Updated by Muhasin PU over 2 years ago

Updated by Amal Cyriac almost 2 years ago

Updated by Muhasin PU almost 2 years ago

Updated by Muhasin PU almost 2 years ago

Updated by unnikannan S over 1 year ago

Updated by Junaid M over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Junaid M over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Anil KV over 1 year ago

Updated by Seema Mathew over 1 year ago

Updated by Vivekp V over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Vivekp V over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Junaid M about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Junaid M about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S 11 months ago

Updated by Vivekp V 10 months ago

Updated by unnikannan S 10 months ago

Updated by unnikannan S 10 months ago

Updated by Vivekp V 10 months ago

Updated by unnikannan S 10 months ago

Updated by unnikannan S 9 months ago

Updated by Vivekp V 9 months ago

Updated by unnikannan S 9 months ago

Updated by unnikannan S 9 months ago

Updated by Vivekp V 9 months ago

Updated by unnikannan S 9 months ago

Updated by Vivekp V 8 months ago