developer toolbox

http://postbooks.sourceforge.net/

http://www.xtuple.com/comparison

postbooks licenca je http://www.xtuple.com/CPAL (OSI kompatibilna licenca)

• Database reporting
• International Language Packs
• Contacts
• Opportunities
• Incidents / Trouble Tickets
• ToDo's / Tasks
• Quotes
• Sales Orders
• Accounts Receivable
• Purchase Orders
• Accounts Payable
• General Ledger
• Shipping / Receiving
• Inventory (Single Warehouse) <<<<<<<<<<<<< nije znači podržano više magacina ?
• Item Master Information
• Bills of Materials (BOM)
• Work Orders
• Project Management
• Multi-Currency
• Financial reporting
• Multi-Locations in Warehouse ??
• Assemble-to-Order Configurator
• Kitting

http://www.xtuple.com/postgresql

A key technology of xTuple ERP is the open source database PostgreSQL (pronounced Postgres S-Q-L, or Postgres for short). Postgres is developed and maintained by a global community of talented programmers and database professionals. It is, in our opinion, one of the leading examples of the power of open source software development.

Because the program is a database, which typically serves as the guardian of mission-critical business information, the Postgres commmunity is meticulous about code quality and data integrity. Enhancements to Postgres must withstand rigorous peer review, and critical bug fixes are typically "back-patched" to the past several releases of the product - a commitment to quality and security that exceeds that of many commercial vendors.

xTuple ERP makes heavy use of Postgres' embedded procedural language, called PL/PGSQL. Whenever any kind of transaction is taking place in the system - a financial account being credited or debited, a piece of inventory being moved, or an order being taken - that is happening in a Postgres stored procedure, trigger, or function.

Among the benefits of this approach is that it is relatively easy for other client software besides the xTuple ERP graphical client to access business functionality. xTuple partners and customers have developed various alternative interfaces to access the Postgres backend database, including Web portals, wireless devices, and desktop office productivity software.

We are also well-versed in advanced Postgres solutions such as replication from a production database to a live backup or failover system, tuning and optimizing of a Postgres database. For those new to Postgres, we offer installation, configuration, and upgrades of your Postgres database, as well as xTuple servers (with any Edition of xTuple ERP database installed and preconfigured) that can function as appliances, in either a tower or rackmounted form. We even offer production support for your internally-developed Postgres solutions.

xTuple is proud to be a longstanding member of the Postgres community, and you can be confident that our global network of Postgres experts can support anything from the first-time user to the most demanding professional database environment.

http://postbooks.sourceforge.net/videos/BusinessFlow-WorkOrders.swf

ooou baš su detaljno pokrili radne naloge - kako utrošak materijala tako i same operacije veazno za realizaciju radnog naloga

http://www.xtuple.org/ApiWhitePaper

The xTuple Application Programmer Interface (API) is designed to make importing data directly into the database much safer and easier than it is going directly into the regular table structure. The specific target audience is users such as solution providers and customers who wish to import legacy data or integrate e-commerce solutions with xTuple Applications (including the open source PostBooks and the commercial-licensed editions) without having deep experience with xTuple business logic. Our appoach is to allow users to create, access, and update xTuple documents using a special database schema that closely mirrors the graphical user interface (GUI).

http://postbooks.sourceforge.net/videos/IntroTopics-ERPonLinux.swf

http://opensourcebizapps.com/postbooks.aspx

http://www.howtoforge.com/postbooks_on_ubuntu704

root@nmraka-5:~# su -c "su -s /bin/bash postgres"

postgres@nmraka-5:/home/hernad/devel/postbooks$ psql -U postgres -f init-3.2.2.sql template1

CREATE ROLE
CREATE ROLE

postgres@nmraka-5:/home/hernad/devel/postbooks$ createdb -O admin production

postgres@nmraka-5:/home/hernad/devel/postbooks$ pg_restore -d production postbooks_quickstart-3.2.2.backup -v

hernad@nmraka-5:~/devel/postbooks$ sudo apt-get install pgadmin3

hernad@nmraka-5:~/devel/git/postbooks/xtuple/trunk$ sudo apt-get install libqt4-sql-psql

openrpt - izgleda pravo brz, kad se samostalno koristi inteligentan je i za određenu tabelu zna izgenerisati list layout

build xtouple-a gui klijenta je trajao haos dugo ako ne i više sahata

sam klijent međutim zauzima 30-tak MB memorije.

Korisnički interejs, pristup bazi sve je super brzo

razočaran sam General Ledger-om (GL - Finansije) koji je za malu djecu u odnosu na naš FIN

GL je ostavio loš dojam jer mi ne dopušta praktično ništa osim iznosaa, D/P te opisa stavke. E sad ne znam kako je kada se obrađuje invoice - izlazna faktura. Za razliku od Fmk ovdje se te transakcije, pretpostavljam, uopšte ne unose u GL nego se automatski generišu na osnovu invoice-a.

Međutim, GL reporting i analize koje sam vidio na ovom videu nikako nisu za malu djecu - dapače.

Ono što je super recimno kod pregleda GL, kada se dođe do stavke koja se odnosi na fakturu, ja mogu za sekundu dođi do preglea te fakture.

Za sve izvještaje postoji export izvještaja u csv, koji se može otvoriti u openoffice calc-u.

Acconts Receivable A/R - kupci, naplata od kupaca

http://postbooks.sourceforge.net/videos/BusinessFlow-AccountsReceivable.swf

interesantno je da se uplate ne knjiže u G/L-u nego u A/R-u što baš i nije fleksibilno. Kako je sa preuplatama ili avansnim plaćanjima recimo ?