Import account

20. Import account 

• Short description: Test the Accounting import works correctly

• Steps:
  • Login as userA
  • Go to Master data management->Import data->Import File loader
  • Select the chart of accounts. This chart of accounts must be the same as selected for theinitial client set up otherwise the process import accounts wouldn't overwrite the default values.
  • Select the format file= Accounting-Accounts
  • Mark Header first line
  • Click Process

• Please verify the new imported accounts are in this temporary window

• • Go to the database manager software and execute the next sentences:
    • update c_elementvalue set value = 'xx' || value where ad_client_id = v_client;
    • The parameter v_client is the ID of the client that you have already created
    • delete from c_elementvalue_operand;
    • Commit;
  • Go into any of the records that are in the window Import Account and click on button "Import accounts" and:
    • Update default marked
    • Delete imported marked
    • Create new combination not marked
  • Click OK
  • Go again to the database manager software, and execute the next statement:
    • delete from c_elementvalue where value like 'xx%' and ad_client_id =v_client;
    • commit;

• Issues to verify:

If you cannot execute correctly the last statement, means the import accounts has failed

• Additional data:

Please see Chart of accounts for more information

select name, ad_client_id from ad_client ;
NAME                      AD_CLIENT_ID
------------------------- ------------
System                               0
SampleClient                   1000000

update c_elementvalue set value = 'xx' || value where ad_client_id = 1000000 ;

1356行が更新されました。

delete from c_elementvalue_operand;

0行が削除されました。  commit ;

SQL> select count(*) from c_elementvalue;

COUNT(*)
----------
    2712

SQL> delete from c_elementvalue where value like 'xx%' and ad_client_id = 1000000 ;

1356行が削除されました。

SQL> commit ;

Create Physical inventory

19. Create Physical inventory 

• Short description: Create inventory in order to test other features without needed of purchasing or producing anything

• Steps:
  • Login as userA
  • Go to Warehouse management-->Transactions-->Physical inventory
  • Click New and fill the mandatory fields and save
  • Click button "Create Inventory Count List"
    • Select a storage bin=Standard
    • Inventory Quantity=0
  • Click Ok
  • Move to lines and for each line write in the "Quantity count" box 10000 and fill the attribute set value
  • Move back to the header and process (Process inventory count)

• Issues to verify:Go to Warehouse management-->Analysis tools-->Stock report and click HTML format. Products should be shown

在庫数は入力したが　Stock report は表示されない。

Edit Business partner

18. Edit Business partner 

Note: If you don't want to edit all the business partner using the application please use this Oracle script or this PostgreSQL script

• Short description:Test the way of editing a business partner. Example for "CUSTOMER A"

• Preconditions: set some sales representatives.
  • Login as userA
  • Go to Master Data management-->Business partner
  • Click on search button from the toolbar
  • Write "SALESMAN A" in the name box and click OK
  • Move to Employee tab and edit the values:
    • Mark Sales Representative and save.
  • Do the same for SALESMAN B.

Steps

• Login as userA
• Go to Master Data management-->Business partner
• Click on search button from the toolbar
• Write "CUSTOMER A" in the name box and click OK
• Move to Customer tab and edit the values:
  • Invoice Terms: Customer schedule After Delivery
  • Invoice Schedule: Schedule Customer A
  • Price list: Customer A
  • Form of Payment: Money Order
  • Payment Terms: 30 days, 5
  • Sales Representative: Salesman A

Edit products

17. Edit products

Note: If you don't want to edit all the products using the application please use this Oracle script or this PostgreSQL script

• Short description:Test the way of editing a product. Example for product "Raw material A"

• Steps
  • Login as userA
  • Go to Master Data Management->Product
  • Click on search button from the toolbar
  • Write "RMA" in the "Search Key" box and press OK
  • Edit the values:
    • Tax Category=VAT 10%
    • Mark Purchase
    • Not mark Sale
    • Attribute set=Serial number
  • Save

Next : Create BOM production

Create Invoice Schedule

16. Create Invoice Schedule 

• Short description: Create an invoice schedule to use in Generate invoices test case

• Steps:
  • Login as userA
  • Go to Master Data Management->Business Partner Setup->Invoice schedule
  • Click New and fill:
    • Name: Schedule customer A
    • Invoice Frequency: Monthly
    • Day of the Month: 1
    • Invoice Cut-Off Day: 31

Create Payment term

15. Create Payment term 

Note: If you don't want to create all the payment terms using the application please use this Oracle script or this PostgreSQL

• Short description:Create payment terms to add to business partner. Do as example "30 days, 5"

• Steps:
  • Login as userA
  • Go to Master Data Management->Business partner setup->Payment Term
  • Click New fill:
    • Value=30d/5
    • Name=30 days, 5
    • Mark "Fixed Due Date"
    • Maturity Date 1=5
    • Offset Month Due=1

• Additional data: Doing the example for "30 days, 5", remember to remove from the script the code related to this issue.

DECLARE
v_paymentterm_id NUMBER(10);
v_client_id NUMBER(10);
BEGIN
SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;

SELECT COALESCE(MAX(C_PAYMENTTERM_ID),999999) +1 INTO v_paymentterm_id FROM C_PAYMENTTERM;

INSERT INTO C_PAYMENTTERM
(C_PAYMENTTERM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY,
 NAME, ISDUEFIXED, NETDAYS, FIXMONTHOFFSET, ISNEXTBUSINESSDAY, ISDEFAULT, VALUE, ISVALID)
VALUES
 (v_paymentterm_id, v_client_id, 0, 'Y', SYSDATE, 100, SYSDATE, 100, '90 DAYS', 'N', 0, 3, 'N', 'N', '90d', 'N');
ad_update_sequence();
commit;
END;

Create Pricelist

14. Create Pricelist 

Note: If you don't want to create all the pricelist using the application please use this Oracle script or this PostgreSQL script

• Short description: Create pricelist for all the products. Do as example SALES pricelist
• Steps
  • Login as userA
  • Go to Master Data management->Pricing->Pricelist
  • Click New and fill Name=SALES mark Sales price list, currency=EUR
  • Move to tab Price list version
  • Click New and fill Name=Sales, Price List Adjustment= Standard and valid from date=01-01-2000
  • Move to tab Product price
  • Click new and select Product "A Final goods". Uncheck the flag "Stocked" in order to find the product
  • Fill for each price (List price, Standard price, price limit) fill 2. Do the same for "B Final goods", "C Final goods"

• Additional data: Doing the example for "SALES", remember to remove from the script the code related to this issue.

Oracle Script を実行する際には

ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY'  ;

が必要。

Create Attribute set

13. Create Attribute set 

• Short description: Create sets of attributes for the Products.

• Steps
  • Login as userA
  • Go to Master Data Management->Product Setup->Attribute Set
  • Click New, fill name=Serial number
  • Mark Serial No.
  • Run this Oracle script or this PostgreSQL script to create the rest of sets

DECLARE
v_attributeset_id NUMBER(10);
v_client_id NUMBER(10);

BEGIN

SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
SELECT COALESCE(MAX(M_ATTRIBUTESET_ID),999999)+1 INTO v_attributeset_id FROM  M_ATTRIBUTESET;

INSERT INTO M_ATTRIBUTESET (M_ATTRIBUTESET_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,CREATEDBY, UPDATED, UPDATEDBY, NAME, ISLOT, ISGUARANTEEDATE, ISSERNO)
VALUES(v_attributeset_id, v_client_id, 0, 'Y', sysdate, 100,sysdate,100,'Lots','Y','Y','N');
   
AD_UPDATE_SEQUENCE;
COMMIT;
END;

Import Taxes

12. Import Taxes 

• Short description:Import from the temporary tax table to the final one

• Steps:
  • Login as userA
  • Go to Master Data Management->Import Data->Import Tax
  • Entry in edition mode and click on button Import Tax and then OK

• Issues to verify:Take a look in the field Import Error Message to see if there are any errors and Go to Financial management->Accounting->Setup->Tax rate and verify that all the taxes are there

手動で画面よりインターフェイステーブルに VAT 3% 　だけ登録し、インターフェイス処理を実行。

Tax Rate の登録を確認

Import products / Business partner

10. Import products
11. Import Business partners

