Do You Want Your Own Fully Programmable ERP? - Part 2 > NetSparsh

Home
>
Small Business
>
Do You Want Your Own Fully Programmable ERP? - Part 2

Do You Want Your Own Fully Programmable ERP? - Part 2

In the first article we mentioned the main characteristics that should have a software to be used as a Front-End with some functions of an Enterprise Resources Planning ERP:

ODBC,
Replication,
Computed Views,
Integrated e-Mail,

and we used the Lotus Notes example, but in principle will be possible to use other softwares with similar functions.

Now we will see a practical case, a system to detect and control - marketing, sales, new purchase orders - your aground products. As we know, the salesman prefer to sold new products only, and your aground products will be less and less sold.

We assume that your company already have an online managerial/accounting system, with evidently its own database.

1. We will use a method to transfer your managerial/accounting data to the Notes relational database, and although this last one has tools for that - ODBC for example - we recommended the purchase of a specific software for that purpose in order to be more flexible and with more powerful features, that must allow the following transfers:

From Notes to your relational database
From your relational database to Notes
From a Notes database to another Notes database
From ASCII files to Notes database
From Notes database to ASCII files
Synchronization of both databases
Scheduled type transfers - in a defined time, or hour or minute or day, etc.

Normally this kind of software works with the following databases - and this probably include the database type used by your company:

ALLBASE/SQL, Btrieve, Clipper, DB2, dBASE, Excel, Gupta SQLBase, IMAGE/SQL, INFORMIX, INGRES, InterBase, Microsoft SQL Server, Microsoft Access, Microsoft FoxPro, Netware SQL, Oracle, Paradox, Progress 6, SQL/400, SQL/DS, Sybase, Teradata, Files text, XDB, and also the databases types ODBC, client/server and desktop, etc.

2. We will decide what fields from your managerial/accounting system - here so called of dbCompany - you need in your new ERP. We can, for example

To establish the relationship of one-to-one, field x in Notes field y in the dBcompany,
Or we need a non-existent information, what fields we have to bring from the dBcompany to compute - in Notes - in order to obtain the desired information. We are speaking about "information", not of data.

3. We will decide if we need data transcriptions and/or data conditionally computed. A simple example would be the need - in Notes - to generate the resulting information x of the data y,k,z from the dBcompany.

4. Summarizing the above functions Second and Third - about each different product we need from your dBcompany:

All the P.Os, products received, code, description, during the period t, with dates, quantities, costs, vendors, etc
The whole sales, during the period t, with dates, quantities, sales prices, responsible salesman, etc.

5. We acquire - extract - those data, to be placed in specific Notes fields, and creating the Notes "Views".

We will continue in the next article.

Publishing Guidelines: You may publish my article in your newsletter, on your website or in your print publication provided you include the resource box at the end. Notification would be appreciated but is not required.

About The Author

J.C.Melo is a 73-years old IT professional with 54 years of experience in computer & technology entrepreneurship. He was the owner of the first minicomputer factory in South America and Consultant for the U.S. Government in several contracts. Now is the CEO of http://mba-open-university.net and http://erp-enterprise-resources-planning-courses.us.

[email protected]

In The News:

When to Consider Hiring an Accountant for Your Small Business NavAs a small business owner, you're probably looking for ways to save money on operating costs whenever possible. You might even have a bit of financial ...

What small businesses need to know about Federal Budget 2019 Financial PostCFIB president Dan Kelly says small businesses have reason to worry over some of the measures introduced in the budget.

Small businesses must prepare, understand options | Business Observer-ReporterSmall businesses must prepare and understand their options, Chris Eberlein writes in this column.

How Small Businesses Can Master The Art Of Selling On Amazon ForbesEveryone knows Amazon is killing America's small businesses — right? Believe it or not, many small business leaders say just the opposite. When commercial ...

House price falls could spill over into small business, financial regulators warn ABC NewsFalling house prices could spill over into small business lending, squeezing already tight credit conditions and their ability to raise much needed cash, according ...

Parties battle it out on small business energy blueprint Sydney Morning HeraldEnergy minister Angus Taylor said the government "owes it" to small businesses to enact a default market offer for energy prices. The government, Labor Party ...

How small businesses are impacted by tax reform CNBCSmall business owners are benefiting from a business deductions in the tax code but the change to the individual tax code expires after 2025. So what does this ...

Governor Walz recognizes Small Business Development Centers wtip.orgGovernor Tim Walz has proclaimed March 20 “Small Business Development Centers Day” in Minnesota, recognizing the important role Small Business ...

Small businesses cheer Trump tax reforms, but some feel they didn't go far enough CNBCTax breaks enacted to help small businesses aren't permanent, and that's made it difficult for business owners to make long-term decisions.

Suncorp targets extra $3b in small biz loans Sydney Morning HeraldSuncorp has vowed to ramp up small business lending by $3 billion, buoyed by officials pushing back against a key recommendation of the Hayne royal ...

Small business logistics to become hyper-personalized | Transport and logistics Enterprise InnovationCome 2020, delivery will become hyper-personalized – transforming how Asia's entrepreneurs and small businesses grow, connect and compete globally.

Small business grows in NYS, but pay lags behind nation Times Union Albany. New York might be doing a little better at creating small business jobs than the rest of the nation, but those jobs aren't paying as well as those elsewhere ...

Small Business 401(k) Recordkeeper Redesigns Website PLANSPONSORLT Trust's new website will serve as a 401(k) resource center to employers sponsoring 401(k) plans and to their employees.

US Air Force boosting small business contracting to increase innovation IHS Jane's 360Key Points The US Air Force is emphasising more small business contracting The *service* wants more cutting-edge technologies to start in the USAF The US Air ...

Load shedding: Small business owners are losing money EWNMany business owners have introduced flexitime for workers and are using generators to power the essentials.

Federal budget 2019: Top takeaways for private companies The Globe and MailPerry Yuen is an associate partner in EY Canada's Private Client Services practice. The federal budget tabled by Finance Minister Bill Morneau focuses on the ...

Small Business Women Celebrated in Gros Islet Loop News St. LuciaWomen around the world celebrated International Women's Day on the 8th of this month but to some organizations, the entire month of March is dedicated to ...

Salt City Coffee Credits Small Business Development Center for Cafe's Continued Success WAERThe owners of a small business in Syracuse says they probably wouldn't be celebrating their business' second anniversary if it was not for great coaching.

New Data Breach Trends: Small Business Identity Records Now Target #1 for Hackers CPO MagazineNew 4iQ report indicates that data breaches were up by over 420% from 2017, exposing a total of almost 15 billion identity records. Small businesses are being ...

Governor Abbott Invites South Texas Entrepreneurs To Small Business Conference In Edinburg Valley Town CrierEDINBURG – Governor Greg Abbott invites South Texas entrepreneurs looking to start or grow their businesses to a Small Business Conference on Friday, ...

/REPEAT -- Federal budget: Little relief from rising small business taxes/ Canada NewsWireCanada Training Benefit requires stronger link to employer needs OTTAWA, March 19, 2019 /CNW/ - The Canadian Federation of Independent Business (CFIB) ...

Michaelia Cash guides local small business through red tape Morning BulletinNew resource hub announced for small businesses.

Small businesses suffer under bank credit squeeze The Australian Financial ReviewSmall businesses face a worsening credit squeeze as more lenders tighten the screws on using the equity in residential properties for borrowing, by reining in ...

HP Updates Its Consumer and Small Business PCs Thurrott.comHP today announced new Envy laptops and convertibles for consumers and a new lineup of ProBooks and HP ProDesk PCs for small businesses.

Gov. Abbott invites local entrepreneurs to small business conference in Edinburg MonitorSouth Texas entrepreneurs looking to start or grow their business can attend a Small Business Conference on Friday, March 29 in Edinburg, according to a ...

Schemel, Shippensburg to host Small Business Outreach Day Herald-Mail MediaWAYNESBORO, Pa. — Pennsylvania state Rep. Paul Schemel will partner with the Shippensburg (Pa.) University Small Business Development Center to host ...

Small businesses oppose new tax Fenton Tri County TimesOn March 5, Gov. Gretchen Whitmer released her proposed 2020 budget. This proposed budget contains a number of controversial items, such as an increase ...

What’s the magic number for cash in a small business? Here are strategies to figure that out. Philly.comHere are some tips on how to manage cash, often the most important indicator of a small firm's financial health.

Small Business Administration closing local flood victim outreach offices DailyTrib.comFROM STAFF REPORTS. U.S. Small Business Administration officials announced they are closing the Disaster Loan Outreach Offices in Burnet and Llano ...

Real Estate Investing Writer for Small Business Publication - REMOTE OK job with Marc Waring Ventures LLC | 393039 mediabistro.comYour role in a nutshell: The Real Estate Investing Writer will be our resident expert in buy-and-hold real, fix-and-flip, and other real estate investing strategies.

Small Business Center to hold 'Marketing Your Business' seminar The MountaineerThe Small Business Center at Haywood Community College will offer a free seminar titled, “Marketing Your Business,” Tuesday, April 2, 5:30-8:30 p.m. at the ...

Blake Pate named Small Business Person of the Year in Florence SCNowFLORENCE, S.C. – Blake Pate followed in his father's footsteps on Tuesday when he was named the 2019 Small Business Person of the Year during the ...

Cabin Coffee named one of nation's best small businesses Clear Lake Mirror Reporter(Above) Cabin Coffee owners Brad and Angie Barber. The owners of a Clear Lake homegrown— make that 'home-brewed' business— have been named as ...

Atlanta Small Business Profile - Zach Wojohn, Executive Parking Systems Atlanta Small Business NetworkOn this week's episode of the Atlanta Small Business Profile, Ted Jenkin welcomes Zach Wojohn, president and CEO of Executive Parking Systems, Inc.

Opinion: Small business tax would kill Michigan jobs The Detroit NewsCalley writes: "We should be sending small businesses a thank you note, not a substantially larger tax bill."

Businesses are missing out on government tender opportunities DynamicBusinessBusinesses are losing out on lucrative projects as they are not submitting for work through government tenders. In particular it is SMEs that are not.

Microsoft: Windows 10 Will Auto-Uninstall Buggy Updates...And Other Small Business Tech News This Week ForbesHere are five things in technology that happened this past week and how they affect your business. Did you miss them? 1 — Microsoft: Windows 10 can now ...

Covington Small Business Program provides incentives to give boost to four more businesses User-generated contentA pizza pub, a full-*service* salon, a wedding design/planning firm, and a soon-to-arrive coffee shop that will feature music and art are the latest beneficiaries of ...

U.S. CEO Optimism Cools as Global Uncertainty Dims Outlook Washington PostOptimism among chief executive officers of large U.S. companies cooled for a fourth straight quarter amid greater uncertainty about global economic growth, ...

Small Business Spotlight: Delightfully Delicious WHECIt's a dog eat dog world when it comes to the competitive pet treats business...

Small businesses shift focus to talent retention Greater Baton Rouge Business ReportAs the labor market continues to tighten, small businesses are starting to fight to retain employees, The Houston Chronicle reports. Ninety-three percent of small- ...

Businesses are using parking to ramp up revenue DynamicBusinessThe new Parkable app is making use of empty business spaces A new shared economy platform is connecting businesses and people who have vacant parking ...

Know When to Fold 'Em: When Is It Time to Close Your Small Business? Black EnterpriseOpening a business is a great moment of pride. You hang your sign and tell everyone you know about your new venture. Unfortunately, it is that same pride that ...

Small Business Development Center opening at Temple Ambler Temple University NewsTemple University is expanding its Small Business Development Center to its suburban Ambler Campus.

Expectations of weaker economy unites small business owners Boston 25 NewsNEW YORK (AP) - Although small businesses vary widely in terms of size, industry and issues, they do appear to be generally united by a growing uneasiness ...

There is a plan for a job in every home Mail and GuardianThe DA's six-point plan would make a big difference in unleashing small businesses, helping them to flourish, grow and employ more South Africans. (Delwyn ...

Fyzical Rallies Small Businesses For United Way The Transylvania TimesUnited Way of Transylvania County (UWTC) and the Brevard office of Fyzical Therapy & Balance Centers (formerly Perfect Balance Physical Therapy)

In the News: Surveys Provide Mixed Message about Small Business Outlook Small Business TrendsShares. |. Print This Article · Email this Article. 0. Shares. Email this Article Print This Article. We usually like to keep things crystal clear for small business owners.

Hammond announces crackdown on late payments to small businesses Financial TimesSmall businesses hope the end of late payments “could finally be in sight” after Philip Hammond announced a crackdown on the practice that causes 50,000 ...

Federal Budget not great news for small businesses, says PG Chamber Chief MY PG NOWThe federal Liberal budget announced yesterday was certainly indicative of the election year that we're in, according to Chief Executive Officer of the Prince ...

Brewer named VT Small Business Person of the Year Vermont BizThe owner of a St. Albans brewing company is named the 2019 Vermont Small Business Person of the Year. Steve Gagner, owner and founder of 14th Star ...

The Supreme Court’s Online Sales Tax Ruling Is Already a Huge Headache for Small Businesses - Reason.com ReasonAn overlooked ruling could force small businesses to pay sales tax in dozens, even hundreds, of jurisdictions where they have no representation.

Cincinnati restaurateur named Ohio’s Small Business Person of the Year Cincinnati Business CourierThe owner of a Mount Washington restaurant that began in modest fashion five years ago is the recipient of a prestigious state award.

