Ray Carnes vcloud9ray

Functional and Technical Lead for Odoo Implementations. Analysis, Design, Implementation and Maintenance of Odoo Systems.

vcloud9ray / fiduciary_automated_action.py

Last active August 30, 2017 23:53

Odoo. UI. Automated Action to update Fiduciary if Override is used.

	query = "update res_partner set commercial_partner_id =" + str(object.x_commercial_partner_id.id) + " where id = " + str(object.id) + ";"
	env.cr.execute(query)

	# Execute Python Code Action based on an Automated Action listening for UPDATES to res.partner
	# Add x_commercial_partner_id with appropriate group restricted view

vcloud9ray / delete_transactions.sql

Last active December 7, 2017 17:55

Odoo. SQL. Clean up a database with transactions in it.

	delete from crm_lead;

	delete from purchase_order_line;
	delete from purchase_order;

	delete from sale_order_line;
	delete from sale_order;

	delete from procurement_order;
	delete from procurement_group;

vcloud9ray / res.partner.py

Last active August 25, 2017 17:20

Odoo. ORM. res.partner. Set fiscal position to Tax Exempt when Country is not United States

	@api.onchange('country_id')
	def _onchange_country(self):
	usa_country_id = self.env['res.country'].search([('name','=','United States')]).id
	tax_exempt_fiscal_position = self.env['account.fiscal.position'].search([('name', '=', 'Tax Exempt')])
	for record in self:
	if record.country_id.id != usa_country_id :
	record.property_account_position_id = tax_exempt_fiscal_position