Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0037473Openbravo ERPJ. Demo datapublic2017-12-13 18:552018-03-19 18:35
AtulOpenbravo 
AtulOpenbravo 
normalminorhave not tried
closedfixed 
5
 
3.0PR18Q1 
dmiguelez
Core
No
0037473: Sample data (F&B International Group Client) for 3.0PR18Q1
Following the "How to evolve F&B" document instructions create the transactions of Oct., Nov. and Dec. 2017 in both organizations (US and Spain) for F&B International Group Client.
1) In a clean instance with no modules, execute:
ant install.source
2) Execute ant update.database and execute ant export.sample.data -Dclient="F&B International Group" -Dmodule=org.openbravo. Commit the changes.
3) Create new transactions
4) Verify the inserted data
5) ant export.sample.data -Dclient="F&B International Group" -Dmodule=org.openbravo
No tags attached.
Issue History
2017-12-13 18:55AtulOpenbravoNew Issue
2017-12-13 18:55AtulOpenbravoAssigned To => AtulOpenbravo
2017-12-13 18:55AtulOpenbravoModules => Core
2017-12-13 18:55AtulOpenbravoTriggers an Emergency Pack => No
2017-12-13 18:55AtulOpenbravoIssue generated from0036880
2017-12-14 21:18AtulOpenbravoStatusnew => scheduled
2017-12-14 22:46AtulOpenbravoNote Added: 0101047
2017-12-14 22:47AtulOpenbravoNote Edited: 0101047bug_revision_view_page.php?bugnote_id=0101047#r16459
2017-12-19 13:00hgbotCheckin
2017-12-19 13:00hgbotNote Added: 0101126
2017-12-19 13:00hgbotCheckin
2017-12-19 13:00hgbotNote Added: 0101127
2017-12-19 13:00hgbotStatusscheduled => resolved
2017-12-19 13:00hgbotResolutionopen => fixed
2017-12-19 13:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/552c324c464bf754d1100a5847df82856ced8cbc [^]
2017-12-19 13:00dmiguelezReview Assigned To => dmiguelez
2017-12-19 13:00dmiguelezNote Added: 0101128
2017-12-19 13:00dmiguelezStatusresolved => closed
2017-12-19 13:00dmiguelezFixed in Version => 3.0PR18Q1
2018-01-03 12:39hudsonbotCheckin
2018-01-03 12:39hudsonbotNote Added: 0101532
2018-01-03 12:39hudsonbotCheckin
2018-01-03 12:39hudsonbotNote Added: 0101533
2018-03-19 18:35AtulOpenbravoIssue cloned0038172

Notes
(0101047)
AtulOpenbravo   
2017-12-14 22:46   
(edited on: 2017-12-14 22:47)
Test plan:

-Go to purchase order, filtered by the quarter records, check there are 6 purchase order F&B US East Coast (3 for Fruit & Bio, and 3 for Happy Drinks) and 3 purchase orders to F&B US West Coast.
-Go to good receipt, filtered by the quarter records, check there are 6 good receipt F&B US East Coast (3 for Fruit & Bio, and 3 for Happy Drinks) and 3 good receipt to F&B US West Coast.
-Go to purchase invoice, filter by the quarter, check there are 6 purchase invoice F&B US East Coast and 3 purchase invoice to F&B US West Coast.
-Go to purchase invoice, filter by the quarter records, check there are 12 service purchase invoice F&B US, Inc and 12 service purchase invoice to F&B España, S.A.
-Go to payment out and check the suppliers payments
-Go to payment out and check there are a salaries g/l item to F&B España, S.A. and F&B US, Inc ← Only if you have entered a payment, otherwise look at the Financial Account transaction for the G/L Item “Sueldos y Salarios” or “Salaries”.
-Go to g/l journal and check the lines
-Go to sales order filter by the quarter records check there are 6 F&B US East Coast (3 for Sleep and 3 for Healthy), 3 F&B US West Coast, 6 F&B España - Región Norte (3 for Alimentos and 3 for Hoteles) and 3 F&B España - Región Sur.
-Go to goods shipment filter by quarter records check there are 6 F&B US East Coast (3 for Sleep and 3 for Healthy), 3 F&B US West Coast, 6 F&B España - Región Norte (3 for Alimentos and 3 for Hoteles) and 3 F&B España - Región Sur.
-Go to sales invoice filtered by quarter records check there are 6 F&B US East Coast (3 for Sleep and 3 for Healthy), 3 F&B US West Coast, 6 F&B España - Región Norte (3 for Alimentos and 3 for Hoteles) and 3 F&B España - Región Sur.
-Go to sales invoice, filtered <0 in days till next due. Notice that the applied filter resulted 0 records.
-Go to financial account check that there is 1 imported bank statements per quarter and check the reconciliation, to F&B España, S.A. in Cuenta de Banco and F&B US, Inc in Bank Account 1
- In Open/Close Period Control window check that periods are open for next 2 years.
- In Currency Conversion, check that conversion from USD to EUR and from EUR to USD is available for next 3 months.
- In Amortization window, check that record with date 31-12-2017 are processed.

(0101126)
hgbot   
2017-12-19 13:00   
Repository: erp/devel/pi
Changeset: 4ba9b3e34059f72551a16124720e7321beea1698
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Dec 14 23:34:53 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4ba9b3e34059f72551a16124720e7321beea1698 [^]

Related To Issue 37473:Sample data (F&B International Group Client) for 3.0PR18Q1

Export changes prior to transactional sample data creation

---
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
---
(0101127)
hgbot   
2017-12-19 13:00   
Repository: erp/devel/pi
Changeset: 552c324c464bf754d1100a5847df82856ced8cbc
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Dec 15 03:23:36 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/552c324c464bf754d1100a5847df82856ced8cbc [^]

Fixes Issue 37473: Sample data (F&B International Group Client) for 3.0PR18Q1

Sample data (F&B International Group Client) for 3.0PR18Q1 for the month of Oct., Nov.
and Dec. 2017. Following the "How to evolve F&B" document instructions transactions
created for 3.0PR18Q1 release.

---
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_CONVERSION_RATE.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_ATTRIBUTESETINSTANCE.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
---
(0101128)
dmiguelez   
2017-12-19 13:00   
Code Review + Testing Ok
(0101532)
hudsonbot   
2018-01-03 12:39   
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/c81e0d3cbab5 [^]
Maturity status: Test
(0101533)
hudsonbot   
2018-01-03 12:39   
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/c81e0d3cbab5 [^]
Maturity status: Test