0011260: GL Posting by DB tables does not work properly if several accounting schemas are used

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011260

Openbravo ERP

09. Financial management

public

2009-11-05 13:32

2009-11-20 00:00

Reporter

networkb

Assigned To

vmromanos

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.50MP8

Target Version

2.50MP9

Fixed in Version

2.50MP9

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0011260: GL Posting by DB tables does not work properly if several accounting schemas are used

Description

Scenario:

* Organization with is Accounting Schema.
Org1 Organization (Legal with accounting) with is Accounting Schema.
Org2, Org3 Organizations (Generic, Org1 as Parent Organization), with its own Accounting Schema.

If an invoice is posted in Org2 (using post button in Invoices), is posted properly: in * Accounting Schema, Org1 and Org2.

However, if invoices are posted in GL Posting by DB Tables, the same invoice is posted in *, Org1, Org2 and Org3.

Steps To Reproduce

Create a new Client in General Setup > Client > Initial Client Setup.
As Client Admin, create a new Organization in General Setup > Enterprise > Initial Organization Setup.
Call it "Org1", and should be "Legal with accounting". Select a CSV (or an installted COA), check BP, Product and Project and press Ok.
Go to General Setup > Enterprise > Organization. Search Org1.
Set as "Summary level". Check "Allow period control" and select one calendar.
Finally, press "Set as ready", and OK.
Go back to General Setup > Enterprise > Initial Organization Setup.
Create a new Organization. Call it Org2 and should be "Generic" and its Organization parent, should be Org1. Select a CSV, check BP, Product and Project. Press OK.
Repeat this process with Org3.
Go to General Setup > Enterprise > Organization. Search Org2. Press "Set as Ready".
Do the same within "Org3".
go to Financial Management > Accounting > Setup > Fiscal Calendar. Go to Year tab.
Press "Create periods".
Go to Financial Management > Accounting > Transactions > Open/close period control.
Create a new record, select Org1 organization, Until period "Dec-09" and as action "Open period".
Finally, press "Process".
Create a Sales Invoice (probably would be needed to create BP Category, BP, Product Category, Product, Price Lists, etc).
Complete it and post it. Three groups of GL entries will be shown.
Go to Financial Management > Accounting > Transactions > Reset accounting.
Select Invoices as Tables and check "Delete accounting entries".
Press OK.
Go to Financial Management > Accounting > Transactions > GL Posting by DB tables. Do not select anything and press OK.
Go back to Sales Invoice.
Press "Posted" buttom. See its GL entries. Four groups are shown.

Proposed Solution

Additional Information