Inventory Purchase Improvements

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…

@emre, can we get some Grouping in the following Inventory screens:

  • Warehouses
  • Recipes (?)

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 :slight_smile:

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.

  • Integrating accounting to inventory transactions so we can automatically update supplier accounts. (and tax accounts)
  • Adding a Tax amount under transaction documents (not orders) so you’ll be able to manually type total tax amount as it printed on invoice. We’ll update purchase taxes account with that amount.
  • Adding a setting to let user select if tax is included to prices or not so we’ll know if we’ll update purchasing accounts (and also calculate cost) by decreasing tax amount or not.
  • Adding a setting on order lines to define tax rate so we’ll be able to calculate total tax automatically but we’ll still allow user to modify total tax manually.
  • Calculating tax amounts separately for each tax rate and update individual tax accounts.
  • Finally assigning tax templates to inventory items to define default tax rates.

What I’ve asked is if you’re requesting all of them or just the last item :slight_smile:

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.