Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0012813 | Openbravo ERP | Z. Others | public | 2010-03-26 07:49 | 2010-12-09 16:00 |
|
| Reporter | sureshbabu | |
| Assigned To | mirurita | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | |
| Product Version | 2.50 | |
| Target Version | | Fixed in Version | 2.50 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Advanced Payables and Receivables Mngmt |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0012813: Amount column value mismatches in FIN_Payment & FIN_Payment_Detail |
| Description | i created a two invoices each of invoice amount for 52.20 euros for BP: Mc Givers.
Then i created Payment document using Make Payment window(Procurement Management || Transactions || Make Payment || Header), by adding a invoice document of payment amount 52.20.
Then i verified the amount column in both the tables FIN_Payment, FIN_Payment_Detail using the below query
select Amount from FIN_Payment where documentno='700000';
Select sum(amount) from FIN_Payment_Detail where FIN_PAYMENT_ID IN (select FIN_PAYMENT_ID from FIN_Payment where documentno='700000');
Both shows the same amount.(52.2)
But later i "Reactivated" the above payment document and added one more purchase invoice of payment amount 52.20(Now there are two lines in lines tab)
Then i executed the below query but i am finding the difference in sum of amount
select Amount from FIN_Payment where documentno='700000'; (Result: 52.2)
Select sum(amount) from FIN_Payment_Detail where FIN_PAYMENT_ID IN (select FIN_PAYMENT_ID from FIN_Payment where documentno='700000'); (Result: 102.4)
|
| Steps To Reproduce | |
| Proposed Solution | |
| Additional Information | |
| Tags | Advance Rec & Payables |
| Relationships | |
| Attached Files |  Make payment is reactivated and addd one more invoice document.JPG (85,590) 2010-03-26 07:49
https://issues.openbravo.com/file_download.php?file_id=2385&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2010-03-26 07:49 | sureshbabu | New Issue | |
| 2010-03-26 07:49 | sureshbabu | File Added: Make payment is reactivated and addd one more invoice document.JPG | |
| 2010-03-26 07:49 | sureshbabu | OBNetwork customer | => No |
| 2010-03-26 08:01 | sureshbabu | Tag Attached: Advance Rec & Payables | |
| 2010-03-26 08:01 | sureshbabu | Assigned To | => gorkaion |
| 2010-04-13 11:50 | gorkaion | Status | new => scheduled |
| 2010-04-13 11:50 | gorkaion | Note Added: 0026121 | |
| 2010-04-13 11:50 | gorkaion | Assigned To | gorkaion => mirurita |
| 2010-04-13 11:50 | gorkaion | fix_in_branch | => pi |
| 2010-04-22 13:18 | mirurita | Note Added: 0026570 | |
| 2010-04-22 13:18 | mirurita | Status | scheduled => resolved |
| 2010-04-22 13:18 | mirurita | Resolution | open => fixed |
| 2010-04-28 11:14 | sureshbabu | Note Added: 0026748 | |
| 2010-04-28 11:14 | sureshbabu | Status | resolved => closed |
| 2010-04-28 11:14 | sureshbabu | Fixed in Version | => 2.50 |
| 2010-12-09 16:00 | anonymous | sf_bug_id | 0 => 3133086 |