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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

design defect

0037046

new

Triage Omni OMS

Known Issues related to Costing Functionality

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-09-27 12:41	ngarcia	New Issue
2017-09-27 12:41	ngarcia	Assigned To	=> Triage Finance
2017-09-27 12:41	ngarcia	Modules	=> Core
2017-09-27 12:41	ngarcia	Triggers an Emergency Pack	=> No
2017-09-27 12:41	ngarcia	Issue Monitored: networkb
2017-09-27 13:28	Practics	Issue Monitored: Practics
2017-10-10 17:24	dmiguelez	Relationship added	related to 0037046