Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025337Openbravo ERPJ. Demo datapublic2013-12-16 08:512013-12-26 17:17
Sandrahuguet 
AtulOpenbravo 
normaltrivialhave not tried
closedfixed 
20Community Appliance
 
 
pramakrishnan
Core
No
0025337: Sample data (F&B client)monthly update: create transactions of December
Following the "How to evolve F&B" document instructions create the transactions of December 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
2013-12-16 08:51SandrahuguetNew Issue
2013-12-16 08:51SandrahuguetAssigned To => dmiguelez
2013-12-16 08:51SandrahuguetModules => Core
2013-12-16 08:51SandrahuguetTriggers an Emergency Pack => No
2013-12-17 06:52AtulOpenbravoStatusnew => scheduled
2013-12-17 06:52AtulOpenbravofix_in_branch => pi
2013-12-18 07:20AtulOpenbravoNote Added: 0062754
2013-12-19 09:06AtulOpenbravoNote Edited: 0062754bug_revision_view_page.php?bugnote_id=0062754#r5267
2013-12-19 11:44AtulOpenbravoAssigned Todmiguelez => AtulOpenbravo
2013-12-26 07:50hgbotCheckin
2013-12-26 07:50hgbotNote Added: 0063078
2013-12-26 07:50hgbotStatusscheduled => resolved
2013-12-26 07:50hgbotResolutionopen => fixed
2013-12-26 07:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/24a63ac4e92510140197f4d154ece7003dbab7a8 [^]
2013-12-26 07:50hgbotCheckin
2013-12-26 07:50hgbotNote Added: 0063079
2013-12-26 08:11pramakrishnanReview Assigned To => pramakrishnan
2013-12-26 08:11pramakrishnanNote Added: 0063080
2013-12-26 08:11pramakrishnanStatusresolved => closed
2013-12-26 17:17hudsonbotCheckin
2013-12-26 17:17hudsonbotNote Added: 0063084
2013-12-26 17:17hudsonbotCheckin
2013-12-26 17:17hudsonbotNote Added: 0063085

Notes
(0062754)
AtulOpenbravo   
2013-12-18 07:20   
(edited on: 2013-12-19 09:06)
Test plan:

1 ] Go to Purchase Order window, filter December 2013 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 December 2013 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-12-2013, 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-01-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. All payments due in the current month should be reflected.

6 ] Go to Financial Account and check there are a salaries g/l item in the transactions for the December 2013 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 December 2013. 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 December 2013 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 December 2013 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 December 2013 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 December 2013 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.

(0063078)
hgbot   
2013-12-26 07:50   
Repository: erp/devel/pi
Changeset: 24a63ac4e92510140197f4d154ece7003dbab7a8
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Dec 19 16:29:17 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/24a63ac4e92510140197f4d154ece7003dbab7a8 [^]

Fixes Issue 0025337: Sample data (F&B client) monthly update for December 2013

---
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/C_TAX.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
M referencedata/sampledata/F_B_International_Group/OBUIAPP_VIEW_ROLE_ACCESS.xml
---
(0063079)
hgbot   
2013-12-26 07:50   
Repository: erp/devel/pi
Changeset: 34e7bab6fb2128c77fde5574d31067840e29570a
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Thu Dec 26 12:10:37 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/34e7bab6fb2128c77fde5574d31067840e29570a [^]

Related to Issue 25337: Changed G/L Journal Description

---
M referencedata/sampledata/F_B_International_Group/GL_JOURNAL.xml
---
(0063080)
pramakrishnan   
2013-12-26 08:11   
Verified
(0063084)
hudsonbot   
2013-12-26 17:17   
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/34e7bab6fb21 [^]

Maturity status: Test
(0063085)
hudsonbot   
2013-12-26 17:17   
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/34e7bab6fb21 [^]

Maturity status: Test