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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008524
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2009-04-09 10:302009-10-06 00:00
ReporternetworkbView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionno change requiredFixed in Version2.40MP4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50betaSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008524: Duplicate lines are added to sales invoice, when the user create's Sales order (POS) for a product which has negative inventory

DescriptionDuplicate line items are added to the sales invoice, if a product has negative inventory in warehouse and create a Sales order for the same product with document type as POS.



Steps To ReproduceStep 1) Run the stock report to verify the inventory of the warehouse. identify any product which has positive qty(i.e., Hammer qty = N)

Step 2) Move to Sales Management and complete a sales order with document type as POS (Sales Management || Transactions || Sales Order || Header)
with BP = <any business partner> and product = hammer , Qty = N+1 and click complete button 'Process completed successfully' with Receipt id & Invoice id

Step 3) Create another Sales order with document type as POS and select the same BP, Product = hammer and Qty = 10 and click complete button. 'Process completed successfully' message appears with Receipt id & invoice id.

Open the above created sales invoice and check the line item details.

Actual result: you can find 3 line items instead of one line item




Tags250 final review
Attached Filesjpg file icon Need to check the line items in Sales invoice, if the inventory is in negative.JPG [^] (136,807 bytes) 2009-04-09 10:30

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0008405 closedgorkaion A POS order (sales order) can not be reactivated more than once 
related to defect 0008266 closedgorkaion Function M_INOUT_CREATE (Create/Generate Shipments) delivers from locators where the quantity is negative 
depends on backport 0008525 closedrafaroda Duplicate lines are added to sales invoice, when the user create's Sales order (POS) for a product which has negative inventory 
depends on backport 00106722.35MP16 closedrafaroda Duplicate lines are added to sales invoice, when the user create's Sales order (POS) for a product which has negative inventory 

-  Notes
(0020627)
rafaroda (developer)
2009-10-01 14:25
edited on: 2009-10-01 14:27

The current behaviour in pi and 2.40 when allowing negative stock is the following:

1) Run stock report and see the quantity stocked of Hats: 499 units in ML1 (Warehouse Management || Analysis Tools || Stock Report)
2) Create Hat stock for ML2 (101 units) and ML3 (50 units) locators and process it (Warehouse Management || Transactions || Physical Inventory || Header)
3) If you run the stock report for Hats, you have now:
* 499 Units in ML1
* 101 Units in ML2
* 50 Units in ML3
* Total = 650
4) Create an POS Sales Order of 670 Hats and complete it.
5) The Shipment created has 4 lines, which is correct:
* 499 Units movement in ML1
* 50 Units movement in ML3
* 101 Units movement in ML2
* 20 Units movement in ML1
6) Run the stock report: you have now -20 Units in ML1
7) The Invoice created has 4 lines: each line is linked with the corresponding shipment line which is the regular behaviour of Openbravo ERP.

Openbravo ERP 2.3x branch is missing the fix of issue 0008266 Function M_INOUT_CREATE (Create/Generate Shipments) delivers from locators where the quantity is negative. With this fix the behaviour will be the same as in 2.40 and pi.

If you want to display the invoice lines grouped when printing the invoice, the report will have to be customized.

(0020668)
rafaroda (developer)
2009-10-02 14:34

It has being agreed that this is the regular behaviour of Openbravo ERP.

Backport to 2.3x branch of issue 0008266 can be found at 0010842

- Issue History
Date Modified Username Field Change
2009-04-09 10:30 sureshbabu New Issue
2009-04-09 10:30 sureshbabu Assigned To => rafaroda
2009-04-09 10:30 sureshbabu File Added: Need to check the line items in Sales invoice, if the inventory is in negative.JPG
2009-04-09 10:30 sureshbabu Regression testing => No
2009-04-09 10:30 sureshbabu Tag Attached: 250 final review
2009-04-09 10:34 sureshbabu Summary Duplicate line is added in sales invoice, If a product has negative inventory, and if the user create's Sales order (POS) => Duplicate lines are added to sales invoice, when the user create's Sales order (POS) for a product which has negative inventory
2009-04-09 10:34 sureshbabu Description Updated
2009-04-09 10:36 rafaroda Assigned To rafaroda => gorkaion
2009-04-09 10:37 rafaroda Status new => scheduled
2009-04-09 10:37 rafaroda fix_in_branch => pi
2009-04-09 10:37 rafaroda Relationship added related to 0008405
2009-04-23 18:57 hgbot Checkin
2009-04-23 18:57 hgbot Note Added: 0015638
2009-04-23 18:57 hgbot Status scheduled => resolved
2009-04-23 18:57 hgbot Resolution open => fixed
2009-04-23 18:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/d930f7e2bfdfed340ab9fd07d682e96bbc963e68 [^]
2009-04-23 19:04 gorkaion Status resolved => new
2009-04-23 19:04 gorkaion Resolution fixed => open
2009-04-23 19:04 gorkaion Status new => scheduled
2009-04-23 19:05 gorkaion Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/d930f7e2bfdfed340ab9fd07d682e96bbc963e68 [^] =>
2009-04-23 19:05 gorkaion fix_in_branch pi =>
2009-04-23 19:08 jpabloae Note Deleted: 0015638
2009-09-21 09:44 rafaroda Issue cloned 0010672
2009-09-21 09:44 rafaroda Relationship added depends on 0010672
2009-10-01 13:30 rafaroda Relationship added related to 0008266
2009-10-01 14:25 rafaroda Note Added: 0020627
2009-10-01 14:25 rafaroda Reporter sureshbabu => networkb
2009-10-01 14:25 rafaroda Assigned To gorkaion => rafaroda
2009-10-01 14:27 rafaroda Note Edited: 0020627
2009-10-02 14:34 rafaroda Note Added: 0020668
2009-10-05 08:02 rafaroda Status scheduled => closed
2009-10-05 08:02 rafaroda Resolution open => no change required
2009-10-06 00:00 anonymous sf_bug_id 0 => 2873172


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker