Configuring the default date and time formats

日付書式　Date Format を変更するにはやはり再コンパイルが必要

やはり　YYYY/MM/DD に関連した不具合があるため、 DD-MM-YYYY にしようとしたが
Openbravo.properties の NLS_DATE_FORMAT の変更だけでは対応できない。

Configuring the default date and time formats

To change the default Openbravo ERP date format launch the setup tool inside the config/setup-tool directory.

Once all the changes are done, recompile and deploy Openbravo ERP:

ant compile.complete 

ant war 

ant deploy 

Configuring the default numbering format

You can modify the default numbering format by editing the Format.xml file inside config directory. You should have decimal="." grouping="," for every category. Once this is done you will have to restart Tomcat and the reports will show as you wish.

http://wiki.openbravo.com/wiki/Openbravo_ERP_installation#Configuring_the_default_date_and_time_formats

2.6 Sales Management

Pay the Purchase Invoice

5. Pay the Purchase Invoice 

• Short description:Test the cash journal using the payment that is above

• Steps:
  • Login as userA
  • Go to Financial management->Receivables and Payments->Transactions->Cash journal
  • Click New, fill the mandatory fields and save
  • Move to Lines Tab
  • Click New and select Cash Type: Debt-Payment
  • Click on Payment icon and:
    • Business partner: VENDOR A
    • Unmark Receipt check
    • Be carefully with the dates. You will only see the payment within the correct ranges
    • Click Search and mark the payment. Click OK
  • Verify the Amount field is filled with the amount of the payment
  • Go back to header and process
  • Click "Not posted"
  • Verify the journal entry is correct

• Issues to verify:When you process a Cash journal, a Settlement is created in order to cancel the payment. To verify this:
  • From the Cash journal window move to Lines tab
  • Select one line and click "Linked Items"
  • You must see the link "Settlement - Cancelled Payments". Click it
  • You must see the link of the payment. Click it
  • You must browse to Cancelled Payments tab

ora-6508　が発生するケースあり。( C_CASH_POST )

Accounting Purchase Invoice 仕入仕訳

4. Accounting Purchase Invoice 

• Short description:Accounting the above purchase invoice

• Steps:
  • Login as userA
  • Go to Procurement management->Transactions->Purchase invoice
  • Being in edit mode click "Not Posted" and click OK
  • Verify the created journal is correct
    
  
  
  
  
  
  
  
  
  
  
  
  
  
  

• Additional data: If you cannot see the button "Not Posted" please go to General setup->Application->Session Preferences. Mark "Show accounting tabs" and then click "Save preferences". Doing this you will be able to enter in the book
  
  
  

Create Purchase Invoice 仕入れ明細請求

• Short description: Testing the button 'Create lines from' and the way of creating purchase invoices

• Steps:
  • Login as userA
  • Go to Procurement management->Transactions->Purchase invoice
  • Click New and select Transaction Document= AP Invoice[買掛]
  • Select the business partner using two possibilities:
  • A.- Click on the bp icon and verify:
    • When you click the bp icon a pop-up window must show up and the radio button 'provider' must be checked. Please select VENDOR A
  • B.- Or write in the bp box VA and verify:
    • A pop-up window doesn't show up and the bp box is filled with the name VENDOR A
  • For both cases verify:
    • Invoice from: "Pamplona, Street Purchase center nº1"
    • The combo box User/Contact must have the value: John
    • Price list: PURCHASE
    • Form of payment: Wire Transfer
    • Payment terms: 90 days
  • Click on button 'Create lines from' and verify:
    • Business partner: VENDOR A
    • In the "Order" combo box there is the purchase order
    • In the "Shipment" combo box there is the good receipt
  • Select the good receipt and click OK
  • Move to Lines and verify:
    • Product: A Raw material
    • Taxes: VAT 10%
    • The box "Purchase Order Line" is filled properly
    • The box "Shipment/Receipt Line" is filled properly
  • Go back to Header and click Complete
  • Move to Payments and verify:
    • Due Date 90 days after the invoice date
    • Form of Payment: Wire transfer

ORA-6508 で完了できず。　データの問題か？
0005111: Oracle error after completing a purchase invoice

https://issues.openbravo.com/view.php?id=5111

C_INVOICE_POST.xml の改訂履歴　を確認した範囲でもこの不具合は報告されていない。

