OpenV: Free Enterprise Resource Planning via NetBeans IDE

openv is a total business software package developed primarily for the manufacturing business sector.

it provides many of the same functional mechanics that are found in commercial  erps (enterprise resource planning) packages such as accounting, receiving, shipping, order entry, costing, edi, and shop floor control:

the application is completely free to use and can be set up relatively quickly and painlessly depending on the scale and size of your current business data and practices. the application is a thick client and requires only the java run time environment and a mysql database server. while the entire application and database can be launched from a single machine (either linux or windows), the optimum layout would be a client machine (running either linux or windows) and a mysql installation on a separate machine (preferably linux). the application can be installed within a matter of minutes.

once installed, a site setup guide is provided to walk you through the setup of your site's specific data requirements, i.e. chart of accounts, item master, customer master, etc.

get the application here:

http://www.vcscode.com/openv.php

development environment

openv is developed entirely within netbeans ide 8.

t he application itself is a thick-client gui application using swing with a mysql backend. the netbeans install is hosted on a fedora 21 linux machine using java 1.7 sdk. the mysql database version is 5.6 iand is hosted on the same fedora machine.

the application itself is primarily menu-driven. each major functional area has a master menu with drill down menus for specific sub-menus under the parents. the layout manager used for the main menus is “card layout” with each menu / card having its own jpanel. each end-user menu click brings to the front the jpanel associated with that particular menu. the jpanels class names and associated jmenu names are stored in the database for easier maintenance and coding. menu access security is also stored in the database per user id.

screenshots

the main screen is essentially the primary background screen seen upon launching openv.  it provides a master menu bar for navigation within the application.

the item master shows most of the associated fields relevant to a single part number. recent activity tables, location quantity tables, costing fields, and bill of material tree structure showing components and operations are provided in this screenshot.

this image shows a bar chart of top 20 parts scrapped within the provided date range. there are many different charting options within the scrap menu to analyze scrap quantities and trends.

the edi log entry, also shown at the start of this article, shows inbound edi transactions for a given date range. the trading partner ids, doc control numbers, timestamps, and edi type are provided, as well as a single-click option to see the actual format of the raw file. this particular image shows an inbound xml formatted file to the right of the image: