Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025509Openbravo ERPJ. Demo datapublic2014-01-20 09:072014-02-12 18:29
Sandrahuguet 
gauravdeshmukh 
normalminorhave not tried
closedfixed 
20Community Appliance
 
 
pramakrishnan
Core
No
0025509: Sample data (F&B client)monthly update: create transactions of January
Following the "How to evolve F&B" document instructions create the transactions of January in both organizations (US and Spain) for F&B client.
1) In a clean instance, execute
ant create.database -Dapply.on.create=true
or ant install.source
2) Create new transactions
3) Verify the inserted data
4) ant export.sample.data
No tags attached.
Issue History
2014-01-20 09:07SandrahuguetNew Issue
2014-01-20 09:07SandrahuguetAssigned To => AtulOpenbravo
2014-01-20 09:07SandrahuguetModules => Core
2014-01-20 09:07SandrahuguetTriggers an Emergency Pack => No
2014-01-23 12:50gauravdeshmukhAssigned ToAtulOpenbravo => gauravdeshmukh
2014-01-23 12:51gauravdeshmukhStatusnew => scheduled
2014-01-27 07:39gauravdeshmukhReview Assigned To => pramakrishnan
2014-01-27 07:39gauravdeshmukhNote Added: 0063688
2014-01-27 11:37hgbotCheckin
2014-01-27 11:37hgbotNote Added: 0063714
2014-01-27 11:37hgbotStatusscheduled => resolved
2014-01-27 11:37hgbotResolutionopen => fixed
2014-01-27 11:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d7ed2de7ac4a003906f217b544f42b61f408dfba [^]
2014-01-27 11:39pramakrishnanNote Added: 0063715
2014-01-27 11:39pramakrishnanStatusresolved => closed
2014-02-12 18:29hudsonbotCheckin
2014-02-12 18:29hudsonbotNote Added: 0064118

Notes
(0063688)
gauravdeshmukh   
2014-01-27 07:39   
1 ] Go to Purchase Order window, filter January 2014 records, check the following 2 records for F&B US, Inc East Coast, 1 record for F&B US, Inc West Coast, 2 records for F&B España - Región Norte, 1 record for F&B España - Región Sur.

2 ] Go to Good Receipt window, filter January 2014 records,check the following.
    2 records for F&B US, Inc East Coast, 1 record for F&B US, Inc West Coast, 2 records for F&B España - Región Norte, 1 record for F&B España - Región Sur.

3 ] Go to Purchase Invoice window, filter records for 31-01-2014, check the following. 2 records for F&B US, Inc East Coast, 1 record for F&B US, Inc West Coast, 2 records for F&B España - Región Norte, 1 record for F&B España - Región Sur.

4 ] Go to Purchase Invoice window, filter with date 03-02-2014, check the following.4 records in purchase invoice of servcies for F&B US, Inc., 4 records in purchase invoice of services for F&B España, S.A.

5 ] Go to payment out and check the suppliers payments for December 2013.
Records against the Purchase Invoice for the goods purchased, Records against the Purchase Invoice for the services. 7 entries for F&B US. Inc. [4 entries of services invoice and 3 for normal invoice] And 7 entries for F&B España. S.A. [4 entries of services invoice and 3 for normal invoice]

6 ] Go to Financial Account and check there are a salaries g/l item in the transactions for the January 2014 Month.1 record under financial account 'Cuenta de Banco' for F&B España, S.A, 1 record under financial account 'Bank Account 1' for F&B US, Inc.

7 ] Go to G/L Journal Batch >> Filter record for January 2014. 1 record for F&B US, Inc. Under this record check 15 records in G/L Journal Lines.

8 ] Go to Sales Order window, filter January 2014 records. Check the following.
   2 records for F&B US East Coast, 1 record for F&B US West Coast, 2 records for F&B España - Región Norte, 1 record for F&B España - Región Sur.

9 ] Go to Goods Shipment window, filter January 2014 records. Check the following.2 records for F&B US East Coast, 1 record for F&B US West Coast, 2 records for F&B España - Región Norte, 1 record for F&B España - Región Sur.

10 ] Go to Sales Invoice window, filter January 2014 records. Check there are 2 records for F&B US East Coast, 1 record for F&B US West Coast, 2 records for F&B España - Región Norte and 1 record for F&B España - Región Sur.

