u/ThornyKeeks

▲ 2 r/negosyo+1 crossposts

Best Local Business Operating Hours

Nowadays, is it best to have local non-mall businesses open at 9 AM to 6 PM? Or is the traditional 8 AM - 5 PM still the most acceptable?

I have a start-up small company and we're finally about to ramp-up office operations. My business partners and I are in a bit of a contention on operating hours. For context, our business is into wholesale and retail of our own brand of food and personal care products. We will deal with distributors (big and small ones), resellers and retailers (mix of corporations and individuals).

Traditionally, local businesses that don't normally require night operations run from 8 AM to 5 PM. But as some companies operate to consider impacts of rush hour or actual activities between businesses, it might be better if 9 AM to 6 PM.

The contention here is that some of my partners think it's best to start business at 10 AM and end 7 PM, since it's always traffic in the mornings for employees to go to work and leave early.

My concern though is that businesses will not stop for time of employees regardless, and we'll lose business opportunities if we start the day late. And besides, not all employees are night owls (like me), and some would even want to leave the office early regardless.

reddit.com
u/ThornyKeeks — 6 hours ago
▲ 1 r/Odoo

Updating Tax Grids in Tax and Remapping All Accounting Transactions

This is a bit technical (configuration-wise). I made a custom set of taxes with the following configuration (to simplify my illustration):

  • 12% VAT NRDSP - "Group of Taxes" type, containing Tax A and Tax B
  • Tax A - normal percentage tax which uses tax grids "TaxA1" and "TaxA2"
  • Tax B - a percentage tax that's withholding type (negative %) and uses "TaxB1" and "TaxB2" tax grids

Now I've already had a few quarters of tax closing and previous periods have been locked. The problem is that I had a mistake in the tax grid mapping of Tax B. I updated Tax B with "TaxB3" and "TaxB4" tax grids, but had to apply these retroactively as well.

Would there be any other issue if I just temporarily unlock prior periods, then set old invoices using the main tax ("12% VAT NRDSP") to draft then re-confirm them?

I'm hoping any relevant tax report logic should still be ok and updated properly as long as the tax grids from historical invoices are updated.

reddit.com
u/ThornyKeeks — 3 days ago
▲ 2 r/Odoo

User Issue: Random Server Error in Data Importing

Hi - I've been encountering this error randomly when importing data lately (specifically, on Accounting app's importing of checks in Check Warehouse, on Odoo v19.0 Enterprise Online).

Odoo Server Error
Unable to read file 'Some File.xlsx' as 'xlsx' (guessed using mimetype 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet').

It happened initially on a test DB cloned from Production using real data (only about 25 records having not more than 10 columns. Was able to upload successfully, but now it's happening to the Production one as well.

I don't like to think this is a browser issue as error is on server side to begin with. Thoughts anyone? TIA!

reddit.com
u/ThornyKeeks — 11 days ago

First Time Dealing with Major Distributor

We're a startup company barely 1 year, having our own brand of food products. We were recently approached and currently negotiating with a distributor company (more than 15 years na ata in the business) and they have existing SKUs from different brands they manage with different major retailers (e.g., SM, Robinsons, multiple independent stores). One of their terms is that they purchase inventory from us at 90-day payment terms. We're trying to negotiate to reduce that but better if we get some payment outright as the terms are heavy for us cash flow wise.

I'd like to get some advice here:

  1. Is it normal to have payment terms with distributors with no deposit or some partial payment upfront per purchase from the supplier/manufacturer?
  2. How do you normally do background check or CI for a corporation? Are there 3rd party services for this?
  3. What are the key things we need to consider in dealing with distributors, especially red flags?

Thanks in advance!

reddit.com
u/ThornyKeeks — 14 days ago
▲ 2 r/Odoo

Temporarily Disabling Users

I used to think that temporarily archiving users will disable their access while the admin changes things, and everything gets restored once users are unarchived.

But we encountered an issue where users lost their Discuss channels once they were unarchived. Worse, I read in this post that Activity entries by users are gone once users are archived and not restored when they get unarchived: https://www.reddit.com/r/Odoo/comments/1iumhen/help_activities_deleted_when_user_archived/

Is there a better way to disable users (and restore them later) easily?

reddit.com
u/ThornyKeeks — 17 days ago
▲ 2 r/Odoo

Email Template for Expense Approval

Hi, I tried searching for the email template used for notifications to approver and submitter of the expenses submitted via Expense app, but could not find it in Settings >> Technical >> Email >> Email Templates (while on debug mode, and even if I remove all filters).

Is the template found somewhere else? I wanted to update it with better formatting and more details on the expense to approve (approval email only says there's something to approve). I'm using Odoo Online v19.0. TIA!

reddit.com
u/ThornyKeeks — 28 days ago
▲ 2 r/Odoo

Additional Landed Costs After Some Sales

From what I understood somewhere, when additional landed costs are applied to delivered inventory after some of them have already been sold, the system also automatically adjusts the cost of goods sold (COGS) to reflect the added landed costs.

I tried it out on a test DB, and it seems that a landed cost tagged to an old inventory delivery will prorate the landed cost itself (seems to be based on remaining unsold inventory from that delivery) and not affect those already sold (i.e., adjustments in COGS).

For example, applying a $1,000 landed cost to a batch delivery of 100 items will reflect a total of $1,000 additional valuation to these if none have been sold yet. But if there were 90 already sold, applying a $1,000 landed cost to that delivery again, will only incur total of $100 in total valuation adjustment.

Is this the real intended behavior?

P.S.: When I Google-searched "can landed costs be reapplied in Odoo", one of the answers stated this as well: "If items have already been sold: The system automatically moves that variance to the Cost of Goods Sold (COGS) account, so adjusting via a Landed Cost record will properly expense the difference."

reddit.com
u/ThornyKeeks — 1 month ago
▲ 2 r/Odoo

"Invoiced Not Delivered" List

I noticed in Odoo Accounting app (I'm using V19.0 Online), that there's this list called "Invoiced Not Delivered" (under Accounting app >> Review >> Sales: Invoiced Not Delivered menu), and I see a lot of accumulated orders.

These orders were already delivered, but I noticed they're still tagged as "undelivered" because of line items on service-type products (e.g., delivery fee, discount) or non-inventory-tracked goods. How can these products be set to be ignored by this list? TIA!

reddit.com
u/ThornyKeeks — 1 month ago

Usual GROSS Profit Margin % Ranges

Hi, new to this reddit, and asking for advice. I have a start-up corporation building my own brand of food, health supplements and personal care products with some partners. What's the typical gross profit margin percentage range for my industry in the Philippines?

Maybe to add a bit more context on the industry I'm in or the company we're building:

  1. Our products are made locally, but we aim to target mid- to high-end consumers.
  2. We both do wholesale (to distributors and resellers) and retail (physical store and online)

I wanted to understand the usual gross profit margin % range as I'm thinking it would help us price our products better and see how we can handle OPEX and project net profit down the line.

If anyone has good references on this out there as well, I really appreciate it.

I'm no expert in business, so if my way of thinking about this topic is wrong, I'm more than happy to be educated and corrected too. TIA!

reddit.com
u/ThornyKeeks — 2 months ago
▲ 1 r/Odoo

When creating a year-end journal entry (JE) to record retained earnings, I end up having a P&L with ZERO net profit (using the default P&L report). It shouldn't be the case, right? I need help if I'm doing it wrong.

I've been looking at info from Odoo and other sources and past posts, but I'm confused on the proper way in creating the year-end closing JE. Odoo samples and docs show the Belgian localization, but there seems to be no "official" one for generic approach (let alone something localized for a country).

So the approach I understand for a database with no specific localization for year-end closing:

  1. Create a journal entry dated on year end, and with the balance in the "Current Year Unallocated Earnings" line in the GENERIC Balance Sheet, enter that value as Credit onto an equity account (mine would be "Retained Earnings").
  2. Enter the double-entry as something like "Profit Brought Forward" but as an expense type of account, then save and post the entry.
  3. If you view the Balance Sheet, it would correctly zero out the "Current Year Unallocated Earnings" which is also shown in videos I've seen.

What's not typically discussed is what happens to the P&L. The Belgian P&L has no issue since it's specifically made to allocate the "expense" type of "Profit Brought Forward" to a line that doesn't disrupt the overall net profit.

But for those who can only have the generic P&L (if their fiscal localization doesn't create one like mine), the "Profit Brought Forward" logically ends up as part of operational expenses. So after the year-end entry is posted, I end up with zero net profit in the P&L.

Should I be using a different account type? I'm using V19 (online), although this may still apply to older versions. TIA!

EDIT: Just re-phrased my question in first line.

reddit.com
u/ThornyKeeks — 2 months ago