Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0047248Openbravo ERPJ. Demo datapublic2021-06-24 18:282021-06-25 18:51
AtulOpenbravo 
AtulOpenbravo 
normaltrivialhave not tried
closedfixed 
5
 
PR21Q3 
Core
No
0047248: Sample data (F&B International Group Client) for 3.0PR21Q3
Following the "How to evolve F&B" document instructions create the transactions of Apr., May. and Jun. 2021 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.
related to defect 0049871 closed aferraz Conversion Rate for months starting july is missing 
Issue History
2021-06-24 18:28AtulOpenbravoNew Issue
2021-06-24 18:28AtulOpenbravoAssigned To => AtulOpenbravo
2021-06-24 18:28AtulOpenbravoModules => Core
2021-06-24 18:28AtulOpenbravoTriggers an Emergency Pack => No
2021-06-24 18:28AtulOpenbravoIssue generated from0046144
2021-06-24 19:01AtulOpenbravoStatusnew => scheduled
2021-06-25 07:02AtulOpenbravoNote Added: 0129787
2021-06-25 08:05hgbotNote Added: 0129788
2021-06-25 18:51hgbotNote Added: 0129801
2021-06-25 18:51hgbotResolutionopen => fixed
2021-06-25 18:51hgbotStatusscheduled => closed
2021-06-25 18:51hgbotFixed in Version => PR21Q3
2021-06-25 18:51hgbotNote Added: 0129802
2021-06-25 18:51hgbotNote Added: 0129803
2022-07-22 17:31jarmendarizRelationship addedrelated to 0049871

Notes
(0129787)
AtulOpenbravo   
2021-06-25 07:02   
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
(0129788)
hgbot   
2021-06-25 08:05   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/409 [^]
(0129801)
hgbot   
2021-06-25 18:51   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: c5cf9e9057890aa1dae08233964017d3281130c6
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-06-25T16:47:46+00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/c5cf9e9057890aa1dae08233964017d3281130c6 [^]

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

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

---
M referencedata/sampledata/F_B_International_Group/AD_ORG.xml
M referencedata/sampledata/F_B_International_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
---
(0129802)
hgbot   
2021-06-25 18:51   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: ceca9de7d350ebdd7b8a6a7914a89d782cb24697
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2021-06-25T16:47:46+00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/ceca9de7d350ebdd7b8a6a7914a89d782cb24697 [^]

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

Following the "How to evolve F&B" document instructions,
created transactions of Apr., May. and June. 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/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
---
(0129803)
hgbot   
2021-06-25 18:51   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/409 [^]