Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0046144Openbravo ERPJ. Demo datapublic2021-03-24 20:092021-06-24 18:28
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR21Q2 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0046144: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-03-24 20:09AtulOpenbravoNew Issue
2021-03-24 20:09AtulOpenbravoAssigned To => AtulOpenbravo
2021-03-24 20:09AtulOpenbravoOBNetwork customer => No
2021-03-24 20:09AtulOpenbravoModules => Core
2021-03-24 20:09AtulOpenbravoTriggers an Emergency Pack => No
2021-03-24 20:09AtulOpenbravoIssue generated from0045534
2021-03-24 20:09AtulOpenbravoStatusnew => scheduled
2021-03-29 12:49AtulOpenbravoNote Added: 0126982
2021-03-29 15:11hgbotMerge Request Status => open
2021-03-29 15:11hgbotNote Added: 0126985
2021-03-30 09:29hgbotMerge Request Statusopen => approved
2021-03-30 09:29hgbotNote Added: 0127014
2021-03-30 09:29hgbotResolutionopen => fixed
2021-03-30 09:29hgbotStatusscheduled => closed
2021-03-30 09:29hgbotFixed in Version => PR21Q2
2021-03-30 09:29hgbotNote Added: 0127015
2021-03-30 09:29hgbotNote Added: 0127016
2021-03-30 09:29hgbotNote Added: 0127017
2021-03-30 09:29hgbotNote Added: 0127018
2021-03-30 09:29hgbotNote Added: 0127019
2021-03-30 09:29hgbotNote Added: 0127020
2021-03-30 09:29hgbotNote Added: 0127021
2021-03-30 09:29hgbotNote Added: 0127022
2021-06-24 18:28AtulOpenbravoIssue cloned0047248

Notes
(0126982)
AtulOpenbravo   
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   
2021-03-29 15:11   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/339 [^]
(0127014)
hgbot   
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   
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   
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   
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   
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   
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   
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   
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   
2021-03-30 09:29   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/339 [^]