Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005823
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 04. Warehouse managementmajoralways2008-11-04 17:222011-02-04 09:15
ReporterjtarbalView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40betaSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005823: Same product with the same lot number purchased multiple times should appear in the same stock

DescriptionSame product purchased at different times with the same lot number appears twice in stock (or as many times as purchased).

In this case, it would be great if the stock of the different entries would be grouped, so that in the stock report the same product and attributes appreared only once.

In the same way, when doing a goods shipment, the different entries are treated as different products, although they have the same attributes and are stored in the same storage bin. This is a problem in the next example:
  - Imagine we received in two times 10 units of product A of lot 1 in storage bin SB1 and 15 units of product A of lot 1 in storage bin SB1 (same product, attributes and storage bin).
  - If we need to ship 18 units of product A, we will have to create a goods shipment with two different lines, for example 10 units of product A of lot 1 from storage bin SB1 and 8 units of product A of lot 1 from storage bin SB1. Otherwise, the stock report will show -8 units of product A of lot 1 in storage bin SB1 and 15 units of product A of lot 1 in storage bin SB1, instead of showing 7 units of product A of lot 1 in storage bin SB1.
TagsClean-up, ReleaseCandidate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0010541)
rafaroda (developer)
2008-11-24 10:22

This is not a bug but yes the normal behaviour of the application. Lot attribute is a instanciable attribute so it creates you a new entry in the m_ttributeinstance table. Another thing is that your configuration is not the correct one as you are allowing to have negative stock.
(0010556)
jtarbal (reporter)
2008-11-24 12:32

This was a feature request and not a bug. We know that this is not the current behavior of the system, but we think it should be improved. Please, classify it as feature request.
(0013627)
jtarbal (reporter)
2009-02-18 09:58

The impact of not having this feature is that even if in the warehouse there is enough quantity to deliver a sales order for specific product and attributes, if the reception of the goods has been done in different "Goods Receipt" documents, it is not possible to put in one line in the "Goods Shipment" the quantity that is needed to be delivered. As the application is not capable to sum up the quantities of the different receptions, it has to be treated as different products with different attributes even if it is not true. Thus, this is a "must have" in all industries that use attributes for the purchased products.

- Issue History
Date Modified Username Field Change
2008-11-04 17:22 jtarbal New Issue
2008-11-04 17:22 jtarbal Assigned To => rafaroda
2008-11-04 17:22 jtarbal sf_bug_id 0 => 2221492
2008-11-10 14:25 rafaroda Assigned To rafaroda => pjuvara
2008-11-17 08:20 pjuvara Type feature request => defect
2008-11-24 10:22 rafaroda Regression testing => No
2008-11-24 10:22 rafaroda Status new => closed
2008-11-24 10:22 rafaroda Note Added: 0010541
2008-11-24 10:22 rafaroda Resolution open => no change required
2008-11-24 12:32 jtarbal Note Added: 0010556
2008-11-24 12:50 rafaroda Status closed => new
2008-11-24 12:50 rafaroda Resolution no change required => open
2008-11-24 12:51 rafaroda Type defect => feature request
2008-11-24 12:58 pjuvara Tag Attached: Clean-up
2008-11-24 12:58 pjuvara Tag Attached: ReleaseCandidate
2008-11-24 12:58 pjuvara Status new => acknowledged
2008-11-24 12:59 pjuvara Summary Same product purchased at different times with the same lot number appears twice in stock (or as many times as purchased) => Same product with the same lot number purchased multiple times should appear in the same stock
2009-02-18 09:58 jtarbal Note Added: 0013627
2011-02-04 09:15 jpabloae Assigned To pjuvara => rmorley


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker