Category: Accounting

How To Create An Odbc Dsn To Access Pastel Accounting Partner Data

Posted on by blogger

How to Create an ODBC DSN to Access Pastel Accounting Company Data (Pervasive Workgroup)

It’s really easy to create and Open Database Connectivity (ODBC) Data Source (DSN) to access your Pastel Accounting company data and this document will show you how.
BUT:
Be careful to use read-only mode because you can change data, (useful for data repair)
This procedure in this document is only for use with Pervasive Workgroup installations, (the same procedure on Pervasive Server has more steps)

1.Open Pervasive Control Centre

a.Accessing Pervasive Control Centre from the menu

i.From the Start menu, Select Programs -> Pervasive (If it isn’t there got to b.)

ii.From the Pervasive Menu, Select Pervasive.SQL -> Pervasive.SQL Control Centre.

b.Alternative: Access Pervasive Control Centre from the Run command

i.From the Start menu, Select Run.

ii.Type PCC.exe into the text box and click OK.

iii.The Pervasive Control Centre Opens

2.From the Engines node: Expand the computer node to see the Databases node.

3.Expand the Databases Node

4.Right Click the Databases folder to access Context Menu, Select New -> Database

5.The New Database Screen opens

6.Enter PASTELDEMO into the Database name Box and press Tab

7.When in the location field, click the ellipsis button to open the Browse for Folder Window
From the Browse for Folder screen, find and select the _Demo subfolder of your Pastel installation. (For your live data use the pastel company data directory, but follow along until you are clear on the procedure)

8.On the rest of the New Database Screen complete the fields as below.
a.Deselect Create dictionary files
b.Deselect Relational integrity enforced
c.Select Read Only from the Open mode dropdown

9.Click Finish to save the new database. The new database will appear as an expandable node below the Databases folder in PCC (Pervasive Control Centre).

10.Expand PASTELDEMO -> Expand Tables
you can see tables that Pastel uses to store its data (see list of tables and fields in other posts)

11.Double Click CustomerMaster table to view the data stored in the table.

When you Double Click the table it creates the SQL query -Select * from CustomerMaster-, which means -Select all columns from CustomerMaster-. You can see columns of data in the grid section.
To better understand what you are seeing, compare the grid data to the data in the Customers Explorer grid in the Pastel _Demo Company. Notice the -Ackerman Mr R’ in both programs.

Your Source Data in your Pastel Accounting Xpress/ Partner is now accessible.

Knowledgable microsoft Office users should be off to a flying start now in terms of creating refreshable spreadsheets and maile merge word documents. A few ideas for spreadheets would could be costing schedules for project type companies, commision spreadsheets for salepeople, picking slips and delivery schedules,

Mail merge documents are fantastic for sales orietated type tasks, especially when selection factors such as sales volume, territory, sales code etc. may be specified for sniper accuracy in offer targeting

I hope this article has stimulated your interest in leveraging your current Pastel accounting investment
In our next entry we will show you how to use this ODBC DSN that we have just created to access transaction information directly from Microsoft Excel.

Finance and Accounting Diploma can be right choice for Students after 12th or Graduation

Posted on by blogger

Everyone wants to make money but few know how to manage them and use for business purpose to grow known as business leaders, however true business leaders know how to do that with or without a degree or knowledge they are also known as conventional business men, however due to advancement of accounting finance and taxation knowledge and skills it has become almost very important, many businessmen have employed qualified accounts and finance professionals to manage their business in professional manner, and such professionals are in high demand and will remain in high demand for ever, these experts are those individuals who manage the wealth and generate income for business houses. Since accounts is the base of every business and commercial transaction hence a basic knowledge of accounting is very important, since most of the accounting staff and finance professionals work together alongwith taxation and payroll in any business organisation. To become such professionals one needs to know the accounting and finance courses offered at different level by different accounting institute, these institute offers various accounts training, such courses can be availed by students after 12th in commerce or there are some professional courses which can be completed after B Com Graduation. In India there are options like B Com Graduation M Com post graduation courses which can be opted after 12th commerce students, such degree are merely qualification for any accounting and finance related jobs, however there are many institutes like:- CA (The Institute of Chartered Accountants of India commonly known as ICAI) CS (The Institute of Company secretary of India ICSI) ICWA (The Institute of Cost and Works Accountants) IPA (The Institute of Professional Accountants)

