inventree / InvenTree

Open Source Inventory Management System
https://docs.inventree.org
MIT License
4.12k stars 739 forks source link

Sales Reports VAT #4763

Closed mabroens closed 1 year ago

mabroens commented 1 year ago

Please verify that this feature request has NOT been suggested before.

Problem statement

Currently the customers/suppliers/manufacturers do not have a field indicating the VAT number nor VAT %. could this be added and can we then use it in the sales report?

Suggested solution

add 2 additional field to customer details: VAT.Nr and VAT %. add order.customer.vat to be used in rendering reports.

Describe alternatives you've considered

?

Examples of other systems

No response

Do you want to develop this?

SchrodingersGat commented 1 year ago

Adding tax support is complex and would need to be carefully considered. I certainly don't feel confident enough in my accounting knowledge to make a claim on how it should be implemented.

I think it would be a useful feature to add (I certainly have been asked about it a lot) - so, let's open it up for discussion! How should we implement it?

miggland commented 1 year ago

Adding a VAT number for the customer is straightforward - it's just a number, and doesn't have any immediate implications. I put it in the description field for companies, but that's just because I thought it was handy.

VAT-% and so on is definitely more complicated. Not only will it depend on customers, it might depend on what you are selling as well, ie be different per sales order line.

Customers, sales orders, sales order lines all have metadata activated. I would suggest this is something that could be put in the metadata fields, by a plugin.

mabroens commented 1 year ago

Sounds good thank you. we need to print the VAT number on the invoices.

as for the VAT per part. true. this would actually imply that a part gets a VAT% since depending on the good these might very. but also the customers/suppliers/manufacturer have a VAT%. typically when selling within the same country you need to charge VAT. but under some circumstance the buyer might be free from VAT. but whenever sending to other countries thats when we do not need add VAT and hence the VAT% could be 0 i guess.

Customer setting would in my case overwrite the part.vat.

miggland commented 1 year ago

The point is that it's very hard to get this right, in general. What you describe is valid in the EU - what about outside? If VAT functionality is a part of the core, it needs to be use-able for all cases.

A plugin is much more flexible, and can be used by those who require it / adapted to fit local regulations.

matmair commented 1 year ago

InvenTree does not include proper business accounting functionality. So I would really question if it makes sense to create full invoices from it.

@SchrodingersGat I think we should discuss putting this on the roadmap. It suggests that we will - at some point - implement tax support. From my experience with this area I can tell you 2 things: 1) Getting it right every time is very hard 2) Getting it wrong makes your life as a business and individually very hard

Although we are MIT licensed and do not have any warranty to fear I think including even adding a percentage puts us in an ethical liability to get it right. Without anyone with proper tax/accounting knowledge on the core team, we should stay away from taxes or proper accounting as far as possible IMO.

SchrodingersGat commented 1 year ago

@matmair I would tend to agree - we either get it perfect of explicity don't do it. My preference would strongly be to allow easy ingress / egress of order data to other systems which support finance / accounting operations, and focus on the stock management side.

I have recently been discussing this topic with regard to GST in Australia. Implementing a generic system which works "everywhere" would be exceptionally difficult.

github-actions[bot] commented 1 year ago

This issue seems stale. Please react to show this is still important.

mabroens commented 1 year ago

Hi All,

for now i just created two templates one fo export (excl VAT) and one including VAT.

closing this issue