Skip to Content
This question has been flagged
pythoninvoiceaccount.movehelp
2 Replies
2805 Views
Avatar
Diana

Hi everyone. 

I have a custom module name ''timbrados'', wich have 2 dates. DATEA1 AND DATEB1 and a integer field value = '154258'

what i want is to compare the dates on TIMBRADOS with the dates on ACCOUNT.MOVE

if dateA1<= INVOICEDATE1 and dateB1>= INVOICEDATE2

if the condition is true, i need to add that value from ''timbrados'' in the account.move form


i know it is about some python function but I'm a newbie on this and i dont know where to begin


Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

If the fields are of type date, you can directly compare the values.

eg: if self.date_field_1 <= self.date_field_2:
# Write the code

If you want to add integer with field of type date, you should import relativedelta as shown below.

from datetime import date
from dateutil.relativedelta import relativedelta

value = 10
self.date_field_1 = date.today()
self.date_field_2 = self.date_field_1 + relativedelta(days=value)

Now the value of field date_field_2 will be date_field_1 + 10 days

Regards

Avatar
Discard
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hello, Diana

I hope you are doing well.

- You can compare two dates with a simple if function as shown in the example below.

Find Code in Comment. 

Hope, This will help you.

Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari 

Avatar
Discard
Jainesh Shah(Aktiv Software)

Example:
So, You can write like this, in function in which you want to update your custom field:

You have two dates e.g. dateA1 and dateB1

def function_name(self):
custom_module_records = self.env[model].search([])
for record in custom_module_records:
for invoice in self:
if record.dateA1<= invoice.INVOICEDATE and record.dateB1>= invoice.INVOICEDATE:
invoice.update({'field':record.custom_field })

FYI:
model: Custom module records.
field: account.move's field that you want to update.
custom_field: custom module's field which you want to update in account.move.

Related Posts Replies Views Activity
receivable amount not updated (move not balanced) after adding new tax line
invoice balance account.move
Avatar
0
Feb 24
594
Auto generate invoice attachment
python invoice api
Avatar
Avatar
1
Mar 23
1055
Error in studio domain
invoice account.move studio
Avatar
Avatar
1
Feb 23
751
Create invoice via xmlrpc Solved
python invoice xmlrpc
Avatar
Avatar
1
Nov 22
1889
Creating invoice in accounting module
invoice account.move sale.order
Avatar
Avatar
1
Aug 21
2329