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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0030787
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] J. Demo dataminorhave not tried2015-09-08 09:082015-09-18 05:08
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione0699a68c178
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0030787: Sample data (F&B International Group Client) for PR15Q4

DescriptionFollowing the "How to evolve F&B" document instructions create the transactions of July, August and Sept 2015 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) Truncate tables that appear in the Log Clean Up process. Keep process request scheduled. Commit the changes
4) Delete row from fact_acct table. Keep two years of accounting. Commit the changes.
5) Create new transactions
6) Verify the inserted data
4) ant export.sample.data -Dclient="F&B International Group" -Dmodule=org.openbravo.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0080457)
vmromanos (manager)
2015-09-17 16:11

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
(0080458)
hgbot (developer)
2015-09-17 16:13

Repository: erp/devel/pi
Changeset: 771d9ae99aa2c58a7d600970338d4491ebc2eccc
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Sep 09 09:50:06 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/771d9ae99aa2c58a7d600970338d4491ebc2eccc [^]

Related to issue 30787:Export module scripts changes of sample data

The changes made in the ant update.database command has been
exported from the sample data and commited.

---
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_TAXCATEGORY.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
M referencedata/sampledata/F_B_International_Group/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/F_B_International_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0080459)
hgbot (developer)
2015-09-17 16:13

Repository: erp/devel/pi
Changeset: e0699a68c178614359eaa83b0b05cdc3cea1cd0f
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Sep 14 12:27:25 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e0699a68c178614359eaa83b0b05cdc3cea1cd0f [^]

Fixed issue 30787: Sample data (F&B International Group Client) for 3.0PR15Q4

Updated sample data for 3.0PR15Q4

---
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_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_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
---
(0080460)
vmromanos (manager)
2015-09-17 16:14

Reviewed
(0080477)
hudsonbot (developer)
2015-09-18 05:08

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/68dbc59de475 [^]
Maturity status: Test
(0080478)
hudsonbot (developer)
2015-09-18 05:08

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

- Issue History
Date Modified Username Field Change
2015-09-08 09:08 AtulOpenbravo New Issue
2015-09-08 09:08 AtulOpenbravo Assigned To => AtulOpenbravo
2015-09-08 09:08 AtulOpenbravo Modules => Core
2015-09-08 09:08 AtulOpenbravo Triggers an Emergency Pack => No
2015-09-10 05:50 AtulOpenbravo Status new => scheduled
2015-09-17 16:11 vmromanos Note Added: 0080457
2015-09-17 16:13 hgbot Checkin
2015-09-17 16:13 hgbot Note Added: 0080458
2015-09-17 16:13 hgbot Checkin
2015-09-17 16:13 hgbot Note Added: 0080459
2015-09-17 16:13 hgbot Status scheduled => resolved
2015-09-17 16:13 hgbot Resolution open => fixed
2015-09-17 16:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0699a68c178614359eaa83b0b05cdc3cea1cd0f [^]
2015-09-17 16:14 vmromanos Review Assigned To => vmromanos
2015-09-17 16:14 vmromanos Note Added: 0080460
2015-09-17 16:14 vmromanos Status resolved => closed
2015-09-18 05:08 hudsonbot Checkin
2015-09-18 05:08 hudsonbot Note Added: 0080477
2015-09-18 05:08 hudsonbot Checkin
2015-09-18 05:08 hudsonbot Note Added: 0080478


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker