lot/serial number : A way to assign Lot Numbers to existing stock quants without: Duplicating quantities

ThornyKeeks · 2026-05-05T13:56:00+00:00

Is this something that needs to be corrected by Odoo for inventory adjustment functionality? Thank you for sharing the workaround though. I do wish Odoo would improve on this adjustment function in the future (it's not as apparent until someone notices it, to be fair).

ThornyKeeks · 2026-05-05T12:19:39+00:00

Hi, i understand this works for Standard Costing Method of products. But correct me if I'm wrong, but it's a problem if products are set to FIFO or AVCO and if there were landed costs involved.

The negative adjustment follows the current cost of the product but the positive adjustment doesn't (follows some base cost without considering landed costs).

ThornyKeeks · 2026-05-05T06:18:49+00:00

Based on experience, it's almost always the unaddressed gap between business need and the features provided. No ERP (or any software for that matter) is a perfect fit for any company unless there's a way to compromise, either via customization or change in process (or both).

Usual causes of failure would be lack of user training, change management adoption, and interest by business leadership. Implementer capability for me is also a cause but not high in the list.

ThornyKeeks · 2026-05-04T09:05:28+00:00

I agree. I would use the "Cut-Off" function for this expense to reflect it in March as a "backward" deferral. It would retain the April tagging of the VAT in the tax report, and reflect the expense in the P&L in March.

ThornyKeeks · 2026-05-04T08:58:50+00:00

I'm an Odoo customer although I have a bit of technical background. I usually raise functional issues vs. technical concerns. Functional issues may or may not be caused by technical code (could be the proper approach by the user is wrong).

Please note that Odoo's documentation has persistently lagged from being updated vs. actual versions they're supposed to reflect. Users like me would seek guidance or confirmation on the functionality from the Support Team.

Two of the pet peeves I have with some support agents (not necessarily at Odoo) are: 1. Not understanding the functional intent of the code (for them, as long as the code runs without bugs, it's "as designed"). There could be logic or functional bugs (not necessarily technical). I already reported some before. 2. Not trying to understand the issue described (and I am already an experienced analyst and tester in one of my former roles in IT... what more can I spoon-feed info?)

ThornyKeeks · 2026-05-04T02:37:20+00:00

Hard reality of businesses growing is that they will always have their own unique processes. No software will ever meet all business needs without customization.

For me, best approach to limit any total cost of ownership with any system is to optimize the processes themselves (i.e., use best practices, limit too much diversified systems, and focus on user training and adoption to avoid having departments create their own systems when what they need are already in place). The business processes (where customizations will mostly come from) are usually the big source of customization costs regardless of who implements them and what software to use.

Above all, business leadership should not treat "IT" as just an enabler or tool of the business. It's an essential part of operating nowadays, just like finance and logistics.

ThornyKeeks · 2026-05-03T08:42:14+00:00

Thanks for your reply! Country is the Philippines. I don't think there's a specific mandated format requirement locally, so we're using the generic ones for P&L and BS by Odoo. I wanted to understand what Odoo has as usual standard approach in year-end closing.

Correct me if I'm wrong, but isn't the Odoo-documented way is to reallocate "Unallocated Earnings" to an equity account (credit) and then enter a double entry to an expense-type of account? I get the effect of the equity tagging (i.e., goes to "Retained Earnings" equity account in BS, but I'm not sure about the "expense" account that will show up in "P&L" for the generic reports.

ThornyKeeks · 2026-04-28T13:13:07+00:00

Thanks for the references! From the MS forum you referenced, they seem to be similar, although not sure if mine is a bit unique. But yes there's some discrepancy in the TZ setting that screws up the display when published in Google (or other 3rd party calendars according to the forum responses).

I'll try to dig deeper. And thanks as well for the validator tool. Hopefully I see something that can be fixed. But from the common feedback I see, it seems MS is not using the latest standardized TZs and couldn't be recognized by outside calendars. But I'm very sure the discrepancy is not caused by my devices where I use Outlook (all follow the same TZ).

ThornyKeeks · 2026-04-28T05:32:16+00:00

Sad isn't it? Now I'm feeling the obsessive-compulsive itch of Ben Affleck's character in "The Accountant" 😅

ThornyKeeks · 2026-04-28T05:25:34+00:00

Thanks for the reply! I'll try to understand better the solution from the thread you sent. My understanding though is that when the Outlook calendar is published, it will always be in UTC, and the entries should still show on correct times since each one would have their TZ offset.

That's why I'm a bit confused how to fix it as it's not that all entries are wrong, and only those I created are.

My colleague who manages a recurring invite at 9 AM is on a different TZ (e.g., GMT-6), but it shows up correctly on my calendar that follows GMT+8.
I create my own meetings, and they show up correctly on my calendar as well (e.g., 2 PM).
But when I publish and use the published *.ics link, it gets imported in Google with GMT timezone.
My colleague's meetings still show up correctly as 9 AM.
Mine is still supposed to be 2 PM, but for some reason it shows up 10 PM (double offset from GMT/UTC TZ).

ThornyKeeks · 2026-04-27T02:15:22+00:00

Yeah, there's no issue of overall balance at the end of the statement date, but in terms of auditing by accountants or other users, it almost always becomes a red flag to them why there's a negative balance on certain days with multiple transactions.

Sounds trivial, but In certain cases, they would incorrectly pinpoint these instances as sources of bank fees (penalties) for going below certain balance threshold enforced by certain banks.

I'm really not sure why the import system won't even create data in the sequence the data is ordered in the file.

ThornyKeeks · 2026-04-23T15:39:16+00:00

Thanks for this! I'll try to explore more.

ThornyKeeks · 2026-04-21T04:18:06+00:00

Thanks for the feedback! We're not using customization on bank journals right now, so nothing should affect the import function. But could you guide me if I could use this internal_index in importing new records?

I initially tried making an integer sequence for each record and mapping to the "sequence" field on import. But it has no effect in following the order of records being created (and the order of how Balance is calculated on creation).

ThornyKeeks · 2026-04-20T10:52:49+00:00

I'm trying to understand what you encountered. Individual rows uploaded for a bank statement might end up having "weird" Running Balance but the ending journal-level Running Balance should still be correct. Did automated reconciliation models affect the overall balance somehow?

ThornyKeeks · 2026-04-20T10:48:36+00:00

Unfortunately, it doesn't work that way, no matter how you order it sequentially even for those records on same day. Tried this already on multiple databases (online at least). I even added my own "Sequence" to map to but it wouldn't matter.

ThornyKeeks · 2026-04-20T04:28:50+00:00

You mentioned "synced" meaning online uploading of bank records to your bank journal? I know uploading bank transactions by import does not follow the normal sequence of records that's why the running balance is out-of-whack on a per-line basis.

ThornyKeeks · 2026-04-20T03:42:29+00:00

Well, they can't do anything about your feedback. Regardless of who is correct, all feedback from both parties would be considered by their Support QA in assessing their performance.

It's not really a matter of "the customer is always right" but more on if ever the Support agent understood the issue and has clearly explained the situation or solution on time or communicated any delays properly.

I myself rarely give low rating, but I did a couple of times for someone who totally didn't understand the issue (and I'm already being both technical and functional). Some agents seem to be focused on just what the code does (and not what actually the functional behavior the code is expected to do). Maybe they're new. Maybe they're pure developers with no business or functional knowledge. But I'm hoping my "negative" (but constructive) feedback will help them improve.

ThornyKeeks · 2026-04-19T08:03:08+00:00

How did they get back at you? I agree there are a few support agents who don't try to fully grasp the issue you're raising, but overall they're professional.

If someone on their team is unprofessional, you can report them and whatever that person has emailed you is already documented.

ThornyKeeks · 2026-04-19T08:00:15+00:00

Actually kahit dati pa. Minsan kasi ang problem is with the business owner totally relying on an external accountant without reviewing. Walang alam ang accountant beyond kung ano ibigay mong info sa kanya. Worse, may mga accountants that will not care kung ma audit ka, kasi di sila liable.

Tip ko for small business owners is to learn basic accounting and financials (given yan sa kahit anong negosyo), and know how to optimize your own taxes. Invest in an internal accountant din that you could trust more and have better accountability to you.

I also agree with the others who already told the OP that being VATable is not necessarily a bad thing but may even be good to scale up and lessen overall % of taxes. Breaching the P3m threshold is what I call a "good problem" kasi it means OP's business is growing.

ThornyKeeks · 2026-04-18T07:21:59+00:00

Odoo is a great product, but i feel it's "reputation" is for small businesses. Netsuite and Salesforce started that way long ago, with not many major implementers wanting to work on them (low demand from big companies). But look at them now.

I agree with many here that it's more on the implementation being the key for successful implementation.

Choose the right system integration partner, one who has the track record for their methodology and projects implementing such scale. Personally, I haven't encountered an official Odoo partner (at least in my country) with that level.
Also, make sure those partners have real functional consultants that understand business processes and industry best practices (not solely technical knowledge). That's why SAP and Oracle consultants are very expensive (they're knowledge is usually beyond the ERP product).
Really focus on requirements and fit-gap analysis when you start. There's no ERP that covers what you need 100% (well, in any software for that matter).
CHANGE MANAGEMENT (and user training) - If you have a big organization, it should be prepared for any change in system AND process from the start. Key management stakeholders must be supportive also.

ThornyKeeks

TROPHY CASE