Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048027Openbravo ERP07. Sales managementpublic2021-11-10 14:012021-11-11 17:01
Reporterdromero 
Assigned Tovmromanos 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutioninvalid 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0048027: Irrelevant data in create line from order popup
DescriptionOB allows to ship or invoice more qty than ordered when isquantityvariable flag is checked as Y in product window. How when we ship more than the order qty we see that qty comes in negative on create lines pop up window . This leads to unnecessary confusion to users and its a junk data that is kept.

The video: https://drive.google.com/file/d/1Nz2pyjwA32775IascnPtWdijoyhDF8ZF/view [^]
Steps To Reproduce1) Go to the "Sales Order" window and create an order with 3 products that each product has the "Operative Quantity" 60,50 and 40

2) Select "Book" and we give it OK

3) Go to "Sales invoice" and create one

4) Complete the data with the same as "Sales order" and press "Create Lines From Order" where we will select the order created in "Sales order"

5) Verify that the fields in the "Lines" tab are correct, we select "Quantity 60" and we change it to "50" we will be able to observe the error that it shows us

6) In "Quantity 40" we change it to 60 and save it

7) Press the "Complete" button and click on "Do not use credit"

8) Create "Sales invoice" again and complete the data

9) Press the button "Create Lines From Order" and we can see that the Quantity of the lines that we modify appear in negative where previously we would have 60, 50 and 40
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-11-10 14:01dromeroNew Issue
2021-11-10 14:01dromeroAssigned To => Triage Finance
2021-11-10 14:01dromeroModules => Core
2021-11-10 14:01dromeroRegression date => 2021-11-22
2021-11-10 14:01dromeroTriggers an Emergency Pack => No
2021-11-11 16:26vmromanosRegression date2021-11-22 =>
2021-11-11 16:26vmromanosAssigned ToTriage Finance => vmromanos
2021-11-11 17:01vmromanosReview Assigned To => vmromanos
2021-11-11 17:01vmromanosNote Added: 0132986
2021-11-11 17:01vmromanosStatusnew => closed
2021-11-11 17:01vmromanosResolutionopen => invalid

Notes
(0132986)
vmromanos   
2021-11-11 17:01   
This is working as expected.

The Is Quantity Variable flag allows you to ship and invoice more (or less) quantity than the originally ordered.

Usually, when quantity variable products are involved, the sales invoice is created from the goods shipment (not from the sales order), so you can invoice exactly what you delivered to the customer.

Once you have fully invoiced the shipment/order, you should close the sales order so it won't appear anymore as candidate to invoice.

Note that it's impossible for the system to know if you want to rectify an over-invoiced quantity or not if you don't close the order and you try to invoice from the order. However, if you invoice from the shipment the system has that information and therefore it doesn't show the negative lines.

As a summary, when working with quantity variable products, try to invoice always from the shipment and close the sales order as soon as everything has been completed. In this way you won't have any confusion.