Skip to content

Instantly share code, notes, and snippets.

@syci

syci/update_charts.sql

Created February 19, 2018 21:17
Show Gist options
  • Save syci/8d7e9d7d02208843bf478621a2dbe390 to your computer and use it in GitHub Desktop.
Save syci/8d7e9d7d02208843bf478621a2dbe390 to your computer and use it in GitHub Desktop.
Download ZIP
Update Account Chart Odoo SQL
Raw
update_charts.sql
update account_account set code=substring(code from 1 for 4) || '00'|| substring(code from 5 for 2) where char_length(code) = 6;
# Ponemos las cuentas en Odoo a 8 dígitos si no lo están
# Lo pasa a 8, si quiere ponerlos a 9 concatena '000' en lugar de '00'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment