TAAS

Chart of Account List Items
============================
Category Code
Parent Group Code
Code(Group/Ledger/Main Ledger)
Name(Group/Ledger/Main Ledger)
Display Name
Type
Main Ledger Type
Remarks
Status

Customer
===============
Code
Name
Display Name
Group
Category
Type
Family
Sys Type
Default Currency Code
Main Ledger Code(Not set then Select Default or Input)
Phone
Email
Address
Place
City
Country
ZIP Code
State
Fax
TRN Number
Credit Limit
Counter Staff
Commission Agent
ID Number
ID Expiry Date
Passport No
Passport Expiry Date
Passport Issued By
Remarks
Status

Supplier
============
Code
Name
Display Name
Group
Category
Type
Family
Sys Type
Default Currency Code
Main Ledger Code(Not set then Select Default or Input)
Phone
Email
Address
Place
City
Country
ZIP Code
State
Fax
TRN Number
ID Number
ID Expiry Date
Remarks
Status

Employee
=======================
Code
Name
Display Name
Group
Category
Type
Family
Sys Type
Default Currency Code
Main Ledger Code(Not set then Select Default or Input)
Phone
Email
Address
Place
City
Country
ZIP Code
State
Fax
TRN Number
ID Number
ID Expiry Date
Passport No
Passport Expiry Date
Passport Issued By
Remarks
Status

Commission Agent
================
Code
Name
Display Name
Group
Category
Type
Family
Sys Type
Default Currency Code
Main Ledger Code(Not set then Select Default or Input)
Phone
Email
Address
ZIP Code
Country
State
Country
Fax
TRN Number
ID Number
ID Expiry Date
Passport No
Passport Expiry Date
Passport Issued By
Remarks
Status

Cash
======
Code
Name
Display Name
Main Ledger Code(Not set then Select Default or Input)
Default Currency Code
Cash Type
Remarks
Status

Bank
=======
Code
Name
Main Ledger Code(Not set then Select Default or Input)
Default Currency Code
Group
Category
Type
Family
Address
Place
City
Country
ZIP Code
State
Contact Person
Contact Phone
Contact Email
Remarks
Status

Credit Card
===========
Code
Name
Display Name
Card Type
Main Ledger Code(Not set then Select Default or Input)
Default Currency Code
Own/Customer Card
Remarks
Status

Corporate Card
================
Code
Name
Display Name
Card Type
Main Ledger Code(Not set then Select Default or Input)
Default Currency Code
Own/Customer Card
Remarks
Status

Received Cheque
================
Code
Name
Display Name
Type
Main Ledger Code(Not set then Select Default or Input)
Default Currency Code
Remarks
Status

Received Cheque
================
Code
Name
Display Name
Type
Main Ledger Code(Not set then Select Default or Input)
Default Currency Code
Remarks
Status

GUI Changes

->Properties list 'Index' Column width reduce and 'Column' Width Ingress
->Incress 'File' Name entrybox width
-> Category Left Margin Ingress
-> Chart of Account
- 'Type' to 'Input Type String'
-> Customer and Supplier
- 'Main Ledger' to 'Default Main Ledger' (Select box)
-> Add a Tab 'Wrong Data'
List Clolumns
# | [All Column - import inputs ] | Error
[Excel file correct and import again]
-> Add a Tab - 'Not Imported'
-List Columns
# | Code Name | Main Ledger | Error

Excel to list:-

this.insGlobalFunctions.fnReadExcelFile(objFileEvent);

NEW CHANGES - FIXED
----------------------
Discuss with anil whether the Import need first two requirements fields,
1. Code and name in same column in excel file :
A checkbox Code and name in same column
Give same column no: for both code and name and if the check box is ticked then an entry box: Split character.
Add tooltip to the fields.

2. If the code is not auto generated and no code in excel file then a check box, No code-- if the check box is ticked then an entry box: code character
add title to the fields.

3. The default action type should be: Remove all and insert.