C_INVOICE_POST Procedure の再作成により動作するようになる。

Create Goods receipt 入庫処理

2. Create Goods receipt 

• Short description: Testing the button 'Create lines from' and the way of creating goods receipt

• Steps:
  • Login as userA
  • Go to Procurement management->Transactions->Goods receipt
  • Click new and select VENDOR A as a business partner. Save
  • Click on button 'Create lines from' and verify:
    • Business partner: VENDOR A
    • In the "Order" combo box there is the purchase order
  • Select the purchase order
  • Select a warehouse position
  • Select the purchase order line
  • Click OK
  • Move to Lines
  • Click on Attribute set value icon and fill the values and click OK
  • Go back to header and Complete

Create a purchase order

1. Create a purchase order 

• Short description:Create an order to be used when creates a good receipt

• Steps:
  • Login as userA
  • Go to Procurement management->Transactions->Purchase Order
  • Click New and two possibilities:
  • A.- Click on the bp icon and verify:
    • When you click the bp icon a pop-up window must show up and the radio button 'provider' must be checked. Please select VENDOR A
  • B.- Or write in the bp box VA and verify:
    • A pop-up window doesn't show up and the bp box is filled with the name VENDOR A
  • For both cases verify:
    • Invoice from: "Pamplona, Street Purchase center nº1"
    • The combo box User/Contact must have the value: John
    • Price list: PURCHASE
    • Form of payment: Wire Transfer
    • Payment terms: 90 days

Vendor が設定されていないと Business Partner に表示されない。

Product を選択する際の Price List は "Pruchase -EUR" を選択しないと　A Raw material が表示されない。

• Move to tab Lines and click New. There are two possibilities:
• A.- Click on the product icon and verify:
  • When you click the product icon a pop-up window must show up.
  • The price list combo must be filled with the value Purchase
  • When click Search only 3 products must appear: A Raw material, B Raw material, C Raw material. Select A Raw material
• B.- Or write in the product box RMA and verify:
  • A pop-up window doesn't show up and the product box is filled with the name Raw material
• For both cases verify:
  • UOM:Unit
  • Unit price:2
  • List price:2
  • Tax:VAT 10%
• Fill in Ordered quantity= 1
• Move to header and complete. Verify:
  • Summed Line Amount= 2
  • Grand Total Amount= 2.2

Complete しても　Grand Total Amount= 2　となり 2.2 とはならず。

2.5 Procurement management

2.5 Procurement management

Create Bank

2. Create Bank 

• Short description:Create a bank and related to a business partner. The goal of relating a business partner with the bank is to be able to use the remittance window

• Steps:
  • Login as userA
  • Go to Financial management->Receivables & Payables->Setup->Bank
  • Click New
  • Fill the mandatory fields:
    • Name: SampleBank
    • Bank code: 1234
    • Branch code: 0001
    • Control Digit: 0
    • Address:
      • 1st Line:Sample Street
      • Postal Code:31010
      • City:Pamplona
      • Region:Navarra
      • Country:Spain
  • Save
  • Move to Account and fill the mandatory fields:
    • Partial Account No.:1111111111
    • Control Digit:0
    • Mark "Show Spanish"
  • Save

• Go to Master Data->Business partner
• Click New and fill
  • Search Key:BANK
  • Name:Bank
• Go back to Bank click on Bpartner icon and, after marking the option "All", select the business partner

Create remittance type

1. Create remittance type 

• Short description:Create a remittance to test other features

• Steps:
  • Login as userA
  • Go to Financial management->Receivables & Payables->Setup->Remittance type
  • Click New and fill:
    • Name:'Remittance 19'
    • Mark Consolidate
    • Payment Rule Consolidated:Bank Remittance
    • Final Status:In Remittance
    • Returned Status: Returned
  • Move to Parameter tab
  • Click New
  • Fill Name=Contract, content=001 and save
  • Click New
  • Fill Name=Cuaderno, content=19 and save

• Aditional data:Please write the names as it is explained. Both, Contract and Cuaderno, are parameters that OB uses

2.4 Administration financial data

2.4 Administration financial data

Update Business partner to add a business partner tax category

4. Update Business partner to add a business partner tax category  

• Short description: Create business partner tax category to test taxes in transactional documents. Add the new category to Customer A

• Steps:
  • Login as userA
  • Go to Master Data management->Business partner
  • Select "CUSTOMER A" and, inside Customer tab, select "SO BP Tax Category"=Vat 3%+Charge 0.5%

Create G/L Item

3. Create G/L Item 

• Short description: Create a GL/Item to test other features

• Steps:
  • Login as userA
  • Go to Financial management->Accounting->Setup->G/L Item
  • Click New and fill name=G/L Item A
  • Move to Accounting tab
  • Create a new record
  • Select an expense account (i.e 649 using ESAccounts) for both debit and credit
    • If the account combination does not exist first find the account then select the organization and press Save

Editing Document sequence

2. Editing Document sequence 

• Short description: Edit the document sequences for AR Invoice

• Steps:
  • Login as userA
  • Go to Financial management->Accounting->Setup->Document type
  • Select "AR Invoice" record in edit mode
  • Click link Document Sequence
  • Fill Prefix=I/ ,Next Assigned Number=1

Create fiscal calendar

1. Create fiscal calendar

会計期間を開く

• Short description: Create periods and open document for each period

• Steps:
  • Login as userA
  • Go to Financial management->Accounting->Setup->Fiscal calendar->Year
  • Click button create periods
  • Move to each period and click button Open/Close All

• Issues to verify: For any period move to Period control tab and verify the documents are open

import.sample.data ( V2.50MP1)

３月２日のファイルでも以下のエラーとなる

https://code.openbravo.com/erp/devel/pi/log/cbbf45c0800c/referencedata/sampledata/Accounting_Test.xml

https://code.openbravo.com/erp/devel/pi/file/cbbf45c0800c/referencedata/sampledata/SmallBazaar.xml

https://code.openbravo.com/erp/devel/pi/log/cbbf45c0800c/referencedata/sampledata/SmallBazaar.xml

import.sample.data:

[echo] Importing sample reference data

[importsampledata] 2 [main] ERROR org.openbravo.base.util.CheckException - Property shipmentReceiptLine does not exi

st for entity MaterialMgmtMaterialTransaction

[importsampledata] org.openbravo.base.util.CheckException: Property shipmentReceiptLine does not exist for entity Materi

alMgmtMaterialTransaction

[importsampledata] at org.openbravo.base.util.Check.isNotNull(Check.java:72)

2.50 tar ball

2.50 の tar ball をダウンロードして ant install.source すると
Database が Oracle でも PostgreSQL でも接続エラーとなる。

compile:

    [javac] Compiling 68 source files to C:\Openbravo\OpenbravoERP-2.50MP1\src-core\build\classes

    [javac] C:\Openbravo\OpenbravoERP-2.50MP1\src-core\src\org\openbravo\database\ConnectionPool.java:83: シンボルを見つけられません。

    [javac] シンボル: クラス OpenbravoDriverManagerConnectionFactory

    [javac] 場所    : org.openbravo.database.ConnectionPool の クラス

    [javac]     ConnectionFactory connectionFactory = new OpenbravoDriverManagerConnectionFactory(_server,

    [javac]                                               ^

    [javac] C:\Openbravo\OpenbravoERP-2.50MP1\src-core\src\org\openbravo\database\ConnectionProviderImpl.java:150: シンボルを見つけられません。

    [javac] シンボル: クラス OpenbravoDriverManagerConnectionFactory

    [javac] 場所    : org.openbravo.database.ConnectionProviderImpl の クラス

    [javac]     ConnectionFactory connectionFactory = new OpenbravoDriverManagerConnectionFactory(dbServer,

Virtual Machine Appliance の /opt/AppsOpenbravo 以下のソースを
もってきて ant すると、エラーとはならない様子。

sample data

2.50MP1 環境でも sample data のインストールは失敗する。

0007899: Build Failed in ant target import.sample.data

https://issues.openbravo.com/view.php?id=7899

# cd /opt/AppsOpenbravo

# ant install.source

.

clean.src.gen:

generate.entities:

 [workflow] Adding param: /opt/AppsOpenbravo/src/org/openbravo/base/gen/gen_entity.oaw

 [workflow] Adding param: -pob.properties.location=/opt/AppsOpenbravo/config/Openbravo.properties

 [workflow] Adding param: -pbase.src.gen=/opt/AppsOpenbravo/src-gen

 [workflow] Adding param: --ant

    [javac] Compiling 441 source files to /opt/AppsOpenbravo/build/classes

import.sample.data:

     [echo] Importing sample reference data

BUILD FAILED

/opt/AppsOpenbravo/build.xml:494: The following error occurred while executing this line:

/opt/AppsOpenbravo/build.xml:398: The following error occurred while executing this line:

/opt/AppsOpenbravo/src/build.xml:180: org.openbravo.base.exception.OBException: No import files present in the import directory: /opt/AppsOpenbravo/referencedata/sampledata

Total time: 27 minutes 3 seconds

Openbravo ERP: 2.50MP1 available

Openbravo ERP: 2.50MP1 available
http://forge.openbravo.com/plugins/espnews/browse.php?group_id=100&news_id=112

- ダウンロードした ファイルを Module Management より実行する。

注意:

bug in the 2.50 appliance delete the /opt/AppsOpenbravo/README file before launching the upgrade.

/opt/AppsOpenbravo/README ファイルを手動で削除してからパッチを適用すること

一部適用でエラー

update.database:
Database connection: jdbc:postgresql://localhost:5432/openbravo. User: tad
Database has local changes. Update.database will not be done. If you want to force the update.database, do: ant update.database -Dforce=yes (you will lose all your changes in the application dictionary if you do it)
The following error occurred while executing this line:
/opt/AppsOpenbravo/src-db/database/build.xml:126: Database has local changes. Update.database not done.

手動にて強制実行

[root@localhost AppsOpenbravo]# pwd

/opt/AppsOpenbravo

[root@localhost AppsOpenbravo]# ant update.database -Dforce=yes

...

BUILD SUCCESSFUL

Total time: 7 minutes 13 seconds

[root@localhost AppsOpenbravo]# pwd

Product Import / Error

2.50 では Procuct の Import を実行する前に default tax code の設定が必要。
エラーが表示される。　default tax code 設定後、　再度 Import を実行すると
ハングアップする。

強制的に

# service postgresql restart 　した後は必ず
# service tomcat restart 　　　が必要

PostgreSQL だけ再起動し、 Tomcat を再起動しない場合、以下のようなエラーとなる。

HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.hibernate.TransactionException: JDBC rollback failed
org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
org.openbravo.dal.core.SessionHandler.rollback(SessionHandler.java:226)
org.openbravo.dal.core.DalThreadHandler.doFinal(DalThreadHandler.java:48)
org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:70)
org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85)
root cause
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
Exception: java.net.SocketException: Broken pipe
Stack Trace:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

Ver.2.50 Virtual Machine Appliance

Virtual Machine Appliance

SVN から取得した最新バージョン 2.50 で　

http://localhost:8088/openbravo/

にてアクセス可能となったので　Acceptance Test をこの環境で実行。

