Enterprise Resource Planning

Open Source is a software movement where developers regain the costs of creating a software product through alternate revenue streams to the traditional proprietary software approach. The added costs of creating a proprietary niche include the use of dongles and complex activation code schemas that are abandoned by using the open source model. Revenues are typically found in annual support agreements and consulting fees instead of attempting to control the installation with added levels of complexity that are needed to achieve the standard proprietary approach.

Linux is a fundamental building block of much of the open source movement. Started by Linus Torvalds, popular Linux variants include Ubuntu, Debian and Gentoo, however commercial Linux and Unix probably are more likely to be based on Solaris, Redhat or SUSE from Novell. Consulting and support agreements with Novell, Redhat and Oracle involve investments that rival but fall short of the costs of commercial server solutions like Microsoft’s Windows Server but their stability and usability for the professionals well indoctrinated in the use of Bash, Cron and ssh are paramount.

Use of a solid Linux foundation is also available as a service by such large players in the rental server market like Amazon.com and Rackspace. Database layers like MySQL and PostgresSQL are widely supported and offer an alternative to the expensive Oracle and SQL server layers, and are more than adequate for databases of less than 10 gigabytes which is sufficient for most SMB applications.

LAMP ERP

Linux based open source software packages offer the richest and most rapidly evolving applications.

ERP or Enterprise Resource Planning also entails the normal accounting operations required in a small and medium sized business, the integration between the post-mortem analysis functions, planning procedures and the basic data collection and organizational functions required for a backbone business information system leave business planners wanting an integrated package of data processing functions to interface with the planning procedures.

Linux based open source software packages offer the richest and most rapidly evolving applications. That Redmond Washington vendor can enter a market and abandon it in a matter of a few years, leaving users with unsupported application software. While the life cycle for a release of a desktop operating system may be less than five years, many ERP implementation last two decades or more. Elements of major million dollar ERP software packages contain business logic with roots in the Fortran and Cobol of the 1960’s.

Certain SQL based packages lack much business logic entirely and the relatively new, but robust procedural language of the Oracle flavor, Plsql is developing and creating an inventory of business logic. But licensing costs drive information system specialists to continue to use applications based on the Unix operating system and the known source code model. These models rely on vendors like Redhat and Novell to maintain expertise at a lower cost while providing the option to ‘go it alone’ that indeed major banks and telecoms exercise.

Linux, Apache, MySql and PhP combine to provide applications for the business community, and with the use of Perl banking providers like Paypal provide incredibly robust and yet secure micro application environments that employ technology in innovative and profitable ways. But businesses that merely outgrow the Quickbooks model, which lacks the aforementioned integration desires that forward thinking business owners seek leave small manufacturers for example to look at packages of the next tier such as Peachtree, MAS-90 and even the Redmond solutions.

However, businesses might come across three very innovative vendors that use Linux as a basis, yet provide compatibility with Windows and Macinstosh for the most part. Linux in the previously mentioned telecom operations provides the least downtime, and many times Oracle has used Linux to set world records in the database transaction processing arena. For more information on visit www.web-atlanta.com for more information on open source modeled and Linux based LAMP ERP solutions.

What is ERP

Enterprise Resource Planning

Accounting and Operations

Bookkeeping, but more comprehensive

ERP = Enterprise Resource Planning. A comprehensive suite of applications to manage planning and operational functions requiring massive information processing in the business environment

MSInc fills a broad set of IS and IT needs from network support for small businesses with Quickbooks™, Peachtree™, or MS200/500™ accounting modules, as well as customized solutions. We provide network planning, tuning, and connectivity as well as email, web design, PC repair, PC support, and custom MySQL customer service databases. We also provide our own ERP Solution using Thoroughbred™, PVX™, and Basis BBX™ BB8 based accounting and operations systems. Our solutions support a full ERP backbone for manufacturing clients with up to 500 employees. For SaaS or “Software as a Service”, see our new Vehicle Dispatch system, available in lease and purchase license forms. Our lease model leads the way in SOA, or Service Oriented Architecture. Also available for standardized and custom ERP, MRP, CRM, and Financials models in fully normalized designs. Because of our breadth of services, from highly secure financial information, to password accessible customer service portals, through to highly visible and optimized web-sites, we are highly skilled at managing the various security requirements of your company.

