0015608: Error when using form of payment "Cash" and payment term with several lines

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015608

Openbravo ERP

03. Procurement management

public

2011-01-11 12:52

2011-01-19 00:00

Reporter

adrianromero

Assigned To

adrianromero

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

3.0RC3

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0015608: Error when using form of payment "Cash" and payment term with several lines

Description

When trying to complete an invoice using "Cash" form of payment and payment term with several lines you obtain this error:
Error:
inserción o actualización en la tabla «c_cashline» viola la llave foránea «c_cashline_c_debt_payment»

If Form of Payment of the invoice is "Bank deposit" instead of "Cash" than it complete successfully.

Steps To Reproduce

1. Master Data Management || Business Partner Setup || Payment Term || Header : create record with
   Offset Month Due=1
2. Master Data Management || Business Partner Setup || Payment Term || Header >> Lines : add 2 lines:
   one line --> Percentage=60 ; Overdue Payment Days Rule=5; Form of Payment=bank deposit ;
   another line --> Percentage=40 ; Overdue Payment Days Rule=1; Form of Payment=cash ;
3. Procurement Management || Transactions || Purchase Invoice || Header : create record setting Form of Payment=Cash and Payment Terms already created
4. Procurement Management || Transactions || Purchase Invoice || Header >> Lines : add one line
5. Come back to header and try to process. You will obtain error:
Error:
inserción o actualización en la tabla «c_cashline» viola la llave foránea «c_cashline_c_debt_payment»
6. Change Invoice header Form of Payment to "Bank deposit". Process and you will obtain successful message.

Problem is that C_INVOICE_POST makes this comprobation
"IF (v_paymentcheck <> 0) THEN"
before inserting c_debt_payment (line 1524), But it does not make it before inserting in c_cashline (line 1642)

Proposed Solution

Additional Information