Can i add one custom field with formula also....?

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.

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.

Mahaveer,

Can you make your question clearer.

Like:

This is what I did:

1. ...
2. ...
3. ...

This is what I got:

1. ...
2. ...

This is what I expect:

1. ...
2. ...

Please feel free to include screen shots links (via dropbox or imgur) Don't paste them directly in the mail.

best,
Rushabh


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

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.

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.

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.

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.

Thanks Mahaveer, thats clearer,

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.

Please see this slightly oldish manual for help:

http://erpnext.blogspot.in/2011/02/how-to-create-template-for-taxes-and.html

best,
Rushabh


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

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.

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.

<what i did.jpg><What i expect.jpg><By default.jpg>




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 think still there are some confustion to you..


actually in our business we can not claim input tax against output tax therefore we can not save our VAT amount under Tax head.

therefore i added one more column with the name of VAT, so our calculation part made easier.

so can you help me now.....on my expectation.



Thanks 
Regards
CA Mahaveer Somani



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 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.


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

On 07-Sep-2013, at 1:49 PM, Mahaveer Somani <ca...@gmail.com> wrote:

i think still there are some confustion to you..


actually in our business we can not claim input tax against output tax therefore we can not save our VAT amount under Tax head.

therefore i added one more column with the name of VAT, so our calculation part made easier.

so can you help me now.....on my expectation.



Thanks 
Regards
CA Mahaveer Somani



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 Mahaveer,

I think this can be achieved by selecting an expense account in the tax table say VAT Expense as type Total. 

This way you expense out the VAT immediately on receipt of stock and yet keep the valuation of the item without the VAT. 

-anand. 

Sent from my phone

On 07-Sep-2013, at 1:49 PM, Mahaveer Somani <ca...@gmail.com> wrote:

i think still there are some confustion to you..


actually in our business we can not claim input tax against output tax therefore we can not save our VAT amount under Tax head.

therefore i added one more column with the name of VAT, so our calculation part made easier.

so can you help me now.....on my expectation.



Thanks 
Regards
CA Mahaveer Somani



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.

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.

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.

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.

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.