0036534: Error in Costing Background Process if starting date of first costing rule is lower than movement date of existing transactions - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0036534

Openbravo ERP

04. Warehouse management

public

2017-07-26 17:10

2017-09-21 16:49

Reporter

ngarcia

Assigned To

collazoandy4

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

Fixed in Version

3.0PR17Q4

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

47504

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0036534: Error in Costing Background Process if starting date of first costing rule is lower than movement date of existing transactions

Description

Error in Costing Background Process if starting date of first costing rule is lower than movement date of existing transactions

Steps To Reproduce

As group admin role:
   Create a new Legal Without Accounting organization with Initial Organization Setup process
   Go to Organization window and set it as Ready
   Create the required master data: tax category, product, warehouse, storage bin
   Create a physical inventory with a movement date in the future
   Add a product and a cost to it and process it
   Go to Costing Rules window and create a new one
   Set today as Starting Date and Validate it
   Go to Process Request window and schedule Costing Background Process
   Check it finishes with the following error:
      No valid Costing Rule found for given organization and date

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0033937		closed	markmm82	Error in Costing Background Process if first costing rule validated with starting date,previous transactions cost not calculated
related to	defect	0028401		closed	dmiguelez	[Costing] Initialized All Trx process needs to be changed
related to	defect	0021406		closed	gorkaion	Costing Background Process blocked by Transactions without cost calculated.
related to	defect	0036675		closed	markmm82	[Costing Migration Process]: Transactions related with closing inventory lines do not have an entry in Transaction Cost tab

Attached Files

Issue History

Date Modified

Username

Field

Change

2017-07-26 17:10

New Issue

2017-07-26 17:10

Assigned To

=> Triage Finance

2017-07-26 17:10

OBNetwork customer

=> Yes

2017-07-26 17:10

Modules

=> Core

2017-07-26 17:10

Support ticket

=> 47504

2017-07-26 17:10

Triggers an Emergency Pack

=> No

2017-07-26 17:10

Relationship added

related to 0033937

2017-07-26 17:10

Issue Monitored: networkb

2017-07-27 09:52

Resolution time

=> 1502834400

2017-07-27 10:05

Assigned To

Triage Finance => collazoandy4

2017-07-27 15:53

collazoandy4

Status

new => scheduled

2017-07-27 22:54

collazoandy4

Note Added: 0098250

2017-07-31 13:14

Relationship added

related to 0028401

2017-07-31 22:15

collazoandy4

Note Edited: 0098250

bug_revision_view_page.php?bugnote_id=0098250#r15559

2017-08-03 10:10

Note Edited: 0098250

bug_revision_view_page.php?bugnote_id=0098250#r15578

2017-08-03 10:11

Note Edited: 0098250

bug_revision_view_page.php?bugnote_id=0098250#r15579

2017-08-03 10:32

Checkin

2017-08-03 10:32

Note Added: 0098357

2017-08-03 10:32

Status

scheduled => resolved

2017-08-03 10:32

Resolution

open => fixed

2017-08-03 10:32

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/e862781be5c32d5a5e82d8fb6fbb1c02a43b91f3 [^]

2017-08-03 10:56

Review Assigned To

=> aferraz

2017-08-03 10:56

Note Added: 0098358

2017-08-03 10:56

Status

resolved => closed

2017-08-03 10:56

Fixed in Version

=> 3.0PR17Q4

2017-08-03 11:19

Relationship added

related to 0021406

2017-08-28 11:19

Relationship added

related to 0036675

2017-09-21 16:49

Checkin

2017-09-21 16:49

Note Added: 0099293

Notes

Test Plan I: Transaction process date before and Movement date after the costing rule starting date
  As F&B International Group Admin role
    Create a new organization by Initial organization setup as follow:
      Organization: Test1
      Organization type: Legal without accounting.
      Include Accounting File or Accounting Reference Data: N
      Select all data sets.
    Go to Organization window select the previous organization created, set Currency: EUR and set it as Ready
    Go to Tax Category window and create a new record:
      Name: CategoryTest1
    Go to Product window and create a new record:
      Search Key/Name: ProductTest1
    Go to Warehouse and Storage Bin window and create a new record:
      Search Key/Name: WarehouseTest1
      Set any Location
      Create a new record in Storage bin tab:
        Search Key: SB1
    Go to Physical Inventory window and create a new record:
      Movement date: Next Month
      Create a new record in Lines tab:
        Product: ProductTest1
        Quantity count: 10
        Cost: 2
      Process Inventory count list
    Go to Costing Rules window and create a new record:
      Starting Date: Tomorrow
      Validate it
    Check in the Transaction tab of the previous product created that the inventory transaction cost is 0
    Check two more records have been created in Transaction tab related to closing and opening costing rule inventories.
    Check closing inventory cost is 0 and opening inventory cost is not calculated.
    Create a new record in Price tab:
      Create new Price List Version
      Unit and List Price: 3
    Go to Process Request window and schedule Costing Background Process
      Check it finishes successfully with no error
    Check in the Transaction tab of the previous product created that a cost of 30 has been calculated for opening inventory transaction.
    Check in the Costing tab a new record has been created with cost 3.

Repeat the same test setting Transaction process date and Movement date before costing rule starting date.

Test Plan II: Transaction process date after and Movement date before costing rule starting date
  As F&B International Group Admin role
    Create a new organization by Initial organization setup as follow:
      Organization: Test2
      Organization type: Legal without accounting.
      Include Accounting File or Accounting Reference Data: N
      Select all data sets.
    Go to Organization window select the previous organization created, set Currency: EUR and set it as Ready
    Go to Tax Category window and create a new record:
      Name: CategoryTest2
    Go to Product window and create a new record:
      Search Key/Name: ProductTest2
    Go to Warehouse and Storage Bin window and create a new record:
      Search Key/Name: WarehouseTest2
      Set any Location
      Create a new record in Storage bin tab:
        Search Key: SB2
    Go to Physical Inventory window and create a new record:
      Movement date: Last week
      Create a new record in Lines tab:
        Product: ProductTest2
        Quantity count: 10
        Cost: 2
      Process Inventory count list
    Go to Costing Rules window and create a new record:
      Starting Date: Yesterday
      Validate it
    Check in the Transaction tab of the previous product created that the inventory transaction cost is not calculated.
    Go to Process Request window and schedule Costing Background Process
      Check it finishes successfully with no error
    Check in the Transaction tab of the previous product created that a cost of 20 has been calculated for opening inventory transaction.
    Check in the Costing tab a new record has been created with cost 2.

Repeat the same test setting Transaction process date and Movement date after costing rule starting date.