最初の client (このERPソフトを使う会社名のこと）の登録で

Currency(通貨）を設定する必要があるのだが、この List of Values に値が表示されない。　

c_currency テーブルに値が insert されていない。 Seed Data 未登録。

コマンドラインから ant で　creata database する方法はわかったが ...

C:\pleiades\workspace\openbravo>ant create.database -Dapply.on.create=true

にてまず、　dopr user xxx cascade; 　してから、再作成を開始する。
ただ、 Tomcat が起動したままだと　”接続中のユーザーは削除できません”ので注意。

sampledata や　reference data の登録の部分は動作しないようなので、 2.40 の環境から
c_currency テーブルの内容を exp して　imp table=c_currency ignore=y することで
currency は表示されるようにはなったが、 client の登録で失敗する。

新方式　2.50 の Virtual Machine Appliance のインストール形式を利用すること。

これは実に簡単にインストールが完了する。

VMware Player がインストールされていれば、これようのファイルをダウロードして

解凍してえられる　ｖｍｘ　ファイルを　 VMware Player で開くと窓のなかで　OS　が

起動し、　プロンプトに表示される　URL にアクセスすると

OpenBravo の ERP ソフトを利用できるようになっている。

Port 80 で起動しているのでこれまでだめだった Heartbeat テストもクリア。

Tera Term などで　Virtual Machine (192.168.1.2:22 でユーザー openbravo) に Loginできる。

# su - postgres
$ psql -l
List of databases
Name | Owner | Encoding
----------+----------+----------
openbravo | tad | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(4 rows)

\i xxx.sql
\q

$ psql openbravo -f xxx.sql

ファイル名を指定して PostgresSQL で　SQLを実行するため、ファイル共有に

VMware Player のフォルダ共有機能を利用しようとしたが、 Windows 2008 Server の

共有機能とのからみか、なかなかうまくいかず、また時間を費やしてしまった。

/usr/bin/vmware-config-tools.pl

にてVMware Player の表示画面のサイズを変更して大きくする方法がわかったことは成果としてある。
設定変更の反映には再起動が必要。
ただし、今回の Virtual Machine では X11R6 は含まれないため、画面表示のサイズ変更にはメリットはなし。

　$ sftp ユーザー名@ホスト名　

にて Linux 側の設定なしでファイル転送は可能であったので、

cygwin に　Net - OpenSSH と OpenSSL　をいれて、 sftp を使用することに。

FileZilla では sftp://192.168.1.2@openbravo

2.10 Assets: Create Amortization Plan

2.10 Assets: Create Amortization Plan

Skip

2.9 Accounting processes

2.9 Accounting processes

Skip

2.8 Project and Service management

2.8 Project and Service management

Skip

Create Work effort

7. Create Work effort 

• Short description: Test the way of creating a work effort

• Steps:
  • Login as userA
  • Go to Production management->Transactions->Work Effort
  • Click New and fill:
    • Movement date= Current date
    • Starting Time: 08:00:00, Ending time: 16:00:00
  • Move to Production Run tab and click new
  • Select the "WR Phase" and verify:
    • The fields "Required quantity", "Process unit" and "Conversion Rate" are filled based on the WR phase
  • Fill Done quantity=2 and save

• Click on button "Create Standards"
  • The field "Cost centre used" is calculated well depending on you what configure on the Cost Centre. For this case should be 8
• Move to Product tab and verify:
  • You have three lines: A BOM:(P-), B BOM(P-), A Final Goods(P+)
  • The ones for P- must have filled the attribute set value
  • The quantity for the three must be 200 as a result of "Done quantity" x "Quantity" (I/O Products tab)
• For the A Final Goods product fill the attribute set value
• Move back to Work effort tab
• Click on button "Validate Work effort"

設定ミスのためエラー

Create Work requirement

6. Create Work requirement 

• Short description: Create a work requirement to use in the Work effort window

• Steps:
  • Login as userA
  • Go to Production management->Transactions->Work requirement->Header
  • Click New and fill:
    • Select Production Final goods A as process plan
    • Quantity=10
    • Starting Date= The current day
    • Ending Date= The following date
  • Save and click on button "Process Work Requirement"
  • Move to Operation tab and verify:
    • The quantity field has the same value as in Header tab
    • The fields "Cost Center Use Time", "Empty Cells are Zero", "Outsourced" and "Global Use" have the same value as in Operation tab (Process plan window)
  • Move to Product tab and verify:
    • We have three lines: A BOM(P-), B BOM(P-) and A final goods(P+)
    • Each line quantity=100
  • Move back to Operation tab and click New again
  • Select the sequence "Assamble" and verify:
    • The quantity field has the same value as in Header tab
    • The fields "Cost Center Use Time", "Empty Cells are Zero", "Outsourced" and "Global Use" have the same value as in Operation tab (Process plan window)
  • Don´t save

• Additional data:

The field Quantity on Header tab indicates the number of times that we want to process the process plan

Create a process plan

5. Create a process plan 

• Short description: Create a process plan to use in Work Requirement

• Preconditions:
  • Products Final Goods A, A BOM and B BOM must have the production check marked.

• Steps:
  • Login as userA
  • Go to Production management->Transactions->Process plan
  • Click New and fill:
    • Search Key=FGA
    • Name=Production Final Goods A
    • Process unit=FGA unit
    • Conversion rate=100
    • "Insert phase" marked
  • Move to Version tab
  • Click New and fill the dates for the whole year
  • Move to Operation. Click New and fill:
    • Search key=assa
    • Name=Assamble
    • Process=Assamble
    • Cost Center Use Time=10
  • Move to I/O Product
  • Click New and select the product A Final goods as P+
  • Click New twice and select the product A BOM and B BOM as P-
  • Quantities for each three 100

I/O Product の LOV に表示されない場合、Production をチェックを確認。 

• Additional data:
  • Process plan tab
    • Insert phases:Indicates if the work requirement phases will be generated automatically
  • Operation tab
    • Cost Center Use Time:Time used to do the operation once
    • Empty cells are Zero:When creating a production run (Work effort window), by running the "generating standards" process required input and output product quantities are automatically filled in as specified in the work requirement phases (Work requirement window)
    
    

Create a Process/Activit

4. Create a Process/Activity 

• Steps:
  • Login as userA
  • Go to Production management->Setup->Activity
  • Click New and fill the mandatory fields:
    • Name=Assamble
  • Select the cost centre

• Additional data: A process/activity is mandatory in order to create a process plan

Create Cost centre

3. Create Cost centre 

• Short description:

Create a cost centre to use for calculate costs based on the work effort

• Steps:
  • Login as userA
  • Go to Production management->Setup->Cost Center
  • Click New and fill the mandatory fields
  • Mark the check "Calculated"
  • Not mark "By default"

-

Move to Version tab, click New and fill

• "Valid from date" with the 1st of January of the current year
• Cost=100
• And select "per Produced Units" for Cost UOM

Additional data

• Tab Cost centre
  • If "Calculated" is marked but not "By default", when process the Work effort, OB will calculate the hours used for the sequence based on the initial time and final time
  • If "By default" is marked, OB will calculate the hours used for the sequence based on the process plan
  • If any is marked, OB will do nothing
• Tab Version
  • Per hour: Based on the cost centre unit that is in the tab Operation (Window process plan)
  • Per Kilogram: Based on the weight of product window. Produced units x Weight
  • Per percentage: This is only for Indirect cost purposes
  • Per Produced Units: Based on produced units

Installation and setup of Eclipse IDE

http://wiki.openbravo.com/wiki/Installation_and_setup_of_Eclipse_IDE

2.40 でが Buildの構成が以下のように設定されているが、

http://wiki.openbravo.com/wiki/Installation_and_setup_of_Eclipse_IDE#Compiling_and_building_Openbravo_ERP

2.50 以降では以下のファイルが自動作成されると書かれているが...

org.eclipse.wst.common.component 　

http://wiki.openbravo.com/wiki/ERP/2.50/ReleaseNotes

http://wiki.openbravo.com/wiki/Mercurial_Manual_for_Openbravo_Developers

http://wiki.openbravo.com/wiki/Projects/Modularity/Reference_Data

http://wiki.openbravo.com/wiki/ERP/2.50/ModularityVideos

ant create.database -Dapply.on.create=true

c_doctype,c_uom,c_currency,ad_impformat,ad_impformat_row,c_region,c_country

select count(*) from c_doctype ;

select count(*) from c_uom;

select count(*) from c_currency;

select count(*) from  ad_impformat;

select count(*) from  ad_impformat_row;

select count(*) from  c_region;

select count(*) from  c_country;

Create BOM production

2. Create BOM production 

• Short description: Create a bill of materials production

• Steps:
  • Login as userA
  • Go to Warehouse management->Transactions->Bill of materials production
  • Click New. Fill Name = BOM A. Save

• Move to Production Plan and click NEW
  
• Select Product "A BOM" and production quantity 100. Save
  

• Move back to BOM Production tab
  
• Click on Button "Create/Post Production"

Go to I/O products and verify:

• One line for product A BOM. Quantity = 100
• One line for product B Raw material. Quantity = -100
• One line for product C Raw material. Quantity = -100

• Select A BOM product
• Click on Attribute Set Value icon and fill the attributes. Save

不具合のため 

Fixes bug 8310 Valued stock report does not work in 240

Stock Report は表示できなかったが、SVN より 2.40 をダウンロードし、再Buildした後、このレポートのパッチを適用したところ　Date 指定の際に 19-05-2009 形式で表示されていた日付も修正された。

Openbravo.properties　には

bbdd.sessionConfig=ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD' NLS_NUMERIC_CHARACTERS='.,

Windows の Registory には NLS_LANG=Japanese_Jpana.JA16SJISTILDE
select sysdate from dual では　09-05-19