Social Media Management for Small Businesses: How to Do It Black EnterpriseThe internet has 4.2 billion users, 3.4 billion of whom are actively using social media. Clearly, social media management for small businesses is necessary if you ...

Find best small business software KomandoFind the best small business software solutions to get your business started on the right foot.

Small Business in focus at Brazosport College | News Brazosport FactsThe Small Business Development Center at Brazosport College offers a wealth of free knowledge and skills to those who are interested in starting, buying or ...

Keep your business booming: Five keys to small business success Forbes IndiaA Seattle entrepreneur speaks about the things to keep in mind to improve chances of small business success.

Raleigh business struggling after video shows thief stealing thousands in equipment WTVD-TVA Raleigh small business owner is hoping someone can identify a thief who has put his electrical company in a bind.

Grab woos small businesses with suite of financial services The Business TimesSingapore. GRAB is stepping up its efforts to court micro-entrepreneurs and small and medium enterprises (SMEs). On Tuesday, the firm launched a slew of ...

Small firms have 'no resources' for no-deal Brexit planning Sky NewsSmall businesses are resigned to whatever happens with Brexit as they do not have the resources to plan for a no-deal scenario, according to the Federation of ...

Digital Lending To Small Business Set To Surge, Says BCG-Omidyar Report BloombergQuintIf payments were the chosen flavor of the fintech universe a few years ago, then digital lending, particularly to small business, is the newest opportunity attracting ...

Veem Unveils Tariff Relief Program to Ease Small Business Concerns Small Business TrendsVeem, a business financing and payments platform, recently unveiled a tariff relief program designed to help those affected by the U.S. China trade war.

Recent college grad grows business through Miss Muff'n acquisition The Daily MemphianIn three years, Kelsey Loebel went from baking in her parents' kitchen in Collierville to buying one of Germantown's most established bakeries. Loebel founded ...

ACTU’s push for minimum wage hike a risk for small firms The West AustralianSmall WA companies say they are in no condition to absorb an 11 per cent hike in the minimum wage over two years as proposed by the ACTU.

The Small Business Development Center Anniversary at UMD Center for Economic Development FOX 21 OnlineDULUTH, Minn. – UMD's center for Economic Development celebrated the anniversary of all small business development centers across the U.S., which were ...

Amify raises its first venture round on a promise: to boost revenue for third party sellers on Amazon TechCrunchSmall businesses have a complicated relationship with Amazon . While they fear the company because they have no control over it, Amazon's platform is also a ...

Small Business Hiring Breaks Record The Wall Street JournalThe great American jobs machine is still roaring. Slowing global growth and trade friction may cloud the economic horizon, but U.S. small businesses in ...

A third of small businesses have no cyber security strategy City A.M.A third of small businesses in the UK have no cyber security strategies in place, a new report has found. Research by charity Business in the Community (BITC) ...

Can Small Businesses Really Afford to Neglect IT? Small Business TrendsFor companies that ignore tech, redefining IT for XaaS can quickly go from cure-all to problem if the myriad tools aren't properly managed.

Small business hit hardest by Eskom crisis, warns Uasa CitizenPublic Enterprise Minister Pravin Gordhan's admission that he was unable to say when the rotational blackouts would come to an end was a clear indication of ...

Shanghai banks pledge to help small business Shine NewsShanghai banks said on Tuesday they would aim to provide more innovative and customized financial products and services to help private businesses grow, ...

Best Small Business Web Site to be Named by Web Marketing Association in 23rd Annual WebAward Competition PR.comThe 23rd annual international WebAward Competition for Web site development is now accepting entries. The WebAwards is the standards-defining competition ...

Our prosperity is built on small business The AustralianTwo weeks ago, I wrote about the exponential rise of sole traders who surged by 65000 last financial year, up from 10000 just five years earlier.

List of all private investors for small business in South Africa 2019 Briefly.co.zaThe long list of ⭐ PRIVATE INVESTORS FOR SMALL BUSINESS IN SOUTH AFRICA ⭐ is the best motivation if you have a great idea, but no starting capital.

Small businesses use internet, intuition for consumer trends Asbury Park PressWhen small business owners want to know consumer spending trends, their methods can be as fancy as internet analytics or as basic as intuition.

"It's a mess": Midwest flooding leaves small businesses reeling Marketplace APMHeavy rain and melting snow have brought historic flooding to parts of the Midwest. Around 200 miles of Missouri River levees in Nebraska, Iowa, Missouri and ...

