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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0046144
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] J. Demo datatrivialhave not tried2021-03-24 20:092021-06-24 18:28
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in VersionPR21Q2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0046144: Sample data (F&B International Group Client) for 3.0PR21Q2

DescriptionFollowing the "How to evolve F&B" document instructions create the transactions of Jan., Feb. and Mar. 2021 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
(0126982)
AtulOpenbravo (developer)
2021-03-29 12:49

 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 Financial Account transaction check there are “Sueldos y Salarios” in F&B España, S.A. and “Salaries” in F&B US, Inc .
-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
(0126985)
hgbot (developer)
2021-03-29 15:11

 Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/339 [^]
(0127014)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 7540f86b0a46b33a75a65b9c23582f55ca889099
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T17:10:01+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/7540f86b0a46b33a75a65b9c23582f55ca889099 [^]

Related to BUG-0046144: Sample data (F&B International Group Client)
for 3.0PR21Q2

** Executed update.database and exported changes prior to creating
transactions as sample data for 3.0PR21Q2

---
M referencedata/sampledata/F_B_International_Group/AD_SEQUENCE.xml
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
---
(0127015)
hgbot (developer)
2021-03-30 09:29

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 99b2fd975375031dbed90a19b4896d3ae2a011cd
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T17:31:58+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/99b2fd975375031dbed90a19b4896d3ae2a011cd [^]

Fixes BUG-0046144:Sample data (F&B International Group Client)
for 3.0PR21Q2

Following the "How to evolve F&B" document instructions,
created transactions of Jan., Feb. and Mar. 2021 in both
organizations (US and Spain) for F&B International Group
Client.

---
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
---
(0127016)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 1dda3a26de0e26b0ea61f05522bdc6b406a0e151
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T17:50:34+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/1dda3a26de0e26b0ea61f05522bdc6b406a0e151 [^]

Related To BUG-0046144: Clean up fact_acct upto 31-12-2018

---
M referencedata/sampledata/F_B_International_Group/A_AMORTIZATION.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/FACT_ACCT.xml
M referencedata/sampledata/F_B_International_Group/FIN_FINACC_TRANSACTION.xml
M referencedata/sampledata/F_B_International_Group/GL_JOURNAL.xml
M referencedata/sampledata/F_B_International_Group/M_INOUT.xml
M referencedata/sampledata/F_B_International_Group/M_MATCHINV.xml
---
(0127017)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 6bfbfbe4a08f1f4e70101d747fe669acb8b9a1bc
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T17:51:27+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/6bfbfbe4a08f1f4e70101d747fe669acb8b9a1bc [^]

Related To BUG-0046144:Clean up Period Control and Period Control
log for period upto 2018 year

---
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL.xml
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL_LOG.xml
---
(0127018)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 336fc290a93d150b922a102753ada9b835bbec56
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T17:52:21+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/336fc290a93d150b922a102753ada9b835bbec56 [^]

Related To BUG-0046144: Truncated table M_Stock_Proposed

---
R referencedata/sampledata/F_B_International_Group/M_STOCK_PROPOSED.xml
---
(0127019)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: a561b02bcae903493c676a371ca4ec964cf9f531
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T18:07:49+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/a561b02bcae903493c676a371ca4ec964cf9f531 [^]

Related To BUG-0046144:Removed complete status process requests

---
M referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
---
(0127020)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 012e7b2a3e5fc6c3c4581320f9e9f0b422e828ed
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T19:01:27+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/012e7b2a3e5fc6c3c4581320f9e9f0b422e828ed [^]

Related To BUG-46144:

---
M referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.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/FACT_ACCT.xml
---
(0127021)
hgbot (developer)
2021-03-30 09:29

 Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 6b8be0b6c224f9051eacccd989c418d0e3b58337
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-03-29T21:17:54+05:30
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/6b8be0b6c224f9051eacccd989c418d0e3b58337 [^]

Related To BUG-0046144: Close year 2017, 2018, all periods
gets permanently closed, they could be re-open using undo
end year process in end year close window

---
M referencedata/sampledata/F_B_International_Group/AD_ORG_CLOSING.xml
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL.xml
---
(0127022)
hgbot (developer)
2021-03-30 09:29

 Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/339 [^]

- Issue History
Date Modified Username Field Change
2021-03-24 20:09 AtulOpenbravo New Issue
2021-03-24 20:09 AtulOpenbravo Assigned To => AtulOpenbravo
2021-03-24 20:09 AtulOpenbravo Modules => Core
2021-03-24 20:09 AtulOpenbravo Triggers an Emergency Pack => No
2021-03-24 20:09 AtulOpenbravo Issue generated from 0045534
2021-03-24 20:09 AtulOpenbravo Status new => scheduled
2021-03-29 12:49 AtulOpenbravo Note Added: 0126982
2021-03-29 15:11 hgbot Note Added: 0126985
2021-03-30 09:29 hgbot Note Added: 0127014
2021-03-30 09:29 hgbot Resolution open => fixed
2021-03-30 09:29 hgbot Status scheduled => closed
2021-03-30 09:29 hgbot Fixed in Version => PR21Q2
2021-03-30 09:29 hgbot Note Added: 0127015
2021-03-30 09:29 hgbot Note Added: 0127016
2021-03-30 09:29 hgbot Note Added: 0127017
2021-03-30 09:29 hgbot Note Added: 0127018
2021-03-30 09:29 hgbot Note Added: 0127019
2021-03-30 09:29 hgbot Note Added: 0127020
2021-03-30 09:29 hgbot Note Added: 0127021
2021-03-30 09:29 hgbot Note Added: 0127022
2021-06-24 18:28 AtulOpenbravo Issue cloned 0047248

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker