Difference between revisions of "User:Trifonnt/MyReadings2"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
Line 268: Line 268:
 
* Historic Data
 
* Historic Data
 
** [http://tinyerp.org/wiki/index.php/Main/GermanNeedsEn TinyERP Historic Data]
 
** [http://tinyerp.org/wiki/index.php/Main/GermanNeedsEn TinyERP Historic Data]
 +
 +
== ERP Books ==
 +
* [http://www.bus.indiana.edu/erp/Books/books.html ERP BOOKS LISTING]
 +
* [http://www.dummies.com/WileyCDA/DummiesTitle/mySAP-ERP-For-Dummies.productCd-076459995X,page-tableOfContents.html mySAP ERP For Dummies]
 +
* [http://www.sysoft-fr.com/en/gen/books-us.asp ERP related books]
 +
 +
 +
== ERP articles ==
 +
* [http://www.revenue.ie/index.htm?/leaflets/warehouse.htm Customs Warehouse]
 +
* [http://fscavo.blogspot.com/2007/08/total-cost-study-for-open-source-erp.html Total cost study for an open source ERP project]
 +
 +
 +
Historic Data
 +
* [http://tinyerp.org/wiki/index.php/Main/GermanNeedsEn German Needs in ERP Area]
 +
** [http://jtemporal.sourceforge.net/ JTemporal]
 +
** [http://en.wikipedia.org/wiki/Temporal_database Temporal database]
 +
** [http://www.martinfowler.com/eaaDev/timeNarrative.html Temporal Patterns]Martin Fowler
 +
** [http://martinfowler.com/eaaDev/TemporalProperty.html Temporal Property]Martin Fowler
 +
 +
== Open Standards ==
 +
* OAccounts
 +
** [http://www.accmanpro.com/2009/03/16/oaccounts-is-it-feasible/ OAccounts - is it feasible?]
 +
** [http://www.yes-no-cancel.co.uk/2009/03/04/oaccounts-setting-your-accounts-data-free/ OAccounts - Setting your accounts data free]
 +
** [http://ept.github.com/oaccounts/ OAccounts – Open Accounting Data]
 +
 +
* OASIS UBL
 +
** [http://www.yes-no-cancel.co.uk/wp-content/uploads/2008/11/invoice.xml Example OASIS UBL Invoice]
 +
 +
 +
== University ERP systems ==
 +
* [http://kualiproject.org/ Kuali]
 +
 +
 +
== On Demand ERP systems ==
 +
* [http://www.myerp5.com ERP5]
 +
* [http://www.plex.com www.plex.com]Good web site.
 +
 +
== Comparison of Open Source ERP Systems ==
 +
* [http://www.big.tuwien.ac.at/research/publications/diplomatheses/herzog.pdf A Comparison of Open Source ERP Systems]
 +
* [http://rfptemplates.technologyevaluation.com/Compare-ERP.html List with criteria to compare ERP systems]
 +
 +
== SAP ==
 +
* [http://www.camagazine.com/2/2/1/6/6/index1.shtml Shattering the SAP myth]Lists SAP Business One features
 +
* [http://sap.ittoolbox.com/documents/popular-q-and-a/sap-business-one-proscons-3200 SAP Business One Pros/Cons]
 +
* [https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60022998-5d17-2b10-dbaa-8e3ab357fa55 Data Governance using SAP MDM - Part 1]
 +
* [https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9082a7dc-de18-2b10-5d84-a2697306b94d Data Governance using SAP MDM – Part 2]SAP Master Data Governance
 +
 +
 +
== Compiere ==
 +
My opinion is that this is very outdated information, but who knows...
 +
* [http://www.sybase.com/aseex_resources Compiere on Sybase]
 +
* [http://sourceforge.net/tracker/index.php?func=detail&aid=1058112&group_id=29057&atid=410218 The Achilles-heel of most ERP solutions]
 +
 +
* [http://www.compiere.in.th/er253b-th/ Compiere ER Data model]
 +
 +
* Interesting posts from Compiere forums
 +
** [https://sourceforge.net/forum/message.php?msg_id=4741205 sf.net forum post]Albert totally killed Compiere Inc.
 +
Take over Compiere you need Albert
 +
 +
 +
* [http://solsticeplus.com/en/index.html]HR and Payroll built on Compiere;
 +
* [https://sourceforge.net/forum/message.php?msg_id=5133892 sf.net post]
 +
 +
* [http://www.docstoc.com/docs/1006831/Introduction-to-Compiere Introduction to Compiere]Intersting how people use buzz words like SOA and make produce non true statements.  Compiere is not SOA application! Where are the Service in Compiere? Who cares? Important is to make good advertisement :)
 +
 +
== OpenBravo ==
 +
* [http://wiki.openbravo.com/wiki/index.php/Web_Services_Introduction Web Services]
 +
* [http://jordimash.blogspot.com/2007/12/openbravo-and-ez-publish.html Openbravo and eZ Publish interoperability]
 +
* [http://spreadsheets.google.com/pub?key=pPWZAST9Jg5FQBzfEy0kTQw Google Spreadsheet - product priorities]
 +
* [http://sourceforge.net/forum/forum.php?thread_id=2139722&forum_id=597808 Translation and Localization for Bulgaria]
 +
 +
* nice mesage about non existing functionality.
 +
<pre>
 +
this functionality does not exist in Openbravo standard product. However, this should be a relatively simple extension to build, especially in release 2.50 where there is a full layer of APIs that allow you to read and write transactional data using RESTful web services.
 +
 +
You could also build this functionality as a reusable module and share it with the rest of the community.
 +
</pre>
 +
 +
 +
=== OpenBravo POS ===
 +
* DB Settings
 +
** hsqlDB as Standalone Server
 +
 +
MUST Start Hsql Db FIRST!
 +
<pre>
 +
jdbc:hsqldb:hsql://localhost/xdb;shutdown=true
 +
</pre>
 +
 +
** hsqlDB as Embedded Server - 1
 +
<pre>
 +
jdbc:hsqldb:file:C:\adempiere-cd\workspace\adempiere-stable\Openbravo POS\sampledb\openbravopos-db;shutdown=true
 +
</pre>
 +
 +
** hsqlDB as Embedded Server - 2
 +
<pre>
 +
jdbc:hsqldb:file:C:\Users\trifon\openbravopos-db;shutdown=true
 +
</pre>
 +
 +
=== OpenTPV ===
 +
* [http://www.opensistemas.com/prensa/noticias/muestra_noticia/article/11/338/ OpenTPV]OpenTPV is an extension of Openbravo POS developed by a partner of Openbravo
 +
** [https://sourceforge.net/forum/message.php?msg_id=6981998 sf.net forum post]
 +
 +
== Open Compiere ==
 +
* [http://opencompiere.sourceforge.net/releasenotes/ReleaseNotes-r261-build20070723.xhtml list with bug fixes transfered from Adempiere] Amazing - EDI is part of it :) - Thank you!
 +
 +
= MES - Manufacturing Execution System =
 +
* [http://www.factority.org FACTORITY]
 +
** [http://wiki.factority.org/index.php/Technology_Overview Technology Overview]
 +
 +
= WMS - Warehouse Management System =
 +
* [http://www.mywms.org myWMS]
 +
 +
* sf.net
 +
** [https://sourceforge.net/projects/openwms/ picoWMS]
 +
 +
= POS =
 +
 +
== POS Hardware ==
 +
* [http://www.upos.com.pl/index.php?lang=eng Upos]
 +
* [http://www.eltrade.com/ Eltrade]
 +
* [http://www.anzisoft.ro/ AnziSoft]
 +
 +
== TouchScreen ==
 +
* [http://www.elotouch.com/Products/Computers/15D1/default.asp Elotouch]
 +
 +
== Tina POS ==
 +
* [http://wiki.openbravo.com/wiki/index.php/TinaPOS_Integration TinaPOS Integration]
 +
 +
 +
=== Weak sides ===
 +
* [https://sourceforge.net/forum/message.php?msg_id=4441167 Bill Of Materials]
 +
 +
 +
=== Questions and Answers ===
 +
 +
==== How to add Dual currency? ====
 +
* [https://sourceforge.net/forum/message.php?msg_id=4732820 sf.net post]

Revision as of 06:14, 20 July 2010

Postal Code Web Service


INCOTERMS


Pricing

Interesting Proposal/Requiremnts

Web Service

1. Products - When entering a new product, call an UPC/EAN webservice (http://www.gepir.org/) that validates a product UPC/EAN and populates the item description and trade info (size, weight, etc).

2. Business Partners - When entering a new Business Partner, call a Company Registrar to validate (and populate) company registration / vat numbers and registered address, directors, etc.

3. Credit Checking - When entering a new Business Partner, call a webservice to perform a credit vetting / check after which the report can be populated into a credit check table or attached to the record.


Double UOM


Expectations from Adempreie

* It must be stable. I'm running my business and other's businesses on it and it must not stop working at any time.
* When I upgraded to the 3.52a release the invoices stopped printing due to a bug. To get the invoice printing to work Adempiere must be patched. This shouldn't happen in releases.
* User friendly - If the system isn't user friendly it's harder to convince people to work in it.
* Secure - I posted previously a message about Adempiere being easy to break into and that it can't be on an untrusted network. It's OK to have an insecure application as long as everybody knows it's insecure. For business critical data the implementors must know how to secure Adempiere.

I'm working on the user friendliness part (the Account Editor was the first step) and when I have time I'd like to work on the security part.

One example on how user friendliness can be improved is to increase the searchability
in accounts (you can't zoom to documents from accounts-view today) and make
a really simple form for creating manual general ledger entries. Manual general
ledger entries today are far too much work than what a normal accountant is
used to in other systems.

Posterita WEB POS

CRM systems


Comparison of CRM systems

Localized in Bulgarian

On Demand prising


Interesting news/Forum post regarding CRM systems

 - vi /usr/local/dimdim/Mediaserver/mods/lighttpd.conf and leave port 80 not 81

then

vi /usr/local/dimdim/ConferenceServer/apache-tomcat-5.5.17/webapps/dimdim/WEB-IN
F/classes/resources/dimdim.properties

dimdim.ServerAddress=SERVER_ADDRESS
dimdim.serverPortNumber=81
dimdim.dmsServerAddress=SERVER_ADDRESS:81
dimdim.dmsServerInternalAddress=localhost:81

then
 - vi /usr/local/dimdim/ConferenceServer/apache-tomcat-5.5.17/webapps/dimdim/WEB
-INF/classes/resources/streaming.properties

and modifiy port from 80 to 81

streaming_server.2.rtmp_url=http://SERVER_ADDRESS:81/screenshare/
streaming_server.2.rtmpt_url=http://SERVER_ADDRESS:81/screenshare/
streaming_server.2.max_number_of_streams=-1
streaming_server.2.supported_stream_types=DTP

locate server.xml and modify port on 81

restart dimdim and go to http://SERVER_ADDRESS:81/dimdim
* NOTE if made this cherrypy dont give error for / at final...

Control port 443 and 1935
The dimdim start well


Wiki

XWiki


GIS - Geographic Information System


Monitoring Applications/Systems

Log Analyzer

  • awstats.sourceforge.netAWStats is a free powerful and featureful tool that generates advanced web, streaming, ftp or mail server statistics, graphically.

CAD/CAM

Android

MFG/MRP - Manufacturing

Articles

Manufacturing Terminology

Queue time

Amount of time a person, signal, or thing spends before being attended to, or before value adding work is performed to or on it. In many factories queue time constitutes about 90 percent of the total lead time. It is a subset of cycle time.

Queuing time

The time between the arrival of material at a workstation and the start of work on it

Cycle time

Period required to complete one cycle of an operation; or to complete a function, job, or task from start to finish. Cycle time is used in differentiating total duration of a process from its run time.

Waiting time

Period at job for which an employee is paid but is unable to work due to factors beyond his or her control. Also called allowed time, downtime, or idle time.

ERP Systems

  • PostBook Server part build with Postgre SQL procedures.
    • Good points[1]:
      • - Amazing categories in master data setup - accounting and so on.
      • - Very user-friendly forms
    • Weak points:
      • - PostBooks has not workflow (or i could not find it) and ERP system without workflow is meaningless.
      • - Only desktop application
      • - Technical weakness are DB Stored procedures.

Small ERP/POS/MFG/WMS/Billing systems

Bulgarian


ERP Requirements

Features that a composite of UK government bodies classified as Mandatory, Highly Desirable and nice-to-have in financial systems. Chapter 9 sets out their requirements on fixed assets. List they came up seems to have general application.

ERP Books


ERP articles


Historic Data

Open Standards


University ERP systems


On Demand ERP systems

Comparison of Open Source ERP Systems

SAP


Compiere

My opinion is that this is very outdated information, but who knows...

  • Interesting posts from Compiere forums 
Take over Compiere you need Albert


  • Introduction to CompiereIntersting how people use buzz words like SOA and make produce non true statements. Compiere is not SOA application! Where are the Service in Compiere? Who cares? Important is to make good advertisement :)

OpenBravo

  • nice mesage about non existing functionality.
this functionality does not exist in Openbravo standard product. However, this should be a relatively simple extension to build, especially in release 2.50 where there is a full layer of APIs that allow you to read and write transactional data using RESTful web services.

You could also build this functionality as a reusable module and share it with the rest of the community.


OpenBravo POS

  • DB Settings
    • hsqlDB as Standalone Server

MUST Start Hsql Db FIRST! 

jdbc:hsqldb:hsql://localhost/xdb;shutdown=true
    • hsqlDB as Embedded Server - 1
jdbc:hsqldb:file:C:\adempiere-cd\workspace\adempiere-stable\Openbravo POS\sampledb\openbravopos-db;shutdown=true
    • hsqlDB as Embedded Server - 2
jdbc:hsqldb:file:C:\Users\trifon\openbravopos-db;shutdown=true

OpenTPV

Open Compiere

MES - Manufacturing Execution System

WMS - Warehouse Management System

POS

POS Hardware

TouchScreen

Tina POS


Weak sides


Questions and Answers

How to add Dual currency?

Retrieved from "http://www.adempiere.com/index.php5?title=User:Trifonnt/MyReadings2&oldid=45435"