Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035339Openbravo ERP09. Financial managementpublic2017-02-22 12:582017-07-20 23:50
Reporterpsanjuan 
Assigned Tocollazoandy4 
PriorityurgentSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035339: Prepayment Amount shown / updated in the invoices is not correct for some scenarios.
DescriptionPrepayment Amount shown / updated in the invoices is not correct for some scenarios.
Steps To ReproduceGo to Sales order window and create a new one for F&B España, Alimentos y Supermercados busines partner.

Create a sales order line. Select any product. Enter quantity = 5, Unit price = 100.00. Use an exempt tax, therefore otal gross amount is 500.00 €

Book the order and pay it.

Go to sales invoice window and create a new one for F&B España, Alimentos y Supermercados business partner.

Use Create Lines from and select the order. Press OK.

Check that prepayment amount showns 500.00
Go to lines and change the quantity form 5 to 2. Complete the invoice.

Verify that prepayment amount shown is 500.00, that is not exactly correct as invoice gross amount is 200, therefore prepayment amount used and shown should be 200.00

Complete and Post the invocie.

Verify that customer prepayment ledger accounts correctly shows 200.00.

Once more, go to Sales Invoice window create a new one for the same partner. Use Create Lines from and select the order prepaid.
Verify that now the quantity shown in the lines is 3, and the prepayment amount shown is still 500.00 but that is not exactly correct as 200.00 have already being used for first invoice.
Proposed Solutiontbd
Additional Information
TagsNo tags attached.
Relationships
related to defect 0034993 closed Sanjota Prepayment amount value is not correctly updated after changing the Sales Invoice lines. 
related to defect 0036297 closed collazoandy4 Wrong schedule details information when Voiding an invoice which is prepaid via sales order 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-22 12:58psanjuanNew Issue
2017-02-22 12:58psanjuanAssigned To => Triage Finance
2017-02-22 12:58psanjuanModules => Core
2017-02-22 12:58psanjuanTriggers an Emergency Pack => No
2017-02-22 12:59psanjuanRelationship addedrelated to 0034993
2017-02-22 13:55psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14660#r14660
2017-07-04 09:24aferrazRelationship addedrelated to 0036297
2017-07-11 20:41collazoandy4Assigned ToTriage Finance => collazoandy4
2017-07-11 22:07collazoandy4Statusnew => scheduled
2017-07-20 23:50collazoandy4Note Added: 0098157
2017-07-24 15:57collazoandy4Note Edited: 0098157bug_revision_view_page.php?bugnote_id=0098157#r15543

Notes
(0098157)
collazoandy4   
2017-07-20 23:50   
(edited on: 2017-07-24 15:57)
Test Plan I
  As F&B International Group Admin Role
    Go to Sales order and create a new record for Alimentos y Supermercados, S.A bp and Invoice Terms: Immediate
      Create a new record in Lines tab:
        Product: Cerveza Ale 0,5L, Ordered Quantity: 10, Net Unit Price: 2
      Book the order and pay it
      Check Total Gross Amount 21.78
    Go to Sales Invoice and create a new record for Alimentos y Supermercados, S.A bp
      Create a lines from previous order without discount line
      Edit the line Invoiced Quantity: 2
      Complete the invoice and check Prepayment amout = 4.84 and Payment complete: Y
    Create another header in Sales Invoice window for Alimentos y Supermercados, S.A bp
      Create a lines from previous order including discount line
      Complete the invoice and check Prepayment amout = 16.94 and Payment complete: Y

Test Plan II
  As F&B Internation Group Admin Role
    Go to Sales order and create a new record for Alimentos y Supermercados, S.A bp and Invoice Terms: Immediate
      Create a new record in Lines tab:
        Product: Limonada 0,5L, Ordered Quantity: 5, Net Unit Price: 1
        Book the order and check Total Gross Amount: 5.45
        Add a payment with Actual Payment: 2
    Go to Sales Invoice window and create a new record for Alimentos y Supermercados, S.A bp
      Create a lines from previous order without the discount line
      Edit the line Invoiced Quantity: 2, Net Unit Price: 0.5
      Complete the invoice and check Prepayment amout = 1.21 and Payment complete: Y
    Create another header in Sales Invoice window for Alimentos y Supermercados, S.A bp
      Create a lines from previous order including discount line
      Complete the invoice and check Prepayment amout = 0.79 and Payment complete: N

