Sat. Dec 4th, 2021

As the worldwide monetary crunch chokes firms badly throughout industries, methods and means to chop prices at the moment are excessive on company agenda – be it massive companies or SMEs. One of many prices related to enterprise operations is that of software program licensing. And in relation to computerization, there is not any higher resolution than an Enterprise Useful resource Planning system which has historically been a excessive ticket software program funding largely out of attain of small companies. With Open Supply, this development is ready to vary as there are a variety of free ERPs obtainable which companies can use to automate and centrally handle their dispersed accounting, buying and stock actions by way of a single built-in interface. These ERPs largely have a paid help bundle along with a free model in order to help these having buying energy, in addition to those that simply want the system to get began with with in-house experience. One such ERP is PostBooks obtainable within the form of PostBooks.

This information walks by way of the set up course of over a Ubuntu 7.04 (and better) system and transient introduction of the system. Word that in contrast to different software program techniques that are able to run after obtain, ERPs require a bit extra configuration as these techniques should not self-contained. They make use of a database utility to maintain all of the user-data and reviews and so on, whereas the front-end offers interface to enter enterprise transactions. Typically, ERPs are web-based, which suggests they require a web-server the place the complete utility is hosted. For that reason, there might be a number of recordsdata to obtain – one for the primary program, and there might be database scripts to create vital tables and so on. Over a time period, these set up steps are being made simpler although.

Putting in PostBooks in Home windows:

Window set up is fairly easy course of because the installer comes with database set up together with pattern information. Merely obtain and set up utilizing the one executable file and run utilizing username and password admin.

Putting in PostBooks in Ubuntu:

Uubntu set up requires database and a little bit of guide configuration. This is how:

Step zero – Set up PostgreSQL

It is a perquisite database for PostBooks ERP. Set up it utilizing the next command:

sudo apt-get set up postgresql-Eight.1 postgresql-contrib-Eight.1

Step 1 – Obtain Postbooks

PostBooks provides a number of varieties of downloads that may swimsuit totally different wants. For instance, full installers, separate shopper and database, paperwork, movies and even digital machine model which suggests able to run picture of a whole pre-installed system in Digital Field and VMWare codecs. This information walks by way of a typical and simple to check set up the place every little thing resides on one system. Superior customers can set up database individually on a unique machine to permit a number of shopper entry throughout community.

Obtain the next three setup recordsdata utilizing wget command:

The tar.bz2 file for Linux

Fast Begin file

init.sql file

Word that the wget command downloads within the present folder.

Step 2 – unpack the compressed file

Use the next command which unpacks the downloaded archive and creates a folder with the identical title because the file.

tar xvfj PostBooks-2.2.0Beta3-Linux6.tar.bz2

Step three – Configure PostgreSQL and set it up for PostBooks

Open the file /and so on/postgresql/Eight.1/foremost/pg_hba.conf in Textual content Editor and see the final part titled # TYPE DATABASE USER CIDR-ADDRESS METHOD. Right here, remark out all the three uncommented strains by putting hash character in entrance of them and change them with the underlined strains as proven under:

Present part of the file:


# “native” is for Unix area socket connections solely

native all all ident sameuser

# IPv4 native connections:

host all all md5

# IPv6 native connections:

host all all ::1/128 md5

Up to date part of the file (updates proven as underlined)


# “native” is for Unix area socket connections solely

#native all all ident sameuser

native all all belief

# IPv4 native connections:

#host all all md5

host all all belief

# IPv6 native connections:

#host all all ::1/128 md5

host all all ::1/128 belief

After which restart the server utilizing:

sudo /and so on/init.d/postgresql-Eight.1 restart

Now create PostBooks database

sudo su postgres

psql -U postgres -f init.sql template1

createdb -U mfgadmin mfg

pg_restore -U mfgadmin -d mfg postbooks_quickstart.backup -v

Word that these instructions should be executed from the identical folder the place the downloaded recordsdata reside.

Step four: Begin PostBooks

From the folder the place PostBooks is unpacked, use the next command to start out PostBooks:


Username and password is: mfgadmin

Overview of PostBooks

As is the case with any ERP, PostBook caters for all main operations of a small to medium sized manufacturing firm. It could possibly additionally serve different corporations say in providers sector or retail as solely a sub-set of modules are required and relaxation change into routinely redundant. The principle interface has bought menus at prime describing every useful space of enterprise that it caters to. This consists of Merchandise, Stock, Buy, Manufacturing, CRM, Gross sales and Accounting. Begin off with System menu to configure fundamental construction of the group. Sub-menu Grasp Info permits the person to outline calender, currencies, trade charges and departments and so on. Second essential space to configure is sub-menu Configure Modules the place every particulars of dealing with earlier listed modules could be set. For instance, whereas dealing with inventories, a examine could be put in place to disallow buy order receipt if the amount differs from the order, or to pop-up a warning if the distinction is in a user-defined vary. Equally, there are a variety of configuration objects that may outline enterprise guidelines – comparable to permitting gross sales reductions or not. Common Ledger could be outlined intimately by way of Accounting module configuration by setting format of GL hierarchy displaying foremost section, revenue heart, sub-accounts and their character lengths, together with defining necessary accounts comparable to retained incomes, trade charge distinction and discrepancy accounts.

As soon as the modules are configured for fundamental traits and parameters, the following job is to outline Maser Info for every related module utilizing its personal menu. This entails module particular info. For instance, in Merchandise, items of measurement, product class and product class represent its grasp info. For accounts, this consists of financial institution accounts, price and expense classes and so on. Beneath every module there are sub-menus for reviews and evaluation which makes this ERP fairly complete in nature.

There are different free ERPs obtainable for Ubuntu as effectively – and most of them run on Mac and Home windows as effectively. With ample documentation, person manuals, and free on-line demos obtainable, small companies can make investments a while in researching the obtainable choices to save lots of price of buying a customized constructed ERP.

Choices that may be explored embrace MyERP5, OpenBravo, Compiere and so on.

OpenSource ERPs have come a great distance from simply being an idea to a actuality in use by many firms all over the world – with and with out paid help. Its ironic that OpenSource options haven’t been explored to the fullest extent. But when executed so, it holds quite a lot of promise beginning proper on the working system degree and rising as much as the extent of specialised purposes comparable to ERPs.

Word: All of the instructions are for use as root person.

By admin

Leave a Reply

Your email address will not be published. Required fields are marked *