Outsourcing, Eastern metro Atlanta. Small and Medium Sized Business.

Purchase Price Variance

Standard costing techniques in ERP

In absorption accounting, the measurement of the inflation or deflation of prices on raw material is measured with purchase price variance. A unit of raw material is assigned a standard cost for the year and the variation in landed cost for deliveries is tracked not with a complicated scheme of tracking on a lifo or fifo basis where each molecule of raw material can be allocated to a product that reaches the consumer, but a standard periodic cost is assigned to a unit of purchased goods. For example, if we choose to fix the cost of a #8-32 1/2″ Stainless round slotted head machine screw at $.15 for the year, the portion of the final cost of a product that uses this purchased item need not change just because the landed price for one million screws that week was $.149900 each.

We freeze the standard cost for the screw at $.15 and book a purchase price variance, favorable, of a hundred bucks. The mechanics require an accounting discipline and business logic in the purchasing and accounts payable departments of recording the landed price vs the standard. When an invoice is received from a vendor on the raw material account, the first thing we want to ascertain is that the material was received and that our vendor deserves to be paid for goods that were delivered and accepted for inventory. This means that a given purchase order receipt, which was a debit to inventory on hand for a given part number should be matched up with the invoice. This receipt is marked then as paid and the accounts payable can be processed with no shoe leather put to waste by either the purchasing or accounting departments.

A register of vouchers accepted for a given day then can be generated with the landed cost put against the standard cost to determine the favorable or unfavorable purchase price variance for raw material acquisition.

ERP and CRM

  • ERP – Enterprise Resource Planning. An integrated set of software applications to manage materials, inventory levels, supplier demand, capacity, product structure, bills of labor as well as being integrated with a accounting system capable of billing, order backlog, receivables and payables.
  • CRM – Customer Relationship Planning. A sales force and customer service tool to manage prospects, leads, customer complaints and follow up, conversion and retention. Sometimes integrated with a phone system, customer account and call center functions may fall under the broad umbrella of a CRM solution.

https://youtube.com/watch?v=OZutelDNgzE

  Erp Packages  CRM Packages
 Quickbooks XTuple and Postbooks Compiere OpenBravo SugarCRM
 Opentaps

Invest in control first, then equipment

Economically Sound, Fundamentally Strong, ERP the way your business deserves!

Don’t wait to implement ERP. Gain hold of the production planning process to optimize bookings against capacity. Collaborate on orders and dispatching. Daily data backups are sent automatically across the country between datacenters to provide the highest level of disaster recovery. Data and functions are secured by passwords, users have access to modules according to rights granted by the administrator, and each user’s account requires login with an encrypted password. WRbil has million dollar ERP features, for costs similar to the support costs you would pay for most proprietary based systems.

[[image file=”dispatch.jpg” alt=”manufacturing” title=”resource planning” align=”right” ]]

Technological Evolution

Atlanta is on the leading edge of open source, small footprint, capital efficient ERP solutions. Developed for service, process, discrete, and job shop situations, WRbil© ERP has revolutionized the speed and ease of implementation for small and medium sized business. The ease of use and lights out technical backbone complements the needs of Atlanta’s fast paced, dynamic business environment. The Warbil© approach helps companies navigate the Scylla of information sharing challenges and the Charybdis of punitive software licensing costs. While the applications industry remains heavily burdened by legacy technologies, the Open Source Community has produced frameworks widely adopted by consumer and business alike. Office applications, server operating systems, and mainframe hardware still drive an overwhelming share of the ERP market. This requires most established businesses to suffer with high licensing costs, staff intensive computer networks, and expensive hardware platforms. Despite these hurdles, most ERP is built on layers of ancient technologies laden with these drawbacks.

