*** red1 has joined #idempiere | 00:03 | |
*** is-mw has quit IRC | 00:13 | |
*** red1 has quit IRC | 00:51 | |
*** red1 has joined #idempiere | 02:53 | |
*** ChanServ sets mode: +o red1 | 02:53 | |
*** red1 has quit IRC | 03:12 | |
*** CarlosRuiz has joined #idempiere | 03:21 | |
*** ChanServ sets mode: +o CarlosRuiz | 03:21 | |
*** hieplq has joined #idempiere | 03:46 | |
*** CarlosRuiz has quit IRC | 03:49 | |
*** HansR42 has quit IRC | 04:53 | |
*** norbertbede has joined #idempiere | 04:57 | |
*** jmpiloq__ has joined #idempiere | 05:11 | |
*** Devastator has quit IRC | 05:14 | |
*** hieplq has quit IRC | 05:48 | |
*** jmpiloq__ has quit IRC | 06:10 | |
*** norbertbede has quit IRC | 06:24 | |
*** norbertbede has joined #idempiere | 06:40 | |
*** a42niem has joined #idempiere | 06:51 | |
*** nmicoud has joined #idempiere | 07:07 | |
*** HansR42 has joined #idempiere | 07:09 | |
*** KermitTheFragger has joined #idempiere | 07:33 | |
*** hieplq has joined #idempiere | 09:08 | |
*** is-mw has joined #idempiere | 09:12 | |
*** hieplq has quit IRC | 09:35 | |
*** is-mw2 has joined #idempiere | 10:02 | |
*** hieplq has joined #idempiere | 10:02 | |
*** is-mw has quit IRC | 10:03 | |
*** nmicoud_ has joined #idempiere | 10:12 | |
*** nmicoud has quit IRC | 10:14 | |
*** hieplq has quit IRC | 10:54 | |
*** hieplq has joined #idempiere | 12:18 | |
*** HansR42 has quit IRC | 12:28 | |
*** red1 has joined #idempiere | 12:45 | |
*** jbwiv has quit IRC | 12:58 | |
*** jbwiv has joined #idempiere | 12:59 | |
JanThielemann | nmicoud_ ayt? | 13:09 |
---|---|---|
nmicoud_ | yes | 13:10 |
JanThielemann | about your question in google groups | 13:11 |
JanThielemann | if you check a checkbox on the invoice header, you want that when you create invoice lines they all get the same tax id | 13:11 |
nmicoud_ | something like that yes | 13: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 header | 13:13 |
JanThielemann | that could be done with minor code modification | 13:13 |
*** CarlosRuiz has joined #idempiere | 13:14 | |
*** ChanServ sets mode: +o CarlosRuiz | 13:14 | |
JanThielemann | or maybe even without | 13:14 |
JanThielemann | in display logic of C_Tax_ID in C_InvoiceLine you could only display it if in header a checkbox is set to yes | 13:14 |
JanThielemann | also you could display a C_Tax_ID in C_Invoice if checkbox is set to yes | 13:15 |
JanThielemann | and then use the value from header (if available) as default value in line | 13:15 |
nmicoud_ | could be interesting, yes | 13:15 |
nmicoud_ | and no code, which is the most important: ) | 13:16 |
nmicoud_ | thanks for the tip ;) one less beer | 13:18 |
JanThielemann | @SQL=SELECT C_Tax_ID AS DefaultValue FROM C_InvoiceLine WHERE c_invoice_id = @C_Invoice_ID@ ORDER BY Line | 13:24 |
JanThielemann | as default logic works fine | 13:25 |
nmicoud_ | i think @C_Tax_ID@ should do the same | 13:26 |
nmicoud_ | as your statement should return nothing for the 1st line | 13:26 |
JanThielemann | i thought on the first line you can chose whatever you want | 13:32 |
nmicoud_ | yes | 13:32 |
JanThielemann | so if there is no line, you don't get a default value from the sql and chose whatever you want | 13:32 |
JanThielemann | on the second line you will get the value from the first line | 13:33 |
nmicoud_ | yes, but i think that the sql statement does the same as @C_Tax_ID@ | 13:33 |
JanThielemann | really? | 13:33 |
nmicoud_ | i think | 13:33 |
JanThielemann | i thought if i create a new entry it has it's own @C_Tax_ID@ in the context | 13:34 |
JanThielemann | not the one from the previously created line | 13:34 |
nmicoud_ | no, AFAIR, it will take the 'previous' value | 13:34 |
nmicoud_ | i mean, from the previous line | 13:34 |
JanThielemann | ah ok | 13:34 |
JanThielemann | i tested it and the context always shows me the tax id from the current entry | 13:43 |
nmicoud_ | and if you create a new line ? | 13:44 |
JanThielemann | so if i create one with tax id 106 and then create a new one where 104 is default, the context says 104 | 13:44 |
JanThielemann | and i didn't saved the entry yet | 13:44 |
JanThielemann | so maybe my sql is better :) | 13:44 |
nmicoud_ | i see :) | 13:44 |
JanThielemann | hmm | 13:52 |
JanThielemann | i tried to use a virtual column to count the lines and determine via context if tax field should be displayed | 13:52 |
JanThielemann | but when i create a new entry, my virtual column says 0 | 13:52 |
JanThielemann | the sql is (SELECT COUNT(il.C_Tax_ID) FROM C_InvoiceLine il WHERE il.C_Invoice_ID=C_InvoiceLine.C_Invoice_ID) | 13:53 |
JanThielemann | when i create a new entry, the C_Invoice_ID is already set but it seems that the virtual column is not refreshed | 13:53 |
nmicoud_ | refreshed when saving | 13:53 |
JanThielemann | therefore it says 0 instead of the real cound and i cant use it for hiding the field | 13:53 |
JanThielemann | no, look. i have 2 lines. virtual column says 2 | 13:54 |
JanThielemann | i create a new entry | 13:54 |
JanThielemann | virtual column says 0. after save it says 3 | 13:54 |
JanThielemann | i 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 it | 13:54 |
JanThielemann | nmicoud_: 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, thanks | 14:07 |
*** red1 has quit IRC | 15:01 | |
*** allgood has joined #idempiere | 15:05 | |
*** allgood has left #idempiere | 15:05 | |
*** CarlosRuiz has quit IRC | 15:31 | |
*** Devastator has joined #idempiere | 15:32 | |
*** Devastator has joined #idempiere | 15:32 | |
*** hieplq has quit IRC | 15:33 | |
*** a42niem_ has joined #idempiere | 15:35 | |
*** a42niem_ has left #idempiere | 15:37 | |
*** norbertbede has quit IRC | 15:42 | |
*** CarlosRuiz has joined #idempiere | 15:59 | |
*** ChanServ sets mode: +o CarlosRuiz | 15:59 | |
*** nmicoud_ has quit IRC | 16:10 | |
*** KermitTheFragger has quit IRC | 16:11 | |
*** hieplq has joined #idempiere | 16:26 | |
*** jbwiv has quit IRC | 16:41 | |
*** norbertbede has joined #idempiere | 16:44 | |
*** CarlosRuiz has quit IRC | 17:00 | |
*** norbertbede has joined #idempiere | 17:24 | |
Not-522e | [IDEMPIERE] hieplq created IDEMPIERE-2508 process non stop when enter continue to show info panel | 17:26 |
Not-522e | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2508 | 17:26 |
*** norbertbede has quit IRC | 18:43 | |
*** CarlosRuiz has joined #idempiere | 20:04 | |
*** ChanServ sets mode: +o CarlosRuiz | 20:04 | |
*** norbertbede has joined #idempiere | 20:28 | |
*** a42niem has quit IRC | 21:05 | |
*** hieplq has quit IRC | 22:05 | |
*** red1 has joined #idempiere | 22:18 | |
*** ChanServ sets mode: +o red1 | 22:26 | |
*** CarlosRuiz has quit IRC | 22:37 | |
*** CarlosRuiz has joined #idempiere | 22:39 | |
*** ChanServ sets mode: +o CarlosRuiz | 22:39 | |
*** CarlosRuiz has quit IRC | 22:47 | |
*** HansR42 has joined #idempiere | 23:01 | |
*** norbertbede has quit IRC | 23:58 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!