Odoo Tutorials

Import Bank Account Statements from CSV with Raw Data (No QIF File Required)

Import bank statements and reconcile them easily. If you don't know what a .qif file is or cannot get one from your bank, you don't need one. Simply dump the raw data from your bank account history in online banking and format it the way I show you in the video.

How to Automatically Backup your Database

How to backup your database automatically every day and send it to a remote server. You can choose to backup just the data or the data and the filestore. Warning: backing up the filestore will require sufficient space on your server for all of those files being inserted in the backup .zip file. The auto_backup module by Yenthe Van Ginneken is available for free in the Odoo app store: https://www.odoo.com/apps/modules/10.0/auto_backup/. There is a version of OpenERP 6 and Odoo 8, 9, 10, and 11.

How to Use Developer Mode

This video details how and why one should activate the developer mode in Odoo 10. The video also explains how to find fields and models for customizing reports, running sql queries, developing custom modules and much more. The developer mode can be activated by clicking the "Activate Developer Mode" link on the main settings page in Odoo 10 Community and Odoo 10 Enterprise. Once active, the developer mode provides tooltips that come up when mousing over field labels in forms. These tooltips give quick access to technical details about that field such as it's model (object), related fields (if there are any), technical field name for reports and custom modules, etc.

Multi-currency Purchasing and Accounting

This video shows the inexperienced Odoo user how to activate multi-currnency, set up currency rates, assign currencies to your suppliers, create a purchase order to the supplier in a different currency than your base currency, receive product into stock and create and pay the invoice. We examine the journal entries: currency conversion, exchange rate account and how the entries will reflect the currency of your vendor but the accounting will always be in your company's currency.

• Turn on Multi-Currency: Accounting > Configuration > Settings > Currencies
• Set up currency rates: Accounting > Configuration > Multi-Currencies > Currencies
• Assign currencies to suppliers: Purchases > Vendors > Sales and Purchase (tab) > Supplier Currency
• Create PO and add supplier. Watch the currency change to that of the supplier
• Receive goods from supplier and invoice
• Pay the invoice and inspect the journal entries
• The invoice and payment journal entries will be shown in the supplier's currency but your books will reflect them in your base currency