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.

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.

sudo apt install python-celery-common

all configuration to run the celery process is put in a python file sometimes called tasks.py

celery -A tasks worker –loglevel=info

But you might have multiple workers named worker1.py and worker2.py so you would start them in two separate shells using

celery -A worker1 worker –loglevel=info
celery -A worker2 worker –loglevel=info

The “functions” you are going to background will be in worker1 or worker2.

In bash, getting a web page

curl https://www.web-atlanta.com/ >html.html

The bash curl command has nothing to do with Canadian Curling, which is like shuffleboard on ice amidst the tension garnered tolerating a joke about the Queen or the national health care system from a surfboard riding processed cheese eating upper Mexican from south of the barbarian line. In bash, curl is short for client url, a simple http request of a web address.

In Python

x = urllib2.urlopen("https://www.web-atlanta.com")
w = x.read()

And as a part of a class init

  def __init__(self,TableName,filename,url):
    self.sqhandle=sqlite3.connect(filename) # empty if noexist
    self.sq1cursor = self.sqhandle.cursor()
    self.filename = filename
    try:
      self.sq1cursor.execute('''CREATE TABLE '''
         +TableName+''' (somenum real, somestring text)''')
      self.sqhandle.commit()
    except:
      print TableName,"table already exists"
    self.samples = 0
    x = urllib2.urlopen(url)
    self.pagedata = x.read()

So if we instantiate a class we now have the html as classname.pagedata and sqlite3 handle and cursor as classname.sqhandle and sq1cursor

We need to do some things with sql like

    command = 'INSERT INTO '+table+' VALUES (' + x +', "'+ y +'")'
    try:
      classname.sq1cursor.execute(command)
      classname.sqhandle.commit()
    except:
      print command

sqlite3 insert a row

  def sqlinsert(sqhandle,sq1cursor,table,x,y):
    command = 'INSERT INTO '+table+' VALUES (' + x +', "'+ y +'")'
    try:
      sq1cursor.execute(command)
      sqhandle.commit()
    except:
      print "failed to ", command

Perl with DBI, Perl Database access

!/usr/bin/perl -w

#

script to add up some table data

use DBI;
use CGI::Carp qw(fatalsToBrowser);

print “Content-type: text/html\n\n”;
my $dbh = DBI->connect(’dbi:mysql:database=DATABASE_NAME;host=localhost’, ‘USERNAME’, ‘PASSWORD’)
or die “Couldn’t connect to database: ” . DBI->errstr;

my ( $k, $id, $book_date, $svc_type, $cust_id, $time_pref, $a_sched,$a_eight);
my $t_date=”20080115″;

$sqlquery = qq( SELECT id, book_date, svc_type, cust_id, time_pref, FROM orders WHERE  move_date = $t_date );
$sth = $dbh->prepare ( $sqlquery );
$sth->execute() || die “Couldn’t execute query: ” . DBI->errstr;

$k = 0;
$sth->bind_columns( \$id, \$book_date, \$svc_type, \$cust_id, \$move_date, \$time_pref, \$est_men, \$est_trks );
while ( $sth->fetch() ) {
$a_sched  += 1;
if ( $time_pref eq “8-9A.M.” ) { $a_eight  +=1; }
}

Now $a_sched contains the number of records $a_eight contains the number of 8-9A.M. record for that date.

atlanta custom database design   vehicle dispatch ERP

On your Linux system with Perl, create this program and chmod it to 755.

#!/usr/bin/perl -w
print "Hello World";

Places uses different heuristics from organic search results pages and say that inclusion in Google Places is not influenced by your Google advertising budget.

Whether you are creating your listing or engaging in Google Places Listing Optimization, we need to take advantage of as many features as possible without abusing any areas and thus risking a lengthy period of invisibility on the Google search results pages. Remember that Google is not a consulting firm, does not charge for your local listing, and like the IRS, relies on you to either hire a CPA or figure it out, preferably a little of both. Google Places uses different heuristics from organic search results pages and say that inclusion in Google Places is not influenced by your Google advertising budget. There are a lot of lies and hype about Google Places, partly because of Google’s lack of support but also greatly due to the ignorance and naivety of business owners when it comes to understanding search engine results.

• Business Name: Use precisely your legal business name, or risk a penalty.
• Do Not stuff keywords or geographic terms here.
• Categories: Use all five categories to not just tell consumers what you do, but to influence search results.You must use the first category for a Google approved category.
• Images & Video: Load 10 images and at least 1-3 videos to ensure the listing is 100% complete. See our section on Youtube optimization.
• Citations. These are like links, but they don’t require a hyperlink with the url as much as they depend on the exact same business name and phone number, possibly address for things like yp.com, citysearch or angieslist.
• Have your business address prominent on your web-site, and enter the URL on your Google Places listing.

The last practice is a real problem for small business, many of which are run out of our homes. But once we grow to open an office location, use this key to maximize results. Reviews also help, as well as people searching for your exact business name and town, and even asking directions. All these activities are recorded by google and make your listing more important.

Tuples and lists

Both are arrays, but tuples are immutable. This means that once you define a tuple, you cannot add elements, pop, append, remove an element, etc. You need to create a new tuple out of the old one every time you make a change.

• Tuples (1,2,3,4,5,6) are great for static definition. They are hashable, lean and unequivocal.
• Lists [1,2,3,4,5,6] are great for computation. They are mutable and queueable.

Both are addressed with integers in brackets.

Whether it is a list or a tuple, addressing one element is the same.

create a tuple with y = (“a”,”b”,”c”) and do this;

y = ("a","b","c")
print (y[0])
for i in y:
    print (i)

For lists and tuples, know this too;

for i in range(0,len(y)):
    print (i,y,y[i])

Now redefine y as a list and try it again. Same results?

Commands

mailq # note the message id – ten (10) alpha key to emails in queue

postcat -vq nnnnnnnnnn

postsuper -d nnnnnnnnnn

cd /etc/postfix; vi virtual; postmap virtual # forwarding

cd /etc/postfix; vi rbl_override; postmap rbl_override #whitelist

Postfix queues: pending and deferred.

Deferred queue is for messages that have soft-failed. Postfix will retry sending deferred emails.

Modern web design can be a waste of money because the most attractive web-site on the internet will generate very little interest in your products or services if no one can find it. Search engines such as Google, Bing, and Yahoo are used by people to locate products and services on the internet. This includes finding companies all over the world and in your neighborhood. Search engine optimization services (SEO) and internet marketing strategies must be used to gain quality visitors through search engines.

No other Atlanta company can compete with the knowledge depth at Web Atlanta for search engine optimization. While we provide PPC services to boost traffic of qualified prospects our internet marketing strategies, campaigns, and optimization work can give companies an organic presence two to three times greater than their size. Our services concentrate on the major aspects influencing the searches of qualified prospects and our keyword research is done at a level of transparency and interaction that every other competitor fails to provide. When we partner on your brand name you will learn how truly rote is this process others seek to represent as some sort of magic elixir.

Local Search is a mysterious area where our partner format of SEO empowers our clients. We stress the importance of not only domain ownership but of claiming and verifying local listings. Divergence and convergence of search results are not well understood, but superbly anticipated by our unsurpassed computer science oriented staff. Google and Yahoo are convinced that customers will increasingly use Local Search to find products and services in their local area. We excel at making sure local listings achieve rankings because local search has long ago surpassed use of the Yellow Pages to find businesses. Our expertise at web-site content analysis means our customers are prominently displayed in the Local Search components of Bing, Google and Yahoo.

The major search result providers use factors to determine rankings related to the importance and relevance of a site and its importance to other sites and publications on the internet. Effective methods of promoting a web-site organically include blogs, press releases, classified ads, directories, twittering and social bookmarking,

The fastest way to generate visitors from the search engines is to implement a Pay Per Click campaign. Google, Microsoft, and Yahoo offer paid advertisements that appear on search results pages and on their respective partner sites. Advertisers pay Google, Microsoft, and Yahoo every time a visitor clicks on the ad and visits the advertiser’s web site. The amount the advertiser pays the search engines depends on the amount the advertiser bids on a keyword. Very little optimization of a web site is necessary to begin a Pay Per Click campaign and drive relevant traffic to a web site. The bids for competitive keywords can get expensive. We have the expertise to create effective advertisements, minimize the cost, and maximize the benefits from Pay Per Click campaigns.

We stress the importance of not only domain ownership but of claiming and verifying local listings.