Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0043518Openbravo ERPJ. Demo datapublic2020-03-17 18:132020-06-23 15:55
AtulOpenbravo 
AtulOpenbravo 
normaltrivialhave not tried
closedfixed 
5
 
3.0PR20Q2 
vmromanos
Core
No
0043518: Sample data (F&B International Group Client) for 3.0PR20Q2
Following the "How to evolve F&B" document instructions create the transactions of Jan., Feb. and Mar. 2020 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.
Issue History
2020-03-17 18:13AtulOpenbravoNew Issue
2020-03-17 18:13AtulOpenbravoAssigned To => AtulOpenbravo
2020-03-17 18:13AtulOpenbravoModules => Core
2020-03-17 18:13AtulOpenbravoTriggers an Emergency Pack => No
2020-03-17 18:13AtulOpenbravoIssue generated from0042605
2020-03-17 18:14AtulOpenbravoStatusnew => scheduled
2020-03-18 17:18AtulOpenbravoNote Added: 0118681
2020-03-20 14:58hgbotCheckin
2020-03-20 14:58hgbotNote Added: 0118717
2020-03-20 14:58hgbotCheckin
2020-03-20 14:58hgbotNote Added: 0118718
2020-03-20 14:58hgbotStatusscheduled => resolved
2020-03-20 14:58hgbotResolutionopen => fixed
2020-03-20 14:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/237c1004f93e047fa36d179d84b75c9b40d90456 [^]
2020-03-20 14:59vmromanosReview Assigned To => vmromanos
2020-03-20 14:59vmromanosNote Added: 0118719
2020-03-20 14:59vmromanosStatusresolved => closed
2020-03-20 14:59vmromanosFixed in Version => 3.0PR20Q2
2020-04-06 11:53hgbotCheckin
2020-04-06 11:53hgbotNote Added: 0118974
2020-04-06 11:54hgbotCheckin
2020-04-06 11:54hgbotNote Added: 0118975
2020-04-06 11:54hgbotStatusclosed => resolved
2020-04-06 11:54hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/237c1004f93e047fa36d179d84b75c9b40d90456 [^] => http://code.openbravo.com/erp/devel/pi/rev/336f87c612bb9ec6ef201cb8332ac2c32957fe6c [^]
2020-04-06 15:52cbernerNote Added: 0119000
2020-04-06 15:52cbernerStatusresolved => closed
2020-06-23 15:55AtulOpenbravoIssue cloned0044459

Notes
(0118681)
AtulOpenbravo   
2020-03-18 17:18   
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 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
(0118717)
hgbot   
2020-03-20 14:58   
Repository: erp/devel/pi
Changeset: 935c5eb5636055405808e682ac4cccb4db48b29d
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Mar 17 23:00:42 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/935c5eb5636055405808e682ac4cccb4db48b29d [^]

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

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

---
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
---
(0118718)
hgbot   
2020-03-20 14:58   
Repository: erp/devel/pi
Changeset: 237c1004f93e047fa36d179d84b75c9b40d90456
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Mar 18 21:52:14 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/237c1004f93e047fa36d179d84b75c9b40d90456 [^]

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

Following the "How to evolve F&B" document instructions,
created transactions of Jan., Feb. and Mar. 2020 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
---
(0118719)
vmromanos   
2020-03-20 14:59   
Code review & testing OK
(0118974)
hgbot   
2020-04-06 11:53   
Repository: erp/devel/pi
Changeset: dc30dc22cb7d54cf36217f208c66f167f234912d
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Mar 17 23:00:42 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/dc30dc22cb7d54cf36217f208c66f167f234912d [^]

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

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

---
M referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
---
(0118975)
hgbot   
2020-04-06 11:54   
Repository: erp/devel/pi
Changeset: 336f87c612bb9ec6ef201cb8332ac2c32957fe6c
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Mar 18 21:52:14 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/336f87c612bb9ec6ef201cb8332ac2c32957fe6c [^]

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

Following the "How to evolve F&B" document instructions,
created transactions of Jan., Feb. and Mar. 2020 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
---
(0119000)
cberner   
2020-04-06 15:52   
closed: wrongly reopened