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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037206
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2017-11-02 08:172017-11-15 20:40
ReporterAtulOpenbravoView Statuspublic 
Assigned Tocollazoandy4 
PrioritynormalResolutionopenFixed in Version
StatusscheduledFix 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

0037206: Wrong outstanding amount after voiding a partial prepaid sales invoice

DescriptionWhen a partially prepaid sales invoice is voided, its outstanding amount is wrongly set in the invoice header as well as payment plan.

Same is the case in purchase flow.
Steps To Reproduce- Register Sales Order for "Restaurantes Luna Llena, S.A." in "F&B España, S.A" organization and Invoice terms=immediate
- Add new line for product "Vino Blanco 0,75L", price=100 and tax= Entregas IVA 21%
- Process order. Total Gross Amount = 114.95
- Run Add payment to partially a the order for eg:-100.00
- Register Sales Invoice for "Restaurantes Luna Llena, S.A.", run "create lines from" and select one line. Process invoice.
- Realize that Invoice Amount = 114.95, Total Paid = 100.00, Outstanding amount = 14.95
- Post the invoice. Realize that posting is correct

  Customer Prepayment Account = 100.00 Debit
  Customer Account = 14.95 Debit
  Product Revenue = 100.00 Credit For Products
  Product Revenue = 5.00 Debit For Discount
  Tax Due = 19.95 Credit

- Void the Sales Invoice.
- Realize that original Invoice outstanding amount is negative and wrong. Navigate to payment plan, Outstanding amount is negative and wrong.

This amount is exactly the negative value of the (invoice amount - prepaid amount)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0036297 closedcollazoandy4 Wrong schedule details information when Voiding an invoice which is prepaid via sales order 
related to defect 0028527 newTriage Omni OMS Wrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added. 

-  Notes
(0100536)
collazoandy4 (reporter)
2017-11-15 20:40

 Test Plan
  Go to Sales Order window and create a new record:
    Bussines Partner: Alimentos y Supermercados, S.A
    Invoice Terms: Immediate
    Create a new record in Lines tab:
      Product: Agua sin Gas 1L Ordered Quantity: 10
    Book the order
    Add payment of 10.00
  Go to Sales Invoice and create a new record for Alimentos y Supermercados, S.A
    Create lines from previous order
    Complete the invoice and check:
      Payment complete: No
      Prepayment amount: 10.00
    Go to Payment Plan tab and check:
      Number of payment: 1 Expected amount: 16.66 Received amount: 10.00 Outstanding amount: 6.66
    Go to Payment Details tab and check:
      Received amount: 16.66 Amount: 10.00
    Void the invoice and check:
      Payment complete: Yes
      Prepayment amount: 0.00
    Go to Payment Plan tab and check:
      Number of payment: 1 Expected amount: 16.66 Received amount: 16.66 Outstanding amount: 0.00
    Go to Payment Details tab and check:
      Received amount: 10.00 Amount: 16.66
  Go to the reversed invoice and check:
    Payment complete: Yes
    Prepayment amount: 0.00
    Go to Payment Plan tab and check:
      Number of payment: 1 Expected amount: -16.66 Received amount: -16.66 Outstanding amount: 0.00
    Go to Payment Details tab and check:
      Received amount: -16.66 Amount: -16.66
  Go to Payment In window and check a new dummy payment was created:
    Amount: 0
    Go to Lines tab and check that have two lines one asociated to the reversed and the other to the original invoice
  Go to the previous order created and pay it with an amount of 6.66
  Go to Sales Invoice and create a new record for Alimentos y Supermercados, S.A
    Create lines from previous order
    Complete the invoice and check:
      Payment complete: Yes
      Prepayment amount: 16.66
    Go to Payment Plan tab and check:
      Number of payment: 2 Expected amount: 16.66 Received amount: 16.66 Outstanding amount: 0.00
    Go to Payment Details tab and check:
      Received amount: 6.66 Amount: 16.66
      Received amount: 10.00 Amount: 16.66
    Void the invoice and check:
      Payment complete: Yes
      Prepayment amount: 0.00
    Go to Payment Plan tab and check:
      Number of payment: 1 Expected amount: 16.66 Received amount: 16.66 Outstanding amount: 0.00
    Go to Payment Details tab and check:
      Received amount: 6.66 Amount: 16.66
      Received amount: 10.00 Amount: 16.66
  Go to the reversed invoice and check:
    Payment complete: Yes
    Prepayment amount: 0.00
    Go to Payment Plan tab and check:
      Number of payment: 1 Expected amount: -16.66 Received amount: -16.66 Outstanding amount: 0.00
    Go to Payment Details tab and check:
      Received amount: -16.66 Amount: -16.66
  Go to Payment In window and check a new dummy payment was created:
    Amount: 0
    Go to Lines tab and check that have three lines one asociated to the reversed invoiced and the other two to the original invoice

- Issue History
Date Modified Username Field Change
2017-11-02 08:17 AtulOpenbravo New Issue
2017-11-02 08:17 AtulOpenbravo Assigned To => Triage Finance
2017-11-02 08:17 AtulOpenbravo Modules => Core
2017-11-02 08:17 AtulOpenbravo Triggers an Emergency Pack => No
2017-11-02 08:17 AtulOpenbravo Relationship added related to 0036297
2017-11-02 08:18 AtulOpenbravo Relationship added related to 0028527
2017-11-02 08:19 AtulOpenbravo Steps to Reproduce Updated View Revisions
2017-11-13 15:09 collazoandy4 Assigned To Triage Finance => collazoandy4
2017-11-13 23:26 collazoandy4 Status new => scheduled
2017-11-15 20:40 collazoandy4 Note Added: 0100536

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker