Wednesday, 21 December 2016

ERP Integration

 

 

 Financial setup




STEP 1
1. Go to Admin module
2. Go to Table tabfolder
3. Select Business Type
4. Select General in the Table Code column
5. Create your own business type. each company's accounting structure is depended on the/it's business type.

STEP 2
1. Go to Accounts module
2. Read through the classifications rules.
3. Go to the Required tabfolder
4. Select the Business Type, see example "General"
5. Create or modify your accounting structure based on the classification rules above

STEP 3
1. Go to the Company module
2. Go to the Financial Setup tabfolder.
3. Select the company.
4. Select the year.
5. Click on Period # field and click the new record button, bottom left to create the financial year periods. 1-12 periods - records
6. Click on the save record button, bottom left.
7. Go to the Chart of Accounts tabfolder
8. Click on the Create/Update Chart of Accounts, based on the business type attached to the company, see Company tabfolder Business field and also Admin module Accounts Required tabfolders
9. Modify the Other Ref, Other Title, Analysis Code1->Analyze by department, Analysis Code2-> Analyze by project or event

Other Ref
[M]M15-1000 -> first letter of Company Ref
M[M]15-1000 -> first letter of business type
MM[15]-1000 -> financial year
MM15-[1000] -> account code based on classification

STEP 4
1. Go to the Opening Balances tabfolder
2. Enter the opening balances and date based on audited accounts, the Net[Dr/Cr] must equal to 0 zero
3. Click on the Post Opening Balances button.

STEP 5
1. Go to the Budgets tabfolder
2. Select the respective account
3. Click on Period # field and click the new record button, bottom left to create the periodic budgets. 1-12 periods - records
4. Click on Update Budget button followed by Refresh Chart button

 

 

GL code allocations



 
STEP 1
1. Go to the Company module.
2. Go to the Bank Accounts tabfolder.
3. Select the Bank A/c Name and go to the GL A/c Ref field.
4. Select the bank account GL code and attach it to the bank account record.
5. Go to the Tariffs, Expenses and Payment tabfolder and check that they have corresponding GL codes in you chart of accounts structure.

STEP 2
1. Go to System - GL - Allocate GL Codes module
CSBMS - Business Management System
CSCMS - Clinic Management System
CSFMS - Farm Management System
CSPMS - Property Management System
CSSNL - Savings and Loans System
2. Go to Cus/Sup/Emp tabfolder
CSBMS - Cus/Sup/Emp tabfolder
CSCMS - Cus/Sup/Emp tabfolder
CSFMS - Cus/Sup/Emp tabfolder
3. Select Customer and attach the debtors/accounts receivable GL A/c code
CSBMS - Customer
CSCMS - Patient & Company
CSFMS - Customer
CSPMS - Tenant, Property & Landlord
CSSNL - Clients - since deprecated see Client Transaction Types below
4. Select Supplier attach the credit/accounts payable GL A/c code
5. Select Employee and attach the employee expense GL A/c code, when the payroll is not in use
6. Select Stores and attach the inventory and cost of goods COG GL A/c codes
7. Go to Exp/Trf/Payments tabfolder see company module tariffs, expenses & payments
8. Select Expense and attach the respective expense GL A/c codes
9. Select Tariffs and attach the revenue/income GL A/c codes
10. Select Payment and attach the cash, bank GL A/c codes

STEP 3
CSSNL - Savings and Loans System
1. Go to Facilties - Client Transactions Types
2. Select respective Fees and attach revenue GL A/c codes
3. Select respective Savings and attach liabilities GL A/c codes
4. Select respective Shares and attach liabilities GL A/c codes
5. Select respective Loans and attach respective loan, current assets, GL A/c codes
6. Select respective Interest and attach revenue GL A/c codes
7. Select respective Penalties and attach revenue GL A/c codes
8. Select respective Other Income and attach revenue GL A/c codes

 

 

GL posting




