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.
Microsoft Dynamics GP Fixed Assets helps you create and maintain records of assets such as property, plant equipment and vehicles. This module provides complete tracking of fixed assets from the time they are acquired up to the point when they are retired from use.
Description and Tracking of assets
Dynamics GP 10.0 Fixed Assets module enables users to efficiently manage the physical inventories – defining the specific assets, where they are located and the condition of each item. Besides tracking leased assets, it also tracks the movement of assets from one location to another as well as the repair and maintenance of the items. Ensuring that the hazard insurance policies are current and up to date is vital in case of catastrophic events and this module keeps track of policy expirations.
Seamless Integration with General Ledger Accounting
Dynamics GP 10.0 Fixed Assets module allows accountants to properly report the state of affairs to the stakeholders such as shareholders and creditors, by providing the means to capitalize, depreciate and dispose assets. This accounting software also provides the capability of demonstrating the impact of Fixed Assets on the General Ledger and keeping Payables, Purchasing, Receivables, Sales and General Ledger tightly integrated and providing a seamless flow without any effort.
Future Projections and Tax Reporting
Forecasting depreciations is a feature within Dynamics GP 10.0 Fixed Assets, which allows projections into the future. Tax reporting is also easily facilitated as it allows the same asset to be depreciated across two different methods and facilitates comparisons. This module also allows users to specify different rules for state and federal taxes, as the taxation may be different. The way it is reported at the corporate level as opposed to the taxation level may be entirely different and Dynamics GP 10.0 accommodates this easily.
Key benefits
1)The main benefit of using Dynamics GP 10.0 Fixed Assets is that it allows you to create an unlimited number of book classes. Book Class records allow you to group assets according to how depreciation should be handled when reporting to Federal, State, and Corporate levels. Book class records can also be used to group assets based on type of property, depreciation method, depreciable life and averaging convention.
2)It enables you to define 15 user defined fields in the Fixed Asset Company window. This facilitates flexibility and scalability across many industries.
3)Accuracy of data is maintained, since only valid data can be entered in the transactional windows based on the Book class, Location, Account Groups and Insurance Classes etc. that have been pre-defined.
4)Fixed Assets enables complete flexibility as depreciation can be calculated for a single asset, an asset class, a group of assets, assets in a particular book or all assets.
5)Depreciation projections can be run, to forecast the potential impact in the future without affecting the Fixed Asset files.
6)If there are any changes to fixed assets, Dynamics GP 10.0 allows you to reset the depreciation for the current year or to the beginning of the life of the asset or to depreciate forward using the new data.
7)Mass changes can be processed easily, for retiring assets. Once the asset is retired, the gain or loss is automatically calculated based on the selling price and the net book value.
8)Mass changes can also be processed for transfers of assets. Whether the asset is transferred or received, the appropriate depreciation is automatically allocated for the transferring asset and this depreciation will be calculated on the transfer date of the asset.
9)There are numerous reports that come standard with the Fixed Assets module. These reports can be easily modified or customized to meet the companys user requirements.
10)The inquiry window allows you to trace the origin of the transaction even if it came from outside of the Fixed Asset module.
11)There is seamless integration between Fixed Assets, Purchasing Order Processing, Payables and General Ledger, without any additional work on the part of the users.
For more information on Microsoft Dynamics-GP 10.0, please visit Integrity Partners online at https://www.integritymbs.com or call 888.869.4090 ext 701. The Certified Microsoft Partner Firm Integrity Partners provides Microsoft Dynamics- GP ( formerly known as Great Plains) install & ongoing services for the following regions: New York, NY, Brooklyn NY, Bronx NY, Queens NY, All Areas of Connecticut, Pennsylvania, New Jersey, Nassau County ,Suffolk County ,Westchester County ,Rockland County, Putnam County , Orange County , Dutchess County , Ulster County ,Northern New Jersey , Hudson County , Union County , Essex County, Passaic County , Bergen County ,Morris County ,Middlesex County , Monmouth County , Mercer County , Hunterdon County , Somerset County , Ocean County (North of Toms River) , Sussex County, Southwestern Connecticut , Fairfield County , New Haven County , Litchfield County, Newark, New Jersey , Jersey City, New Jersey, Yonkers, New York, Paterson, New Jersey, Bridgeport, Connecticut, Elizabeth, New Jersey , New Haven, Connecticut ,Stamford, Connecticut , Waterbury, Connecticut, Edison, New Jersey. New York City Great Plains consultants, Microsoft Dynamics GP Consultant NYC, NYC Dynamics GP consultants, NYC Great Plains Consultants, NYC Microsoft Great Plains Partner, Microsoft Dynamics GP partners in NY, microsoft dynamics gp consultants, microsoft dynamics gp firm, Microsoft Dynamics GP New Jersey, Microsoft Dynamics GP NJ, Microsoft Dynamics GP Partners, Microsoft Dynamics GP Training, Accounting Software, accounting software, business management accounting software, ERP Software, GP 10.0, GP 9.0, Great Plains accounting software, Great Plains Software, Microsoft Dynamics GP 10.0, Microsoft Dynamics, Microsoft Dynamics GP, Microsoft Dynamics GP 9.0, Microsoft Great Plains, microsoft great plains consultants, microsoft great plains firm, Microsoft Great Plains New Jersey, Microsoft Great Plains New York, Microsoft Great Plains NJ, Microsoft Small Business Financials, Small business accounting software. Integrity Partners does provide National & International Microsoft Dynamics-GP Services as well.
Accounting is the study of how businesses track their income and assets over time. Accountants do much more than the generic presumptions; they compute costs and efficiency gains from new technologies, participating in strategies for mergers and acquisitions, quality management, developing and using information systems to track financial performance, tax strategy, and health care benefits management.
The career is a highly momentous and versatile. The field is usually divided into three broad areas: auditing, financial/tax and management accounting. Audit: Work in audit involves checking accounting ledgers and financial statements within corporations and government.
Budget Analysis:
Budget analysts are responsible for developing and managing an organizations financial plan.
Financial:
Financial accountants prepare financial statements based on general ledgers and participate in important financial decisions involving mergers and acquisitions, benefits/ERISA planning and long-term financial projections.
Management Accounting:
Management accountants work in companies and participate in decisions about capital budgeting and line of business analysis.
Tax:
Tax accountants prepare corporate and personal income tax statements and develop tax strategies involving issues such as financial choice, how to best treat a merger or acquisition, deferral of taxes, when to expense items and the like.
Various levels of skill are apportioned dissimilarly amongst the divisions which implies that depending on your position their will be specific demands on your adeptness, while average
speaking skills are requisites for all areas; the ability to synthesize varies from throughout each. Audit accounting requires a medium level of skill, tax and financial demands a low level of skill, and Management accounting a high level of proficiency.
Entry level accountants can expect a very team oriented environment. Often they will start as a junior member of a team responsible for auditing an important account or preparing financial statements. It is imperative that junior members learn to pull their weight, and function as a capable, effective, and useful member of the unit. Anyone interested in the field can prepare for a bright career.
According to the bureau of labor statistics their have been considerable increases in job openings, reflective of the fields growth and competitiveness. With the right skills and education this growth establishes the possibility for an incredibly profitable career.
Top firms include KPMG/Peat Marwick, Ernst and Young, Deloitte and Touche, Arthur Anderson, Price WarterhouseCoopers, Grant Thornton, BDO Seidman, and McGladerly and Pullen. College graduates seeking entry level positions should consider employment with these firms. Most people do not make partner at public accounting firms but the experience and training can be excellent.
From there, many move on to careers with an accounting focus in business or government. Ambitious talented accountants can advance their career with the acquisition of skills and experience along the way and subsequently enjoy a very successful career.
SAP FI module is the new package introduced specifically for financial concerns. It is special package which comes up with capability of meeting all accounting and financial needs of the organization. It is a module where financial managers can review the financial position of the company in real time. The SAP FI modules real time functionality allows the financial manager to take better decision making and strategic planning for the organization. The other standard feature of FI module is that it integrates with materials management, production planning, sales and distribution, plant maintenance, project systems and human resources modules.
Some of the components and elements comprised are accounts receivable, accounts payable, asset accounting, consolidation, general ledgers and still more. When a company decides to make use of SAP, it is required to come up with several primary prerequisite configurations. The structure of the firm should be processed properly by the managers and it is the foremost step which should be set up for business reporting requirements. The structure should be created along with client, company, business area configurations. The highest unit in SAP system is client unit which contains master records, tables and valid records. A company unit is a unit where financial statements can be created assigned with many company codes.
More number of FI configuration considerations is business area, COA, GL, fiscal year and currencies. The configuration requirement for set up in SAP consisting are chart of accounts, fiscal year variants and currencies. SAP is popularly referred among the users has fully integrated system. It is therefore better for the users to know about the integration points available in the module. The organization units are defined better in FI and other SAP modules. To transfer the data between FI and CO (controlling), company code is required to be assigned in each module. When generating the business transactions, the business areas are required to be entered with updated information.
Document postings will be automatically posted in the year along the Fiscal Year variant set-ups based on the month, start and end dates within the given period. As people know that SAP is an integration development system where more benefits can be availed. There are several integration points available in SAP which can be used for other application progressions. Nowadays, SAP modules fetch good demand among the business organization. Different sorts of are integrations are outsourced to meet the requirements of the people. It is used to meet all accounting and financial needs of the organization.
The most effective (and realistic) use of business planning options is likely to be a combination of several approaches undertaken with a coordinated effort. As noted below, complicated problems will usually require complex solutions. This will often translate to a series of business management and planning maneuvers that can take a number of months or even several years to complete. Business owners will be wise to avoid any working capital consulting expert portraying the problem-solving process as easy or quick.
For a company that is not experiencing one or more substantial problems, the need for new business planning options is rarely a high priority. However even for the most healthy business, contingency plans are advisable. A valuable illustration of the value of contingency planning for business financing is seen in recent examples of banks suddenly eliminating commercial mortgage loans programs with little or no advance notice. Unfortunately changes can continue to occur with little warning due to the level of chaos that currently prevails throughout commercial banking.
For most complex problems, there are rarely simple solutions. The current difficulties for small business owners are a growing challenge. For most businesses, similar circumstances have not been seen during the past several decades. Without at least some outside help, even a highly experienced business owner is likely to be missing enough direct experience to make it through the maze of current problems and changes.
The disturbing number of changes which have occurred throughout the business world recently support the growing need for business management and consulting options. To adequately address many of the complicated changes impacting business financing options, most business owners will not have enough technical skills or information. For even the most skilled borrower, when they discover that many banks have imposed significant fee increases for their commercial finance services, finding effective alternatives (that are also less costly) for business funding services will probably prove to be difficult. Because they are different as well as new approaches to replace traditional bank financing, viable business finance alternatives can seem confusing.
Because of cost issues, many small businesses will often not consider small business finance consulting even when serious problems are acknowledged. Costs cannot be ignored for this or any other corporate service. This is particularly true in the current economic environment because very few businesses have substantial discretionary funds to cover new business expenses. It will nevertheless be necessary sometimes for a business to spend money like this in order to either reduce costs or increase sales.
Searching for additional management options has probably already begun by prudent small business owners seeking help to lessen the impact of the severe financial conditions seen recently. The most effective alternatives are likely to include business planning and small business finance consulting. Various strategies for cost control will also be helpful for most small businesses trying to cope with reduced sales volume.