summaryrefslogtreecommitdiff
path: root/import_account_move_line.ktr
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-11-17 08:50:28 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-11-17 08:50:28 +0700
commit7ebd4feeb5dcb847cffdfbf8937200fad00b6ba6 (patch)
tree95c042194c0e30302e51bbac27a763433a4cf76d /import_account_move_line.ktr
parent984ff84af0f042afafc0bfeee76f381d4558d9c6 (diff)
add where clause in account move
Diffstat (limited to 'import_account_move_line.ktr')
-rw-r--r--import_account_move_line.ktr2
1 files changed, 1 insertions, 1 deletions
diff --git a/import_account_move_line.ktr b/import_account_move_line.ktr
index 04082d0..0f58b0b 100644
--- a/import_account_move_line.ktr
+++ b/import_account_move_line.ktr
@@ -892,7 +892,7 @@
<sql>select aml.* from account_move_line aml
join account_move am on am.id = aml.move_id
where (am.move_type = 'out_invoice' or am.journal_id = 3)
---and aml.write_date >= (now() - '5 days'::interval)</sql>
+and aml.write_date >= (now() - '5 days'::interval)</sql>
<limit>0</limit>
<lookup/>
<execute_each_row>N</execute_each_row>