summaryrefslogtreecommitdiff
path: root/import_account_move.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.ktr
parent984ff84af0f042afafc0bfeee76f381d4558d9c6 (diff)
add where clause in account move
Diffstat (limited to 'import_account_move.ktr')
-rw-r--r--import_account_move.ktr2
1 files changed, 1 insertions, 1 deletions
diff --git a/import_account_move.ktr b/import_account_move.ktr
index a9b4ffe..333b706 100644
--- a/import_account_move.ktr
+++ b/import_account_move.ktr
@@ -1011,7 +1011,7 @@
<connection>erp indoteknik production (localhost)</connection>
<sql>select am.* from account_move am
where (am.move_type = 'out_invoice' or journal_id = 3)
---and am.write_date >= (now() - '5 days'::interval)</sql>
+and am.write_date >= (now() - '5 days'::interval)</sql>
<limit>0</limit>
<lookup/>
<execute_each_row>N</execute_each_row>