Niagara Falls Community Development: First round of small business support fund grants announced Niagara Frontier PublicationsThe Niagara Falls Community Development Department (NFCD) is announcing Small Business Support Fund (SBSF) grant awards to three local, ...

3/17/19: American Black Journal - Small Business Workshop / Fresh Nation Detroit PBS - One DetroitThe 5th annual Small Business Workshop is coming up in May, and this year's theme focuses on how small business owners can navigate changes in the ...

Pamplin Media Group - Governor's Marketplace offers small-business connections Pamplin Media GroupGovernor's Marketplace offers small-business connections , Local News, Portland local News, Breaking News alerts for Portland city.

Small Business Credit Startup Launches Innovation Competition Award in Partnership with New York SBDC - Press Release Digital JournalBetterfin was founded in 2017 by Eric Griego and Dan Gabrieli who met working together on the credit technology at OnDeck capital in 2014. Since starting, the ...

4 reasons you should work for a small business Fox BusinessIt can be a smart move for your career, but maybe not for the reasons you think.

Made in Vermont: Local Businesses Win Out Over Chains U.S. News & World ReportIn the Green Mountain State, residents eschew large stores in favor of independent retailers.

How to protect your small business from the dark web TechRepublicEducation, monitoring and response tools, and training about the dark web are essential to protecting your small business from cybercriminals.

The definitions of micro, small, and medium businesses have just been radically overhauled – here's how Business Insider South Africa"Very small enterprises" have disappeared entirely, as have asset-value ceilings. And companies with turnover of up to R220 million can now qualify as ...

DOE Announces $100 Million in Small Business Innovation and Technology Funding Energy.govWASHINGTON, D.C. – Today, the U.S. Department of Energy (DOE) Small Business Innovation Research (SBIR) and Small Business Technology Transfer ...

Property one option for small business The Australian Financial ReviewWhen most small business owners think about acquiring property through their self-managed super fund (SMSF), they often assume the only way to do it is by ...

Scotiabank cuts interest rates for mortgages, small business loans Loop News JamaicaScotiabank has announced it is reducing interest rates for mortgages and small business loans to new lows. The bank revealed new reduced loan rates of 6.99 ...

Tag: Small Business Accounting Software Market TechZiffySmall Business Accounting Software Market Report Provided Full Details of Executive summary, Scope of the report, Research Methodology, Introduction, 2019 ...

A $10 billion deficit: Small businesses are Australia's biggest tax dodgers, ATO says SmartCompany.com.auThe ATO is targeting cash-only businesses in a crackdown on $10 billion in unpaid small-business income tax, Chris Jordan has said.

Small Biz Focus: Arlington -- The #1 Digital County in the U.S. ARLnowFor the third consecutive year, Arlington County was ranked the #1 Digital County in the United States, but what exactly is a digital county? This weeks Small.

Australia's NAB to expand threshold for small business protections ReutersNational Australia Bank said on Friday it would expand the threshold for small business protections and would work with regulators to implement other key ...

73% of All Small Business Teams Will Have Remote Workers by 2028 Small Business TrendsThe latest statistics from Upwork reveal the growth of remote workforce trends. Will we all wind up working from home eventually?

Binghamton Business Plan Competition Open wnbf.comEntries are being taken for the latest Binghamton Local Development Corporation and SUNY Broome Entrepreneurial Assistance Program Business Plan ...

61% of Veteran Small Business Owners Built Their Business on Facebook Small Business TrendsIf small business owners want to succeed, they need to understand the impact of technology on small business and customer expectations.

3 ways your small business can break the hiring mold Fox BusinessYou don't have to do things the same way larger companies do.

About.me acquired by mobile-first small business startup Broadly TechCrunchPersonal homepage startup About.me has been acquired. Again! The company, once bought by AOL for a reported $35 million, decided a couple years after the ...

Why Your Small Business Needs Search Engine Marketing Business.comSearch engine marketing (SEM) platforms are absolutely necessary in the modern marketing landscape. Here's what you need to know.

How to Protect Your Brand with a Trademark Small Business TrendsYou likely have heard about trademarking your brand to protect your small business identity. But do you know how to do it and why it's important to use it?

Big banks join forces with mini-hubs for small business Financial TimesThree of Britain's four largest banks have teamed up to launch jointly-run mini- branches for business customers amid rising concerns that branch closures and ...

Starting a Small Business? This $20 Class Will Teach You How to Help It Thrive. EntrepreneurBarry Moltz shows students how to establish profitable, sustainable ventures across 15 hours of *content*.

Do You Want Your Own Fully Programmable ERP? - Part 2

Small Business Small Business