Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031416Openbravo ERP04. Warehouse managementpublic2015-11-10 13:482015-12-28 17:06
Reporterpsanjuan 
Assigned Tononofrancisco 
PriorityurgentSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031416: CostingUtils.periodClosed method is not retrieving correct Fiscal Calendar
DescriptionCostingUtils.periodClosed method is not retrieving correct Fiscal Calendar.

This method is used in two process:
CostAdjustmentProcess and PriceDifferenceByDateProcess.
Steps To ReproduceGo to F&B España and check that it has assigned "Calendario España" Fiscal Calendar.

Go to Fiscal Calendar and create a new calendar for F&B España, named "A_Calendar". Create for this calendar year 2015 as well as 2015 periods.

Check that it is not possible to open/close the periods related to this new calendar because it is not the one associated to F&B España Organization.

Go to Landed Cost Type window:
       Org: *
       Landed Cost Distribution Algorithm: by amount
       Product: Descuento 10%

  Go to Purchase order window
      create a new one for Cerveza Ale and F&B España org.

  Create the Goods Receipt related for F&B España org.
 
  Create the Purchase invoice related for F&B España org.
      Add the Discount: Descuento 10%
 Process it.

Go to Landed Cost window,
   create a new one for España and the Landed Cost Type:created before
   Cost tab: add a cost value = 10
   Receipt tab: select the goods receipt created before.
Try to process it.

You will get below an error because Nov-15 of "A_Calendar" is being taken and that is not correct as Nov-15 of "Calendario España" should be the one to take. See image attached.
Proposed SolutionThis method needs to be modified therefore the period of the calendar related to the organization is the one selected.
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Issue_31416.png (93,795) 2015-11-10 13:56
https://issues.openbravo.com/file_download.php?file_id=8710&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2015-11-10 13:48psanjuanNew Issue
2015-11-10 13:48psanjuanAssigned To => Triage Finance
2015-11-10 13:48psanjuanModules => Core
2015-11-10 13:48psanjuanTriggers an Emergency Pack => No
2015-11-10 13:55psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10124#r10124
2015-11-10 13:55psanjuanProposed Solution updated
2015-11-10 13:56psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10125#r10125
2015-11-10 13:56psanjuanFile Added: Issue_31416.png
2015-12-21 20:41nonofranciscoNote Added: 0082913
2015-12-28 17:05nonofranciscoAssigned ToTriage Finance => nonofrancisco
2015-12-28 17:06nonofranciscoStatusnew => scheduled

Notes
(0082913)
nonofrancisco   
2015-12-21 20:41   
Test plan:

As Openbravo / F&B International Group Admin

In Organization Window
 Open F&B España, S.A in form view
 Verify Allow Control Period is checked
 Verify Calendario España is selected

Create a new Fiscal Calendar
 Name = A_Calendar
 Organization = F&B España, S.A
 Create a new year
  Fiscal Year = 2015
  Create Periods

In Open / Close Period Control
 Verify is not possible to open/close periods of the new calendar

Create a new Landed Cost Type
 Organization = *
 Name = A_Landed_Cost_Type
 Landed Cost Distribution Algorithm = Distribution by Amount
 Product = Descuento 10%

Create a new Purchase Order
 Organization = F&B España, S.A
 Business Partner = Bebidas Alegres, S.L.
 Create a new Line
  Product = Cerveza Ale 0,5L
  Ordered Quantity = 10
 Book the order

Create a new Goods Receipt
 Organization = F&B España, S.A
 Business Partner = Bebidas Alegres, S.L.
 Create lines from
  Order = Purchase order previously created
  Quantity = 10
  Storage Bin = Rn-0-0-0
 Complete the receipt
 Generate Invoice From Receipt
  Price List Version = Tarifa Bebidas Alegres

In Purchase Invoice Window
 Select the purchase invoice previously created
 Add a new Basic Discount
   Basic Discount = Descuento 10%
 Complete the Invoice

Create a new Landed Cost
 Organization = F&B España, S.A
 Create a new Cost
  Landed Cost Type = A_Landed_Cost_Type
  Amount = 10
  Create a new Receipt
   Goods Receipt = the previously created
   Goods Receipt Line = the one that is available
  Process the Landed Cost

Realize that a success message is shown indicating the Cost Adjustment document number that has been created