Getting Started

The purpose of this lesson is to help you get started with ERP Academy.

Getting Started - Where to Start

The main Coursework page is designed to be studied from the top down. I would start at the top, and work your way down. Do not hesitate to ask questions or offer suggestions via the group's mailing list <chuboe-id-training@googlegroups.com>. With all videos, if you feel like something should be changed, improved, or removed, please let me know. You will not hurt my feelings! I want the material to be as accurate and concise as is possible. Thank you for your feedback!!

Getting Started - iDempiere First Look

This video assumes you have not seen iDempiere or ADempiere before. It helps you understand how to navigate, and it demonstrates the concepts of buying, storing, shipping and selling stocked products.

Getting Started - iDempiere for Service Industry

Getting Started - Professional Services + Stocking Distributor

Getting Started - ADempiere First Look

This video demonstrates the concepts as above. The biggest difference is that is uses ADempiere.

Getting Started - Understanding the Database

The vast majority of iDempiere uses PostgreSQL as the database. The other option is Oracle. I have used both, and I strongly prefer PostgreSQL. Below are thoughts and tools to help you get acclimated to the database schema.

iDempiere does a great job of creating DDL that includes articulates foreign key references. This means you can use any DB schema tool to inspect the relationships.
The Most common tables are:
- AD_User
- C_BPartner
- AD_Role
- C_Order and C_OrderLine
- M_InOut and M_InOutLine
- C_Invoice and C_InvoiceLine
- C_Payment
- Fact_Acct - holds all financial posting records
Description of Table Prefixes and common table conventions.
Here is a link that groups most tables.
On almost any window in iDempiere, you can click on the 1/x record link (located in the upper-right corner) to see the table behind that window.