QA test plan 2.50/Multi Currency Reports

Contents 1 Test cases 1.1 Previous data 1.2 Procurement Management 1.3 Warehouse Management 1.4 Production Management 1.5 Sales Management 1.6 Project & Service Management

Test cases

The structure for the test cases is:

• Short description
• Steps
• Issues to verify

Previous data

 1.Create a currency conversion

• Short Description: Create the conversion rate for currency

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to General Setup->Application->Currency
  • Create a conversion from EUR to USD
  • Move to Conversion Rates tab and Fill:
    • Currency: Euro
    • To Currency: USD
    • Valid from Date: 01-01-2000
    • Valid to Date: 01-01-2010
    • Multiple Rate by: 2

• Issues to verify: User's accounting schema currency must appear selected by default.

Procurement Management

Previous data

Using the sample data that comes with OpenbravoERP create a purchase order with the following values:

• Vendor: Turtle Logistics
• Product: Beer
• Quantity: 1
• Price actual: 2. This will make easier to verify issues
• Status of the order: Complete

Then create a shipment and invoice based on this purchase

1.Purchase Dimensional Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Procurement Management->Analysis Tools-> Purchase Dimensional Report
  • Fill the mandatory fields

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • A drop-down list displaying all currency ISO codes
  • Select "USD" in the Currency drop down list
  • Click on HTML Format and PDF and verify the currency are shown as chosen
  • The symbol of the chosen currency must be displayed on the right side of the amount
  • Amounts in Euros 2€ but in dollars 4$

2.Material Receipts Dimensional Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Procurement Management->Analysis Tools-> Material Receipts Dimensional Report
  • Fill the mandatory fields

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • User's accounting schema currency must appear selected by default.
  • Select "USD" in the Currency drop down list
  • Click on HTML Format and PDF and verify the currencies are shown as chosen
  • The symbol of the chosen currency must be displayed on the right side of the amount
  • Amounts in Euros 2€ but in dollars 4$

3.Purchase Invoice Dimensional Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Procurement Management->Analysis Tools-> Purchase Invoice Dimensional Report
  • Fill the mandatory fields
  • Select "USD" in the Currency drop down list
  • Click on HTML Format and PDF and verify the currencies are shown as chosen

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • User's accounting schema currency must appear selected by default
  • The symbol '$' must be displayed on the right side of the amount
  • Amounts in Euros 2€ but in dollars 4$

4.Purchase Order Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Procurement Management->Analysis Tools-> Purchase Order Report
  • A pop-up window must show up
  • Select "USD" in the Currency drop down list
  • Select the proper dates and click OK
  • Do the test for HTML, PDF and Excel formats

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • User's accounting schema currency must appear selected by default
  • The Price and Amount are displayed in the report with the chosen currency (EUR-E)
  • Amounts in Euros 2€ but in dollars 4$

5.Vendor Invoice Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Procurement Management->Analysis Tools-> Vendor Invoice Report
  • Select "USD" in the Currency drop down list
  • Click on HTML Format, PDF and verify the currency are shown as chosen

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • User's accounting schema currency must appear selected by default
  • Amounts in Euros 2€ but in dollars 4$

Warehouse Management

1.Shipper Report

• User cases
  • Procurement: The warehouse manager receives the goods but the shipper is going to charge for that. So in the header of the Goods receipt he has to register the shipper and the freight type cost
  • Sales: The warehouse manager is going to send some goods and the shipper is going to charge him for that. So he has to register the shipper and the freight type cost

• Previous data
  • You need a shipper. To get that you need to go to Setup->Shipping company. To be able to calculate the freights you need to have well configure the conditions for that shipper. The location conditions must be the same as the locations from to of the warehouse and provider/customer
  • Procurement
    • The freight cost is calculated depending on the location of the warehouse and in the location of the vendor or provider
  • Sales
    • The freight cost is calculated depending on the location of the warehouse and in the location of the customer

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Warehouse Management->Analysis Tools-> Shipper Report
  • Fill the mandatory fields and click HTML format

• Issues to verify:
  • User's accounting schema currency must appear selected by default
  • All currency ISO codes must be displayed in drop down list

2.Valued Stock Report

• Previous data: Assuming that sample data comes with the ERP:
  • Product Grand Beer: Cost type= Average
  • It is a must to have entries into the warehouse based on a purchase order/s
  • Launch the Average cost process. To do that Go to Warehouse management->Transactions->Generate average cost

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Warehouse Management->Analysis Tools-> Valued Stock Report
  • Fill the mandatory fields and click HTML Format. Products should be shown
  • Select USD as currency

