Tag Archives: statement

Crystal Reports for SQL Based ERP Systems SAP Organization One particular, Microsoft Dynamics

Crystal Reports for SQL Based ERP Systems SAP Organization One particular, Microsoft Dynamics

SQL Server opens new horizons in Crystal Reports design and deployment. Right here you possibly can separate the report presentation from data choice layer. Instead of linking tables directly in CR it is easy to now develop SQL View or Stored Process and test their outcomes prior to opening Crystal Reports Designer. Speaking about particular Corporate or Smaller Enterprise ERP platform – here it is advisable to know table structure in order to create SQL View. In this modest publication we would like to offer you two examples: SAP Business enterprise A single and Microsoft Dynamics. Let’s start with advantages of SQL View and Stored Procedure as report information pulling:

1. SQL View. Let’s assume that you don’t prefer to do choose statement test directly in Crystal and would like to keep away from such annoying problems as duplicate rows and incorrect Mcsa Exams summaries. Plus you’d like to use such constructions as SQL Union. And as well as that you just do not wish to develop the entire report and then potentially comprehend that it does not perform as expected and you would must redo tables linking and redesign fairly substantially the entire report. Then what you may determine to perform is make SQL View and test its outcomes in SQL Server Management Studio

2. Stored Procedure. CR is treating final Select statement or Union as its base. Stored Process parameters are translated into Crystal parameters. What are the positive aspects of Stored Process? Properly in SP you’re not restricted to just sophisticated joins in Select statement or Union. Here you can use parameters, temporary tables, data update (be cautious usually do not compromise data integrity!). It really is also probable to use Exec statement and develop Choose statement on the fly analyzing the set of parameters. You can also use SQL cursors specially in creating temporary tables. Stored Procedure could give you the advantage of much better performance comparing towards the view as here Crystal doesn’t must apply restrictions towards the total View selection and each of the job are accomplished in high efficiency SQL Server. Let’s now move on to SAP B1 tables and fields

3. SAP Organization 1. For anybody who is not doing long-term programming project in Computer software Development Kit then there’s no should install it and review tables diagram from there. We recommend you just login SB1 user workstation and in menu mark View -> System Information. Let’s now assume that your custom report will should pull the fields from Sales Invoice. Open Sales invoice form and place the cursor over the field in question. Table and field name information will be displayed in the bottom left corner of the user interface. Some comments before you begin your SQL View or Stored Process creation. SAP BO is three tiers Compact Business ERP application. This means that direct data update via custom SQL statements will be detected by Watch Dog service and transmitted to SAP. Consider just information selection and try to steer clear of updates on the SQL Stored Process level

4. Microsoft Dynamics ERP and CRM Family. There are several products where direct pick from SQL Server database is OK. Among them GP (formerly known as Great Plains), NAV (former Navision), CCNA Certification SL (originally Solomon) and CRM. In the case of Dynamics AX Axapta direct access to SQL Server is not recommended and rather you should consider X++ code and such development tool as MorphX. Microsoft actually is trying deemphasize Crystal Reports and rather advise SQL Server Reporting Services (SSRS)

5. Financial Reporting where Crystal is not recommended. General Ledger is tightly connected with Accounting theory and double entry. When you really need to generate Balance Sheet, Profit and Loss Statement or Statement of Cash flow including consolidated versions please consider such tools as Microsoft Management Reporter or its predecessor FRx. If you ever decide to recreate P&L directly in Crystal you should expect to reproduce most of FRx enterprise logic and this is in our opinion not a feasible idea

http://endeavor30.articlealley.com/crystal-reports-for-sql-based-erp-systems-sap-organization-one-particular-microsoft-dynamics-2430171.html

Credit Card Statement Abbreviations

Credit Card Statement Abbreviations

This list will explain the meaning of the abbreviations on the credit card processing billing sheet of the monthly charges for processing credit cards. At first glance, the customer print out may be difficult to understand. Take a time to study the layout of the statement. Each merchant services provider has an assorted format for the monthly statement. Look at the sections first and then look at the columns. The columns usually list things currency volume, number of transactions, individual purchase fees, discounts percentage and discount paid.

Here is a list of the meaning of abbreviations and meaning of some of the words found on the credit card processing print out.

Meaning of Abbreviations on Merchant Services Statement

* ADJ = adjustment

* AMEX = American Express

