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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035339
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 09. Financial managementmajoralways2017-02-22 12:582017-07-20 23:50
ReporterpsanjuanView Statuspublic 
Assigned Tocollazoandy4 
PriorityurgentResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
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

0035339: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0034993 closedSanjota Prepayment amount value is not correctly updated after changing the Sales Invoice lines. 
related to defect 0036297 closedcollazoandy4 Wrong schedule details information when Voiding an invoice which is prepaid via sales order 

-  Notes
(0098157)
collazoandy4 (reporter)
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

- Issue History
Date Modified Username Field Change
2017-02-22 12:58 psanjuan New Issue
2017-02-22 12:58 psanjuan Assigned To => Triage Finance
2017-02-22 12:58 psanjuan Modules => Core
2017-02-22 12:58 psanjuan Triggers an Emergency Pack => No
2017-02-22 12:59 psanjuan Relationship added related to 0034993
2017-02-22 13:55 psanjuan Steps to Reproduce Updated View Revisions
2017-07-04 09:24 aferraz Relationship added related to 0036297
2017-07-11 20:41 collazoandy4 Assigned To Triage Finance => collazoandy4
2017-07-11 22:07 collazoandy4 Status new => scheduled
2017-07-20 23:50 collazoandy4 Note Added: 0098157
2017-07-24 15:57 collazoandy4 Note Edited: 0098157 View Revisions

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker