Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-230415 - stock detail report won't sort by date|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-230415]
* Issue
** Running quantity is carrying forward from one item to the next
* Requirement
** Report should be able to be ran for multiple products with proper running quantity
#1 Add a New drop down list "Reset Running Qty for"
Values in the list
# Commodity
# Category
# Item
# Commodity-Location
# Category-Location
# Item-Location
# Item - Storage Location
# Item - Storage Unit
# Storage Location
# Storage Unit
Based on the selection, reset the running qty. Change the sort order by of the report based on this filter to facilitate running qty reset.
Default sort order
# Commodity
# Category
# Item
# Location
# Transaction Date
# BatchId
When a Storage Location or Storage Unit is used as reset filter change the sort order to
Sort order becomes
# Storage Location
# Storage Unit
# Transaction Date
# BatchId
#2 Calculate Opening Qty balance based on Date filter and Reset Running Qty For values.
#3 Also check if "Group By with total" for Quantity field is working correctly.
|