#idempiere IRC log for Tuesday, 2015-03-10

*** red1 has joined #idempiere00:03
*** is-mw has quit IRC00:13
*** red1 has quit IRC00:51
*** red1 has joined #idempiere02:53
*** ChanServ sets mode: +o red102:53
*** red1 has quit IRC03:12
*** CarlosRuiz has joined #idempiere03:21
*** ChanServ sets mode: +o CarlosRuiz03:21
*** hieplq has joined #idempiere03:46
*** CarlosRuiz has quit IRC03:49
*** HansR42 has quit IRC04:53
*** norbertbede has joined #idempiere04:57
*** jmpiloq__ has joined #idempiere05:11
*** Devastator has quit IRC05:14
*** hieplq has quit IRC05:48
*** jmpiloq__ has quit IRC06:10
*** norbertbede has quit IRC06:24
*** norbertbede has joined #idempiere06:40
*** a42niem has joined #idempiere06:51
*** nmicoud has joined #idempiere07:07
*** HansR42 has joined #idempiere07:09
*** KermitTheFragger has joined #idempiere07:33
*** hieplq has joined #idempiere09:08
*** is-mw has joined #idempiere09:12
*** hieplq has quit IRC09:35
*** is-mw2 has joined #idempiere10:02
*** hieplq has joined #idempiere10:02
*** is-mw has quit IRC10:03
*** nmicoud_ has joined #idempiere10:12
*** nmicoud has quit IRC10:14
*** hieplq has quit IRC10:54
*** hieplq has joined #idempiere12:18
*** HansR42 has quit IRC12:28
*** red1 has joined #idempiere12:45
*** jbwiv has quit IRC12:58
*** jbwiv has joined #idempiere12:59
JanThielemannnmicoud_ ayt?13:09
nmicoud_yes13:10
JanThielemannabout your question in google groups13:11
JanThielemannif you check a checkbox on the invoice header, you want that when you create invoice lines they all get the same tax id13:11
nmicoud_something like that yes13:12
nmicoud_you choose the tax_id on the first line and then, the field would be in readonly mode. or even better, the field would be put on the header13:13
JanThielemannthat could be done with minor code modification13:13
*** CarlosRuiz has joined #idempiere13:14
*** ChanServ sets mode: +o CarlosRuiz13:14
JanThielemannor maybe even without13:14
JanThielemannin display logic of C_Tax_ID in C_InvoiceLine you could only display it if in header a checkbox is set to yes13:14
JanThielemannalso you could display a C_Tax_ID in C_Invoice if checkbox is set to yes13:15
JanThielemannand then use the value from header (if available) as default value in line13:15
nmicoud_could be interesting, yes13:15
nmicoud_and no code, which is the most important: )13:16
nmicoud_thanks for the tip ;) one less beer13:18
JanThielemann@SQL=SELECT C_Tax_ID AS DefaultValue FROM C_InvoiceLine WHERE c_invoice_id = @C_Invoice_ID@ ORDER BY Line13:24
JanThielemannas default logic works fine13:25
nmicoud_i think @C_Tax_ID@ should do the same13:26
nmicoud_as your statement should return nothing for the 1st line13:26
JanThielemanni thought on the first line you can chose whatever you want13:32
nmicoud_yes13:32
JanThielemannso if there is no line, you don't get a default value from the sql and chose whatever you want13:32
JanThielemannon the second line you will get the value from the first line13:33
nmicoud_yes, but i think that the sql statement does the same as @C_Tax_ID@13:33
JanThielemannreally?13:33
nmicoud_i think13:33
JanThielemanni thought if i create a new entry it has it's own @C_Tax_ID@ in the context13:34
JanThielemannnot the one from the previously created line13:34
nmicoud_no, AFAIR, it will take the 'previous' value13:34
nmicoud_i mean, from the previous line13:34
JanThielemannah ok13:34
JanThielemanni tested it and the context always shows me the tax id from the current entry13:43
nmicoud_and if you create a new line ?13:44
JanThielemannso if i create one with tax id 106 and then create a new one where 104 is default, the context says 10413:44
JanThielemannand i didn't saved the entry yet13:44
JanThielemannso maybe my sql is better :)13:44
nmicoud_i see :)13:44
JanThielemannhmm13:52
JanThielemanni tried to use a virtual column to count the lines and determine via context if tax field should be displayed13:52
JanThielemannbut when i create a new entry, my virtual column says 013:52
JanThielemannthe sql is (SELECT COUNT(il.C_Tax_ID) FROM C_InvoiceLine il WHERE il.C_Invoice_ID=C_InvoiceLine.C_Invoice_ID)13:53
JanThielemannwhen i create a new entry, the C_Invoice_ID is already set but it seems that the virtual column is not refreshed13:53
nmicoud_refreshed when saving13:53
JanThielemanntherefore it says 0 instead of the real cound and i cant use it for hiding the field13:53
JanThielemannno, look. i have 2 lines. virtual column says 213:54
JanThielemanni create a new entry13:54
JanThielemannvirtual column says 0. after save it says 313:54
JanThielemanni thought you could use the virtual column to hide C_Tax_ID after the first line is created but this apparently does not work as i expected it13:54
JanThielemannnmicoud_: You could create a column C_Tax_ID on C_Invoice and a checkbox isSingleTax. Then you could use @0|C_Tax_ID@ as default logic for C_Tax_ID on C_InvoiceLine. To hide the field you could use "@0|IsSingleTax@ = 'N' as display logic for the tax field.14:07
nmicoud_yes, it will work, thanks14:07
*** red1 has quit IRC15:01
*** allgood has joined #idempiere15:05
*** allgood has left #idempiere15:05
*** CarlosRuiz has quit IRC15:31
*** Devastator has joined #idempiere15:32
*** Devastator has joined #idempiere15:32
*** hieplq has quit IRC15:33
*** a42niem_ has joined #idempiere15:35
*** a42niem_ has left #idempiere15:37
*** norbertbede has quit IRC15:42
*** CarlosRuiz has joined #idempiere15:59
*** ChanServ sets mode: +o CarlosRuiz15:59
*** nmicoud_ has quit IRC16:10
*** KermitTheFragger has quit IRC16:11
*** hieplq has joined #idempiere16:26
*** jbwiv has quit IRC16:41
*** norbertbede has joined #idempiere16:44
*** CarlosRuiz has quit IRC17:00
*** norbertbede has joined #idempiere17:24
Not-522e[IDEMPIERE] hieplq created IDEMPIERE-2508 process non stop when enter continue to show info panel17:26
Not-522e[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-250817:26
*** norbertbede has quit IRC18:43
*** CarlosRuiz has joined #idempiere20:04
*** ChanServ sets mode: +o CarlosRuiz20:04
*** norbertbede has joined #idempiere20:28
*** a42niem has quit IRC21:05
*** hieplq has quit IRC22:05
*** red1 has joined #idempiere22:18
*** ChanServ sets mode: +o red122:26
*** CarlosRuiz has quit IRC22:37
*** CarlosRuiz has joined #idempiere22:39
*** ChanServ sets mode: +o CarlosRuiz22:39
*** CarlosRuiz has quit IRC22:47
*** HansR42 has joined #idempiere23:01
*** norbertbede has quit IRC23:58

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