diff options
| -rw-r--r-- | calculate_margin_invoice_v2.ktr | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/calculate_margin_invoice_v2.ktr b/calculate_margin_invoice_v2.ktr index 83afda0..f145e2b 100644 --- a/calculate_margin_invoice_v2.ktr +++ b/calculate_margin_invoice_v2.ktr @@ -1166,7 +1166,8 @@ left join res_partner rp3 on rp3.id = tsol.vendor_id where aml.account_id in (466) and am.state = 'posted' and tso.state in ('sale', 'done') -and aml.date >= '2024-06-01' +--and aml.date >= '2024-06-01' +and aml.write_date >= (now() - '3 days'::interval) order by tsol.id</sql> <limit>0</limit> <lookup/> @@ -1623,7 +1624,7 @@ order by tsol.id</sql> </remotesteps> <GUI> <xloc>368</xloc> - <yloc>128</yloc> + <yloc>112</yloc> <draw>Y</draw> </GUI> </step> @@ -1658,7 +1659,8 @@ left join res_partner rp3 on rp3.id = tsol.vendor_id where aml.account_id in (462) and am.state = 'posted' and tso.state in ('sale', 'done') -and aml.date >= '2024-06-01' +--and aml.date >= '2024-06-01' +and aml.write_date >= (now() - '3 days'::interval) order by tsol.id</sql> <limit>0</limit> <lookup/> |