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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036745
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2017-08-29 20:112017-10-19 10:49
Reportercollazoandy4View Statuspublic 
Assigned Tocollazoandy4 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036745: Purchase order schedule details is not updated when same purchase order line is invoiced twice and second invoice have a negativ

DescriptionPurchase order schedule details is not updated when same purchase order line is invoiced twice and second invoice is changed to a a negative qty
Steps To ReproduceGo to Payment Term and create a new record:
  Name: 30-60
  Offset month due: 2
  Add line with "percentage due" = 50 and "offset month due" = 1
Go to Business Partner window and relate this new payment term to "Bebidas Alegres" BP.

Register Purchase Order for Bebidas Alegres using "30-60" payment term. (order no 1000190)
  Add line for any product and qty=800, price = 1.00 and exempt VAT (Compras exentas).
  Add another line for different product and qty=200, price = 1.00 and exempt VAT.
  Process the Order and check total gross amount of the order is 1,000.00

Register a Purchase Invoice for Bebidas Alegres using "30-60" payment term. (invoice no 10000946)
  Run "Create lines from" and select line of 800 units line from the order.
  DO NOT process invoice.

Register another Purchase Invoice for Bebidas Alegres using "30-60" payment term. (invoice no 10000947)
  Run "Create lines from" and select line of 800 units once more from the order.
  Edit the line to set qty=-320 units.
  DO NOT process invoice

Process first invoice (invoice no 10000946).
  Run "Add payment" in this first invoice and realize that details are correct :
   Outstanding Amount = 400.00, (order no 1000190, invoice no 10000946)
   Outstanding Amount = 400.00, (order no 1000190, invoice no 10000946)
   Select the details and press DONE.
Check:
  A new Payment Out is created related to the order and the invoice.
  The Invoice is paid (Payment Complete = Yes) Go to the Payment Plan tab and realize that two records was created wit outstanding amount = 0.
  Go back to the order (order no 1000190). Refresh and go to Payment Out Plan, realize that payment plan has been updated
   Paid = 800
   Outstanding = 200.
   It is correct!!!

Process second invoice (invoice no 10000947).
  Run "Add payment" in this second invoice and realize that details are not correct the order is not related in the payment:
    Outstanding Amount = -160.00, (invoice no 10000947)
    Outstanding Amount = -160.00, (invoice no 10000947)
  Select the details and press DONE.
  Check:
    A new Payment Out is created related to the invoice and not to the order.
    The Invoice is paid (Payment Complete = Yes) Go to the Payment Plan tab and realize that two records was created with outstanding amount = 0.
    Go back to the order (order no 1000190). Refresh and go to Payment Out Plan, realize that payment plan has not been updated wich is incorrect the payment plan should be updated with the payment made to the second invoice.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00253123.0PR14Q3 closededuardo_Argal Wrong payment detail distribution when negative order is invoiced using fractionated payment term 
related to defect 00269513.0PR14Q3 closedgorkaion Wrong payment distribution when creating partial invoices from a prepaid order 
related to defect 0033500 closedAtulOpenbravo Wrong payment schedule details when return to vendor document is invoiced using credit a memo invoice 

-  Notes
(0098961)
collazoandy4 (reporter)
2017-09-12 03:03

 Test Plan I
  Create a Purchase Order for Bebidas Alegres, S.L. bp
    Create a new record in Lines tab:
      Product: Cerveza Ale 0,5L
      Ordered quantity: 10
      Net Unit Price: 1
      Tax: Compras exentas
    Book the order
  Create a new Purchase Invoice from previous order created and edit the invoice quantity to -5
    Pay the invoice and check a new payment out is created with:
      Invoiced Amount: -5
      Paid Amount: -5
  Check the order payment plan:
    Expected amount: 10
    Paid: -5
    Outstanding: 15
    Number of payment: 1
Test Plan II
  Register Purchase Order for Bebidas Alegres using "30-60" payment term. (order no 1000190)
   Add line for any product and qty=800, price = 1.00 and exempt VAT (Compras exentas).
   Add another line for different product and qty=200, price = 1.00 and exempt VAT.
   Process the Order, therefore total gross amount of the order is 1000.00
  Register a Purchase Invoice for Bebidas Alegres using "30-60" payment term. Dated on 10-08-2016. (invoice no 10000946)
   Run "Create lines from" and select line of 800 units line from the order. DO NOT process invoice
  Register another Purchase Invoice for Bebidas Alegres using "30-60" payment term. Dated on 10-08-2016. (invoice no 10000947)
   Run "Create lines from" and select line of 800 units once more from the order.
   Edit the line to set qty=-320 units. DO NOT process invoice
  Process first invoice (invoice no 10000946).
   Run "Add payment" in this first invoice and realize that details are correct :
     12-09-2016 Outstanding Amount = 400.00, (order no 1000190, invoice no 10000946)
     10-10-2016 Outstanding Amount = 400.00, (order no 1000190, invoice no 10000946)
   Select the details and press DONE.
   Notice:
    A new Payment Out is created related to the invoice and the invoice.
    The Invoice is paid (Payment Complete = Yes) Go to the Payment Plan tab and realize that two records was created wit outstanding amount = 0.
   Go back to the order (order no 1000190). Refresh and go to Payment Out Plan, realize that payment plan has been updated
    Paid = 800
    Outstanding = 200.
   It is correct!!!
  Process second invoice (invoice no 10000947).
   Run "Add payment" in this first invoice and realize that details are correct :
     12-09-2016 Outstanding Amount = -160.00, (order no 1000190, invoice no 10000947)
     10-10-2016 Outstanding Amount = -160.00, (order no 1000190, invoice no 10000947)
   Select the details and press DONE.
   Notice:
    A new Payment Out is created related to the invoice and the invoice.
    The Invoice is paid (Payment Complete = Yes) Go to the Payment Plan tab and realize that two records was created with outstanding amount = 0.
   Go back to the order (order no 1000190). Refresh and go to Payment Out Plan, realize that payment plan has been updated
    Paid = 480 => 800 (paid in the first invoice) - 320 (paid in the second invoice)
    Outstanding = 520 => 1000 (total of the order) - 480 (already paid)
   It is correct!!!
(0099957)
psanjuan (manager)
2017-10-19 10:48

 Issue rejected as no need to fix.
It is correct that the order is not updated with the payment plan of the second invoice, negative invoice as the correct way of approaching this scenario, would be to create a return order from which get the information.

- Issue History
Date Modified Username Field Change
2017-08-29 20:11 collazoandy4 New Issue
2017-08-29 20:11 collazoandy4 Assigned To => Triage Finance
2017-08-29 20:11 collazoandy4 Modules => Core
2017-08-29 20:11 collazoandy4 Triggers an Emergency Pack => No
2017-08-30 09:33 psanjuan Description Updated View Revisions
2017-09-06 15:44 collazoandy4 Assigned To Triage Finance => collazoandy4
2017-09-06 15:45 collazoandy4 Status new => scheduled
2017-09-12 03:03 collazoandy4 Note Added: 0098961
2017-09-12 09:40 aferraz Relationship added related to 0025312
2017-09-12 09:40 aferraz Relationship added related to 0026951
2017-09-12 09:41 aferraz Relationship added related to 0033500
2017-09-20 11:31 aferraz Steps to Reproduce Updated View Revisions
2017-10-19 10:48 psanjuan Note Added: 0099957
2017-10-19 10:49 psanjuan Status scheduled => closed
2017-10-19 10:49 psanjuan Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker