Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0010909

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

major

always

2009-10-08 11:05

2009-10-24 00:00

Reporter

networkb

View Status

public

Assigned To

dalsasua

Priority

urgent

Resolution

fixed

Fixed in Version

2.50MP8

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

2.50MP7

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

2.50MP5

SCM revision

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0010909: The reset accounting process does not work when you select a table

Description

The reset accounting process does not work when you select a table.
If you don't select anything the process works well but if you
want to delete the accounting only for the selected tab,
the process does not unpost anything.

Steps To Reproduce

-Create an post a settlement
-go to Financial management > Accounting > Reset accounting
-Select the settlement table
-Execute the process
You get the folling message:
@Updated@ = 0, @Deleted@ = 0

If you don't select the table the process work

Proposed Solution

replace the code
        EXECUTE
          'SELECT AD_Org_ID
          FROM ' || v_TableName || '
          WHERE ' || v_TableName || '_ID =''' || v_Record_ID || ''' AND AD_CLIENT_ID =''' || v_AD_Client_ID || ''' '
          INTO v_AD_Org_ID;

with the following in order to select the organization of the parameter instead of the organization of the document.

IF (v_Record_ID!='0') THEN
        EXECUTE
          'SELECT AD_Org_ID
          FROM ' || v_TableName || '
          WHERE ' || v_TableName || '_ID =''' || v_Record_ID || ''' AND AD_CLIENT_ID =''' || v_AD_Client_ID || ''' '
          INTO v_AD_Org_ID;
    END IF;

Tags

Relationships [ Relation Graph ] [ Dependency Graph ]

has duplicate

defect

2.50MP7

closed

Reset accounting process: When using the "table" combo box the reset accounting does not delete anything

Notes
(0020994) hgbot (developer) 2009-10-14 09:46	Repository: erp/devel/pi Changeset: 6e2cf9eac6842d16b12a4e5a99fa2e460a319cda Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Wed Oct 14 09:46:06 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/6e2cf9eac6842d16b12a4e5a99fa2e460a319cda [^] Fixes issue 10909: The reset accounting process does not work when you select a table --- M src-db/database/model/functions/FACT_ACCT_RESET.xml ---

(0021360) arunkumar (viewer) 2009-10-23 12:48	Tested & Working fine.

Issue History
Date Modified	Username	Field	Change
2009-10-08 11:05	networkb	New Issue
2009-10-08 11:05	networkb	Assigned To	=> rafaroda
2009-10-08 11:05	networkb	OBNetwork customer	=> Yes
2009-10-09 08:27	networkb	Target Version	2.40MP11 => 2.50MP7
2009-10-09 08:28	networkb	Target Version	2.50MP7 => 2.50MP8
2009-10-09 08:33	rafaroda	Assigned To	rafaroda => dalsasua
2009-10-09 08:33	rafaroda	Priority	immediate => urgent
2009-10-09 08:33	rafaroda	Status	new => scheduled
2009-10-09 09:31	networkb	Target Version	2.50MP8 => 2.50MP7
2009-10-13 12:18	psarobe	Relationship added	has duplicate 0010849
2009-10-14 09:46	hgbot	Checkin
2009-10-14 09:46	hgbot	Note Added: 0020994
2009-10-14 09:46	hgbot	Status	scheduled => resolved
2009-10-14 09:46	hgbot	Resolution	open => fixed
2009-10-14 09:46	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/6e2cf9eac6842d16b12a4e5a99fa2e460a319cda [^]
2009-10-22 19:26	psarobe	Tag Attached: main
2009-10-22 19:33	psarobe	Tag Attached: 250MP8
2009-10-23 12:48	arunkumar	Status	resolved => closed
2009-10-23 12:48	arunkumar	Note Added: 0021360
2009-10-23 12:48	arunkumar	Fixed in Version	=> 2.50MP8
2009-10-24 00:00	anonymous	sf_bug_id	0 => 2885058

Copyright © 2000 - 2009 MantisBT Group