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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0022979
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2013-02-05 16:592013-05-02 19:06
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PriorityhighResolutionunable to reproduceFixed in Version
StatusclosedFix 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

0022979: When Processing a Payment with WriteOff associated to an Order and an Invoice it does not split well the PaymentScheduleDetails

DescriptionAn Order is created with a Line that has taxes.
An Invoice is created from the previous Order
A Payment is made with WriteOff amount.
When processing it, the Payment Schedule Details are not split correctly.
Steps To ReproduceLogin as Openbravo/openbravo

1. Create a Sales Order
  - In Sales Order Window create a new record with:
    - Organization: F&B US
    - Business Partner: Healthy Food
    - Invoice Terms: Immediate
  - Create a new Line with the values:
    - Product: Cola
    - Ordered Quantity: 100
    - Tax: CA Sales Tax
  - Book it

2. Create a Sales Invoice
  - In Sales Invoice Window create a new record with the values:
    - Organization: F&B US
    - Business Partner: Healthy Food
  - Click on Create Lines From and select all the lines from the previously created Order.
  - In Lines edit the Tax and set it to Exempt.
  - Complete it.

3. Create a Payment
  - In the same Invoice Window, click on Add Payment.
  - Set the Actual Payment as 60.00
  - Click on WriteOff the difference and Process it.

To check the Payment Schedule Details is necessary to do so in the Database, is this Invoice is the last one created, this query might help:

select *
from fin_payment_scheduledetail
where fin_payment_schedule_invoice =
  (select fin_payment_schedule_id
   from fin_payment_schedule
   where c_invoice_id =
     (select c_invoice_id
      from c_invoice
      order by created desc
      limit 1))

It should be only two lines instead of three, and one of them with the writeoffamt as 14.02.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0058446)
dmiguelez (developer)
2013-05-02 19:06

No longer reproducible.

- Issue History
Date Modified Username Field Change
2013-02-05 16:59 dmiguelez New Issue
2013-02-05 16:59 dmiguelez Assigned To => dmiguelez
2013-02-05 16:59 dmiguelez Modules => Core
2013-02-05 16:59 dmiguelez Triggers an Emergency Pack => No
2013-05-02 19:06 dmiguelez Note Added: 0058446
2013-05-02 19:06 dmiguelez Status new => closed
2013-05-02 19:06 dmiguelez Resolution open => unable to reproduce


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker