- 102
- 423 794
Kevin Zaki
Приєднався 6 січ 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.
Переглядів: 946
Відео
Inventory Accounting: Landed Costs - Odoo 17 (Part 10 of 11)
Переглядів 3,1 тис.7 місяців тому
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)
Переглядів 1,1 тис.7 місяців тому
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)
Переглядів 1,4 тис.7 місяців тому
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)
Переглядів 1,1 тис.7 місяців тому
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)
Переглядів 3,4 тис.7 місяців тому
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)
Переглядів 1,5 тис.7 місяців тому
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)
Переглядів 4,2 тис.7 місяців тому
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)
Переглядів 6637 місяців тому
Accounts Payable: Processing Refunds - Odoo 17 (Part 6 of 12)
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
Переглядів 1 тис.7 місяців тому
Accounts Payable: Creating a Bill - Odoo 17 (Part 2 of 12)
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
Переглядів 3 тис.7 місяців тому
Accounting Settings: Reports - Odoo 17 (Part 3 of 5)
Accounting Settings: Overview and Settings - Odoo 17 (Part 1 of 5)
Переглядів 3,7 тис.7 місяців тому
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)
Переглядів 7647 місяців тому
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)
Переглядів 6537 місяців тому
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)
Переглядів 1,5 тис.7 місяців тому
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)
Переглядів 1 тис.7 місяців тому
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)
Переглядів 1,1 тис.7 місяців тому
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)
Переглядів 1 тис.7 місяців тому
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)
Переглядів 1,5 тис.7 місяців тому
Accounts Payable: Employee Expenses - Odoo 17 (Part 12 of 12)
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
Переглядів 1,8 тис.7 місяців тому
Accounts Payable: Deferred Expenses - Odoo 17 (Part 11 of 12)
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
Переглядів 8937 місяців тому
Inventory Accounting: Scrap Inventory - Odoo 17 (Part 8 of 11)
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
Переглядів 1,8 тис.7 місяців тому
Accounts Payable: Register a Payment - Odoo 17 (Part 3 of 12)
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
Переглядів 1 тис.7 місяців тому
Inventory Accounting: Inventory Revaluation - Odoo 17 (Part 9 of 11)
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
Переглядів 2,6 тис.7 місяців тому
Inventory Accounting: Inventory Overview - Odoo 17 (Part 1 of 11)
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
Переглядів 8797 місяців тому
Inventory Accounting: Average Cost (AVCO) & Automated Valuation - Odoo 17 (Part 5 of 11)
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
Переглядів 1,5 тис.7 місяців тому
Inventory Accounting: Manual Inventory Valuation - Odoo 17 (Part 3 of 11)
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
Переглядів 1,1 тис.7 місяців тому
Accounts Payable: Printing Checks - Odoo 17 (Part 5 of 12)
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
Переглядів 1,4 тис.8 місяців тому
Manufacturing Accounting: Variance Analysis - Odoo 17 (Part 4 of 4)
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
Переглядів 2,1 тис.8 місяців тому
Manufacturing Accounting: Work in Progress (WIP) - Odoo 17 (Part 3 of 4)
Manufacturing Accounting: Journal Entries - Odoo 17 (Part 2 of 4)
Переглядів 2,7 тис.8 місяців тому
Manufacturing Accounting: Journal Entries - Odoo 17 (Part 2 of 4)
Hi, I am currently setting up odoo for my beverage distribution business. I have three small storage locations in different regions and they generate their own purchase orders daily. At the end of the day the vendor sends me a single cumulative invoice for all the purchases made in a day. What I do is create a single bill for all those purchase orders but the order lines don't merge and it wastes all of time in reconciling it with the vendors invoice. Is there any way to resolve this issue
Webhooks for inventory?
@ 2:16 you mention journal entries are created when items move into or out of virtual locations. This does not seem to be the case for Virtual Production accounts. It seems the journal entries are only created AFTER the MO has been completed. Is there a way to show the intermediary movements in the valuation journal? i.e. Product pulled from warehouse to production should create an inventor journal entry, after item has been manufactured, another journal entry should be created when it moves to stock. Any ideas? Thanks!
It would seem there is no way to create automatic inventory valuation moves for work in progress. We would like Items pulled from warehouse stock, to move into a temporary "work in progress" account from an inventory valuation perspective. It seems Odoo only creates these entries after the MO is complete. How can we capture the physical inventory moves from stock to "in progress"?
W mans
Hi Kevin I have a problem that vendor bill entry From cost of goods sold To payables That make a big value of stock interim account. Please help
How Can I use multiple source locations on Manufacturing Order. Let's say I want to reserve the components stock from multiple locations in a single MO.
Thank you very much , This is the best explanation for the consolidation module !!!!
The vendor bill make journal From cost of goods sold To payable What should I do
Thank you!! Im hoping you can help, Im trying to make this to only show numbers based off a paid invoice. I just cant figure it out, Could you help?
his case involves Anglo-Saxon pricing and standard pricing. It also pertains to the continental approach and average retext. Please provide more details or a specific focus
Martinez Larry Perez Larry Johnson David
Saved my day! Thanks
while viewing the partner ledger account, i found that Landed cost is payable to the Partner/Supplier/Vendor. Why the landed cost payable to supplier?
ok but what does this sync? only orders? i am trying to achieve a complete sync of all amazons fees and such being imported to the correct accounts
watching you from long time, one of my best teacher in ODOO jounry, waiting for some more compelx scenairo disccsuions. Thank you Mr.Zaki
Great explanation thanks for doing this!
can we use webhook to download a report in odoo studio?
Resupply from .. i can not see it
Thanks, it is very helpful
amazing video. what would you change if we were doing installations for customer jobs?
On point. thank you
at 18:13, scenario for purchase
thank you for your videos, thrilled to watch more
Hi Kevin, thanks for the video. Do you have any material about analytic accounting at the payroll module?
How do you record a donation in odoo accounting (ver 17) and how do you create a budget
Great tutorial. I'm able to make a connection with the command line. But when trying to connect with pgAdmin or DbVisualizer I get "unable to connect to server: ERROR: permission denied for view pg_settings" or "ERROR: permission denied for table pg_database"
Thank you, please create more content for Odoo 17 & 18
Thanks very much for this explanation!
The best explanation I've seen about it! Amazing jog. Thx
The inventory valuation and the balance sheet are supposed to match but ours don't. Do you what could cause that? It is a pretty significant difference.
what if company want to hid accounts when doing internal tranfers
A thumbs up was not enough :) Great thanks!
Hi Kevin Zaki, very good video for my reference, may I know how to activate the inbox notification after creating the message?
Excellent tutorial! I have not found a way to create a separate pipeline for each product or service. Do you know any workarounds for this?
Odoo docs indicates the connector syncs inventory with Amazon. Is it only for the initial set up or is it supposed to keep Amazon inventory in sync with Odoo ? In our experience the connector finds the products "offers" but does not update Amazon as our inventory changes in Odoo. Using Odoo 16.0 and FBM
thanks for the video :) Using payload variable we can receive the passed values in the automated action, without installing the website application: ua-cam.com/video/9KWuFFd7tEw/v-deo.html and to create record inside odoo: ua-cam.com/video/KrVyiSoM1UY/v-deo.html
Best video❤🎉
Thank you very much - this is very useful.
Please help, create a new menu for reports in studio
Nice explanation and simulation
Thanks bro🤝
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.
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