• Short description:Import from the temporary product table to the final one

• Steps:
  • Login as userA
  • Go to Master Data Management->Import Data->Import Products
  • Entry in edition mode and click on button Import Product and then OK

• Issues to verify:Take a look in the field Import Error Message to see if there are any errors and Go to Master Data Management->Product and verify that all the products are there

この画面で　”Imoprot Products" をクリックすることで一時テーブルから最終の位置に登録される。

　Product inserted: 9 　　と表示されている。

この処理により Business Partner の場合、　I_BPartner インターフェイステーブルから C_BPartner テーブルをはじめとした、いくつかのテーブルへの処理が実行されている。

Create Product/Business Partner category

8. Create Product category
9. Create BusinessPartner Category

• Short description:Create a product category to import the data from the temporal tables to the final tables.

• Steps:
  • Login as userA
  • Go to Master data management->Product Setup->Product Category
  • Click New and fill value=RM; Name=Raw materials and save
  • Create Product categories for BOM (Bill of Materials) and FG (Finished Goods) with this Oracle script or this postgreSQL script

• Additional data: Please create these categories with the values RM, BOM and FG respectively in order to import the products that belong to that category.

Raw Material 以外は　Script が用意されているので、これを実行。

DECLARE
v_client_id number(10);
v_product_category_id number(10);

BEGIN
SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
SELECT MAX(M_PRODUCT_CATEGORY_ID)+1 INTO v_product_category_id FROM  M_PRODUCT_CATEGORY;
INSERT INTO M_PRODUCT_CATEGORY (M_PRODUCT_CATEGORY_ID, AD_CLIENT_ID, AD_ORG_ID,
ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, VALUE, NAME, PLANNEDMARGIN)
VALUES (v_product_category_id, v_client_id, 0 , 'Y', sysdate , 100, sysdate, 100, 'BOM', 'BOMs', 0);
v_product_category_id:=v_product_category_id + 1;
INSERT INTO M_PRODUCT_CATEGORY (M_PRODUCT_CATEGORY_ID, AD_CLIENT_ID, AD_ORG_ID,
ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, VALUE, NAME, PLANNEDMARGIN)
VALUES (v_product_category_id, v_client_id, 0 , 'Y', sysdate , 100, sysdate, 100, 'FG', 'Final goods',0);
AD_UPDATE_SEQUENCE();
commit;
end;

Import file loader

7.Import file loader 

• Short description: Test the import data process for Products, Business partner and taxes.

• Steps:
  • Login as userA
  • Go to Master Data Management->Import Data->Import File Loader
  • Select the file I_Products.txt and the format for the products
  • Click OK. This is only to verify that the file is well format
  • Select again the file and the format. Click Process
  • Do the same for Business partners and taxes

• Issues to verify:
  • Go to Master Data Management->Import Data
  • Verify that the products are in the Import Product window
  • Verify that the Business partners are in the Import Business partner window
  • Verify that the taxes are in the Import tax window

• Additional data: To import use the .txt that are in Business partner, Products and taxes

Product データロード用の書式が手入力したものなのでまずはエラーとなることを予想していたが、１度目で Load 成功。

"Process" をクリックすることで、実際の Loading が実行される。

Taxes が "Process" でエラーとなる。　( 2.40 )

ProcessRunError と表示されるだけで、エラーの原因が表示されない

試しに　"Format file: Taxes: Complete" を選択すると書式チェックの段階でフリーズしてしまった。

６行程度のデータなので手動で入力してもこの部分はたいした工数にはならない。

Skip

このエラーの原因を検索していて以下のガイドを見つけた

OPENBRAVO CHART OF ACCOUNTS TESTING GUIDE

http://www.scribd.com/doc/2923732/OPENBRAVO-CHART-OF-ACCOUNTS-TESTING-GUIDE

Create Import Loader Format

Interfaceテーブルはいくか用意されているが残念ながら BOM については用意されていない。

Interface テーブルに対して import するデータの書式はカスタム定義可能であるため、この項にて動作確認。

6.Create Import Loader Format 

• Short Description: Create the import format loader for Business partner, Products and taxes.