STEP 1
1. Go to the General Ledger module.
2. Go to the GL Entries tabfolder. internally generated transactions based on integration
3. Select the Journal Date [Filter] to post one day at a time where necessary.
4. Click on Post GL Entries button to post the internally generated transactions.

STEP 2
Corrections - Each internally generated transaction can be corrected from it's source module, the first two letters denoting it source, i.e.
[PM]1000001 from payment modules,
[RC]1000001 from receipting modules
[IN]1000001 from income modules - CSBMS & CSFMS
[BI]1000001 from income modules - CSCMS & CSPMS
[AP]1000001 from accrual modules - CSSNL
see Company module Sequences tabfolder
1. Go to the respective module, i.e. Cash Receipts.
2. Select the bearer of the transaction, i.e. customer
3. Go to transactions tabfolder
4. Select the transaction that requires correction
5. Go to GL Entries tabfolder
6. Edit/make the desired corrections and save.
7. Go back to STEP 1 above.

  

 

End of year procedures





STEP 1
1. Go to the General Ledger module.
2. Go to the Year End Closing tabfolder. ensure! that you have 3140 - Income Summary and 3110 - Capital accounts in you accounting structure.
3. Click Generate Closing Journal Entries button. the totals must balance before proceeding
3. Click Post Closing Journal Entries & Run Year End Routine button.
This is a fully automated procedure that:
-> closes your financial year,
-> creates the next financial year,
-> creates new financial periods,
-> create new chart of accounts and
-> posts the opening balances.

takes approximately five minutes.
4. Go the GL code allocations section and manually allocate the new year's GL codes accordingly, takes approximately 30 minutes.

 

Report Logo Format

Insert company logo or letter head


1. Go to the Company module.
2. Select the company.
3. Click on the Logo button
4. Insert the company logo or entire company letter head. File types jpg, gif & bmp formats

Position company logo or letter head

1. Go to the Admin module.
2. Go to the Tables tabfolder.
3. Select Report Logo
4. Select Align in the Table Code column and change the Int Value, default is 7.
Options: Right - [3] :-: Left - [7] :-: Centre - [8]

5. Select Height in the Table Code column and change the Int Value, default is 830.
Max is 1130 when Top is set to 0
6. Select Left in the Table Code column and change the Int Value, default is 7965.
Min is 0 when Width is set to 9065
7. Select Sizemode in the Table Code column and change the Int Value, default is 2.
Options: Normal - [0] :-: Stretch - [1] :-: Zoom - [2]
8. Select Top in the Table Code column and change the Int Value, default is 300. Min is 0
9. Select Width in the Table Code column and change the Int Value, default is 1100. Max is 9065. 


Format report footer

1. Go to the Admin module.
2. Go to the Tables tabfolder.
3. Select Report Footer
4. Select Mcl - Bills in the Table Code column and change it to xxx - Bills where xxx is your company ref then change the Alp Value, default is "Please make your payment to .........."
5. Select Mcl - Payments in the Table Code column and change it to xxx - Payments where xxx is your company ref then change the Alp Value, default is "Please note that ......"
6. Select Mcl - Receipts in the Table Code column and change it to xxx - Receipts where xxx is your company ref then change the Alp Value, default is "Thank you for your business"
7. Select Mcl - Statements in the Table Code column and change it to xxx - Statements where xxx is your company ref then change the Alp Value, default is "For any questions, please call ..."

Pre printed stationery

1. Go to the Admin module.
2. Go to the Tables tabfolder.
3. Select Pre Printed
4. Select Bills in the Table Code column and change the Use to Yes, default is No
5. Select Payments in the Table Code column and change the Use to Yes, default is No
6. Select Receipts in the Table Code column and change the Use to Yes, default is No
7. Select Statements in the Table Code column and change the Use to Yes, default is No

Tuesday, 20 December 2016

One PC Installation




One PC installation




1. Install the respective CSXXX_Setup software. XXX -> BMS, CMS, FMS, PMS, or SNL
2. Launch or start the application, i.e. change XXX to:

BMS - Business Management System
CMS - Clinic Management System
FMS - Farm Management System
PMS - Property Management System
SNL - Savings and Loans System

where applicable.

3. In Win7 and above go to your system default directory, i.e. CS BMS in Program Files\CSBMSV800 or Program File (x86)\CSBMSV800.
4. Right mouse click it, CSBMSV800, and go to Properties - Security.
5. Click Edit followed by Add.
6. Type Everyone in the Enter the object names field and press Ok.
7. Click Allow Full control and click Apply, Ok, Ok.
8. Go to C:\Users\{your computer name}\AppData\Local\VirtualStore\Program Files (x86) and delete the CSBMSV800.
8. Re-launch or re-start the application.

Network Installation


Server installation




1. Install the respective CSXXX_Setup software. XXX -> BMS, CMS, FMS, PMS, or SNL
Note the Server computer name, and must share the same workgroup with client computers
2. Launch or start the application, i.e. change XXX to:

BMS - Business Management System
CMS - Clinic Management System
FMS - Farm Management System
PMS - Property Management System
SNL - Savings and Loans System

where applicable.

3. In Win7 and above go to your system default directory, i.e. CS BMS in Program Files\CSBMSV800 or Program File (x86)\CSBMSV800.
4. Right mouse click it, CSBMSV800, and go to Properties - Security.
5. Click Edit followed by Add.
6. Type Everyone in the Enter the object names field and press Ok.
7. Click Allow Full control and click Apply, Ok, Ok.
8. Go to C:\Users\{your computer name}\AppData\Local\VirtualStore\Program Files (x86) and delete the CSBMSV800.
9. Go to your system default directory, i.e. CS BMS in Program Files\CSBMSV800 or Program File (x86)\CSBMSV800
10. Right mouse click it, BMSBKPV800, and go to Share with or Sharing and select share this folder and click Apply, Ok,
11. Right mouse click it, BMSDOCV800, and go to Share with or Sharing and select share this folder and click Apply, Ok,
12. Right mouse click it, BMSDBSV800, and go to Share with or Sharing and select share this folder and click Apply, Ok



Client installation




1. Install the respective CSXXX_Setup software. XXX -> BMS, CMS, FMS, PMS, or SNL
Note the Server computer name, and must share the same workgroup with server computer
2. Launch or start the application, i.e. change XXX to:

BMS - Business Management System
CMS - Clinic Management System
FMS - Farm Management System
PMS - Property Management System
SNL - Savings and Loans System

where applicable.

3. In Win7 and above go to your system default directory, i.e. CS BMS in Program Files\CSBMSV800 or Program File (x86)\CSBMSV800.
4. Right mouse click it, CSBMSV800, and go to Properties - Security.
5. Click Edit followed by Add.
6. Type Everyone in the Enter the object names field and press Ok.
7. Click Allow Full control and click Apply, Ok, Ok.
8. Go to C:\Users\{your computer name}\AppData\Local\VirtualStore\Program Files (x86) and delete the CSBMSV800.
9. Go to your system default directory, i.e. CS BMS in Program Files\CSBMSV800 or Program File (x86)\CSBMSV800
10. Delete BMSBKPV800 directory - folder.
11. Delete BMSDBSV800 directory - folder.
12. Delete BMSDOCV800 directory - folder.
13. Go to the ODBC Configuration section


ODBC configuration




1. Go to the client computer see Client installation section
Note the Server computer name, and must share the same workgroup with server computer
2. Map the database, backup and documents directories - folders from the server computer
3. Go to start, right mouse click on computer and select map network drive...
4. Browse to the server computer name and select the database folder, i.e. BMSDBSV800 and map it to the Z drive. remember to check the reconnect at logon.
5. Browse to the server computer name and select the backup folder, i.e. BMSBKPV800 and map it to the Y drive. remember to check the reconnect at logon.
6. Browse to the server computer name and select the backup folder, i.e. BMSDOCV800 and map it to the X drive. remember to check the reconnect at logon. change XXX to:

