Project

General

Profile

Edit Copy Actions

Feature #27

open

Chart Of Account

Added by Anil KV over 2 years ago. Updated 8 days ago.

Status:
New Changes
Priority:
Normal
Assignee:
Target version:
Start date:
08/23/2022
Due date:
08/31/2022 (over 2 years late)
% Done:

50%

Estimated time:
40:00 h
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Chart Of Account
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Chart Of Account


Files

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

Add

Subtasks


Add

Related issues

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

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

Updated by Anil KV over 2 years ago

accounts.tbl_account

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 #5

Updated by Anil KV over 2 years ago

  • File deleted (1-CsModel.cs)
Actions #6

Updated by Anil KV over 2 years ago

  • File deleted (2-tsModel.ts)
Actions #7

Updated by Anil KV over 2 years ago

  • File deleted (3-CsFile.cs)
Actions #8

Updated by Anil KV over 2 years ago

  • File deleted (4-CsControllerFile.cs)
Actions #9

Updated by Anil KV over 2 years ago

  • File deleted (6-HtmlFile.html)
Actions #10

Updated by Anil KV over 2 years ago

  • File deleted (5-TsFile.ts)
Actions #11

Updated by Anil KV over 2 years ago

  • File deleted (sql.sql)

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 #14

Updated by Anil KV over 2 years ago

  • Estimated time changed from 48:00 h to 40:00 h
Actions #15

Updated by Anil KV over 2 years ago

  • File deleted (sql.sql)
Actions #16

Updated by Anil KV over 2 years ago

Actions #17

Updated by Muhasin PU over 2 years ago

  • Status changed from New to Coding Started
  • % Done changed from 0 to 40
Actions #19

Updated by Muhasin PU over 2 years ago

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

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

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

Updated by Muhasin PU over 2 years ago

Customer & Supplier Tab Pending

Actions #23

Updated by Muhasin PU over 2 years ago

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

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

Updated by Muhasin PU over 2 years ago

  • FIXED..
Actions #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

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)

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

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

Updated by Muhasin PU almost 2 years ago

UPDATED.
  • Parent Validation & Reordering Fixed.
Actions #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

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 #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

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

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 #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

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 #38

Updated by Anil KV over 1 year ago

  • Assignee changed from Junaid M to Vivekp V

Updated by Seema Mathew over 1 year ago

  • Tested By changed from unnikannan S to Seema Mathew

ISSUE FOUNDED****

1.MISSING ASSET

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.

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

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

Updated by unnikannan S over 1 year ago

TESTING DONE

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

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

Updated by unnikannan S about 1 year ago

ISSUE FOUNDED

1.CANT DELETE DEFAULT LEDGERS/MAINLEDGERS

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

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

Updated by unnikannan S about 1 year ago

TESTING DONE

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

Updated by Vivekp V about 1 year ago

ISSUE FIXED

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

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

Updated by unnikannan S about 1 year ago

TESTING DONE

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 )

Updated by Junaid M about 1 year ago

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

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 )

Updated by unnikannan S about 1 year ago

TESTING DONE

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

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)

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

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

Updated by unnikannan S 10 months ago

TESTING DONE

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

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

Updated by unnikannan S 10 months ago

TESTING DONE

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

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

Updated by unnikannan S 9 months ago

TESTING DONE

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

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

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

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

Updated by unnikannan S 8 months ago

TESTING DONE

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

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

Updated by unnikannan S 8 months ago

TESTING DONE

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.

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 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

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

Updated by unnikannan S 8 months ago

TESTING DONE

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)

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]

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

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 #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

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

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 #89

Updated by Vivekp V 11 days ago

  • Status changed from Reopen Bugs to New Changes

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 #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 #92

Updated by Vivekp V 11 days ago

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

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 #94

Updated by Vivekp V 8 days ago

  • Status changed from Reopen Bugs to New Changes
Edit Copy Actions

Also available in: Atom PDF