Project

General

Profile

Edit Copy Actions
Copy link

Feature #9

open

Account Code Setting

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

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Baseem Shan
Target version:
22.12
Start date:
08/04/2022
Due date:
08/08/2022 (over 2 years late)
% Done:

90%

Estimated time:
20:00 h
Owner(Agency):
Travvise
Time Taken(HH):
30.00
Module:
Account Code Settings
Tested By:
unnikannan S
Code Reviewed By:
Shanto Shaji
Quote

Description

Account Code Setting

DELETE FROM accounts.tbl_ac_code_settings;

Insert the Records
INSERT INTO accounts.tbl_ac_code_settings
(vhr_sys_module_name,
sin_type,

sin_allowed_manul_entery,
                    sin_code_gen_method,
                    vhr_code_perfix,
                    sin_start_number,
                    sin_number_length,
                    sin_first_chrs_len)
                VALUES(
                ('CUSTOMER_MASTER', 0, 1, 1, 'CUS', 1, 3, 0),
                ('SUPPLIER_MASTER', 0, 1, 1, 'SUP', 1, 3, 0),
                ('COMMISSION_AGENT_MASTER', 0, 1, 1, 'SAM', 1, 3, 0),
                ('EMPLOYEE_MASTER', 0, 1, 1, 'EMP', 1, 3, 0),
                ('PROFILE_MASTER', 0, 1, 1, 'POF', 1, 3, 0),
                ('SUB_LEDGER_MASTER', 0, 1, 1, 'SBL', 1, 3, 0),
                ('CASH_MASTER', 0, 1, 1, 'CAS', 1, 3, 0),
                ('UPI_MASTER', 0, 1, 1, 'UPI', 1, 3, 0),
                ('BANK_MASTER', 0, 1, 1, 'BNK', 1, 3, 0),
                ('CREDIT_CARD_MASTER', 0, 1, 1, 'CRC', 1, 3, 0),
                ('CORPORATE_CARD_MASTER', 0, 1, 1, 'COC', 1, 3, 0),
                ('RECEIVED_CHEQUE_MASTER', 0, 1, 1, 'RCH', 1, 3, 0),
                ('PAID_CHEQUE_MASTER', 0, 1, 1, 'PCH', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 1, 1, 1, 'AS', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 2, 1, 1, 'AG', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 3, 1, 1, 'AM', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 4, 1, 1, 'AL', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 5, 1, 1, 'LA', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 6, 1, 1, 'LG', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 7, 1, 1, 'LM', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 8, 1, 1, 'LL', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 9, 1, 1, 'IN', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 10, 1, 1, 'IG', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 11, 1, 1, 'IM', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 12, 1, 1, 'IL', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 13, 1, 1, 'EX', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 14, 1, 1, 'EG', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 15, 1, 1, 'EM', 1, 3, 0),
                ('CHART_OF_ACCOUNT', 16, 1, 1, 'EL', 1, 3, 0));

Files

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

Subtasks

Add

Related issues

Edit Copy Actions
Copy link

Also available in: Atom PDF