0002938: Copy From Settlement does not work

Description

It fails during execution due to empty not null columns on insertion.

The solution, in my opinion:

CopyFromSettlement_data.xsql

28,7 â†’ 28,7
ON THE MAIN SELECT INCLUDE:
status_initial as status,

77,8 â†’ 77,8
NOT THIS:
INSERT INTO C_DEBT_PAYMENT ( C_DEBT_PAYMENT_ID, AD_CLIENT_ID, AD_ORG_ID,CREATEDBY, UPDATEDBY, ISRECEIPT,
C_SETTLEMENT_GENERATE_ID,DESCRIPTION, C_BPARTNER_ID, C_CURRENCY_ID, C_BANKACCOUNT_ID,C_CASHBOOK_ID,
PAYMENTRULE, AMOUNT, WRITEOFFAMT, DATEPLANNED, ISMANUAL,GLITEMAMT,C_GLITEM_ID, ISDIRECTPOSTING, ISPAID,ISVALID)
VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),TO_NUMBER(?),TO_DATE(?),?,0,TO_NUMBER(?),?,'N','N')

BUT THIS:
INSERT INTO C_DEBT_PAYMENT ( C_DEBT_PAYMENT_ID, AD_CLIENT_ID, AD_ORG_ID,CREATEDBY, UPDATEDBY, ISRECEIPT,
C_SETTLEMENT_GENERATE_ID,DESCRIPTION, C_BPARTNER_ID, C_CURRENCY_ID, C_BANKACCOUNT_ID,C_CASHBOOK_ID,
PAYMENTRULE, AMOUNT, WRITEOFFAMT, DATEPLANNED, ISMANUAL,GLITEMAMT,C_GLITEM_ID, ISDIRECTPOSTING, ISPAID,ISVALID, STATUS, STATUS_INITIAL)
VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),TO_NUMBER(?),TO_DATE(?),?,0,TO_NUMBER(?),?,'N','N',?,?)
]]>
</Sql>
<Parameter name="cDebtPeymentId"/>

INCLUDE TWO MORE PARAMETERS
100,6 â†’ 100,8
<Parameter name="status"/>
<Parameter name="status"/>

CopyFromSettlement.java
122,7 â†’ 122,9
NOT THIS:
CopyFromSettlementData.insertDebtPayment(conn,this, strDebtPayment, to[0].client, to[0].org, vars.getUser(), data[i].isreceipt, strSettlement, data[i].description, strCBPartnerId, data[i].cCurrencyId, data[i].cBankaccountId, data[i].cCashbookId, data[i].paymentrule, strImporte, data[i].writeoffamt, strDate, data[i].ismanual, data[i].cGlitemId, data[i].isdirectposting);
BUT THIS:
CopyFromSettlementData.insertDebtPayment(conn,this, strDebtPayment, to[0].client, to[0].org, vars.getUser(), data[i].isreceipt, strSettlement, data[i].description, strCBPartnerId, data[i].cCurrencyId, data[i].cBankaccountId, data[i].cCashbookId, data[i].paymentrule, strImporte, data[i].writeoffamt, strDate, data[i].ismanual, data[i].cGlitemId, data[i].isdirectposting, data[i].status);

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

0003699

closed

cromero

Copy From Settlement does not work

Notes
(0003637) cromero (viewer) 2008-04-28 10:41 edited on: 2008-06-12 09:26	Logged In: YES user_id=1500614 Originator: NO Inserted status should be the initial status that the payment had.

(0003638) cromero (viewer) 2008-05-06 02:20 edited on: 2008-06-12 09:26	Logged In: YES user_id=1500614 Originator: NO Fixed in the trunk in revision 3956

(0006527) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1951949 [^]

Issue History
Date Modified	Username	Field	Change
2008-07-08 10:45	psarobe	Status	resolved => closed
2008-07-08 10:45	psarobe	Fixed in Version	2.40alpha-r2 => 2.40beta