* AUTH = authorizations, and is usually related with dealings fees

* AVG TKT = average ticket

* AVS = address verification system, and is a dealings gift surcharge.

* BTCH HDR = batch header. Most processors calculate a small dealings gift for each batch

* CHG = charge

* CHGB = chargeback

* CNP = bankcard not present

* DISC = discount, which is the discount evaluate or percentage evaluate being charged

* DSCV= = Discover

* “MC” effectuation MasterCard

* “NABU” is MasterCard’s dealings fee

* “PCI COMP” effectuation commercialism bill industry compliance. This is an annual fee

* “POS”= location of sale

* QUAL = qualified. The evidence might list the eligible rate, mid-qualified rate, and non-qualified rate

* REF NO = reference number and is assigned to each batch

* STMT FEE= billing fee

* TRANS= transaction

* VS= Visa

* WAT =is a type of dealings fee

Description of Types of Cards

Here are some examples of the types of abbreviations found on the credit card processing print out that are used to describe the assorted credit bill types in the market:

* COMM CNP = commercial, bill not present

* Rewards 2=is a type of credit bill with a rewards program and is charged a mid-qualified rate

* CORPDATA is a corporate credit bill that falls into the non-qualified percentage category

* EIRF=is a type of non-qualified card

* DB or DBT= debit

* ENH MER 3= enhanced merit 3

* MCW= MasterCard World Card

Merchants and business owners should be open to getting quotes from other merchant services companies, as the rates go up twice a year. The merchant services industry is very competitive, so merchants should have a firm sense of understanding of the rates and fees related with accepting credit cards.

http://accountmerchant.articlealley.com/credit-card-statement-abbreviations-1519617.html

PROBLEM ACTION AND RESULTS (PAR) STATEMENTS.

PROBLEM ACTION AND RESULTS (PAR) STATEMENTS.

PROBLEM

Identify a problem that you faced while employed in the job that required extra-ordinary performance in order to solve.

ACTION

State the action that you took in order to solve the problem or that identified a solution. Include a short description that indicates how you prepared to handle the solution.

RESULTS

Now state the results that you obtained after implementing the solution. Express by using numerical terms such as dollars, percentages, or hours saved.

Insert a positive statement detailing your overall accomplishments after each position.

RESULTS STATEMENTS

Utilize PAR structure to develop your result’s statement.

Results Example: Executed restructuring of all equipment maintenance under one department. Increased preventive maintenance completion percentages by 75%.

PAR STATEMENT DEVELOPMENT EXAMPLE

PROBLEM:

Overall production yield at the end of the manufacturing line was 50% below expectation, causing a loss in company revenue. The products built were co-fired electronic ceramic packages used to house computer chips.

ACTION:

Implemented process improvements that provide better product alignment. Developed test procedures to verify alignment accuracy during intermediate manufacturing stages.

RESULT:

Increased the overall production yield 40% and reduced product resident time on the line by 20%.

ACCOMPLISHMENT STATEMENT:

Implemented process improvements in the manufacturing of electronic ceramic packages, increasing the overall production yield 40%.

SAMPLE RESULTS STATEMENTS

GENERAL MANAGEMENT:

Reduced head count by 50% while improving planning service levels, by restructuring organization of planning department and eliminating one layer of management.

Supervised the quality control of 350 diagnostic products worth $7 million per year in sales.

Designed, developed, and implemented a forecast/master production schedule system which resulted in a $2.5 million reduction in inventories in 1986 and record low customer back orders.

FINANCIAL AND ACCOUNTING:

Analyzed monthly data center and labor charges, identifying previously undetected errors often in excess of $30,000 per month.

Developed and controlled a capital and operating budget in excess of $4.5 million annually.

Administered pension plans for 500 employees.

TECHNICAL:

Directed manufacturing of 19 autoimmune diagnostics; products worth $1 million annually.

Produced technical products manual for a leading emergency services and respiratory care equipment manufacturer.

Obtained the Technical Achievement Award for 1985 for developing isolation and purification procedures.

INFORMATION SYSTEMS:

Automated employee records and medical claims functions, reducing staff size by 40% and improving processing time savings $160,000 per year.

Improved laboratory quality control by implementing tracking program utilizing Lotus 1-2-3 spreadsheet template.

Conducted a management software evaluation for one of the world’s largest medical equipment manufactures.

SUMMARY STATEMENT

DESCRIBE YOURSELF

Utilize a Personality Inventory

ï‚- Social Styles

ï‚- Decision Making Styles

ï‚- Communication Styles

ï‚- Organization Styles

EXAMPLE OF A SUMMARY STATEMENT:

Resourceful, results-oriented, hands-on, people / systems manager. Excellent interpersonal communication skills. A team people builder with high ethical standards and work ethic. Fast learner. Successful in applying practical people and computer skills towards creating an effective operation.

http://robertpattersonsr.articlealley.com/problem-action-and-results-par-statements-774629.html

Crystal Reports for SQL Based ERP Systems SAP Business One, Microsoft Dynamics

Crystal Reports for SQL Based ERP Systems SAP Business One, Microsoft Dynamics

SQL Server opens new horizons in Crystal Reports design and deployment. Here you can separate the report presentation from data selection layer. Instead of linking tables directly in CR you can now create SQL View or Stored Procedure and test their results prior to opening Crystal Reports Designer. Talking about specific Corporate or Small Business ERP platform – here you need to know table structure in order to produce SQL View. In this small publication we would like to give you two examples: SAP Business One and Microsoft Dynamics. Let’s begin with advantages of SQL View and Stored Procedure as report data pulling:

1.SQL View. Let’s assume that you do not want to do select statement test directly in Crystal and would like to avoid such annoying issues as duplicate rows and incorrect summaries. Plus you would like to use such constructions as SQL Union. And in addition to that you do not want to create the whole report and then potentially realize that it doesn’t work as expected and you would have to redo tables linking and redesign pretty much the whole report. Then what you may decide to do is create SQL View and test its results in SQL Server Management Studio

2.Stored Procedure. CR is treating final Select statement or Union as its base. Stored Procedure parameters are translated into Crystal parameters. What are the advantages of Stored Procedure? Well in SP you are not restricted to just sophisticated joins in Select statement or Union. Here you can use parameters, temporary tables, data update (be cautious do not compromise data integrity!). It is also possible to use Exec statement and build Select statement on the fly analyzing the set of parameters. You can also use SQL cursors especially in building temporary tables. Stored Procedure could give you the advantage of better performance comparing to the view as here Crystal doesn’t have to apply restrictions to the total View selection and all the job are done in high performance SQL Server. Let’s now move on to SAP B1 tables and fields

3.SAP Business One. If you are not doing long term programming project in Software Development Kit then there is no need to install it and review tables diagram from there. We recommend you just login SB1 user workstation and in menu mark View -> System Information. Let’s now assume that your custom report will need to pull the fields from Sales Invoice. Open Sales invoice form and place the cursor over the field in question. Table and field name information will be displayed in the bottom left corner of the user interface. Some comments before you begin your SQL View or Stored Procedure creation. SAP BO is three tiers Small Business ERP application. This means that direct data update via custom SQL statements will be detected by Watch Dog service and transmitted to SAP. Consider just data selection and try to avoid updates on the SQL Stored Procedure level

4.Microsoft Dynamics ERP and CRM Family. There are several products where direct select from SQL Server database is OK. Among them GP (formerly known as Great Plains), NAV (former Navision), SL (originally Solomon) and CRM. In the case of Dynamics AX Axapta direct access to SQL Server is not recommended and instead you should consider X++ code and such development tool as MorphX. Microsoft actually is trying deemphasize Crystal Reports and rather recommend SQL Server Reporting Services (SSRS)

5.Financial Reporting where Crystal is not recommended. General Ledger is tightly connected with Accounting theory and double entry. If you need to produce Balance Sheet, Profit and Loss Statement or Statement of Cash flow including consolidated versions please consider such tools as Microsoft Management Reporter or its predecessor FRx. If you decide to recreate P&L directly in Crystal you should expect to reproduce most of FRx business logic and this is in our opinion not a feasible idea

6.Please call us 1-866-304-3265, 1-269-605-4904 (for international customers, where our representative pick up the phone in St. Joseph, MI call center) help@efaru.com. We have local presence in Chicagoland, Southern California, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico, Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian, Chinese. Our core expertise is in International Business

Andrew Karasev is Great Plains Certified Master, MVP, help@efaru.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space

http://akarasev.articlealley.com/crystal-reports-for-sql-based-erp-systems-sap-business-one-microsoft-dynamics-2390906.html