• Issues to verify:
  • A drop-down list displaying all currency ISO codes
  • The drop down list 'Currency' is mandatory and cannot be blank
  • Verify that the results are the same as with Euros but with the corresponding conversion rate

3.Invoice Consignment Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Warehouse Management->Analysis Tools-> Invoice Consignment Report
  • Fill the mandatory fields

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • User's accounting schema currency must appear selected by default.
  • Select "USD" in the Currency drop down list
  • If there is sample data, click on PDF Format and verify the currencies are shown as chosen
  • The symbol of the chosen currency must be displayed on the right side of the amount

4.Pareto Product Report

• Previous data: Assuming that sample data comes with the ERP:
  • Product Grand Beer: Cost type= Average
  • It is a must to have entries into the warehouse based on a purchase order/s
  • Launch the Average cost process. To do that Go to Warehouse management->Transactions->Generate average cost

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Warehouse Management->Analysis Tools-> Pareto Product Report
  • Select the filter and fill the mandatory field and click HTML Format.

• Issues to verify:
  • The currency drop down list is mandatory and cannot be blank
  • User's accounting schema currency must appear selected by default.
  • Select "USD" in the Currency drop down list
  • If there is sample data, verify the currencies are shown as chosen

Production Management

1.Standard Costs Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Production Management->Analysis Tools-> Standard Costs Report
  • Select the filter and fill the mandatory field and click HTML Format.

• Issues to verify:
  • User's accounting schema currency must appear selected by default.
  • The currency drop down list is mandatory and cannot be blank
  • Select "USD" in the Currency drop down list
  • If there is sample data, click on HTML Format and verify the currencies are shown as chosen

2.Production Cost Report

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Production Management->Analysis Tools-> Production Cost Report
  • Fill the Years, the dates and the rest of the mandatory fields

• Issues to verify:
  • User's accounting schema currency must appear selected by default.
  • The currency drop down list is mandatory and cannot be blank
  • If there is sample data, click on HTML Format and verify the chosen currencies are shown

Sales Management

Previous data

Using the sample data that comes with OpenbravoERP create a sales order with the following values:

• Organization: A
• Vendor: Mafalda Corporation
• Product: Hat
• Quantity: 1
• Price actual: 2. This will make easier to verify issues (Conversion EUR-USD)
• Status of the order: Complete

Then create a shipment and invoice based on this purchase

And again create another sales order but only create a shipment based on this sales order

1.Sales Dimensional Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Sales Dimensional Report
  • Fill:
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
    • Organization: A
    • Business Partner Group: Customers
    • Dimensions: Business partners and Product
  • Click on HTML and PDF Format and verify the Amounts in EUR is 4 and 8 in USD

• Issues to verify:
  • The symbol '$' must be displayed on the right side of the Amount
  • The currency drop down list is mandatory and cannot be blank
  • The 'Amount' column header must be displayed with "(EUR-E)" the default currency
  • The 'Amount' column header must be displayed with "(USD-$)"

2.Shipments Dimensional Report

• Steps:
  • • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
    • Organization: A
    • Business Partner Group: Customers
    • Currency: EUR and then with USD to check the conversion is working
  • Click on HTML and PDF Format and verify the Amounts in EUR is 4 and 8 in USD

• Issues to verify:
  • The symbol 'E' must be displayed on the right side of the Amount
  • The 'Amount' column header must be displayed with "(EUR-E)" the default currency
  • The 'Amount' column header must be displayed with "(USD-$)"

3.Discount Invoice Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Discount Invoice Report
  • Fill the fields and select the Currency as "USD"
    • From Date: 01-01-2000
    • To Date: 01-12-2010
  • Click on HTML Format. Invoice Report should be shown

• Issues to verify:
  • The symbol '$' must be displayed on the right side of the Price and Amount
  • User's accounting schema currency must appear selected by default
  • All currency ISO codes must be displayed in drop down list

4.Sales Order Returns Dimensional Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Sales Order Returns Dimensional Report
  • Fill the fields:
    • From Date: 01-01-2000
    • To Date: 01-12-2010
    • Currency: USD
    • Organisation: Main
    • Product Group: Food
  • Click on PDF Format. Sales Orders Report should be shown

• Issues to verify:
  • User's accounting schema currency must appear selected by default
  • All currency ISO codes must be displayed in drop down list
  • Verify the chosen currency (USD-$)are displayed in the PDF report

5.Sales Order Report

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Sales Management->Analysis Tools-> Sales Order Report Report
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
    • Warehouse: Main Warehouse
  • Click on HTML Format. Sales Order Report should be shown with Total 4 EUR and 8 in USD

