Feature #27
openChart Of Account
Added by Anil KV over 2 years ago. Updated 8 days ago.
50%
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 |
Subtasks
Related issues
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
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
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
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": "" }
];
Updated by Anil KV over 2 years ago
- Estimated time changed from 48:00 h to 40:00 h
Updated by Muhasin PU over 2 years ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
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
- 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
- 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
- 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
- Parent Validation & Reordering Fixed.
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
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'.
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.
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 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
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
- 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
- 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 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 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 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 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.
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.