Multiple Units added in v4.1.73 … thanks @emre!
It isn’t exactly what I was looking for, since I need to calculate Ounces per Case, and I have no way to define Bottles per Case (other than 288/24=12), but it will suffice, so I’m not complaining…
Multiple Units added in v4.1.73 … thanks @emre!
It isn’t exactly what I was looking for, since I need to calculate Ounces per Case, and I have no way to define Bottles per Case (other than 288/24=12), but it will suffice, so I’m not complaining…
This is one of the last things I would like to see when it comes to Inventory Transactions that would make entering Purchases much simpler: a Default Tax Template on a per-item basis.
I have some suppliers that list their items on invoices with Tax included, but most list Items with Tax excluded, and all suppliers use the same Tax Rates depending on the type of Product. In my case, T1=15% and T2=18%.
Similar to the Default Transaction Cost
, it would be very nice to have a Default Tax Type that could be defined in a way that is similar to Sales. So when I go to Purchase Stock, my line items already contain the Tax Type for that item.
Do you need only tax template selection for items without tax implementation for transactions? I couldn’t understand
Sorry, I don’t understand your question @emre. Basically I want Tax Mappings for Inventory Items.
Currently in my code I am gathering Sales Tax Templates and populating a pick list with the Names (and Rates) for those Templates. Then I have some hard-coded filters for specific Inventory Item Types, for example Alcohol and Cigarettes get T2 (18%) by default, and most everything else gets T1 (15%) by default. There are some items with NoTax as well.
This lets me enter the cost of the item as it appears on an Invoice, and the Tax is added automatically at the proper Rate, giving an Invoice Total that matches what the Supplier gives me. In practice, I don’t need to enter the cost at all, because the Item has a default Cost. If I could get a default Tax as well, I wouldn’t need to guess which Tax the item needs.
This could be done like the Tax Template mappings on the POS/Sales side (makes sense to me), or it could be another field/column in the [InventoryItems]
Table similar to Default Base Cost
and Default Transaction Cost
. Mappings seem to make more sense to me, because you could theoretically assign more than 1 Tax to an Item.
Keep in mind too, Suppliers sell Items of all Tax Rates, so we can’t rely on Supplier Account mappings; instead we need Item Mappings, just like we have for Products.
I mean when we add tax templates for inventory items we should also add tax calculations for purchase transactions and maintain related accounts. What you’re requesting sounds like you don’t need a tax calculation in transactions and only need to know default tax rate. That’s why I’m asked because when you say “it appears on an invoice” I assume you’re talking about your inventory tracking system, not sambapos…
Calculating tax in transactions is something we’ll implement however before doing that we should improve accounting integration for inventory transactions. I’ve implemented 2 more invoicing apps before SambaPOS and this is something needs a lot of development as some suppliers can send tax included invoices, some can send tax excluded and even some suppliers sends invoices where tax amounts incorrectly calculated so what your computer calculates does not match to the printed invoice.
This is my plan for tax.
What I’ve asked is if you’re requesting all of them or just the last item
Yes, I’m requesting just the last one: assigning Tax Templates to Inventory Items to define Default Tax Rates for the Item.
This is the the correct assumption. I am talking about my system, however I want to use as much of the native/default system built-in to SambaPOS as possible. I agree with you on what should be done and needs to be done eventually regarding Tax Calculations, etc… I just don’t need that level of integration yet.
I just want the part outlined in Red, but for Inventory Items instead of Menu Items…
Sounds like big plans and a lot of work @emre! I’m all for it… the Accounting (Money not Stock) for Inventory is one of the last remaining missing pieces.
I’m going to guess that your future plans for Inventory involve the screen on the left, which I am currently not using; instead I use the screen on the right… at least in the case of Account Transactions (I do use the Inventory Transaction Type). The reason for this is simple: my Purchases/Payouts are already well-defined in the Accounting side, so I saw no need to duplicate it - plus, there is no Button Header field on the Inventory side - and I need that button!
@emre, any chance you could improve this: Parent Unit
is NULL
in the DB, but should be Ounce as shown.
In my PHP code, I explicitly set this value, but if the item is created within SambaPOS, the value in the DB is NULL.
EDIT: not a big deal… I added some PHP code to select the ParentUnit as either the TransactionUnit or BaseUnit. Though I still think the ParentUnit value should not be NULL if configured via SambaPOS. Also, I assume that if there are more than 1 AdditionalUnits that use another AdditionalUnit as the ParentUnit, this value will not be NULL in the DB.