The leading edge versus the bleeding edge

The internet is relatively new compared to computing for business. Mainframes penetrated the accounting departments of business in the 1960’s and 1970’s, minicomputers prevailed in the 1980’s, and the desktop PC and the network became the standard in the 1990’s. But by 2000, the internet started coming on-line almost everywhere. Still ERP applications seem to require the use of a network server, similar to the use of minicomputers and mainframes in the past.

Now we have arrived in an age where open source technologies allow companies to rent their servers, like they would office space or a delivery truck. The only requirements are sophisticated applications which offer user level password validation, and a disaster recovery strategy (which is nearly always missing in today’s business networks). For dispatching to serve the customer, promises need to be kept. Misplaced job folders, poor planning, lack of detail available for planning, and inability to ‘explode’ requirements into sub-requirements are solved by use of the WRbil system. WRbil clearly organizes your commitments in real-time and on the apex of availability and visibility. In today’s business world, a company must capitalize on the heart of modern technology. To compete we leverage the internet, internal networks, and their inherent communications and integration capabilities. These tools and strategies are united in the WRbil© ERP system.

Manufacturing Support Inc.   Paypal for higher priority demo!

Atlanta Database Design | BB8 | PHP | MySQL | Apache | L.A.M.P. | RHES

Pages

Valid XHTML 1.0 Transitional

Human Capital Management

Human Capital Management, wetware, workforce, employees, many spiffy bits of jargon to describe Human Resources activities and record keeping. HCM seeks to answer questions about the employee base so that management can make strategic decisions deploying resources to maximize profits.

Employees need to be categorized. Office vs. Production, Drivers vs. Helpers, etc. HCM departments may further facilitate the process of hiring, retention and separation.

Dropbox

Companies use Dropbox.com to store from 10 gigabytes on the free plan to a terabyte or more on paid plans instead of operating expensive raid arrays. Even with a raid array in the computer room, flood fire or other disaster could wipe out the entire contents and backups of a raid array.

Dropbox uses a network of datacenters to manage storage and backups. The Windows Dropbox client is just as easy to use as any mapped drive. Dropbox for IOS and Android allow mobile devices to automatically sync video and pictures from phones and tablets to the corporate Dropbox data storage.

But for storing documents, Dropbox can be just as disorganized as a mapped drive. Wyn Rocket solves this by managing the upload and directory processes. Premium professional Dropbox users can even use protected directories to store Human Capital data out of sight of other corporate users.

The folder for an employee can contain just their application or photo, or a myriad of licensing and qualification documents scanned and uploaded through WRbil.com and are readily available outside of WRbil to those with folder permissions as defined in Dropbox.

WRbil.com acts as an app in its own application directory that is indexed according to our pre-determined set of rules. Once you use WRbil.com to organize your Human Resources Dropbox.com document storage, you will rarely want to use Dropbox.com directly because WRbil is so nimble and intuitive.

Naive phone numbers and internationalization

Phone numbers should be entered as digits, and maybe sometimes a + sign if a country code needs to be used.

A naive phone number in the United States is stored as 2025551212 and formatted as (202) 555-1212.

Internationalization of a naive phone number is achieved by adding the company naive phone number prefix to the phone number, i.e. 2025551212 becomes +12025551212.

All phone numbers can be entered either as naive or international, if the phone number is entered with the plus sign and the country code, it is stored as an international phone number.

For example, most companies in WRbil are US companies, but, for example, Airbus in Toulouse has the internal number  +33561933333, and the formatted number of +33 (561) 933-333

If the WRbil company were French, with a company naive phone number prefix of +33, the phone number could be entered as 561933333 which would be formatted as (561) 933-333

ELD Requirements, January 2016

ELD Requirements pursuant to the December 2015 FMCSA announcement absolutely no later than January 1, 2018 (or December 10, 2017, to be safe) with some older devices grandfathered until January 1, 2020 (December 10, 2019).

Is this the final FMCSA ruling on ELD’s?

