Friday, February 23, 2007

Why Netsis?

• Principle of customer satisfaction and excellence,
• Experienced in corporate customers and international applications,
• More than one thousand certified ERP experts across Turkey,
• Widespread business partner network,
• Easy and quick to use and adapt,
• Flexible, online and real-time working opportunity with other software products,
• Project development and management based on analysis utilising methods at international standards,
• Evaluation of received user demands and general adaptation of requirement demands,
• Local solutions, fast support services and legislative compliance.

Thursday, February 22, 2007

History and Evolution of ERP

1960s
Inventory Management & Control
Inventory Management and control is the combination of information
technology and business processes of maintaining the appropriate level of
stock in a warehouse. The activities of inventory management include
identifying inventory requirements, setting targets, providing replenishment
techniques and options, monitoring item usages, reconciling the inventory
balances, and reporting inventory status.


1970s
Material Requirement Planning (MRP-1)
Materials Requirement Planning (MRP-1) utilizes software applications
for scheduling production processes. MRP generates schedules for the
operations and raw material purchases based on the production requirements of
finished goods, the structure of the production system, the current
inventories levels and the lot sizing procedure for each operation.


1980s
Manufacturing Requirements Planning (MRP-2)
Manufacturing Requirements Planning or MRP utilizes software
applications for coordinating manufacturing processes, from product planning,
parts purchasing, inventory control to product distribution.


1990s
Enterprise Resource Planning (ERP)
Enterprise Resource Planning or ERP uses multi-module application
software for improving the performance of the internal business processes.
ERP systems often integrates business activities across functional
departments, from product planning, parts purchasing, inventory control,
product distribution, fulfillment, to order tracking. ERP software systems
may include application modules for supporting marketing, finance, accounting
and human resources

2000s
The difference between ERP and ERP -2
The difference between ERP and ERP -2 "In 1990 when we coined the term, ERP was enterprise centric with very little awareness of anything going on around it," says Zrimsek. "Today, we’re moving towards collaborative commerce, or c-commerce. To do that you have to share information outside the enterprise."
ERP II systems are not just the backbone of the enterprise. They are also the information link for an enterprise in the supply chain. That’s because the business of tomorrow is going to play multiple roles in multiple supply chains, from traditional sources to electronic marketplaces.
The challenge for ERP -2 is two-fold. First, it’s to aggregate and manage the data surrounding all the transactions of an enterprise as accurately as possible in real time. Then, it’s to open up the system to make that information available to trading partners.

Fusion @6 ForeRunner

Software applications, local software in particular, were first introduced only 10-15 years ago as automation systems that facilitate accounting functions with limited management support systems. In those years, the accounting departments of companies used to keep all the records of the company, even issued the documents like the invoices, etc. Almost any operation that can be defined as corporate application would be handled manually.
With the improvements introduced through the years, we learned about the ERP (Enterprise Resource Planning), a concept almost a classic today. We can illustrate Enterprise Resource Planning as the integrated whole of all the applications of an enterprise, an integrated whole where all operations conducted from receipt of customer orders to shipment.
When evaluated under integrated business solutions, these applications fall under the topic of production planning applications, i.e. product trees, product routing, material requirement planning, capacity planning, production flow control and quality control. Under the topic of logistics and sales applications, on the other hand, are warehouse-branch inventory management, distribution modules, and under finance applications are bank, current accounts, accounts, promissory note/check applications. Under general ledger applications are accounting, inflationary accounting, and cost accounting. Additionally, human resources and inventory management systems are under the topic of integrated business solutions.
With the newly emerging economical process, however, requirements reached different levels. Companies now desire to go beyond the existing integrated systems. Today, fast and correct flow of work not only became a standard, but also technology is expected to provide companies with solutions that introduce strategic competitive advantages. In line with the new developments, we should particularly mention some applications, which new tendencies frequently refer.
Applications as Customer Relations Management, Supply Chain Management, Workplace, and Marketplace are the decision support systems that provide companies with facilities that exceed the above-mentioned solutions that are merely integrated, and furthermore advance their productivity and profitability. Today, these notions constitute the basic concepts of modern business conduct. In order to achieve the success of their business models, all enterprises that endeavour to maintain their existence in the new economy, exploit the advantages offered by technology in outperforming their competitors by distinguishing their corporate strategies.
Netsis follows the stunningly fast improving technologies of our day and thus applies to its products according to the needs and requirements of the domestic market. Supporting our customers in creating their competitive advantages is our priority objective.

Netsis Efforts in Social Responsibility

The local ERP market leader Netsis continues with its “Sustainable Education Project of IT Enterprises toward Information Society,” which it initiated in the context of its corporate responsibility campaign. The project aims at contributing to the education of students as qualified individuals who can produce ideas on IT solutions, design software. In the framework of the project, Netsis employees give courses primarily in computer and industrial sciences departments, and also business administration and economics departments of state universities, and vocational high schools for trade and computes sciences. Since the beginning of the project with the start of the school year in September 2004, the course topics that were covered are “General Definitions,” “Project Management,” “Cost Advantages and Immeasurable Advantages,” “Determining the Data Model,” and Diagrams of the Existing System.” Almost one hundred Netsis employees continue to give courses on voluntary basis in the framework of the project. The project, which Netsis General Manager Murat Ihlamur also personally lectures, includes vocational school like Balçova Ticaret Meslek Lisesi, Göztepe Anadolu Meslek Lisesi, Konak Halk Eğitim Merkezi, Ömer Zeybek Ticaret Meslek Lisesi, and Adnan Menderes University, İzmir İleri Teknoloji Enstitüsü, Ege University Vocational Training School, Konya Selçuk University, Dokuz Eylül University, and Ege University. Among the seminar topics given by Netsis executives are “Netsis and Career,” “Making Career in the IT field,” “Marketing Management.” Netsis that was founded with hundred-percent Turkish capital in 1991, targets to expand the programme to the schools in İstanbul and Ankara in the second phase of the project and then further countrywide. The project is open to participation and waits for the contributions of all companies and non-profit organizations that are active in the Turkish IT sector.