These professional institutes offer professional training and job oriented courses in the field of accounts finance taxation banking auditing etc. students opting for career in commerce can opt for such professional courses as well some of the courses are four years and more this professionals can get regular job in corporate as well as they can have their own consultancy job, in today scenario most of the chartered accountants prefer to opt for a regular job however decade back most of these professional prefer to do their own professional practice.

Then there are institute of accountants like:- IPA (The Institute of Professional Accountants) of India , a Delhi based accounting institute offers Diploma in Accounting a one year course this course is mainly based on practical aspects of computerized accounting, online income tax return filing, e filing related to TDS (Tax deducted at source) Service Tax, Excise, filing of returns related to Provident fund and ESI related matters.

After doing such Diploma in financial accounting students can expect lucrative career options like:- becoming an accountant, account assistant, finance executive, accounts manager, finance manager, tax assistant, audit assistant etc. after graduation courses for commerce students Accounting Courses

Types Of Accounting Jobs And Accounting Job Description Information 101

Posted on by blogger

If you want to receive a higher salary than most professionals, why not become an accountant? Though accountancy may be viewed by other people as a boring job, the truth is, you can get lucrative earnings, and still be able to enjoy challenging work, dependent upon the kind of accounting you want to do. Take note that there are several types of accounting jobs that you can choose from to ensure that you’ll never be bored when holding an accounting post.

Some Basic Information On Accounting

Jobs for accountants usually focus on the financial aspects of a business such as record keeping, analyzing financial data, and so on. Before you can get accounting work, you should at least have a diploma in Accounting. Some employers may also state in the accounting job description that aside from your Bachelor’s Degree, you should also be knowledgeable on fields such as economic principles, computer applications related to accounting, accounting practices, and the likes.

More often than not, most of the types of accounting jobs may also give hired applicants the following job descriptions:

1.Keep track and compile financial data.

2.Analyze financial information for the creation of accurate reports/statements.

3.Keep a record of financial statements/data and update them when needed.

4.Ensure that the deadlines for giving or explaining financial reports are met.

5.Be responsible for performing audits on-time e.g. monthly, quarterly, and annually, and in the most accurate manner.

Jobs For Accountants: The Types

When you want to become an accountant, you also have to decide which type of accounting work you want to engage in.

Bookkeeping is one of the types of accounting jobs available. It is actually a position best for entry-level applicants or newly-grad applicants. The accounting job description of a bookkeeper is to handle and maintain payments, invoices, and other forms of income of the firm/company.

There is also the so-called general accountant who performs similar duties to that of the bookkeeper. General accountants have the responsibility of making any adjustments as well as any accruals on the company’s accounting records.

The position of Certified Public Accountant, or CPA, is also one of the jobs for accountants. It may be considered as the most popular and most lucrative out of all the types of accounting jobs. A CPA’s accounting job description is to be in charge of auditing financial data accurately and of course, timely. CPAs may also be tasked to compute for taxes either for a company or for an individual.

Before you become an accountant, it is important that you first ask yourself which kind of accounting work you’ll be the most interested in.

Why To Join Accounting Management Courses

Posted on by blogger

Account is always an important part for every organization either it is modern or an old company every business maintain its account to understand the profit or loss obtained by the business operations. An account manager reflects the true position of the company in financial terms. Favorable account position means more profits in business and strong position of the firm is depicting by the same. An accountant will maintain the records of financial company, analysis of accounts, implementation of new methods of accountings, and preparing all the accounts of the company.

Students interested in accounting management can take admission in MBA colleges. Here students can take professional account management which is very much essential for modern firms. Students holding an MBA degree get more opportunities as compared to others. Top MBA colleges in India are offering Accounting management courses where students can improve their skills.

Best MBA colleges in India offer professional education of account management after bachelor degree. At post graduate level students can take admission in top MBA colleges in India. Undergraduate students can also take admissions in this course but only few of the recognized board are offering this program.

Students need 50% aggregate marks in commerce stream to take admission in this course. Students must have commerce stream because accounts is the main subject of that stream. Only few of the MBA colleges in India are offering this program. Students will go through an entrance examination and many times MBA institutes conduct their own tests and interview.

Students pursuing MBA in it will improve their interpersonal skills, analysis skills; and knowledge in cost accounting will be improved. Get become perfect account manager MBA in it is must. Students who have vast knowledge in subjects like accounts, finance, law, taxation, insurance will perform better in MBA courses & colleges.

Business scenario in India is changing rapidly and many account managers are needed to complete the demands of new upcoming companies in India. Accounting management is bright career for students who have interest in accounts and sharp skills in management.

Few MBA colleges you can select for this course are:
Wigan & Leigh College, New Delhi
FMS – Faculty of Management Studies, University of Delhi
Management Development Institute, Gurgaon (MDI)
Indian Institute of Management, Lucknow (IIM L)

Students studied in MBA colleges in India are working on high packages with multinational firms and it all depends on your skills and knowledge in accounts.

Career in Accounting

Posted on by blogger

Making a successful career in his life is the ultimate aim of a student. From the starting of his education, a student starts planning about his career goals and aims he need to achieve. Medical, engineering, doctors, scientists, biotechnologists, etc are the careers which one can opt for post completing his studies in the science field. After science, be it medical or non- medical, commerce is the field which attracts students. Many students have been seen opting for career in accounting or commerce after passing their secondary school examinations.

Career in accounting or finance becomes the goal for the student’s pursuing studies in the field of sciences. The different fields to which the commerce subject is divided are: 1.)Accounting. 2.)Banking. 3.)Finance. 4.)Computers. 5.)Business studies. 6.)Economics.

After completing his senior secondary education, commerce students mainly opt for business management, computers or accountancy courses as their graduation subjects. The most popular course which has become the career goal for almost every commerce students these days is career in accountancy. Accounting Job involves the responsibility of maintaining the accounts of the organisation, analysing it and further adding on to the economic development of the company.

The three different fields or courses available in the field of accountancy are:

1.)CA- Charted Accountancy 2.)ICWAI- Cost Accountancy 3.)CS- Company Secretary

All these courses are provided by special institutes and have their individual regulatory bodies, governing the course structure and further career developments in the respective fields.

Charted Accountancy: Charted accountant is the person responsible for few of the most important functions required to run a smooth functioning of the organisation in term of its monetary funds and finances like accountancy, auditing, taxation, etc. The Institute of Charted Accountants of India (ICAI) is the organisation responsible for the regulation of charted accountancy profession in India. The students for becoming a member of this institute, has to go through a series of examinations, appearing before which, he has to register himself with the statutory body of ICAI. There are three levels of CA examination, i.e. CPT- Common Proficiency Test, PCC- Professional Competence Course, and then is the final exam, which has to be cleared, after which the student becomes a members a member of ICAI and can practise his profession in charted accountancy. The minimum time required to do this entire course is 3.5 to 4 years, which is in very rare cases, because the examination is very tough and it consumes years to pass one level.

Cost Accountancy: In this field the person responsible, is required to manage the cost related functions of the company in an organised way, he needs to collect, analyse and assemble all the cost related departments. He also needs to check, the utilisation of the funds is done in the right manner and in the productive direction. The institute responsible for application of the job responsibilities of cost accountancy in the country is The institute of Cost and Works Accountants of India. For taking admission in this course, students needs to clear three levels of examination, conducted by ICWAI, and registration for examination can be done after passing the senior secondary exam. The students having passed out all the three levels of ICWAI exam, other than working as cost accountant in public and private organisations, can also opt for working as a consultant in the field of finance management.

Company Secretary: This is another field which can be opted by the accounts or commerce students after passing their 12th exams. It is regulated by the Institute of Company Secretaries of India, which takes examination of the students applying for the course of CS, there are three levels for the same, after which the student can apply for CS in different companies and industries. As the name suggests, the job is not of a clerical or secretarial job, the CS is responsible for all the legal, board, trustee, managerial and corporate level decisions are taken with reference to the Company Secretary.

Copyright © 2026 Accounting Hermes-Belt . All rights reserved.