0036960: Inventory Amount Update - Reference date should be Date instead of DateTime

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036960

Openbravo ERP

04. Warehouse management

public

2017-09-27 12:41

2017-10-10 17:24

Reporter

ngarcia

Assigned To

Triage Omni WMS

Priority

urgent

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

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

0036960: Inventory Amount Update - Reference date should be Date instead of DateTime

Description

Inventory Amount Update - Reference date should be Date instead of DateTime

1. When backdated transactions fixed is selected at costing rule level, the movement date of the transactions is taken into account to get the stock and cost.

2. When backdated transactions fixed is not selected at costing rule level, the transaction process date of the transactions is taken into account to get the stock and they are filtered by the transaction process date of the first transaction of the following day (movementdate > referencedate)cost in case there exists a transaction with a higher movement date.

As Movement Date in Product - Transactions (M_TRANSACTION) tab does not have hours and it is compared as <= it is not required to have hours on reference date

Steps To Reproduce

As group admin role:
   Create a new product and add a purchase price list to it
   Create a purchase order, add 1 unit the previously created product and book it
   Create a Goods Receipt from it
   Create a new purchase order, add 1 unit the previously created product and book it
   Create a Goods Receipt from it
   Launch the Costing Background Process and check it finishes successfully

   Create a new Inventory Amount Update and set a Reference Date between the transaction process date of the two goods receipt lines
   Add a line to it and the previously created product
   Check two units of the product are shown as the movement date of them is lower than reference date

Proposed Solution

Additional Information