#idempiere IRC log for Tuesday, 2017-04-18

*** Guest49867 has quit IRC00:07
*** maziz has joined #idempiere03:51
*** maziz has quit IRC05:23
*** a42niem has joined #idempiere05:54
*** nmicoud has joined #idempiere06:01
*** a42niem has quit IRC07:26
*** a42niem has joined #idempiere07:26
*** maziz has joined #idempiere07:48
*** CarlosRuiz has joined #idempiere11:41
*** maziz has quit IRC11:44
Not-d2bc[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-334411:46
Not-d2bc[IDEMPIERE] Thanks [~Denis Kuznetsov], I would suggest to implement that in the iDempiere way using @ like context variables, and then using the Env.parseVariable methods passing the MFactAcct as the PO parameter. Regards, Carlos Ruiz11:46
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334411:47
Not-d2bc[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3342 description set to "We can create some GL_Category for one DocBaseType in "Document Type" window and for each GL_Category create one Document Type. For example: No --- DocType --- GL_Category --- DocBaseType 1 --- Allocation --- AP Cash/Payments --- CMA 2 --- Allocation-2 --- AP Cash/Payments-2 --- CMA Then we create document Allocation with doctype =11:50
Not-d2bc"Allocation-2". When we post this document into fact_acct creates lines with GL_Category_ID = "AP Cash/Payments", but it is wrong, because must be GL_Category_ID = "AP Cash/Payments-2". ___________________ Error in Doc.java class in method "public void setDocumentType (String DocumentType)" The solution is: // We have a document Type, but no GL info - search for DocType if (m_GL_Category_ID == 0) { String sql =11:50
Not-d2bc"SELECT GL_Category_ID FROM C_DocType " + "WHERE AD_Client_ID=? AND DocBaseType=?"; + if (getC_DocType_ID() > 0) + sql = sql + " AND C_DocType_ID = ?"; PreparedStatement pstmt = null; ResultSet rsDT = null; try {"11:50
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334211:50
Not-d2bc[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3342 environment set to "None"11:50
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334211:50
Not-d2bc[iDempiere] CarlosRuiz_globalqss pushed 2 commits to release-4.1 [+0/-0/±5] https://bitbucket.org/idempiere/idempiere/commits/12:12
Not-d2bc[iDempiere] globalqss caeaae0 - IDEMPIERE-3338 Document Status Indicator / credits as suggested by Steven Sackett12:12
Not-d2bc[iDempiere] globalqss c0309f3 - IDEMPIERE-3342 In posting, when selecting a GL Category, the type of document is not taken into account.12:12
Not-d2bc[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3342 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Fixed"12:12
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334212:12
Not-d2bc[iDempiere4.1] jenkins built #95 completed (success) http://ci.idempiere.org/job/iDempiere4.1/95/12:37
*** jdpaniagua has quit IRC12:42
*** jdpaniagua has joined #idempiere13:02
Not-d2bc[IDEMPIERE] alan.lesc1 created IDEMPIERE-3345 Interest amount in Payment/Allocation16:02
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334516:02
*** nmicoud has quit IRC16:20
Not-d2bc[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-334516:28
Not-d2bc[IDEMPIERE] Hi [~alan.lesc1], does the "Allocate to charge" solves the problem? http://wiki.idempiere.org/en/NF1.0_Allocate_Payment_To_Charge16:28
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334516:28
Not-d2bc[IDEMPIERE] alan.lesc1 updated IDEMPIERE-3345 Attachment set to "2017-04-18_IDEMPIERE-3345.patch"17:06
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334517:06
Not-d2bc[IDEMPIERE] alan.lesc1 updated IDEMPIERE-3345 labels set to "+Patch"17:06
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334517:06
Not-d2bc[IDEMPIERE] alan.lesc1 updated IDEMPIERE-334517:27
Not-d2bc[IDEMPIERE] Hi [~carlosruiz_globalqss] This patch covers a case when the interest is an additional amount for a specific invoice payment, and makes more sense to tie it to that invoice. We should be able to see how much interest was allocated to a invoice, in the same way we do with discounts and write off, Furthermore, automatic bank reconciliation would be a problem because we would have 1 transactions in the real17:27
Not-d2bcbank account, but 2 in iDempiere. Allocate payment to charge is an useful feature for many other user cases. What do you think?17:27
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334517:27
Not-d2bc[IDEMPIERE] alan.lesc1 updated IDEMPIERE-334517:54
Not-d2bc[IDEMPIERE] [~carlosruiz_globalqss], this feature is partially implemented in the window Bank Statement. It is possible to add an interest amount there. But it's impracticable in automated payment means, and in automatic bank reconciliation. This patch just takes the interest amount to payment/allocation, creating a more dynamic way to insert that information17:54
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334517:54
Not-d2bc[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-334517:55
Not-d2bc[IDEMPIERE] Thanks [~alan.lesc1] for the explanation. Let me try a possible second approach. What about something like C_ChargeWriteOff_ID. In my head I think it can work something like this: - at this moment write off amount is posted against a configured account in BP Group - with my idea if the write-off field has a value then the user can optionally fill a charge in the new field C_ChargeWriteOff_ID - if there is17:55
Not-d2bca charge write off - then the account used for write-off will be that one, otherwise will default to the same that we're using now What is the advantage of this? In my opinion is because you just found one of the cases where a payment/receipt can generate a valid difference, interests, but there are other cases where you can receive (or pay) more or less money for different reasons. With the charge-write-off approach17:55
Not-d2bcwe would cover ANY case, instead of requiring to add new fields for different cases. Look that in your implementation you have an issue because the interest revenue account you are using is about the bank interests, and this kind of interest from due invoices must go to a different account, that can be solved instead with the charge approach as you configure your interest revenue or interest expense charges properly.17:55
Not-d2bcWDYT? Regards, Carlos Ruiz17:55
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334517:55
Not-d2bc[IDEMPIERE] alan.lesc1 updated IDEMPIERE-334518:05
Not-d2bc[IDEMPIERE] Yes, you are right about the bank interest account. It would be necessary additional ones. Great idea about the C_ChargeWriteOff_ID. I will spend some time on this matter. Maybe the interest field, should be implemented only in the brazilian localization18:05
Not-d2bc[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-334518:05
*** CarlosRuiz has quit IRC21:20
*** a42niem has quit IRC21:27

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!