11 ] Go to Sales Invoice, apply filter <0 in 'Days Till Next Due' column. Notice that the applied filter results in 0 records.

12 ] Go to Financial Account 'Bank Account 1' and 'Cuenta de Banco'. Check that there is single record for January 2014 in the Imported Bank Statements for each financial account mentioned and check the reconciliation for F&B España, S.A. and F&B US, Inc.
(0063714)
hgbot   
2014-01-27 11:37   
Repository: erp/devel/pi
Changeset: d7ed2de7ac4a003906f217b544f42b61f408dfba
Author: Gaurav Deshmukh <gaurav.deshmukh <at> openbravo.com>
Date: Fri Jan 24 20:55:49 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d7ed2de7ac4a003906f217b544f42b61f408dfba [^]

Fixes Issue 25509:Sample data (F&B client)monthly update create transactions of January 2014

---
M referencedata/sampledata/F_B_International_Group/AD_ORGINFO.xml
M referencedata/sampledata/F_B_International_Group/AD_PINSTANCE.xml
M referencedata/sampledata/F_B_International_Group/AD_PINSTANCE_PARA.xml
M referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/F_B_International_Group/AD_SEQUENCE.xml
M referencedata/sampledata/F_B_International_Group/AD_USER.xml
M referencedata/sampledata/F_B_International_Group/A_AMORTIZATION.xml
M referencedata/sampledata/F_B_International_Group/A_ASSET.xml
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
M referencedata/sampledata/F_B_International_Group/C_INVOICE.xml
M referencedata/sampledata/F_B_International_Group/C_INVOICELINE.xml
M referencedata/sampledata/F_B_International_Group/C_INVOICELINETAX.xml
M referencedata/sampledata/F_B_International_Group/C_INVOICETAX.xml
M referencedata/sampledata/F_B_International_Group/C_ORDER.xml
M referencedata/sampledata/F_B_International_Group/C_ORDERLINE.xml
M referencedata/sampledata/F_B_International_Group/C_ORDERLINETAX.xml
M referencedata/sampledata/F_B_International_Group/C_ORDERTAX.xml
M referencedata/sampledata/F_B_International_Group/C_ORDER_DISCOUNT.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
M referencedata/sampledata/F_B_International_Group/FIN_BANKSTATEMENT.xml
M referencedata/sampledata/F_B_International_Group/FIN_BANKSTATEMENTLINE.xml
M referencedata/sampledata/F_B_International_Group/FIN_FINACC_TRANSACTION.xml
M referencedata/sampledata/F_B_International_Group/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/F_B_International_Group/FIN_PAYMENT.xml
M referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_DETAIL.xml
M referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_PROPOSAL.xml
M referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_PROP_DETAIL.xml
M referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_SCHEDULE.xml
M referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml
M referencedata/sampledata/F_B_International_Group/FIN_RECONCILIATION.xml
M referencedata/sampledata/F_B_International_Group/GL_JOURNAL.xml
M referencedata/sampledata/F_B_International_Group/GL_JOURNALBATCH.xml
M referencedata/sampledata/F_B_International_Group/GL_JOURNALLINE.xml
M referencedata/sampledata/F_B_International_Group/M_COSTING.xml
M referencedata/sampledata/F_B_International_Group/M_INOUT.xml
M referencedata/sampledata/F_B_International_Group/M_INOUTLINE.xml
M referencedata/sampledata/F_B_International_Group/M_MATCHINV.xml
M referencedata/sampledata/F_B_International_Group/M_MATCHPO.xml
M referencedata/sampledata/F_B_International_Group/M_STORAGE_DETAIL.xml
M referencedata/sampledata/F_B_International_Group/M_STORAGE_PENDING.xml
M referencedata/sampledata/F_B_International_Group/M_TRANSACTION.xml
M referencedata/sampledata/F_B_International_Group/M_TRANSACTION_COST.xml
---
(0063715)
pramakrishnan   
2014-01-27 11:39   
Code Review + Testing - OK.
(0064118)
hudsonbot   
2014-02-12 18:29   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d1a5bb862230 [^]
Maturity status: Test