BMS - Business Management System
CMS - Clinic Management System
FMS - Farm Management System
PMS - Property Management System
SNL - Savings and Loans System

where applicable.

7.1. For 32bit computers, go to control panel, administrative tools, data sources (odbc)
7.2. For 64bit computers, go to c:\Windows\SysWOW64\odbcad32.exe
8. Select the respective software CS BMS V800
9. Click configure button
10. Click select button
11. Click on network button
12. Click on drives next to the network button
13. Select z drive
14. Double click on the database CSBMSDBS in the database name window and click Ok, Ok.
15. Launch or start in the network environment.

Go to the ODBC Configuration section


Backup configuration




1. Login as and Go to Admin module

Note the Server computer name i.e. \\Server

BMS - Business Management System
CMS - Clinic Management System
FMS - Farm Management System
PMS - Property Management System
SNL - Savings and Loans System

where applicable.

Database backup
 
2. Go to Table tabfolder
3. Select Backup Path/Backups Location
4. Select Backup in the Table Code column
5. Change the Description of the backup to the appropriate location i.e. \\Server\BMSBKPV800
6. Click Save button
7. Select Database in the Table Code column
8. Change the Description of the backup to the appropriate location i.e. \\Server\BMSDBSV800
9. Click Save button

Documents & Photos

10. Go to Table tabfolder
11. Select Doc Paths
12. Select Documents in the Table Code column
13. Change the Description of the documents to the appropriate location i.e. \\Server\BMSDOCV800
14. Click Save button
15. Select Photos in the Table Code column
16. Change the Description of the photos to the appropriate location i.e. \\Server\BMSDOCV800
17. Click Save button

What are the system features?

Standard
  • Windows Based: run on Microsoft Windows7 or higher
  • User License(s) : based on user license(s) 1-50 with upgrade or downgrade user licenses (ULs)
  • Multi Company: independent registration and management of data per company
  • Multi Currency: default currency and exchange rate per financial transaction
  • Online Help: online documentation provided at the click of the Help button
  • Online Backup: backup the system online to a pre-defined location
  • Facilities: integrated to Microsoft Office, inbuilt messages, email and internet connectivity
  • Link Files: link or attach word, excel, pdf and photos files to records
  • Data Upload: securely import/upload data from MS Excel spreadsheets
  • Report Generator: includes an integrated report generator for creating user defined reports whose output can be exported to MS Excel spreadsheets



Requirements - minimum
  • Operating System (OS): Microsoft Windows7
  • Processor (CPU): Pentium Duo Core 1GHz - Giga Hertz
  • Hard Disk Space (HDD): 40GB - Giga Bytes
  • Random Access Memory (RAM): 1GB - Giga Bytes
  • Super VGA Display (Monitor): 1024x768 pixels
  • Standard (Devices): Mouse, Keyboard, Printer
  • Printer: Epson LX- 300/350+ for printing statements, receipts and pay slips
  • Backup (Devices): External Harddisk 512GB recommended

What are the benefits of purchasing a license?

A huge amount of work, time and money has been spent developing the Comsoft Suite of software products.





By purchasing a user license(s) you get a customized activated installer for the respective software.

You also support future development including more useful user-friendly features.

Please feel free to post your suggestion and feature requests Click here:

We do read and consider all suggestions, but note that we cannot give any guarantees if and when a feature will be added.

What is an ERP system?


 

 

ERP is ...




ERP is short for enterprise resource planning.

Enterprise resource planning (ERP) is business management software—typically a suite of integrated applications—that a company can use to collect, store, manage and interpret data from many business activities,

Our ERP software products are divided into three sub systems, namely:
  • Management
  • Payroll
  • Financials/Accounting
Each sub system is made up of related modules with each module containing related programs/tasks.

You can implement the entire system as:
  • one integrated system,
  • individual separate sub systems, or
  • individual modules
depending on your requirements