Yes, this is final, immutable, never to be repealed and written in stone, unless things change.

Does the ELD replace paper DOT/FMCSA HOS (Hours of Service) logbooks?

Pretty much.

What do safety officials need to see in an ELD?

An ELD must be mounted to the dashboard, visible to the driver. It must have an instruction manual, although the manual can be electronic, i.e. the instructions can be read from the device itself. The driver must carry eight (8) days of empty logbook pages in the event of device malfunction.

Transmitting Data to Safety Officials – ELD will transmit in at least one ‘Primary’ and at least two ‘Backup’ formats. Primary include Web services, Bluetooth, Email and ‘Backup’ include USB 2.0, Scannable QR codes, TransferJet.

Email must be sent in a standard RFC 5322 Internet Message Format.

But note, in the real world, many Safety Officials will look at the HOS log on the screen of the device itself.

Safety officials will use every means possible to detect when a driver is lying, fudging or cheating, just as they always have, as is their duty.

Many ELD devices designed and put into service prior to the December 10, 2015 announcement are grandfathered until either December 10, 2017 or December 20, 2019 for the really cool ones (and depending on interpretation), paper logbooks are still legal after December 10, 2019, but only in the event of infrequent need or equipment malfunction.

Why would a really cool, new (but pre-2017) ELD still need to be replaced?

New requirements include specific xml formats, web services formats, formats that talk directly with the FMCSA website and database, logging with embedded GPS positioning data and logging with embedded hash codes that prevent tampering, to name a few, will probably require newer equipment. Anti-tampering kiosks are also a plus. Note that many of the anti-tampering requirements collide head on with the transmission requirements, e.g. USB 2.0.

Exceptions.

Timecard or Local Drivers. Short-Hauler, CDL drivers that operate within a 100 air-mile radius of the normal work reporting location or Non-CDL drivers operating within a 150 air-mile radius of their home depot are not required to install an ELD device.

Also, From the FMCSA website – https://www.fmcsa.dot.gov/faq/there-exception-drivers-who-infrequently-use-records-duty-status-rods

Is there an exception to the requirement to use electronic logging devices (ELDs) for drivers who infrequently use records of duty status (RODS)?

An exception was made to provide relief for those drivers who use RODS infrequently (that is, no more than 8 days in any 30-day period). This includes those who only occasionally drive commercial vehicles, and short-haul drivers who use time cards rather than RODS.

What is difficult for the driver in this situation is that he is forced to prove a negative.

Finally, trucks built prior to 2000 may be exempt, partially exempt, or conditionally exempt. Which has nothing to do with RODS, so read the next section.

Data Collected

The ELD should collect some location data, but the FMCSA rule only requires a GPS accuracy of +/- one (1) mile.

Section 395.26 provides that the ELD automatically record the following data elements at certain intervals: date; time; location information; engine hours; vehicle miles; and identification information for the driver, the authenticated user, the vehicle, and the motor carrier. Unless the driver has indicated authorized personal use of the vehicle, those data elements are automatically recorded when the driver indicates a change of duty status or a change to a special driving category. When the driver logs into or out of the ELD, or there is a malfunction or data diagnostic event, the ELD records all the data elements except geographic location. When the engine is powered up or down, the ELD records all the data elements required by §395.26. When a CMV is in motion and the driver has not caused some kind of recording in the previous hour, the ELD will automatically record the data elements. However, if a record is made during a period when the driver has indicated authorized personal use, some elements will be left blank and location information will be logged with a resolution of only a single decimal point (approximately 10-mile radius). In addition to the information that the ELD record

(END OF ARTICLE, for now)

software DOT Hours of Service

First we go to a selected employee and add timecards.

Make sure that employee is in a ‘driver’ category, and has a valid drivers license renewal date.

Then, all we have to do is bring up the employee and go to ‘Views’ -> HOS View and we see the employee’s time expressed as a Federal Motor Carrier (FMCSA) driver logbook page. https://www.youtube.com/embed/pq66r_WEw5c