VAT in Purchase & Sales Item

I'm testing erpnext as i'm search a backoffice web app for an ePOS system.

ERPNEXT seems just perfect.

At the moment i'm testing it from a Retailer point of view and i'm confused on Item and associated VAT.

Ex:

Item: Cocal Cola
Price: 2.00 €
Group: Beverage
Purchase VAT: 21%
Sales VAT: 10%

I'd expect to add the Item Vat on the item form so that when i add the item row in documents (Purchases and Sales) the VAT Footer details are autocalculated.

How can i obtain that ?

Best Regards



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

I really can not figure out how the taxes part works,

How can i add on a document 2 items with different VAT and have vat calculation in the footer ?



Il giorno giovedì 29 agosto 2013 15:33:03 UTC+2, Daniele Favara ha scritto:
I'm testing erpnext as i'm search a backoffice web app for an ePOS system.

ERPNEXT seems just perfect.

At the moment i'm testing it from a Retailer point of view and i'm confused on Item and associated VAT.

Ex:

Item: Cocal Cola
Price: 2.00 €
Group: Beverage
Purchase VAT: 21%
Sales VAT: 10%

I'd expect to add the Item Vat on the item form so that when i add the item row in documents (Purchases and Sales) the VAT Footer details are autocalculated.

How can i obtain that ?

Best Regards



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

Daniel - You will have to set the non-standard tax values in Item Tax table inside Item Master.

Say you have VAT-4 and VAT-6 applicable in Item A and B (separately)

Then in Item A, you must set VAT-6 rate to be 0 and in Item B, you must set VAT-4 to be 0.

In the tax table you must add both your VAT taxes (VAT-4 and VAT-6).

Sorry its not very intuitive at the moment. Maybe the Item tax rates should be in the Tax master not the other way round (Price Lists too have the same issue).

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 29-Aug-2013, at 8:55 PM, Daniele Favara <da...@zeroisp.com> wrote:

I really can not figure out how the taxes part works,

How can i add on a document 2 items with different VAT and have vat calculation in the footer ?



Il giorno giovedì 29 agosto 2013 15:33:03 UTC+2, Daniele Favara ha scritto:
I'm testing erpnext as i'm search a backoffice web app for an ePOS system.

ERPNEXT seems just perfect.

At the moment i'm testing it from a Retailer point of view and i'm confused on Item and associated VAT.

Ex:

Item: Cocal Cola
Price: 2.00 €
Group: Beverage
Purchase VAT: 21%
Sales VAT: 10%

I'd expect to add the Item Vat on the item form so that when i add the item row in documents (Purchases and Sales) the VAT Footer details are autocalculated.

How can i obtain that ?

Best Regards



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

Hi Daniele,

Login into demo.erpnext.com and see the following records:

1. Selling > Sales Taxes and Charge Master > EU VAT
2. Selling > Item > Windmill A Series - see item tax section
3. Selling > Item > Windmill C Series - see item tax section
4. Accounts > Sales Invoice > INV00091

EU VAT is the tax template. It has both type of taxes defined, but with rates as 0. The rates will be set per Item.
Both Items have different taxes defined for them, one as 10% and other as 21%
In Sales Invoice, the items and taxes are selected, and the tax is applied per item.

I think this example should clarify things.

Thanks,
Anand.

On 29-Aug-2013, at 8:55 PM, Daniele Favara <da...@zeroisp.com> wrote:

I really can not figure out how the taxes part works,

How can i add on a document 2 items with different VAT and have vat calculation in the footer ?



Il giorno giovedì 29 agosto 2013 15:33:03 UTC+2, Daniele Favara ha scritto:
I'm testing erpnext as i'm search a backoffice web app for an ePOS system.

ERPNEXT seems just perfect.

At the moment i'm testing it from a Retailer point of view and i'm confused on Item and associated VAT.

Ex:

Item: Cocal Cola
Price: 2.00 €
Group: Beverage
Purchase VAT: 21%
Sales VAT: 10%

I'd expect to add the Item Vat on the item form so that when i add the item row in documents (Purchases and Sales) the VAT Footer details are autocalculated.

How can i obtain that ?

Best Regards



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

1 Like
Hi Daniele, welcoem to the group of European Erpnest users. You are not alone. You will manage your VAT once you understand Erpnext , rgds Robert from the Netherlands

On Thursday, August 29, 2013 3:33:03 PM UTC+2, Daniele Favara wrote:
I'm testing erpnext as i'm search a backoffice web app for an ePOS system.

ERPNEXT seems just perfect.

At the moment i'm testing it from a Retailer point of view and i'm confused on Item and associated VAT.

Ex:

Item: Cocal Cola
Price: 2.00 €
Group: Beverage
Purchase VAT: 21%
Sales VAT: 10%

I'd expect to add the Item Vat on the item form so that when i add the item row in documents (Purchases and Sales) the VAT Footer details are autocalculated.

How can i obtain that ?

Best Regards



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

And in case you want to get more technical about it, here's a post by the Webnotes dev team on the rounding issues with VAT. It may or may not apply to you but it shows that the dev team is actively looking into concerns related to VAT. 

On Friday, August 30, 2013 3:52:09 AM UTC+8, robert wrote:
Hi Daniele, welcoem to the group of European Erpnest users. You are not alone. You will manage your VAT once you understand Erpnext , rgds Robert from the Netherlands

On Thursday, August 29, 2013 3:33:03 PM UTC+2, Daniele Favara wrote:
I'm testing erpnext as i'm search a backoffice web app for an ePOS system.

ERPNEXT seems just perfect.

At the moment i'm testing it from a Retailer point of view and i'm confused on Item and associated VAT.

Ex:

Item: Cocal Cola
Price: 2.00 €
Group: Beverage
Purchase VAT: 21%
Sales VAT: 10%

I'd expect to add the Item Vat on the item form so that when i add the item row in documents (Purchases and Sales) the VAT Footer details are autocalculated.

How can i obtain that ?

Best Regards



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

This works great for products from Item repository. But what about items that are only manually inputed directly in the invoice. I am missing the VAT rate field in the Sales Invoice Item, thus this product is calculated without VAT.
Any ideas on how to solve this?