Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037473
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] J. Demo dataminorhave not tried2017-12-13 18:552018-03-19 18:35
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version3.0PR18Q1
StatusclosedFix in branchFixed in SCM revision552c324c464b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037473: Sample data (F&B International Group Client) for 3.0PR18Q1

DescriptionFollowing 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.
Steps To Reproduce1) 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0101047)
AtulOpenbravo (developer)
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 (developer)
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 (developer)
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 (developer)
2017-12-19 13:00

Code Review + Testing Ok
(0101532)
hudsonbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2017-12-13 18:55 AtulOpenbravo New Issue
2017-12-13 18:55 AtulOpenbravo Assigned To => AtulOpenbravo
2017-12-13 18:55 AtulOpenbravo Modules => Core
2017-12-13 18:55 AtulOpenbravo Triggers an Emergency Pack => No
2017-12-13 18:55 AtulOpenbravo Issue generated from 0036880
2017-12-14 21:18 AtulOpenbravo Status new => scheduled
2017-12-14 22:46 AtulOpenbravo Note Added: 0101047
2017-12-14 22:47 AtulOpenbravo Note Edited: 0101047 View Revisions
2017-12-19 13:00 hgbot Checkin
2017-12-19 13:00 hgbot Note Added: 0101126
2017-12-19 13:00 hgbot Checkin
2017-12-19 13:00 hgbot Note Added: 0101127
2017-12-19 13:00 hgbot Status scheduled => resolved
2017-12-19 13:00 hgbot Resolution open => fixed
2017-12-19 13:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/552c324c464bf754d1100a5847df82856ced8cbc [^]
2017-12-19 13:00 dmiguelez Review Assigned To => dmiguelez
2017-12-19 13:00 dmiguelez Note Added: 0101128
2017-12-19 13:00 dmiguelez Status resolved => closed
2017-12-19 13:00 dmiguelez Fixed in Version => 3.0PR18Q1
2018-01-03 12:39 hudsonbot Checkin
2018-01-03 12:39 hudsonbot Note Added: 0101532
2018-01-03 12:39 hudsonbot Checkin
2018-01-03 12:39 hudsonbot Note Added: 0101533
2018-03-19 18:35 AtulOpenbravo Issue cloned 0038172


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker