Enhancement on Odoo 16

Odoo 16, launch date, October 12, 2022, comes with various exciting features that will take business centralization to next level. Let’s review it as below.

  • Accounting Module

The accounting module in Odoo 16 has been enhanced with the addition of several new tools and features. The ‘Warning/alert‘ function allows you to control customer credit limitations for sales and invoicing immediately.

COA, contacts, entries, and so forth may be readily imported into Odoo’s integrated system.

—> Top Industrial Usecase: Financial sectors such as Investment bankers can get benefitted from new updates in the Accounting module.

  • Knowledge App

This module is much like a knowledge or information-sharing hub, which is the most demanded feature in Odoo 16. Employees can add business proposals, create important documents, and share among their colleagues that will benefit all. 

A user can separate his/her documents based on FavoritesWorkspaces, and Private mode.

—> Top Industrial Usecase: Dealing with multiple documents between wholesalers and customers will help the retail industry to make peace with the Knowledge app by streamlining all documents in one place.

  • Website Builder

Odoo 16 has combined both the front-end and back-end of the Website module to provide an identical user experience, allowing for more customization.

It will improve the user experience of creating and customizing a website without knowing hard-core coding.

—> Top Industrial Usecase: Manufacturing e-commerce industry to design and manage their websites easily. They can represent their products on their website with easy customization.

Do you need to enhance your manufacturing business with Odoo? Consult now for FREE!

  • Coupons, Promotions, & Discounts

These functions are now developed and implemented in Odoo version 16. Coupons, promotions, and discounts can be simply accessible and controlled on your website from the centralized platform. These are suitable for POS (Point of Sale), Sales Orders, and eCommerce.

Odoo 16 has an e-wallet capability. Gift vouchers will be available for Sales Orders as well.

—> Top Industrial Usecase: Food and beverage industry can utilize this feature to market their products and promote their brands.

  • MRP Module

One of the most essential elements of MRP is the ability for users to combine and divide manufacturing orders, which allows for seamless manufacturing management and well-organized planning.

Using the link provided with the Sales Order, the customer may follow the status of the production process of the requested product.

—> Top Industrial Usecase: The electronics industry can get benefitted from the MRP feature of Odoo 16 like any other industry. They can manage their orders easily and streamline business processes.

  • Inventory Module

Businesses will be able to establish a backorder and receive the product from the primary supplier rather than canceling the order each time an item is marked as ‘out of stock.’ The new Odoo 16 update will handle such orders automatically, reducing confusion.

There is more to the inventory module in Odoo 16! Connect with us to know more!

—> Top Industrial Usecase: E-commerce industries face the issue of backorder many times. With the backorder feature in Odoo 16, it will now be easy for businesses to manage inventory without any confusion.

  • Email Marketing Module

In Odoo 16, you may now modify the global properties of your mailing list one at a time without having to deal with integrations.

The new version will also enable customers to develop fresh and unique email templates from previous templates for easy email marketing.

—> Top Industrial Usecase: Event Management companies can highly use this feature of Odoo 16. Without affecting the flow of work, a user can create amazing emails to maintain marketing standards.

Free Odoo online course

The easy way to learn odoo is from their free online course, its link is https://www.odoo.com/zh_TW/slides/all

I list those topic and content as below list for your reference


Topic/Module
1. Getting Start
Create an odoo database
Navigate in odoo
Business Flow: Furniture Store
Business Flow: Consulting Services
Business Flow: Administrative Department
Business Flow: Construction Project
Business Flow: Restaurant
Business Flow: Events and Marketing
Schedule activities
Odoo Discuss
Contacts and Importing data
2. Advanced Features and Settings
Access Rights
Multi company
3. CRM
CRM Basics and Pipelines
Sales Teams
Leads
Lead Generation
Lead Enrichment
Lead Mining
4. Sales
Sales Basics and Your First Quotation
Product Variants
Online Quotation
Delivery Price
Delivery Lead Times
Dropshipping
Pricelists – Multiple
Pricelist – Computed
5. Purchase
Purchase Basics and Your First Request for Quotation
Purchase Lead Times
Reordering Rules
Call for Tenders
Blanket Orders
3-Way Matching
6. Rental
Rental Basics
Planning and Reporting
7. Invoicing
Invoicing Basics – Sales Invoice
Terms and Conditions (T&C) and Payment Terms
Invoice Payment Methods
OR Code on Invoices for European Customers
Sales Tax and VAT
Fiscal Positions
Extra Taxes (ecotax, alcoloh luxury…)
SEPA Direct Debit Mandates (SDD)
8. Accounting
Accounting Overview
Accounting Basics
Payment Follow up
Bank Statements and Reconcilation
Reconciliation of Invoices with a Cash Discount
Vendor Bills Data Payment (Checks and SEPA Credit Transfer)
Batch Desposit of Checks
Vendor Bill and Rounding Methods
Multi-currencies
Reports and Financial Statements
Analytic Accounting
Closing the Fiscal Year
9. Subscription Basic
Subscription Basics
Upsell Subscriptions
Subscription Reports
Automatic Alerts
10. Point of Sale
PoS Configuration for Retail
PoS Configuration for Restaurant
Return and Refund Products
Control your Cash
11. Project and Timesheets
Get started with Project
Tasks & Sub-tasks
Collaborate on Tasks
Get started with Timesheets
Measuring Project Profitability
12. Documents
Documents Basics
Using Documents With Your Accounting App
13. Sign
Sign Basics
14. Survey
Survey Essentials
15. Planning
Planning Basics and Your First Shift
Manage Shifts and Give Employees Autonomy
16. Field Service
Field Service Basics
Invoice Time and Materials + Worksheets
Advanced Settings
17. Inventory
Inventory Basics & Your First Warehouse Operations
Inventory Adjustment Techniques
Units of Measure
Integrate Landed Costs
Using Routes
Push & Pull Rules
Managing Lots
Managing Serial Numbers
Removal Strategies
Picking Methods
18. MRP
MRP Overview
MRP Basics & Your First Manufacturing Order
Create Your Own Advanced BoMs
WorkCenters & Routings
Use an Alternative Work Center
From Sales Order to Manufacturing Order
Subcontracting
Use the Master Production Schedule
Overall Equipment Effectiveness
Product Lifecycle Management
Managing Quality Checks
Managing Maintenance
19. Barcode
Barcode Basics
Scanning Products in PoS
Scanning Order Receipts and Delivery Orders
Scanning Inventory Adjustments and Internal Transfers
20. Website
Website Basic
Create New Content for your Website
Domain, Language, Website Name and Favicon
Form builder
Search Engine Optimization
Multi-Website
Multi-Language
URL Management
21. eCommerce
Product variants – Frontend
Alternative, Accessory and Optional Products
Managing Your Website Catalog Price
Promotion Programs
Coupon Programs
Allow Several Payment Methods in eCommerce
Configure Your Delivery Methods
22. eLearning
eLearning Basics
23. Events
Events Basics and Your First Event
Create an Agenda for Your Event
Track Your Attendees
24. Marketing
SMS Marketing
Manage Social Media Pages
Compaigns
Push Notifications and Live Chat
Email Marketing
Marketing Automation
25. Human Resources
Human Resources Basics
Attendances
Time Off
Emplyees’ Appraisal
Manage Skills and Resumes
Recruit People
Referral Recruitment
Expenses
Manage Payroll
Fleet Basics
Manage Your Fleet
26. Helpdesk
Helpdesk Overview
Manage SLAs
Receiving Tickets
27. Studio
Studio Basics
Create a New App – Entries Form
Create a New App – Reservation Module
Create a New Report to Print
Studiio: Advanced Tips & Tricks
28. Business Cases
Branded T-shirts: Case
Branded T-shirts: Solution
Motorcycle Company: Case
Motorcycle Company: Solution
AirProof Drones: Case
AirProof Drones: Solution
TecPro 2.0: Case
TecPro 2.0: Solution
Superstar Logistic: Case
Superstar Logistic: Solution
29. Technical training – Backend Development
Introduction
Models, Fields and Relations
Computed Fields, Onchange and Constraints
Actions, Menus and Views
Model Inheritance
View Inheritance
Business Flow
Action, Wizard and Context
Access Rights
Play with the ORM
Reports and Financial Statements
Controllers
Paid Course
30. Partnership Knowledge Base     (US$3964.03  – 3 days throughout 3 weeks)
I am a new partner, what’s next
Getting my first prospect
Demo Techniques
How to do a good qualification
Template – Progress Report
31. Training Technical   (3 days private course throughout 3 weekss)
32. OIM Project Leader – On Boarding Partners    (2 days private course throughout 3 weeks)
33. Odoo Certifications v14       (US$250)

Procedure to automate the creation of vendor bill function from invoice pdf file in Odoo

Step 1) Save an invoice pdf file to odoo Document workspace

Step 2) select an invoice from Document workspace, and press the play button of “Create Vendor Bill” as below:

Step 3) Press the “SEND FOR DIGITALIZATION” to auto-read and import the invoice to a payment bill.

Step 4) The invoice info will be import as below, then you can validate it to confirm the bill, which you can prepare its payment in future.

Appendix:

I. What kind of document can be auto-import:

  • Create Bill
  • Create Customer Invoice
  • Create Credit Note

II. The cost of auto-import for each file as below, around HK$1.5 each import :

Diary of IT Man – I start to work as freelance odoo consultant

