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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040360
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] J. Demo datatrivialhave not tried2019-03-12 15:172019-06-15 08:16
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q2
StatusclosedFix in branchFixed in SCM revision1b79f74e4837
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040360: Sample data (F&B International Group Client) for 3.0PR19Q2

DescriptionFollowing the "How to evolve F&B" document instructions create the transactions of Jan., Feb. and Mar. 2019 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 ]
related to defect 0040304 closedAtulOpenbravo Delete records from FACT_ACCT and AD_PROCESS_REQUEST 

-  Notes
(0110486)
AtulOpenbravo (developer)
2019-03-19 05:32

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
(0110616)
hgbot (developer)
2019-03-25 10:05

Repository: erp/devel/pi
Changeset: dd59d9671933ffe0e26fe5a47603c939405fb64f
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Mar 18 20:47:35 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/dd59d9671933ffe0e26fe5a47603c939405fb64f [^]

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

Commit changes when running update database prior to inserting
transactions for 3.0PR19Q2

---
M referencedata/sampledata/F_B_International_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
M referencedata/sampledata/F_B_International_Group/C_ORDERLINE.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
M referencedata/sampledata/F_B_International_Group/M_PRODUCT.xml
M referencedata/sampledata/F_B_International_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0110617)
hgbot (developer)
2019-03-25 10:06

Repository: erp/devel/pi
Changeset: 1b79f74e48372d8e4cc0c153309d98383011a924
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Mar 19 10:29:25 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/1b79f74e48372d8e4cc0c153309d98383011a924 [^]

Fixes Issue 0040360: Sample data (F&B International Group Client)
for 3.0PR19Q2

Sample data (F&B International Group Client) for 3.0PR19Q2 for the
month of Jan, Feb and Mar 2019. Following the "How to evolve F&B"
document instructions transactions created for 3.0PR19Q2 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/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/C_PERIOD.xml
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL.xml
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL_LOG.xml
M referencedata/sampledata/F_B_International_Group/C_YEAR.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
---
(0110618)
Sandrahuguet (developer)
2019-03-25 10:18

verified
(0110887)
hudsonbot (developer)
2019-03-28 14:56

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/b2fbc1588df4 [^]
Maturity status: Test
(0110888)
hudsonbot (developer)
2019-03-28 14:56

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/b2fbc1588df4 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2019-03-12 15:17 AtulOpenbravo New Issue
2019-03-12 15:17 AtulOpenbravo Assigned To => AtulOpenbravo
2019-03-12 15:17 AtulOpenbravo Modules => Core
2019-03-12 15:17 AtulOpenbravo Triggers an Emergency Pack => No
2019-03-12 15:17 AtulOpenbravo Issue generated from 0039845
2019-03-12 15:44 Sandrahuguet Relationship added related to 0040304
2019-03-18 14:24 AtulOpenbravo Status new => scheduled
2019-03-19 05:32 AtulOpenbravo Note Added: 0110486
2019-03-25 10:05 hgbot Checkin
2019-03-25 10:05 hgbot Note Added: 0110616
2019-03-25 10:06 hgbot Checkin
2019-03-25 10:06 hgbot Note Added: 0110617
2019-03-25 10:06 hgbot Status scheduled => resolved
2019-03-25 10:06 hgbot Resolution open => fixed
2019-03-25 10:06 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1b79f74e48372d8e4cc0c153309d98383011a924 [^]
2019-03-25 10:18 Sandrahuguet Review Assigned To => Sandrahuguet
2019-03-25 10:18 Sandrahuguet Note Added: 0110618
2019-03-25 10:18 Sandrahuguet Status resolved => closed
2019-03-25 10:18 Sandrahuguet Fixed in Version => 3.0PR19Q2
2019-03-28 14:56 hudsonbot Checkin
2019-03-28 14:56 hudsonbot Note Added: 0110887
2019-03-28 14:56 hudsonbot Checkin
2019-03-28 14:56 hudsonbot Note Added: 0110888
2019-06-15 08:16 AtulOpenbravo Issue cloned 0041095


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker