Difference for moving AP/AR transaction to history mode in Great Plain/Dynamic system

In Receivables module, a AR transaction document is moved to ‘history’ status when the said document is fully applied and then the Paid Transaction Removal (PTR) routine is processed (i.e. run “Paid Transaction Removal” Option under “Routines”). It is different from AP, whereas In Payables module, a document is auto moved to ‘history’ status when the said document is fully applied.

Installation of an Open Source Prometeo-ERP System


Although Prometeo-ERP System was a phase-out project for any further development, its follow-up project was Django-ERP. However, Django-ERP is still under development, Its function is not ready, and most features are not ready for public use at this moment. Then, I step back to continue to test Prometeo-ERP System. Prometeo-ERP has already provide many useful features, its public release free version had the following features:

  • Authentication & row-level permission system
  • Notification system
  • Custom widgets & dashboards
  • Taxonomy system
  • File browsing
  • Event calendar
  • User tasks & timesheets
  • CRM (Customer Relationship Management)
  • Products management
  • Stock management
  • Human resources management
  • Sales management
  • Project management
  • Knowledge management
  • DMS (Document Management System)

I installed the Prometeo-ERP system to my Raspberry Pi machine, i.e. free OS, free program tools, free application tools, … Great. It is still worth to study it, and I will show the installation installation in the following

read more

Prometeo-ERP System (An Open Source ERP System)


Recently, I found a open source ERP application project which was developed by python and django framework. Prometeo is absolutely an open-source and free of charge. It is very user friendly and user-oriented, too.


1. Checkout sources from the GIT repository:

git clone https://emanuele.bertoldi@code.google.com/p/prometeo-erp/ prometeo




2. Follow the instructions in the README file from the download.

read more

Odoo System Schedule Backup and Restore Database Setup

This module will be work internally as command line interface (for Linux only) through linux crontab to backup and restore database.

  1. Backup database
  2. Restore as database _TEST
  3. Update image (i.e., with test logo) to _TEST

Just install this module, and it should work. Setup schedule time as you need it. Note: Itself, can also be used as scheduler instead of normal scheduler in OpenERP (you will see this backup and restore as one example).


  • Add, Modify, Delete schedule
  • Direct process through command line interface

Setup Procedure

Menu -> Setting/Technical/Scheduler/Crontab Configuration


Crontab Name – name of crontab

Description – more information

Scheduling – crontab scheduling

read more

金蝶 K3 ERP系統之操作問題 - 重複打印領料單

问题1. 生产领料单存在同单号打印多次或打印单据领料后单据没有及时审核,此举导致系统库存数量不准。

方案 1) 限制普通PMC员工不能重复打印生产领料单,只准准许PMC主管级以上才能处理第二次的打印工作。

好处: 可以避免PMC员工重复打印生产领料单。


方案 2) 把打印次数也印在生产领料单上,PMC员工可查看此资料而得知此单据是否重复打印,若打印次数为一次,便绝对不会是重复的了,否则,便要小心检查。

read more

Odoo 企业管理系统操作手册

我尝试这个Odoo企业系统,其功能相当齐全,我打算把其<<即时通讯>>、<<项目管理>>和<<论坛(Forum)>>功能介绍给大家尝试使用,Odoo 企业管理系统操作操作手册如下,供你们參考。

测试Odoo企业系统,请登陆 ..,先选 Database = Demo,然後输入账号 = Demo 和密码 = Demo,如有时间请尝试使用,给予意见。谢谢!


1. 登入,选 Database = test_odoo,然後输入账号和密码 = demo

read more

How to Hidden “Manage Databases” Option on Odoo Logon Screen

Because of security control purpose, it is unsafe to publish the whole database management option to public. Hence, I would suggest to change the database management screen from original screen as below Diagram 1 to Diagram 2. To achieve it, you only need to edit the “base.xml” file under …/addons/web/static/src/xml directory as below steps.

Diagram 1

Diagram 2

Step 1:

#cd /usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/addons/web/static/src/xml

Step 2:

#vi base.xml

Step 3:

read more

Odoo Project Management Training Video

Odoo项目管理 (project management) 是组织活动、计划任务、跟踪问题,记录人力资源成本的组织形式。项目可以分为内部项目(研发活动,加快销售进度),私有项目或者客户参与的项目。 内部用户以项目成员的方式参与到项目中,分享项目的活动讯息。


致於详细的项目管理运作,请參考以下英文版的的 Youtube 下载电影教材:

read more