VAT in Purchase & Sales Item

99 views
Skip to first unread message

Daniele Favara

unread,
Aug 29, 2013, 9:33:03 AM8/29/13
to erpnext-u...@googlegroups.com
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

Daniele Favara

unread,
Aug 29, 2013, 11:25:29 AM8/29/13
to erpnext-u...@googlegroups.com
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 ?

Rushabh Mehta

unread,
Aug 29, 2013, 12:28:55 PM8/29/13
to erpnext-u...@googlegroups.com
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

--
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-fo...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Anand Doshi

unread,
Aug 29, 2013, 12:31:25 PM8/29/13
to erpnext-u...@googlegroups.com
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 <dan...@zeroisp.com> wrote:

robert

unread,
Aug 29, 2013, 3:52:09 PM8/29/13
to erpnext-u...@googlegroups.com
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

lxnow

unread,
Aug 29, 2013, 10:11:15 PM8/29/13
to erpnext-u...@googlegroups.com
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. 
Reply all
Reply to author
Forward
0 new messages