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)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

backport

0015498

2.50MP26

closed

dalsasua

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

Notes
(0033715) adrianromero (viewer) 2011-01-18 14:56	This issue is related with the old payments flow, so cannot be applied to 3.0

Issue History
Date Modified	Username	Field	Change
2011-01-11 12:52	adrianromero	New Issue
2011-01-11 12:52	adrianromero	Assigned To	=> adrianromero
2011-01-11 12:52	adrianromero	Modules	=> Core
2011-01-11 12:52	adrianromero	OBNetwork customer	=> Yes
2011-01-11 12:52	adrianromero	Issue generated from	0015498
2011-01-11 12:52	adrianromero	Relationship added	blocks 0015498
2011-01-11 12:55	adrianromero	Status	new => scheduled
2011-01-11 12:55	adrianromero	fix_in_branch	=> pi
2011-01-18 14:56	adrianromero	Note Added: 0033715
2011-01-18 14:56	adrianromero	Status	scheduled => closed
2011-01-18 14:56	adrianromero	Resolution	open => no change required
2011-01-19 00:00	anonymous	sf_bug_id	0 => 3161266