Tuesday, June 26, 2012

How to create permission matrix for SSRS Report

How to create permission matrix for SSRS Report
Since all report in AX 2012 are migrated in SSRS so it is very important to understand its permission matrix.
There are three way to assign permission in SSRS
To create a system-level Permission
  1. If necessary, log on as a local administrator.
  2. Open a browser window and type the Report Manager URL to start the application. For example http://<server name>/reportserver
  3. Click Site Settings at the top of the page.
  4. Click the Security tab at the side of the page. This page shows all system-level role assignments that are currently defined. On a new report server installation, only the two predefined roles, System Administrator and System User, are visible. There is one built-in role assignment that is created automatically; it maps the built-in local administrators group to the System Administrator role
  5. Click New Role Assignment.
  6. In Group or user name, specify a domain group account that includes all of the users who require permissions to view report server content and subscribe to reports. Specify the account in this format: domain\group. The account should be in the same domain or in a trusted domain. If you do not have a domain group that fits this description, you can specify individual domain user accounts instead.
  7. Select System User.
  8. Click OK.
  9. Click New Role Assignment again.
  10. In Group or user name, type the name of a domain user account for a user who has administrative responsibilities for this report server. Specify the account in this format: domain\user. The account should be in the same domain as the report server or in a trusted domain.
  11. Select System Administrator.
  12. Click OK.
You have successfully created two system-level role assignments. One role assignment grants minimal system-level permissions to a domain group account. The second role assignment grants administrative permissions to a specific user account

To create an item-level Permission

·         Assign the Browser role to users who will view reports and create individual subscriptions. 
·         Assign the Report Builder role to users who will perform all of the tasks provided in the Browser role, plus create reports in Report Builder. 
·         Assign the Publisher role to users who will perform all of the tasks provided in the previous roles, with additional permissions for publishing reports and models from Business Intelligence Development Studio. 
·         Assign the Content Manager role to a small set of users who will manage content on a report server. 
1.       Click Home at the top of the page to open the Report Manager home page.
2.       Click the Folder Settings button.
3.       Click New Role Assignment.
4.       In Group or user name, specify the name of a domain group account that includes all of the users who require permissions to view reports. Specify the account in this format: domain\group. The account should be in the same domain or in a trusted domain. If you do not have a domain group that fits this description, you can specify individual domain user accounts instead.
5.       Select Browser.
6.       Click OK.
7.       Click New Role Assignment again.
8.       Type the name of a domain user account for a user who has administrative responsibilities for this report server. Specify the account in this format: domain\user. The account should be in the same domain or in a trusted domain.
9.       Select Content Manager.
10.    Click OK to save the role assignments.
You have successfully created two item-level role assignments. One role assignment grants minimal permissions to a domain group account. The second role assignment grants administrative permissions to a specific user account.

To create  Permission  on the report

1.       Search Report on which security needed.
2.        click the Properties tab.
3.       Click Security.
4.       Click New Role Assignment.
5.       In Group or user name, specify a domain user account that needs permission to view the report.
6.       Select Browser.
7.       Click OK.
You have successfully created an item-level role assignment on a specific report. The user has permission to open folders and view a single report. No other items are visible to the user. To check your work, ask the user to open Report Manager and access the report.

Friday, June 15, 2012

Dynamics Axapta History

Axapta History

Development of Axapta began in 1983 at Danish company Damgaard Data A/S. The software was mainly targeted at the European market, though the North American market grew rapidly following the release of Axapta 2.1 in 2000.

Axapta 1.0
Mar 1998
The first version of Axapta was released in the US and in Denmark in March 1998 by Danish company Damgaard A/S. It supported both Microsoft SQL Server and Oracle database servers. Notable features were financial, trade, inventory management, logistics and production.
Axapta 1.5
Nov 1998
The second major version of Axapta was released in Norway, Sweden, Germany, UK, Netherlands, Austria, Switzerland, Belgium, Spain and the European Union in November 1998.
Axapta 2.0
Jul 1999
The third major version of Axapta was released to customers in July 1999. Notable new features were the Project Accounting module, Warehouse Management (WMS), External OLAP, Option Pack concept, ActiveX support, COM-connector and an early release of the Axapta Object Server which allowed offloading of some operations from the clients onto a separate server.
Axapta 2.1
Jan 2000
This release stemmed from market demands from Germany, Austria, Switzerland and Spain. It was the fourth major version of Axapta and was released in January 2000. The most notable new feature was the addition of a Web tool called the Customer Self-Service (CSS) which is the precursor to today's Enterprise Portal. With Axapta 2.1 SP3 (Service Pack 3), the AOS (Axapta Object Server) was introduced making Axapta the first fully three-tier ERP-system in the market.

Following the merger of the two Danish companies Navision and Damgaard, Axapta was to be known as Navision Damgaard Axapta for versions 2.5 and 3.0 (up until 3.0 SP5).

Axapta 2.5
Dec 2000
As the fifth major release, Axapta 2.5 brought with it a complete web applications development environment, the Project module, Banking and OLAP. It was released first to Denmark, Austria and United Kingdom in December 2000.
Axapta 2.5 Market Pack
Oct 2001
This market pack was released for Axapta 2.5 in October 2001 in France and Italy. This new application layer contained the Customer Relationship Management module (CRM or Marketing Automation), Commerce Gateway and Product Builder (both Client-side and CSS-side (Web)).

 Microsoft (current)
Microsoft acquired Navision Damgaard during the summer of 2002. Navision Damgaard Axapta was first renamed to Microsoft Business Solutions Axapta, then to Microsoft Dynamics AX for versions 3.0 SP6, 4.0 and 2009.

Axapta 3.0
Oct 2002
The sixth major Axapta release brought with it the Microsoft Axapta Enterprise Portal, new intercompany collaboration functionality, actualized and rebuilt user security and system configuration, expanded geographical reach (more countries), demand planning and enhanced partner productivity tools.
Dynamics AX 4.0
Mar 2006
The seventh major Axapta release brought with it an updated look and feel. As the first version that Microsoft was involved in from the beginning it attempted to integrate better with existing Microsoft technologies. For example, the AOS became a true Windows service, a .Net business connector was provided, CLR interoperability was introduced and XML data exchanges were supported through a set of code classes (Application Integration Framework), full Unicode support was introduced and a new Service Management module.
Dynamics AX 2009
Jun 2008
Originally named AX 4.1, later renamed to AX 5.0 (and finally AX 2009), the eighth major release of Axapta brings with it yet more improvements to the UI. This new version adds role-based concepts to both the Enterprise Portal and Windows clients, support for timezones (UTC), a new Site inventory dimension, and Enterprise Portal development through Visual Studio projects.
Dynamics AX 2012
Aug 2011
Known as AX 6 during development, AX 2012 was released in August 2011. It included improvements to the user interface, general application and developer enhancements, and added industry-specific solutions for Process Manufacturing, Professional Services, and Public Sector organizations. The release also included support for SharePoint 2010, Visual Studio 2010 and SQL Server 2008 R2.
Dynamics AX 2012 Feature Pack
Feb 2012
Released  after AX 2012, the feature pack added a Retail solution in addition to the previously released industry-specific solutions.
Dynamics AX 2012 R2
Q4 2012
Announced at the Convergence 2012 conference, AX 2012 R2 is due to ship in late 2012 and is expected to include enhanced support for Microsoft SQL Server 2012.

Tuesday, June 5, 2012

AX 2012 Add-Ins Error

Above Error comes when Ax add-ins not installed correctly
So install AX Add-ins component again. and compile. it will work fine.

ERP Accounting term

The following accounting term will seems very easy for some but for technical guys its very helpful to understand ERP term ...try this
Accountant - a qualified person who is skilled at managing and analysing business financial records.
Asset - Any type of property; anything that adds value. The assets of a business are money in the bank, accounts receivable, securities held in the name of the business, property or buildings, equipment, fixtures, merchandise for sale or being made, supplies and all things of value that the business owns.
Authorised capital - the total amount of capital which a company, by its memorandum of association, is authorised to offer for subscription. See also, paid up capital.
Balance sheet - A financial statement about a business at a particular point in time. It lists the business assets, liabilities and proprietorship.
Breakeven point - the point at which volume of sales is enough to cover all costs.
Budget - an estimate of expenses and revenue required.
Budgeting - Planning the expected revenue and expenditure of a business for a given period.
Capital - the total owned and borrowed funds in a business.
Capital expenditure - Money spent in purchasing an asset.
Cash flow - the flow of internal funds generated within the business as a result of receipts from debtors, payments to creditors, drawings and cash sales.
Cashflow projection/ cash budget - How much cash your business needs to generate to cover all costs and make an acceptable profit.
Company - a business owned by a group of people called shareholders, which has its own legal identity separate from its owners.
Compliance - procedures that are undertaken at regular intervals or on an ongoing basis to ensure that the regulations and/or laws laid down by an authoritative body are kept.
Controllable expenses - those expenses that can be controlled or restrained by the businessperson.
Cost of goods sold - the total cost to the business of the goods sold during an accounting period. In its simplest form this is the sum of the opening stock plus all purchases less the closing stock.
Creditor - a person or business to which money is owed.
Current assets - includes cash, short-term deposits, customers’ accounts, stock (includes work in progress, raw materials and finished goods), that will be converted into cash during the normal course of business, within a year.
Current liabilities - short-term debts such as bank overdraft, creditors and provisions set aside to pay taxation and other commitments (for example, holiday or long service leave) and expected to come due within one year of the Balance Sheet.
Debt - that which is owed. If you borrow money, buy something on credit or receive more money on an account than is owed, you have a "debt.
Debt capital - money from external sources used to finance a business. See also equity capital.
Debtor - a person or business who owes money.
Depreciation - Loss in value of assets over time.
Depreciation expense - gradual reduction of the value of a fixed asset and gradual application of this cost to the expenses of a business over the useful life of the asset.
Depreciation schedule - a table showing depreciable assets, the year each was purchased, its cost, the percentage by which it is depreciated each year and written down current value.
Direct costs - the costs incurred, in addition to fixed costs, as a result of manufacturing a product or providing a service. Direct costs are made up of direct material, direct labour and direct manufacturing or servicing costs.
Dividend - a distribution of the profits of a company among its members or shareholders.
Drawings - withdrawals of assets (usually cash) from a business by a sole proprietor or a partner. Enterprise - When used generically, an enterprise is defined as the aggregate of all functional elements participating in a business process improvement action regardless of the organisational structure housing those functional elements.
Entity - an individual (sole trader), partnership, a body corporate, a corporation, an Incorporated association or body of persons, a trust or superannuation fund.
Equities - stocks and shares invested in a business and not bearing fixed interest.
Equity capital - money provided by the business owner/s to finance the business.
Expenses - costs incurred by a business in earning income, for example, rent, advertising, wages etc. Finance - The short term funds required for the day to day operation of the business, and the capital funding from various sources required for the longer term financing of the organisation.
Financial statements - formal reports prepared from accounting records describing the financial position and performance of the business.
Fixed assets - the land, buildings, vehicles, materials and equipment owned by a business, which are used to earn revenue rather than being for sale.
Fixed costs - Costs which remain constant whatever the level of business activity. Rent, for example, must be paid whether or not any business is accomplished.
Goodwill - the excess price asked for the sale of a business over the value of its physical assets; an intangible asset, the price of which represents a payment for the existing client base and future profits.
Gross profit - the excess of net sales over cost of goods sold usually expressed as a percentage.
Income - money that is being earned by the business.
Income statement - a financial document that shows how much money (sales) came in and how much money (costs) was paid out. Subtracting the costs from the sales gives you your profit and all three are shown on the income statement.
Intangible assets - those assets of a business, which cannot be assigned a firm, fixed value, such as leases, franchises, goodwill and patent rights.
Inventory - the value of all the stock of physical items that a business uses in its production process or has for sale in the ordinary course of doing business.
Joint Venture - A form of strategic alliance in which a business is owned jointly by two or more independent firms that continue to function separately in all other respects but pool their resources in a particular line of activity.
Key performance indicators (KPIs) - Criteria used for measuring essential tasks and skills involved in a job to assess how well it is being performed.
Limited partners/partnership(s) - a legal partnership where some owners are allowed to assume responsibility only up to the amount invested.
Liquidate - to settle a debt or to convert to cash. This literally means to do away with.
Liquidation - The sale of the assets of a portfolio company to one or more acquirers when venture capital investors receive some of the proceeds of the sale.
Loan/(s) - The advance of a specified sum of money to a person or business (the borrower) by other persons or businesses, or more particularly by a specialist financial institution (the lender), which makes its profits from the interest charged on loans.
Margin - the difference between the selling price and the purchase price of an item usually expressed as a percentage of the selling price.
Compare mark-up. Mark-up - the price increase between buying at wholesale and selling at retail often expressed as a percentage of the wholesale or cost price.
Merchandise - goods that may be sold or traded.
Net - what is left after deducting all charges (see gross).
Net profit - the remainder after all expenses of an accounting period are deducted from all revenue of the same period.
Net worth - the owner/s’ interest in a business, calculated by subtracting all liabilities from the assets of the business.
Non-profit or not-for-profit business - A business that does not operate for the profit or gain of its individual members.
Operating expense - all the expenses normally incurred in running a business, during an accounting period, excluding the cost of goods sold.
Overdraft - a form of loan by which a person with a trading bank current account is given permission to continue making drawings on the account up to an agreed limit, after the balance has been reduced to nil. Overhead(s) - expenses which are incurred in producing a commodity or rendering a service, but which cannot conveniently be attributed to individual units of production or service. Examples are heating, lighting etc.
Paid-up-capital - the total capital of a company. It comprises both shares issued for cash or for acquisition of assets and bonus shares.
Partnership(s) - a legal business relationship of two or more people who share responsibilities, resources, profits, and liabilities.
Personal assets - the money you have in the bank, whatever is owed to you, any securities (shares) that you own, the property you own, whatever part of your home that you own, your furniture and appliances and all the miscellaneous things that you personally own.
Price - Something of value that is exchanged for something else.
Principal - in the case of a loan, refers to the actual amount borrowed and on which interest is paid. Private equity – Includes all non-public equity and hybrid instruments: business angel capital, venture capital, management buy-outs, management buy-ins, and mezzanine arrangements.
Profit - total revenue less total expenses for a period of time calculated in accordance with generally accepted accounting principles.
Profit and loss statement - statement of revenue and expenses showing the profit or loss for a certain period of time.
Profit margin - the amount that the price of a product or service is raised above its cost in order to provide a gross profit.
Proprietary company - a business which is owned by not less than two persons and not more than 50 persons and which restricts the right of the shareholders to transfer shares. Such a business is a separate legal entity and must use the words Proprietary Limited (Pty Ltd) after it name.
Proprietorship - the value of the proprietor’s assets in a business less any external liabilities.
Rate of stock turnover (stock turn) - the ratio of cost of goods sold over average stock (at cost). This indicates how many times, on average, the entire inventory (stock) was sold and replaced during the year. Receivership - the legal condition a company is placed in when an official receiver is appointed to investigate and manage its affairs.
Return on investment (ROI) - the ratio of net profit after income tax, over owner’s equity. Usually expressed as a percentage.
Sales - the total value of goods sold or revenue from services rendered.
Secured - protected or guaranteed as in the case of a loan where the lender holds the title of some asset until the borrower has repaid the loan in full.
Selling - The act of disposing of a product in exchange for money.
Sole trader - a person who trades by himself/herself without the use of a company structure or partners and bears alone full responsibility for the actions of the business.
Solvent - the condition of a business when all debts can be paid as they come due.
Stakeholders - All those who have an interest in an organisation, its activities and its achievements. These may include customers, partners, employees, shareholders, owners, government, and regulators.
Stock - Items produced, manufactured, acquired or purchased by a business for manufacture, sale or exchange. (physical items (inventory) that a business uses in its production process or has for sale in the ordinary course of doing business).
Tangible asset - something substantial or real that is capable of being given an actual or approximate value. Term loan - a loan for a fixed period of more than one year and repayable by regular instalments.
Trade credit - an arrangement to buy goods or services on account, that is, without making immediate cash payment.
Trade discount - an allowance made by a seller to a buyer at the time of purchase, for the deduction of a percentage of the price, provided the payment is made within agreed terms.
Trial balance - a list of all balances in the ledger at a given time.
Turnover - The amount of money that passes through a business during a financial year.
Under-capitalisation - insufficient investment of funds in a business.
Unit Cost - The total costs in resource and material to produce one instance of a product or service. Unsecured loan - a loan that is not backed up by any collateral, such as a home or an automobile offered as security.
Value - Worth, desirability or utility. Usually, determined as a Balance between different characteristics (such as price and benefits).
Variable Cost(s) - Costs which vary in direct relation to the production of goods or services. Variable costs go to zero if the activity stops.
Working capital - Liquid funds available to the business represented by current assets, less current liabilities. (the excess of current assets over current liabilities of any business at any time)