![Kevin Zaki](/img/default-banner.jpg)
- 103
- 367 094
Kevin Zaki
Registrace 6. 01. 2022
Sales Engineer - Mid-Market & Enterprise @ Odoo
Contact me for any questions, comments, or sales inquires.
Connect with me on LinkedIn!
Contact me for any questions, comments, or sales inquires.
Connect with me on LinkedIn!
Inventory Accounting: First In First Out (FIFO) & Automated Valuation - Odoo 17 (Part 6 of 11)
Inventory Accounting: First In First Out (FIFO) & Automated Valuation - Odoo 17 (Part 6 of 11)
The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting books.
There are three primary goals of this course.
Teach you all of the basic accounting functions you need to perform on daily basis to run your business.
We will cover every basic accounting function including Inventory Accounting, Accounts Payable, Accounts Receivable, Reconciliation, Sales Tax, Expense Accounting, Revenue Accounting, and Asset Management. You will be exposed to all of the main accounting reports such as the Balance Sheet, Profit and Loss Statement, and Cash Flow statements. At the end of the course, you will be comfortable making manual journal entries, navigating the General Ledger, and troubleshooting any accounting errors.
Teach you how every application interacts with the accounting application.
If you have used any ERP software you know that every business decision and record you create in the system may affect your accounting books. You must understand the impact of each of your decisions. In this course, we will cover exactly how each application interacts with accounting. This includes manual and automated inventory valuation, expense management, re-invoicing expenses, collecting customer payments, dealing with multiple currencies and exchange rates, applying landed costs, and dealing with cash.
Teach you how to transition from a legacy system to Odoo Accounting.
Once you are comfortable with the software we will go over exactly how to transition your accounting books to Odoo. This process involves importing your trial balance, using clearing accounts, importing your open bills and invoices, and making sure you have all of your location-specific accounts set up such as your scrap, inventory adjustment, and Work in Progress (WIP).
This course is designed for Implementation Consultants or Business Systems analysts, Bookkeepers, Accountants, and anyone evaluating Odoo as an ERP solution. It will be incredibly helpful for anyone who wants to understand the accounting impact on every decision they make throughout the Odoo ecosystem.
During the creation of each video, I attempt to think of all the most common edge cases and bring them to your attention. I take pride in each video being as comprehensive and complete as possible. Every business has slightly different accounting needs. Nonetheless, in this course, you will touch on every accounting function in Odoo. Even if we do not directly cover an exact use case you will have the knowledge to build out your own complete solution.
The only prerequisites for this course are basic accounting knowledge and basic Odoo knowledge. This course will not teach you the fundamentals of accounting.
The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting books.
There are three primary goals of this course.
Teach you all of the basic accounting functions you need to perform on daily basis to run your business.
We will cover every basic accounting function including Inventory Accounting, Accounts Payable, Accounts Receivable, Reconciliation, Sales Tax, Expense Accounting, Revenue Accounting, and Asset Management. You will be exposed to all of the main accounting reports such as the Balance Sheet, Profit and Loss Statement, and Cash Flow statements. At the end of the course, you will be comfortable making manual journal entries, navigating the General Ledger, and troubleshooting any accounting errors.
Teach you how every application interacts with the accounting application.
If you have used any ERP software you know that every business decision and record you create in the system may affect your accounting books. You must understand the impact of each of your decisions. In this course, we will cover exactly how each application interacts with accounting. This includes manual and automated inventory valuation, expense management, re-invoicing expenses, collecting customer payments, dealing with multiple currencies and exchange rates, applying landed costs, and dealing with cash.
Teach you how to transition from a legacy system to Odoo Accounting.
Once you are comfortable with the software we will go over exactly how to transition your accounting books to Odoo. This process involves importing your trial balance, using clearing accounts, importing your open bills and invoices, and making sure you have all of your location-specific accounts set up such as your scrap, inventory adjustment, and Work in Progress (WIP).
This course is designed for Implementation Consultants or Business Systems analysts, Bookkeepers, Accountants, and anyone evaluating Odoo as an ERP solution. It will be incredibly helpful for anyone who wants to understand the accounting impact on every decision they make throughout the Odoo ecosystem.
During the creation of each video, I attempt to think of all the most common edge cases and bring them to your attention. I take pride in each video being as comprehensive and complete as possible. Every business has slightly different accounting needs. Nonetheless, in this course, you will touch on every accounting function in Odoo. Even if we do not directly cover an exact use case you will have the knowledge to build out your own complete solution.
The only prerequisites for this course are basic accounting knowledge and basic Odoo knowledge. This course will not teach you the fundamentals of accounting.
zhlédnutí: 557
Video
Inventory Accounting: Landed Costs - Odoo 17 (Part 10 of 11)
zhlédnutí 1,8KPřed 4 měsíci
Inventory Accounting: Landed Costs - Odoo 17 (Part 10 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accoun...
Accounting Settings: Contacts - Odoo 17 (Part 5 of 5)
zhlédnutí 791Před 4 měsíci
Accounting Settings: Contacts - Odoo 17 (Part 5 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting bo...
Inventory Accounting: Costing Methods - Odoo 17 (Part 2 of 11)
zhlédnutí 760Před 4 měsíci
Inventory Accounting: Costing Methods - Odoo 17 (Part 2 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your acco...
Inventory Accounting: Subcontracting - Odoo 17 (Part 11 of 11)
zhlédnutí 707Před 4 měsíci
Inventory Accounting: Subcontracting - Odoo 17 (Part 11 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your acco...
Accounting Settings: Journals - Odoo 17 (Part 2 of 5)
zhlédnutí 1,9KPřed 4 měsíci
Accounting Settings: Journals - Odoo 17 (Part 2 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting bo...
Inventory Accounting: Standard Cost & Automated Valuation - Odoo 17 (Part 4 of 11)
zhlédnutí 789Před 4 měsíci
Inventory Accounting: Standard Cost & Automated Valuation - Odoo 17 (Part 4 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct...
Accounting Settings: Chart of Accounts - Odoo 17 (Part 4 of 5)
zhlédnutí 2,7KPřed 4 měsíci
Accounting Settings: Chart of Accounts - Odoo 17 (Part 4 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your acco...
Accounts Payable: Processing Refunds - Odoo 17 (Part 6 of 12)
zhlédnutí 376Před 4 měsíci
Accounts Payable: Processing Refunds - Odoo 17 (Part 6 of 12)
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
zhlédnutí 553Před 4 měsíci
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
zhlédnutí 1,8KPřed 4 měsíci
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
Accounting Settings: Overview and Settings - Odoo 17 (Part 1 of 5)
zhlédnutí 2,6KPřed 4 měsíci
Accounting Settings: Overview and Settings - Odoo 17 (Part 1 of 5) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your ...
Accounts Payable: 3-Way Matching - Odoo 17 (Part 7 of 12)
zhlédnutí 484Před 4 měsíci
Accounts Payable: 3-Way Matching - Odoo 17 (Part 7 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accountin...
Accounts Payable: Price Difference - Odoo 17 (Part 8 of 12)
zhlédnutí 424Před 4 měsíci
Accounts Payable: Price Difference - Odoo 17 (Part 8 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your account...
Inventory Accounting: Inventory Adjustments - Odoo 17 (Part 7 of 11)
zhlédnutí 892Před 4 měsíci
Inventory Accounting: Inventory Adjustments - Odoo 17 (Part 7 of 11) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on you...
Accounts Payable: Accrued Expenses - Odoo 17 (Part 9 of 12)
zhlédnutí 614Před 4 měsíci
Accounts Payable: Accrued Expenses - Odoo 17 (Part 9 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your account...
Accounts Payable: Prepayments - Odoo 17 (Part 4 of 12)
zhlédnutí 628Před 4 měsíci
Accounts Payable: Prepayments - Odoo 17 (Part 4 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accounting b...
Accounts Payable: Documents and OCR - Odoo 17 (Part 10 of 12)
zhlédnutí 577Před 4 měsíci
Accounts Payable: Documents and OCR - Odoo 17 (Part 10 of 12) The Complete Odoo Accounting Course Odoo 17 will teach you everything you need to know about the Odoo accounting application. Odoo is an Enterprise Resource Planning (ERP) software with dozens of interconnected applications. Applications such as inventory, manufacturing, website, expenses, and sales have a direct impact on your accou...
Accounts Payable: Employee Expenses - Odoo 17 (Part 12 of 12)
zhlédnutí 745Před 4 měsíci
Accounts Payable: Employee Expenses - Odoo 17 (Part 12 of 12)
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
zhlédnutí 947Před 4 měsíci
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
zhlédnutí 491Před 4 měsíci
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
zhlédnutí 908Před 4 měsíci
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
zhlédnutí 590Před 4 měsíci
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
zhlédnutí 1,4KPřed 4 měsíci
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
zhlédnutí 496Před 4 měsíci
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
zhlédnutí 742Před 4 měsíci
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
zhlédnutí 594Před 4 měsíci
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
Accounts Payable: Overview - Odoo 17 (Part 1 of 12)
zhlédnutí 920Před 4 měsíci
Accounts Payable: Overview - Odoo 17 (Part 1 of 12)
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
zhlédnutí 1KPřed 5 měsíci
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
zhlédnutí 1,5KPřed 5 měsíci
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
Thank you for the information, I found it very helpful!Do you know if there's any way to do "group by" in this case?
Great tutorial Kevin. Thank you!
Thank you for actually clicking the MTO route and showing us the rules. No one else did that and since Odoo is very rules-based we really should understand them if we want to do anything custom.
Nice
Kevin one question though, how do we reflect the additional valuation to the respective GL Accounts of each landed cost applied? bigger companies have detailed COA's and under cost of revenue section they define shipping / custom duties accounts etc. Your illustration nets out the expenses :/
Sounds like a good opportunity to simplify the CoAs. In my opinion, separating out CoGS by what came from shipping doesn't give you any value at the financial statement level. You can always go see how much you spent on shipping in a given month elsewhere in your GL or in your landed costs or product analysis. Imagine looking at your P&L and it shows $500,000 in Shipping CoGS. It means nothing without additional context. If you really want you can sum your debits to the Shipping Expense account originally debited for a specific period and credit General COGS and debit the Shipping COGS for that amount so you can have a pretty accurate idea. Lastly, the only time I saw this done is when a company is using standard cost or manual inventory valuation (therefore not using landed costs) and debiting the shipping bill directly to a COGS account for simplicity.
what about if i want to do revaluation as at a historical date so that the costing of a past transaction is affected by the new cost. Changing the date doesn't help at the moment
I have a searchable excel sheet (quite complex) that currently is being used outside of odoo and requires manual lookup outside of odoo. If I wanted to have odoo use the spreadsheet to display select data related to certain products like work instruction or jig location for product (all on the soread sheet) is it possible to have odoo look up the info via the soread sheet and display certain lines from it?
Thank you for such clear and detailed information.
thank you so much, done watching part 1-5. and will be watching your other videos. i have problem in reconciling in Odoo 17, the validate button is color grey, if i click it nothings happen. but thanks for this.
hope you will have more video in reconciling with this problem, thank you
The expense account inserted in the bill and in the landed cost seem to be both debited and credited respectively by the same value. Is the expense reflected on that account or is it only reflected in the COGS account?
same question, kevin's illustration nets out the defined accoutns. However bigger companies keep track of their COGS.
How about a scenario where we have billed the customer for around 100 different products and they are returning only 1 product? How to take in only that single product to our warehouse and create a credit note based on what was returned?
Thank you for this video. Do you know a way to set the opening balances in v17? I see you have the "view" options on the CoA like I do. I've seen other videos that have "setup" as an option for each account. Thanks in advance!
much thanks, better than hozey ignasiu
Hi my odoo doesn't show the checks part
why mine is not showing the price?
Great Video!!!! Thankyou
Great video! What I do not understand is the fact that the expenses are negative, which will reduce the expenses if more are incurred. Am I right in this logic and is there an issue here or not?
Thanks for your video. What if my expense starts in 14-Jun-2024 to 13-Dec-2014, the generated journal entries created at the end of the month not using my start date and end date. How can I solve this?
if ocr doesnt recongnize PO number can you attach after?
Hey Kevin do you do freelancing for Odoo? I am not happy with my Odoo Team they are slow and I need to get my system up and running and live I signed up with the Starter pack 6 months ago and we have not even imported all of our products
I'm working on setting up Accounting. I have a call in 30 minutes with AvaTax. Hopefully they have a better way of doing sales tax than what this video shows. Although I anticipate they are on the front end to help with determining the county sales tax for which of our 72 counties have the extra .5% county sales tax. Odoo's processing of payments, including using a calculator to input the ending account balance, is mystifying to me. This is a step backwards from even the horrible bookkeeping program I'm moving away from. But it is still early in the setup as I prepare to Go Live. :)
Wow! This is the first process in Odoo that I've seen that, at least at my first 3 views, is a much more complicated, time consuming and ripe for errors than even the poor bookkeeping system that I am leaving. I will watch 3 more times. Maybe I'm missing something. My current system just has a 2 line journal entry after I make an online payment to my credit card company. ??
HI, I am getting a string payload(a dictionary as a string "{'a':1, 'b':2}" instead of a dictionary object in request.get_http_params(), how do I handle that?
Hi, I am trying to generate cost of production in my odoo 17 but it generated cost of production as whole - including raw material and work center. I am not getting how did you get it -1.90 in your case? The video at minute 10:01. Please let me know how to get the separate cost of production like demonstrated in your video?
Thanks for the clear & detailed explanation. After a long time trying to figure out how this feature works your video finally made me get the point!
Awesome work Kevin
💚
Hello Kevin, Very informative video thanks for creating this. I just have one question when employee cost is multiplied by duration why do you divide by 60? In the employee module we already set per-hour cost and duration is also in HH: MM so I guess we just need to multiply. Correct me if I am wrong please.
Is he using a paid version of Odoo? If yes, then how can we do the same in the free version?
Best videos that I have found so far. He explains everything clearly and simply. They are great!
Saved my Day, I am so much greatful .. Great video .. Thanks a Billion
Very useful. Thanks
Just top notch!
Another great video--thank you! I notice that you never update the Sales Orders related to the refund. This would over-represent your sales. Is there anything to be done about that?
Superb 100/100
These options are on visible to me when I try to make a new product category, there is no, Inventory valuation section
Thanks Kevin , wonderful presentation
Hello, not related to this video but I think you can help. I can't seem to get a cost to register for a budgetary position. I tag the analytic a/c in the JV a/c debited ( included as a budgetary position account)but it won't register/hit it in the project budget ??
Great vedio
How do you duplicate a delivery schedule? Where you don't have to "add a line" but duplicate the previous line?
So how does translate into commission And how can I creat a list or dashboard that a sales person can see why his commission Is less because of added cost?
On one database this works very well! But on other database I get an error on the 'request', any thoughts? What am I missing? Webhook #1 failed with error: Traceback (most recent call last): File "ir.actions.server(613,)", line 16, in <module> NameError: name 'request' is not defined During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 383, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "ir.actions.server(613,)", line 18, in <module> NameError: name 'request' is not defined
A CRYSTAL CLEAR DEMO 💯 Thank you so much
Hi KEZ i have a question. I am doing an import of my products on odoo v17. When doing the Inventory Adjustments how do i set it for the end of the previous month because it picks todays date instead of the schedule date i set.
i got request is not defined
Is there a way to duplicate projects that have similar structures but vary slightly. I have a project with 97 tasks inside it. Once i duplicate it the projects seem to be linked. for instance the first project needs to have a design category yet the second one doesn't. still has same stages tags assignees etc. but i need to remove a few stages. When i click delete on the copied version it tells me i need to archive all stages and tasks associated and it pulls that project and the original data. if i archive it they delete off the first project template as well.
After changing Star ranking of the contact, how do you do a soft refresh?
You just need to press enter in the search bar.
Hi Kevin, very good, tks a lot. There´s a way of update all BOM´s from 1 Raw A material (in your example , Parts) to Raw B. Tks in advance. PS: I have 479 Bom´s to update
Hi Kevin - thanks for the video - do you know if the connector can handle multichannel fulfilment orders (MCF)?
Can the consumption of products be logged in a project ?? This video only talks about hours. We need materials to execute our projects. Thnaks.