ZH/Case-Study-01-Journal-01
From ADempiere
Revision as of 19:59, 30 December 2010 by Peanutblake (Talk)
This Wiki is read-only for reference purposes to avoid broken links.
Contents实施日志-01
2010年10月2010-10-27项目发起
2010-10-28系统安装
2010-10-29实体初始化
讨论栏一楼
二楼
三楼> (台灣技術支持團隊說明:perior control單據期間未開啟,單據不可成立單據不可過帳,單據沒有成立沒有庫存帳,單據沒有過帳沒有成本帳)
> (台灣技術支持團隊說明:沒有自動依據單據類別直接反應到財務報表的 ERP 就像是被斬頭的人,是屍塊已經沒有核心價值與靈魂)
2010-10-30重新导入中国会计科目
仓库重新设定
其它
讨论栏一楼
二楼2010年11月2010-11-01实施栏讨论栏2010-11-02物料类别
计量单位
货币设置
UPDATE c_currency SET isactive = 'N'; UPDATE c_currency SET isactive = 'Y' WHERE iso_code='CNY' OR iso_code='USD' OR iso_code='EUR'; 货币折算类型
货币汇率设置
用户
角色
讨论栏一楼
二楼
三楼
四楼
2010-11-03
价格表
业务类型
新建窗体:业务类型
CREATE TABLE C_Business_Type ( C_Business_Type_id numeric(10,0) NOT NULL, ad_client_id numeric(10,0) NOT NULL, ad_org_id numeric(10,0) NOT NULL, "name" character varying(50) NOT NULL, description character varying(200), isactive character(1) NOT NULL DEFAULT 'Y'::bpchar, created timestamp without time zone NOT NULL DEFAULT now(), updated timestamp without time zone NOT NULL DEFAULT now(), createdby numeric(10,0) NOT NULL, updatedby numeric(10,0) NOT NULL ); ALTER TABLE C_Business_Type ADD PRIMARY KEY (C_Business_Type_ID );
增加Business Type下拉选项
ALTER TABLE c_order ADD C_Business_Type_id numeric(10,0) NOT NULL DEFAULT 1000001;
讨论栏一楼 為何不是在單據類別設定
二楼
> Business Type : 會改變客戶訂單是否必須核對價格清單 ?
> Business Type : 是要來判斷或改變哪些管理流程 ?
2010-11-04关联报表
SQL语句
CREATE OR REPLACE VIEW MyProduct_V AS SELECT p.M_Product_ID AS MyProduct_V_ID, p.AD_Client_ID, p.AD_Org_ID, p.isActive, p.created, p.createdby, p.updated, p.updatedby, 'en_US' AS AD_Language, p.M_Product_ID, p.value, p.name, p.M_Product_Category_ID, uom.UoMSymbol, tax.name AS TaxCategory, rl.name AS ProductType, p.volume, p.weight, p.upc, p.sku FROM M_Product p INNER JOIN C_UoM uom ON ( uom.C_UoM_ID = p.C_UoM_ID ) INNER JOIN C_TaxCategory tax on (tax.C_TaxCategory_ID = p.C_TaxCategory_ID) INNER JOIN AD_Ref_List rl ON ( rl.value = p.ProductType AND rl.AD_Reference_ID =270);
CREATE OR REPLACE VIEW MyProduct_VT AS SELECT p.M_Product_ID AS MyProduct_V_ID, p.AD_Client_ID, p.AD_Org_ID, p.isActive, p.created, p.createdby, p.updated, p.updatedby, pt.ad_language AS AD_Language, p.M_Product_ID, p.value, pt.name, p.M_Product_Category_ID, uomt.UoMSymbol, taxt.name AS TaxCategory, rlt.name AS ProductType, p.volume, p.weight, p.upc, p.sku FROM M_Product p INNER JOIN M_Product_Trl pt ON (pt.M_Product_ID = p.M_Product_ID ) INNER JOIN C_UoM uom ON ( uom.C_UoM_ID = p.C_UoM_ID ) INNER JOIN C_UoM_Trl uomt ON (uomt.c_uom_id = uom.c_uom_id) INNER JOIN C_TaxCategory tax ON (tax.C_TaxCategory_ID = p.C_TaxCategory_ID) INNER JOIN C_TaxCategory_Trl taxt ON (tax.C_TaxCategory_ID = taxt.C_TaxCategory_ID) INNER JOIN AD_Ref_List rl ON ( rl.value = p.ProductType AND rl.AD_Reference_ID =270) INNER JOIN AD_Ref_List_Trl rlt ON ( rlt.AD_Ref_List_ID = rl.AD_Ref_List_ID );
CREATE OR REPLACE VIEW MyProductLine_V AS SELECT pb.AD_Client_ID, pb.ad_org_id, pb.isactive, pb.created, pb.createdby, pb.updated, pb.updatedby, 'en_US' AS AD_Language, pb.M_Product_ID, pb.BomQty, pb.Line, pb.Description, p.value, p.name AS BOMProduct, uom.UoMSymbol, rl.name AS BomType FROM M_Product_BOM pb INNER JOIN M_Product p ON (pb.M_ProductBOM_ID = p.m_product_id) INNER JOIN c_uom uom ON ( uom.c_uom_id = p.c_uom_id ) INNER JOIN ad_ref_list rl ON ( rl.value = pb.bomtype AND rl.ad_reference_id =279);
CREATE OR REPLACE VIEW MyProductLine_VT AS SELECT pb.AD_Client_ID, pb.ad_org_id, pb.isactive, pb.created, pb.createdby, pb.updated, pb.updatedby, pt.AD_Language AS AD_Language, pb.M_Product_ID, pb.BomQty, pb.Line, pb.Description, p.value, pt.name AS BOMProduct, uomt.UoMSymbol, rlt.name AS BomType FROM M_Product_BOM pb INNER JOIN M_Product p ON (pb.M_ProductBOM_ID = p.m_product_id) INNER JOIN M_Product_trl pt ON (pt.M_Product_ID = p.m_product_id) INNER JOIN c_uom uom ON ( uom.c_uom_id = p.c_uom_id ) INNER JOIN c_uom_trl uomt ON ( uomt.c_uom_id = uom.c_uom_id ) INNER JOIN ad_ref_list rl ON ( rl.value = pb.bomtype AND rl.ad_reference_id =279) INNER JOIN ad_ref_list_trl rlt ON ( rlt.ad_ref_list_id = rl.ad_ref_list_id); 讨论栏一楼-不建议用View写报表
二楼
讨论栏目
链接 |