• Steps
  • Login as userA
  • Go to Master Data Management->Import Data->Import Loader Format
  • Click New and fill:
    • Name "Product"
    • Table "I_Product"
    • Format "Comma Separated"
  • Move to Field Format and create new records:

Business partner, Taxes 用には SQLが用意されている。

C:\OpenbravoERP24>sqlplus erp/xxxx @6_format_loader.sql

Create role

5.Create role 

• Short description: Create a role to relate to the user "userA"

• Steps
  • Login with userA
  • Go to General setup->Security->Role
  • Click New
  • Fill Name "Sales"
  • Select "Client+Organization"
  • Mark the check Manual and save
  • Click Grant Access: Select "Sales management" and Access "All"
  • Go to Org Access and click New. Select org *
  • Click New and select org Pamplona.
  • Go to User Assignment and select "userA"

• Issues to verify: Login with "userA" and click on "User info". Select the Role (Sales). Verify that you can only access Sales management module windows.

作成した Sales ロールでログインすると Sales 用のメニューしか表示されなくなったが、選択した先の Window の表示でエラーになるのはまだ権限設定を行なっていないからだろうか。

Create User

4.Create user 

• Short Description: Create a user to use for the next test cases

• Steps
  • Login with user created by the initial client setup, SampleClientAdmin/SampleClientAdmin
  • Go to General setup->Security->User
  • Click New and fill the mandatory field:
    • Organization: *
    • First Name "userA"
    • Name "userA"
    • Username "userA"
  • Save
  • Fill the password and save. Password "userA"
  • Move to User Roles and click New and select the SampleClientAdmin role.

• Issues to verify: Verify that you can login with the new user and you have access to all windows

Openbravo ユーザーでログインして、一旦、自分の Role を　SampleClientUser に変更して

Create User しないと、この作成したユーザーの Role に　SampleClientUser 　をアサインできない。

Client作成時に自動作成される　User/Password = SampleClientAdmin/SampleClientAdmin

にてログインして、 userA を作成する。

M_Pricelist.C_Currency_ID に Null

1.Initial client setup

issue8246 として登録されて、fix されているが、Patch がダウンロードできないようでもあり、

alter table m_pricelist modify ( c_currency_id number(10) null ) ;

SQL> desc m_pricelist ;
名前               NULL?    型
------------------ -------- -------------
M_PRICELIST_ID     NOT NULL NUMBER(10)
AD_CLIENT_ID       NOT NULL NUMBER(10)
AD_ORG_ID          NOT NULL NUMBER(10)
ISACTIVE           NOT NULL CHAR(1)
CREATED            NOT NULL DATE
CREATEDBY          NOT NULL NUMBER(10)
UPDATED            NOT NULL DATE
UPDATEDBY          NOT NULL NUMBER(10)
NAME               NOT NULL NVARCHAR2(60)
DESCRIPTION                 NVARCHAR2(255)
BASEPRICELIST_ID            NUMBER(10)
ISTAXINCLUDED      NOT NULL CHAR(1)
ISSOPRICELIST      NOT NULL CHAR(1)
ISDEFAULT          NOT NULL CHAR(1)
C_CURRENCY_ID               NUMBER(10)
ENFORCEPRICELIMIT  NOT NULL CHAR(1)

2.Delete client

しかし　ora-1400 が発生しているにもかかわらず ad_client テーブルにはデータが insert されてしまっているため、 "Delete Client" で削除しなくてはならない。

Initial client setup

Initial client setup

• Short Description: Test the Initial Client Setup process

• Additional data: Use the System Administrator Role for this test

• Steps
  • Login as Openbravo/openbravo
  • Click on icon "user info" and select the role "System Administrator"
    
    
  • 
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
  • Go General Setup -> Client-> Initial client setup
    
    
  • Fill the data and chart of accounts according Client sample data
  • Click OK

• Issues to verify: Verify that the output log is correct

ここで指定した、SampleClientAdmin ユーザーが自動的に作成される。

このユーザーでログイン(　Password = SampelClientAdmin ) し、

以後、ユーザー userA を作成する。

Reference data などインストールに問題がある場合など、この時点でエラーとなる。

2.2 Administration master data

1.Initial client setup

2.Delete client

3.Import/Export Translation