Test Plan III
  As F&B Internation Group Admin Role
    Go to Sales order and create a new record for Alimentos y Supermercados, S.A bp and Invoice Terms: Immediate
      Create a new record in Lines tab:
        Product: Limonada 0,5L, Ordered Quantity: 5, Net Unit Price: 1
        Book the order and check Total Gross Amount: 5.45
        Add a payment with Actual Payment: 2
    Go to Sales Invoice window and create a new record for Alimentos y Supermercados, S.A bp
      Create a lines from previous order
      Edit the line Invoiced Quantity: 2, Net Unit Price: 4
      Complete the invoice and check Prepayment amout = 2 and Payment complete: N
    Create another header in Sales Invoice window for Alimentos y Supermercados, S.A bp
      Create a lines from previous order
      Complete the invoice and check Prepayment amout = 0 and Payment complete: N

Test Plan IV
  As F&B Internation Group Admin Role
    Go to Sales order and create a new record for Alimentos y Supermercados, S.A bp and Invoice Terms: Immediate
      Create a new record in Lines tab:
        Product: Zumo de Piña 0,5L, Ordered Quantity: 6, Net Unit Price: 1
        Book the order and check Total Gross Amount: 6.53
        Add a payment with Actual Payment: 4
    Go to Sales Invoice window and create a new record for Alimentos y Supermercados, S.A bp
      Create a lines from previous order
      Edit the line Invoiced Quantity: 2
      Complete the invoice and check Prepayment amout = 2.42 and Payment complete: Y
    Create another header in Sales Invoice window for Alimentos y Supermercados, S.A bp
      Create a lines from previous order
      Edit the line Invoiced Quantity: 2
      Complete the invoice and check Prepayment amout = 1.58 and Payment complete: N
    Create another header in Sales Invoice window for Alimentos y Supermercados, S.A bp
      Create a lines from previous order including discount line
      Edit the line Invoiced Quantity: 2
      Complete the invoice and check Prepayment amout = 0 and Payment complete: N

Test Plan V
  As F&B Internation Group Admin Role
    Go to Sales order and create a new record for Alimentos y Supermercados, S.A bp and Invoice Terms: Immediate
      Create a new record in Lines tab:
        Product: Limonada 0,5L Ordered Quantity: 10, Net Unit Price: 1
        Book the order and check Total Gross Amount: 10
        Pay the order
        Check Total Gross Amount: 10.89
    Create another header in Sales order window for Alimentos y Supermercados, S.A bp
      Create a new record in Lines tab:
        Product: Vino Blanco 0,75L Ordered Quantity: 5, Net Unit Price: 1.4
        Book the order and check Total Gross Amount: 7.62
        Add a payment with Actual Payment: 5
    Create another header in Sales order window for Alimentos y Supermercados, S.A bp
      Create a new record in Lines tab:
        Product: Vino Tinto 0,75L Ordered Quantity: 3, Net Unit Price: 4
        Book the order and check Total Gross Amount: 13.07
    Go to Sales Invoice window and create a new record for Alimentos y Supermercados, S.A bp
      Create a lines from the three previous order created including discounts lines
      Complete the invoice and check Prepayment amout = 15.89 and Payment complete: N

Test Plan VI
  Repeat the previous tests plan with negative Ordered Quantity

Test Plan VII
  As F&B Internation Group Admin Role
    Go to Sales order and create a new record for Alimentos y Supermercados, S.A bp
      Create a new record in Lines tab:
        Product: Limonada 0,5L Ordered Quantity: -10, Net Unit Price: 1
        Book the order and check Total Gross Amount: -10.89
        Pay the order
    Create another header in Sales order window for Alimentos y Supermercados, S.A bp
      Create a new record in Lines tab:
        Product: Vino Blanco 0,75L Ordered Quantity: 5, Net Unit Price: 1.4
        Book the order and check Total Gross Amount: 7.62
        Add a payment with Actual Payment: 5
    Create another header in Sales order window for Alimentos y Supermercados, S.A bp
      Create a new record in Lines tab:
        Product: Vino Tinto 0,75L Ordered Quantity: 3, Net Unit Price: 4
        Book the order and check Total Gross Amount: 13.07
    Go to Sales Invoice window and create a new record for Alimentos y Supermercados, S.A bp
      Create a lines from the three previous order created including discount lines
      Complete the invoice and check Prepayment amout = -3.27 and Payment complete: N