• Issues to verify:
  • User's accounting schema currency must appear selected by default
  • All currency ISO codes must be displayed in drop down list
  • Verify the chosen currency: The 'Amount' column header must be displayed with "(EUR-E)" the default currency
  • Verify the chosen currency: The 'Amount' column header must be displayed with "(USD-$)"
  • Verify the chosen currency is displayed in the Price and Total

6.Invoiced Sales Order Report

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Sales Management->Analysis Tools-> Invoiced Sales Order Report
  • Fill the fields:
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
  • Select 'Mafalda Corporation'
  • Click on HTML Format. It should be shown with Total 2 EUR and 4 in USD

• Issues to verify:
  • Verify the selected business partner report are displayed with the chosen currency
  • All currency ISO codes must be displayed in drop down list
  • The chosen currency symbol are displayed on the right side of the Price and Total

7.Orders Awaiting Invoice Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Orders Awaiting Invoice Report
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
  • Click HTML Format.

• Issues to verify:
  • Verify the report should be generated with the chosen currencies
  • All currency ISO codes must be displayed in drop down list
  • It should be shown with Total 2 EUR and 4 in USD

8.Delivered Sales Order Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Delivered Sales Order Report
  • Fill the fields:
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
  • Click on HTML Format. Report should be shown

• Issues to verify:
  • Verify the selected business partner report are displayed with the chosen currency
  • All currency ISO codes must be displayed in drop down list
  • It should be shown with Total 4 EUR and 8 in USD

9.Invoice Detail

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Invoice Detail
  • Fill the fields:
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
  • The radio button 'Sales transaction' must be checked
  • Click on HTML Format.

• Issues to verify:
  • Verify the selected Product report are displayed with the chosen currency
  • All currency ISO codes must be displayed in drop down list
  • Verify the Amount as 845,64 $

10.Customer Invoice Report

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Sales Management->Analysis Tools-> Customer Invoice Report
  • Fill the fields:
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
  • Click on HTML, PDF Format.

• Issues to verify:
  • All currency ISO codes must be displayed in drop down list
  • User's accounting schema currency must appear selected by default
  • It should be shown with Total 2 EUR and 4 in USD

11.Sales Invoice Dimensional Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Sales Invoice Dimensional Report
  • Fill the fields:
    • From Date, To Date according with the dates of the sales orders
    • Currency: EUR and then with USD to check the conversion is working
    • Organization: A
    • Business Partner Group: Customers
    • Dimensions: Business partners and Product
  • Click on HTML Format and PDF format

• Issues to verify:
  • All currency ISO codes must be displayed in drop down list
  • User's accounting schema currency must appear selected by default
  • It should be shown with Total 2 EUR and 4 in USD

12.Sales Report by Partner and Product

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Sales Management->Analysis Tools-> Sales Report by Partner and Product
  • A pop-up window must show up and select currency as "USD" and click OK

• Issues to verify:
  • All currency ISO codes must be displayed in drop down list
  • User's accounting schema currency must appear selected by default
  • Verify the reports are generated in the Excel sheet.

Project & Service Management

1.Project Profitability

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Project & Service Management->Analysis Tools-> Project Profitability
  • Click on the bp icon and verify:
    • When you click the bp icon a pop-up window must show up and select 'McGiver Supplies'
  • Click on the Project icon and verify:
    • When you click the Project icon a pop-up window must show up and select 'mafalda - Mafalda project'
  • Select organisation as 'Main' and Project Type as 'Consulting'
  • Select "USD" in the Currency drop down list and Include Suborganizations must be checked

• Issues to verify:
  • Click on PDF Format and verify the selected project report are displayed
  • User's accounting schema currency must appear selected by default
  • All currency ISO codes must be displayed in drop down list

2.Service Project Report

• Steps:
  • Login as Openbravo with role access as OpenbravoAdmin
  • Go to Project & Service Management->Analysis Tools-> Service Project Report
  • Fill the Years, the dates and the rest of the mandatory fields

• Issues to verify:
  • User's accounting schema currency must appear selected by default.
  • The currency drop down list is mandatory and cannot be blank
  • If there is sample data, click on HTML Format and verify the chosen currencies are shown

3.Expense Report

• Steps:
  • Login as Openbravo with OpenbravoAdmin role
  • Go to Project & Service Management->Analysis Tools-> Expense Report
  • Fill the mandatory fields

• Issues to verify:
  • User's accounting schema currency must appear selected by default.
  • The currency drop down list is mandatory and cannot be blank
  • A drop-down list displaying all currency ISO codes
  • If there is sample data, click on HTML Format and verify the chosen currencies are shown

Category: QualityAssurance