Netsis Awards Sales Champions


In December, Netsis awarded its Solution Partner’s that have gained the highest amount of new customers. In the contest, which was organized on regional basis within the framework of a promotional activity, Pronet, Viasoft, and Berka won the first places.
Netsis General Manager Murat Ihlamur presented the Aegean Region winner’s prize personally.

Wednesday, February 21, 2007

Netsis Solutions

Netsis Technology Solutions:

  • Enterprise Resource Planning – ERP
  • Supply Chain Management – SCM
  • Customer Relationship Management – CRM
  • Supplier Relationship Management - SRM
  • Product Life Cycle Management - PLM
  • Human Resources Management - HRM
  • Warehousing & Business Intelligence
  • E-Business – B2B, B2C, G2C, B2E
  • Enterprise Integration
  • Mobile Business Solutions
  • Radio Frequency Identification - RFID
  • Location Based Information Systems
  • Speech Technologies

Netsis Industry Based Technology Solutions:

  • Logistics Business Solutions
  • Retail Business Solutions
  • Automotive Business Solutions

Netsis Solutions

Netsis Technology Solutions:

  • Enterprise Resource Planning – ERP
  • Supply Chain Management – SCM
  • Customer Relationship Management – CRM
  • Supplier Relationship Management - SRM
  • Product Life Cycle Management - PLM
  • Human Resources Management - HRM
  • Warehousing & Business Intelligence
  • E-Business – B2B, B2C, G2C, B2E
  • Enterprise Integration
  • Mobile Business Solutions
  • Radio Frequency Identification - RFID
  • Location Based Information Systems
  • Speech Technologies

Netsis Industry Based Technology Solutions:

  • Logistics Business Solutions
  • Retail Business Solutions
  • Automotive Business Solutions

Netsis Human Resources

With the Human Resources Management System of Netsis you can obtain the automation needed by your Human Resources Department and the integration into other departments.

E-Netsis Applications

With Fusion, Netsis supports the web functions its customers, work partners and supply chains need in the transition to the new economy, and classifies the new economy operations under four headings: e-Sales, e-Collabo

Netsis Planning and Production Applications

With the Planning and Production applications of Netsis you can use the production planning functions, define your bill of materials and routings, keep your production records and get the basic cost data. With the so-called MRP2-level applications you can achieve planning and tracking of the four basic production factors: material, man, machinery and money.

Logistics and Sales Applications

Netsis logistics applications allows you to design your work processes in accordance with the flexibility, activities and innovations as required by your customers. Netsis logistics applications has been designed to reinforce your supply chain according to the concepts you use to increase the productivity of your company.

Awards won by Netsis

Netsis was awarded Microsoft’s “Best Commercial Program” prize in 2001, and Oracle’s “Best Database Export” prize in 2003. Chosen “Turkey’s best institutional software expert” in 2003, the company has succesfully realized its founding vision of becoming the best local ERP provider and is now pursuing its work as a firm exporting sowftware programs to neighboring countries.

Friday, February 16, 2007

Sample NETSIS Database Trigger ON TBLCAHAR

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [UPTR_CAHARU] ON [dbo].[TBLCAHAR]
FOR UPDATE
AS
BEGIN
DECLARE @SUBE_KODU TDBSMALLINT
DECLARE @CARI_KOD TDBCARIKOD
DECLARE @BELGE_NO TDBBELGENO
DECLARE @BORC TDBFLOAT
DECLARE @ALACAK TDBFLOAT
DECLARE @ENT_REF_KEY TDBENTKEY
DECLARE TBLCAHARU CURSOR FOR SELECT SUBE_KODU,CARI_KOD, BELGE_NO, ENT_REF_KEY, BORC, ALACAK FROM INSERTED WHERE CARI_KOD LIKE '20%' AND LEN(CARI_KOD)=11
OPEN TBLCAHARU
FETCH NEXT FROM TBLCAHARU INTO @SUBE_KODU, @CARI_KOD, @BELGE_NO, @ENT_REF_KEY, @BORC, @ALACAK
WHILE @@FETCH_STATUS<>-1
BEGIN
IF EXISTS (select * from TBLCAHAR where SUBE_KODU = @SUBE_KODU AND CARI_KOD= @CARI_KOD AND BELGE_NO=@BELGE_NO AND ENT_REF_KEY = @ENT_REF_KEY)
BEGIN --KAYIT VARSA
UPDATE TBLCAHAR SET BORC=@BORC, ALACAK=@ALACAK
WHERE SUBE_KODU = @SUBE_KODU AND CARI_KOD= @CARI_KOD AND BELGE_NO=@BELGE_NO AND ENT_REF_KEY = @ENT_REF_KEY
END
FETCH NEXT FROM TBLCAHARU INTO @SUBE_KODU, @CARI_KOD, @BELGE_NO, @ENT_REF_KEY, @BORC, @ALACAK
END
CLOSE TBLCAHARU
DEALLOCATE TBLCAHARU
END