Purchase receipt document >>>>>>>> Table Of Item >>>>>>>>>>>>> Rate and Amount >>>>>>>>> there i need some changes..
I added one custom field after "discount %" field which Name = "VAT".
so suppose
Cement bags 200 bags purchase and discount rate = 10% and VAT =14% after discount....
i know i can add VAT under the head "Purchase Taxes and Charges" but
my problem is that if i add VAt under the head "Purchase Taxes and Charges" then the amount will goes to "Duties and taxes" but in our business we can not cliam input tax against output tax...so i want to add this VAT Amount into Purchase Cost.
There fore i need one column after "Discount %" column. which i already made. with the name "VAT" as i already told you.
but the problem is that if Write some percentage in VAT column like 14%, 5%, etc.... then actual rate is still remain same... it does not change... so i think i have to fit a proper formula or code...
I hope i explain it properly, furthere if any confusion in my question then feel free to ask....
but solve it please...
Thanks
Regards
CA Mahaveer Somani
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
On 07-Sep-2013, at 10:13 AM, Mahaveer Somani <ca...@gmail.com> wrote:
Purchase receipt document >>>>>>>> Table Of Item >>>>>>>>>>>>> Rate and Amount >>>>>>>>> there i need some changes..
I added one custom field after "discount %" field which Name = "VAT".
so suppose
Cement bags 200 bags purchase and discount rate = 10% and VAT =14% after discount....
i know i can add VAT under the head "Purchase Taxes and Charges" but
my problem is that if i add VAt under the head "Purchase Taxes and Charges" then the amount will goes to "Duties and taxes" but in our business we can not cliam input tax against output tax...so i want to add this VAT Amount into Purchase Cost.
There fore i need one column after "Discount %" column. which i already made. with the name "VAT" as i already told you.
but the problem is that if Write some percentage in VAT column like 14%, 5%, etc.... then actual rate is still remain same... it does not change... so i think i have to fit a proper formula or code...
I hope i explain it properly, furthere if any confusion in my question then feel free to ask....
but solve it please...
Thanks
Regards
CA Mahaveer Somani
–
You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.
in Picture 1. What is was by defualt format in purchase receipt item table - where i purchase cement 100 Qty @ 100 discount 10% . so amount = 9000 in picture 2. what i did - i add a custom field Name = "VAT" so suppose in above details if there is 5% VAt also then Rate should be = 94.50 and amount should be = 9450 but still Rate = 90 and amount =9000
in picture 3. what i expect - i expect the Rate should be = 94.50 and amount should be =9450
I hope now you understand my problem.
further if any confusion then feel free to ask.
Thanks
Regards
CA Mahaveer Somani
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
The way we handle taxes in ERPNext is via a Taxes and Charges Master. You will have to put VAT in the taxes table not in the Item table. The advantage is that you can put multiple number of taxes against one Item.
On 07-Sep-2013, at 11:49 AM, Mahaveer Somani <ca...@gmail.com> wrote:
as per attached-
in Picture 1. What is was by defualt format in purchase receipt item table - where i purchase cement 100 Qty @ 100 discount 10% . so amount = 9000 in picture 2. what i did - i add a custom field Name = "VAT" so suppose in above details if there is 5% VAt also then Rate should be = 94.50 and amount should be = 9450 but still Rate = 90 and amount =9000
in picture 3. what i expect - i expect the Rate should be = 94.50 and amount should be =9450
I hope now you understand my problem.
further if any confusion then feel free to ask.
Thanks
Regards
CA Mahaveer Somani
–
You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.
You can move the VAT head to expense if you want. You can call it VAT-N for non-refundable VAT. But it should still go in your Tax Table not the Item table.
but i want to do work with my created column. becoz there is one reason my friend.
lets understand this thing: -
suppose i m making a purchase receipt entry and in this entry i written 10% discount and save this entry and submit also.
now i make a purchase invoice from this entry, and save it and submit it....
now when i checked in general ledger : - Discount Ledger then there is nothing while purchase invoice has been submitted....still discount accounts is 0.
it means that discount column is nothing (it is only for calculation purpose).
While VAT column which you are telling me under (TAxes and other Charges) head. takes my amounts under Duties and Taxes or Expenses watever.
But i want my total amount consolidated not in seprate seprate account..
I hope now u understand what i need.
If there is any further query then please feel free to ask.
Thanks
Regards
CA Mahaveer Somani
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
There is no straight forward way right now to meet your requirement. Every product handles a task in a standard way, although it can be done several ways.
In this case, you can easily apply VAT through tax table as an expense head, which actually does not effect your overall account balance. But you do not want ledger entry for VAT, and want to implement it inserting a column in item table. The solution you mentioned is also feasible but needs a lot of efforts at our end, as it affects the heart of the main calculation. You can approach to any of development partner to customize it.
An alternative workaround: Mention VAT amount in tax table but mention same account which is used against item. You can mention "VAT" in the description column which appears in print. In this way, you can get VAT amount in the same account head which is used in the item table.
Note: Please understand changing an existing design (acceptable by hundreds of users) is not so easy as you think.
On 07-Sep-2013, at 5:35 PM, Mahaveer Somani wrote:
i understand what you are trying to say to me:
but i want to do work with my created column. becoz there is one reason my friend.
lets understand this thing: -
suppose i m making a purchase receipt entry and in this entry i written 10% discount and save this entry and submit also.
now i make a purchase invoice from this entry, and save it and submit it....
now when i checked in general ledger : - Discount Ledger then there is nothing while purchase invoice has been submitted....still discount accounts is 0.
it means that discount column is nothing (it is only for calculation purpose).
While VAT column which you are telling me under (TAxes and other Charges) head. takes my amounts under Duties and Taxes or Expenses watever.
But i want my total amount consolidated not in seprate seprate account..
I hope now u understand what i need.
If there is any further query then please feel free to ask.
Thanks
Regards
CA Mahaveer Somani
–
You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.