QA test plan 2.40/Multi accounting schema

Introduction

Openbravo ERP supports parallel accounting by the concept of multi accounting schema. This means that under the same entity you can have different accounting standards(e.g, US GAAP, International GAAP, German HGB, French Accounting standard) with their different currencies.

With this feature, Openbravo ERP is able to account a transaction document in different accounting standards. For each document you will get as many entries in the books as multi schema you define.

Aim of the project

Review all the application in order to see in which places exist a lack of functionality to make sure multi accounting schema works properly.

Impact in the application

• Windows - Tabs
  • Master data management->Business partner set up->Business partner category->Accounting
    • Button: Copy accounts
  • Master data management->Product set up->Product Category->Accounting
    • Button: Copy accounts
  • Financial management->Accounting->Set up->Accounting schema->General ledger
  • Financial management->Accounting->Set up->Accounting schema->Defaults
    • Button: Copy accounts
  • Financial management->Accounting->Analysis tools->Accounting Report
  • Financial Management->Accounting->Analysis Tools->General Account Report Setup->Setup
  • Financial Management->Accounting->Analysis Tools->General Account Report Setup->Setup->Category->Node

• Reports: All of them are in Financial management->Accounting->Analysis tools
  • General accounting report
  • Balance sheet
  • General ledger report
  • General ledger journal
  • Create accounting report
  • Report Cash Flow

• Selectors:
  • Account selector

Previous data

In order to test the new developments, it is a must to create another accounting schema:

1. Create an account tree

• Steps:
  • Login as Openbravo with role access to financial management
  • Go to Financial management->Accounting->Account tree->Element
  • Click New and fill:
    • Type: Account
    • Tree: BigBazaar Element (Cuenta, etc.)

2. Create an accounting schema

• Steps:
  • Login as Openbravo with role access to financial management
  • Go to Financial management->Accounting->Accounting schema->Accounting Schema
  • Click New and fill:
    • GAAP: US GAAP
    • Currency: US dollar
  • Move to Account schema element and create 5 more lines for:
    • Organization
    • Account. Very important to add the new Account tree
    • Product
    • Bus. Partner
    • Project

3. Create a currency conversion

• Steps:
  • Login as Openbravo with role access to General Setup->Application
  • Go to General Setup->Application->Currency
  • Create a conversion from EUR to USD

4. Import file loader

• Steps:
  • Login as Openbravo with role access to Master data management->Import data
  • Go to Master data management->Import data->Import file loader
  • Select the COA AccountsSimplifiedUS06.csv
  • Select Format file: Accountings - Account
  • Press Process

5. Import account

• Steps:
  • Login as Openbravo with role access to Master data management->Import data
  • Go to Master data management->Import data->Import Account
  • Go into any of the existing records. Edit mode
  • Click the button Import Accounts
  • All the flags marked except Create new combination
  • Select the new account element
  • Press OK

6. Update client

• Steps:
  • Login as Openbravo with role access to General set up->Client->Client->Information
  • Mark the flag Second Accounting Schema
  • And then chose the new one in the Second Accounting Schema drop down list

Issues to verify

To check if the new schema has been created successfully:

1.Go to Account tree->Element->Element value and check the tree is built with the corresponding account elements

2.The tabs General ledger and Defaults that are in Financial management->Accounting->Set up->Accounting schema must be filled with one record. If not the import accounts has failed

Test cases

 1. General Accounting Report

Before executing the report, we have to define what we want.

1.1 General account report set up

• Steps:
  • Go to Financial management->Accounting->Analysis tools->General account report set up->Set up
  • Click New and fill the mandatory fields
  • Issues to verify: An accounting schema drop down list
  • Move to Category and click New. Fill the mandatory fields
  • Move to Node and click new and fill the madatory fields
  • Issues to verify: The drop down list Account element must be filled with the account element of the accounting schema that has been selected in the set up tab

1.2 General accounting report

• Steps:
  • Go to Financial management->Accounting->Analysis tools->General Accounting Report
  • Fill the Years, the dates and the rest of the mandatory fields
  • Issues to verify:
    • There must be a new drop down list: Accounting schema
    • When selecting an accounting schema, the Accounting Report combo must be filled with the corresponding values related to that accounting schema
  • Execute the report for all the accounts levels

2. Balance sheet

• Steps:
  • Go to Financial management->Accounting->Analysis tools->Balance sheet
  • Fill the mandatory fields
  • Select Subaccount in the Account level combo
  • Issues to verify:
    • There must be a new drop down list: Accounting schema
    • When selecting Subaccount, there should appear two more drop down list: From Account, To Account
    • These two combos must be filled with the corresponding sub accounts related to the Accounting schema

3. General ledger report

• Steps:
  • Go to Financial management->Accounting->Analysis tools->General ledger report
  • Fill the mandatory fields
  • Issues to verify:
    • There must be a new drop down list: Accounting schema
    • The combo accounting schema is optional, so you should be able to distinguish by accounting schema in the html result

4. Create Accounting Report

Before executing the report, we have to define what we want.

4.1 Accounting report

• Steps:
  • Go to Financial management->Accounting->Analysis tools->Accounting report
  • A. Header of the report
    • Click New and fill:
      • Name
      • Mark Report
      • Mark Shown
      • Mark Summary level
      • Mark Shown
      • Select the accounting Schema
      • Temporary filter Type
    • Issues to verify: The drop down list Accounting schema must be mandatory
  • B. Node of the report
    • Click New and fill:
      • Name
      • Not mark Report
      • Mark Shown
      • Not mark Summary level
      • Mark Shown
      • Select the accounting Schema
      • Select Account
      • Select report type
    • Issues to verify: When you select an accounting schema, the drop down list Account is filled with the correct values
      • Save
  • C. Adding nodes
    • Click on the tree icon
    • Move one node to the corresponding parent
    • Issues to verify: Not allowed to move node that belongs to different accountings schema

4.2 Create accounting report

• Steps:
  • Go to Financial management->Accounting->Analysis tools->Create Accounting report

• Issues to verify:
  • There must be a new drop down list: Accounting schema
  • When selecting the Accounting schema, the account must be filled with the corresponding values related to the accounting schema

5. Report cash flow

• Steps:
  • Go to Financial management->Accounting->Analysis tools->Report cash flow
  • There must be a new drop down list: Accounting schema
  • When selecting the Accounting schema, the account must be filled with the corresponding values related to the accounting schema

Results

All the bugs will be reported with the prefix QA-MAS

See all bugs related to Multi accounting schema.

See all OPEN bugs.