I kept an eye on odoo application for many years (starting from its openerp time in year 2010). Recently, I realized that it became mature and very active in the business application market. The following are several web site which developed by odoo as:

https://hkcin.org/

https://isaboutique.com/

http://www.officeox.com/

https://www.trippen.com.hk/

http://cmaaustralia.hk:8069/

It is a right time for me the join this odoo job market now. Hope I can get its full time/part time/freelance job soon.

Then, it is the right time for me to join in.

odoo Setup Tips

1. How to commend out coding in qewb xml files?

 use <!– cccccccc –> like html

2. How to redirect company(Internal User) to website home page

as above link described

3. Setup to redirect all user to home page after logon:

Setting -> Technical -> User Interface -> Views -> Search Login -> Edit -> redirect value= “‘/'”

4. Delete the Odoo Promotion Message in footer

WebSite Setting -> Customize -> HTML/CSS/JS Editor -> Find “… Promotion Message” -> comment out the Power by message as     <!–                    ..>

5.  3 user types

  1. Internal users can have full access to Odoo applications
  2. Portal users could be customers or suppliers (with access only to relevant documents)
  3. Public users can only access the website

6.  User Groups

There are three groups for sales

  1. Sales Administrators (Managers)
  2. Sales / User: All Documents
  3. Sales / User: Own Documents Only

7.  POS Start Session Error

Validation Error

All available pricelists must be in the same currency as the company or as the Sales Journal set on this point of sale if you use the Accounting application.

Comparison on odoo online, odoo.sh, On-Premise for community and enterprise versions

Recently, I re-picked up the odoo application. I started to use it five years ago, and at that time, its performance was slow and not quite well for usage. Currently, I found that it had a lot of improvement; its function covers many different area from HR, CRM, ERP, e-commerce, POS, helpdesk, project management, online booking, etc. I just got a cert on completed an odoo course. I think it is the right time to invest my time on odoo now, and hope that I can become a freeance on odoo support.

Odoo.sh is an advanced platform compared to Odoo online. Odoo online provides an instance of Odoo basics constraining the users with the usage of same level features provides by Odoo ERP. In Odoo Online platform, there is no provision to use any custom add-ons or custom development of the software which is required by almost every client on this earth as their processes are different, their business workflows are different. Odoo online is not that flexible compared to odoo.sh, as the installation of custom modules is not supported in Odoo online. We can only make the availability of Odoo pre-set modules here. Odoo.sh is scalar in nature allowing the installation of custom modules and further customizations.

FunctionOn-lineOn-PremiseOdoo.sh
Quick/Easy SetupYESYES
Easy maintenance of certified AppsYESYES
Guaranteed 99.9% uptimeYESYES
Automated backupsYESYES
Email ServerYESYES
Odoo certified AppsYESYESYES
Third-party AppsYESYES
Server ControlYESYES
Built-in Developer and System Administration toolsNOT NEEDEDYES

For on-premise installation, it has Odoo Community and Enterprise version. Odoo Community Edition is the free basic version of Odoo supported by open source software. Odoo Enterprise Version, on the other hand is a paid and upgraded version that is more suitable for high value, niche market. Odoo Enterprise Version offers unlimited functional support, version upgrade and Public or Private Cloud hosting in contrast to Odoo Community Version. High speed and performance also differentiate Odoo Enterprise version from Community version.

General Support FunctionEnterpriseCommunity
Unlimited Functional supportYesNo
Upgrades (including your database)YesNo
Public and Private cloud hostingYesNo
User InterfaceEnterpriseCommunity
Desktop – Web BrowserYesYes
Mobile version – Android and Apple phonesYesNo
Studio AccessEnterpriseCommunity
Screen CustomizationYesNo
Report DesignerYesNo
Menus EditorYesNo
Apps CreatorYesNo
Sales ManagementEnterpriseCommunity
Relationship Management (CRM)YesYes
Sales quotations and ordersYesYes
Customer Portal and online paymentYesYes
Digital Phone (VoIP) IntegrationYesNo
Document ManagementYesNo
eSignaturesYesNo
Digital, Subscription and Rental ProductsYesNo
HelpdeskYesNo
Field servicesYesNo
Repair servicesYesNo
Cohort, Dashboard, and Map ViewEnterpriseCommunity
Kanban, list, calendar, and bar graph viewYesYes
new cohort, dashboard, and Map viewYesNo
Inventory ManagementEnterpriseCommunity
Purchase ManagementYesYes
Barcode supportYesNo
Shipping ConnectorsDHL Express, UPS, USPS, FedEx, BPost, EasyPostYesNo
Inter-company AutomationYesNo
Accounting ManagementEnterpriseCommunity
Invoicing & PaymentsYesNo
Full Accounting(Bank Statement Imports, Billing Digitalization, Budgets,Checks, Consolidation, Localizations, Reports, …) YesNo
Manufacturing ManagementEnterpriseCommunity
Resource Planning (MRP)YesYes
Advanced Resource Planning (MRP II)-Work center Control Panel and SchedulingYesNo
Internet of Things (IoT)- Cameras, Footswitches, Scales, Measurement ToolsYesNo
Product Lifecycle Management (PLM)YesNo
MaintenanceYesYes
QualityYesNo
Shipping Connectors- DHL Express, UPS, USPS, FedEx, BPost, EasyPostYesNo
Project ManagementEnterpriseCommunity
Projects and TasksYesYes
Timesheets and task logsYesYes
Planning and ForecastingYesNo
Human Resource ManagementEnterpriseCommunity
Employee DirectoryYesYes
ExpensesYesYes
LeavesYesYes
RecruitmentsYesYes
ExpensesYesYes
PayrollYesNo
AppraisalsYesNo
ApprovalsYesNo
Employee ReferralYesNo
Departments DashboardYesNo
Point of Sale ManagementEnterpriseCommunity
Retail Point of SaleYesYes
Restaurant Point of SaleYesYes
Loyalty Programs and Gift CardsYesNo
Website BuilderEnterpriseCommunity
Website BuilderYesYes
BlogsYesYes
PresentationsYesYes
ThemesYesYes
Form BuilderYesNo
Call-to-Actions BlocksYesNo
VersioningYesNo
A/B TestingYesNo
E-commerceEnterpriseCommunity
Web Store and Shopping CartYesYes
Shipping ConnectorsDHL Express, UPS, USPS, FedEx, BPost, EasyPostYesNo
Amazon ConnectorYesNo
Automatic Sales TaxYesNo
Marketing ManagementEnterpriseCommunity
Events ManagementYesYes
Email MarketingYesYes
Live ChatYesYes
Social media MarketingYesNo
SMS MarketingYesYes
Marketing AutomationYesNo
Lead ScoringYesNo
Email Marketing TemplatesYesNo
MiscellaneousEnterpriseCommunity
E-LearningYesYes
ChatYesYes
Google Integration- Accounts, Calendar, Docs, SheetsYesYes
Fleet ManagementYesYes
Web Services Integration (API)YesYes
Online Appointment SchedulingYesNo

什麼叫 SSIS 和 VSTS

作為今天的程式員應該要知道SSIS和VSTS這兩個名詞。

SSIS 為Microsoft SQL Server Integration Services (SSIS) 是一個平台,用於建立高效能資料整合方案,包括資料倉儲的擷取、轉換和載入 (ETL) 封裝。

Integration Services 包含用於建立及偵錯封裝的圖形工具和精靈;用於執行工作流程功能 (例如 FTP 作業)、執行 SQL 陳述式或傳送電子郵件訊息的工作;用於擷取及載入資料的資料來源和目的地;用於清除、彙總、合併和複製資料的轉換;用於管理 Integration Services 的管理服務,即 Integration Services 服務;以及用於程式設計 Integration Services 物件模型的應用程式發展介面 (API)。

VSTS的全稱是Visual Studio Team System,是由微軟開發的一套具有高生產力、高集成性、可擴展的生命週期開發工具,VSTS使得整個開發團隊擁有更好的溝通與合作,並且保證了更好的質量。

為我們帶來了他的全生命週期管理工具Visual Studio 2005 Team System,旨在改善軟件開發方法在實際開發過程中的有效實施.VSTS擴展了Visual Studio 2005的功能,提供了新的源代碼管理工具, 同時還為開發者提供了單元測試工具和代碼分析工具. 不過VSTS 這次並不是將焦點全放在開發者身上, 它還提供了一系列支持整個開發團隊的工具. VSTS為項目經理, 架構師, 開發者, 測試人員甚至開發經理都提供了相應的支持工具. VSTS提供了一套追踪軟件開發過程的任務管理工具, 為了使整個團隊的軟件開發的過程能夠清晰可見,VSTS還提供了自動生成項目門戶網站(Web Portal)的工具.

Tips to improve MsSQL db performance

If SQL database has poor performance, it will cause timeout issue during retrieve data.  Usually, we have below tips to improve its performance:

  1. Re-build indexes (check the index fragmentation first)
  2. Review the SQL execution plan to find out the most time consuming part
  3. Rewrite the SQL to optimize the execution, overwrite the stored procedure if these steps don’t work
  4. find out the blocking or bottleneck for the statements
  5. check the fragmentation by scripts or manual
  6. check the useless indexes and missing Indexes, then add the missing indexes and delete useless indexes
  7. housekeep the database log file
  8. raise a performance ticket for investigating the issue with Microsoft (need to collect execution plan and profile trace)