VAT on purchase orders

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
19 messages Options
Reply | Threaded
Open this post in threaded view
|

VAT on purchase orders

Hans Bakker

I have a request from a customer to enable the VAT tax calculation on
purchase orders. I have read the messages in the past about this subject
and want to propose the following to implement this feature:

1. add a second glAccountId for outgoing tax to the
TaxAuthorityGlAccount.
2. adjust the programs to calculate the vat (sales tax) on purchase
orders the same way as sales orders, but use for the productstoreId a
blank entry.

Is this a reasonable approach?

Regards,
Hans





Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

rogernb
Hans,

I have the same request from a customer and I consider your approach to be totally reasonable. Nevertheless, I would like to know if it is a good practice to open the java file and just do the needed changes to the code.

I read the code in OrderServices.java and I noticed there are several clauses which ommit the purchase orders while calculating taxes. So I think it is just a matter of modifying these clauses, let the taxes be calculated for purchase orders too and load these taxes in a account.

What do you think? would it be enough to modify the code in OrderServices?


Hans Bakker wrote
I have a request from a customer to enable the VAT tax calculation on
purchase orders. I have read the messages in the past about this subject
and want to propose the following to implement this feature:

1. add a second glAccountId for outgoing tax to the
TaxAuthorityGlAccount.
2. adjust the programs to calculate the vat (sales tax) on purchase
orders the same way as sales orders, but use for the productstoreId a
blank entry.

Is this a reasonable approach?

Regards,
Hans




Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

hans_bakker
Hi Roger,
i think i removed these clauses and the vat calculation should work now.
Did not do the first point yet though....
So please try it..

Regards,
Hans

On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:

> Hans,
>
> I have the same request from a customer and I consider your approach to be
> totally reasonable. Nevertheless, I would like to know if it is a good
> practice to open the java file and just do the needed changes to the code.
>
> I read the code in OrderServices.java and I noticed there are several
> clauses which ommit the purchase orders while calculating taxes. So I think
> it is just a matter of modifying these clauses, let the taxes be calculated
> for purchase orders too and load these taxes in a account.
>
> What do you think? would it be enough to modify the code in OrderServices?
>
>
>
> Hans Bakker wrote:
> >
> >
> > I have a request from a customer to enable the VAT tax calculation on
> > purchase orders. I have read the messages in the past about this subject
> > and want to propose the following to implement this feature:
> >
> > 1. add a second glAccountId for outgoing tax to the
> > TaxAuthorityGlAccount.
> > 2. adjust the programs to calculate the vat (sales tax) on purchase
> > orders the same way as sales orders, but use for the productstoreId a
> > blank entry.
> >
> > Is this a reasonable approach?
> >
> > Regards,
> > Hans
> >
> >
> >
> >
> >
> >
> >
>

Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

rogernb
Hi Hans,

I have removed the clauses already, but I am not sure of how to compile everything again. I run windows so I tried to run:

-ant
-ant run

from the command line, but I see no changes in the application. Can you give to me any suggestion?

thnx,

Roger.

hansbak wrote
Hi Roger,
i think i removed these clauses and the vat calculation should work now.
Did not do the first point yet though....
So please try it..

Regards,
Hans

On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
> Hans,
>
> I have the same request from a customer and I consider your approach to be
> totally reasonable. Nevertheless, I would like to know if it is a good
> practice to open the java file and just do the needed changes to the code.
>
> I read the code in OrderServices.java and I noticed there are several
> clauses which ommit the purchase orders while calculating taxes. So I think
> it is just a matter of modifying these clauses, let the taxes be calculated
> for purchase orders too and load these taxes in a account.
>
> What do you think? would it be enough to modify the code in OrderServices?
>
>
>
> Hans Bakker wrote:
> >
> >
> > I have a request from a customer to enable the VAT tax calculation on
> > purchase orders. I have read the messages in the past about this subject
> > and want to propose the following to implement this feature:
> >
> > 1. add a second glAccountId for outgoing tax to the
> > TaxAuthorityGlAccount.
> > 2. adjust the programs to calculate the vat (sales tax) on purchase
> > orders the same way as sales orders, but use for the productstoreId a
> > blank entry.
> >
> > Is this a reasonable approach?
> >
> > Regards,
> > Hans
> >
> >
> >
> >
> >
> >
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

BJ Freeman
try
ant clean
ant run-install


rogernb sent the following on 8/10/2008 5:17 PM:

> Hi Hans,
>
> I have removed the clauses already, but I am not sure of how to compile
> everything again. I run windows so I tried to run:
>
> -ant
> -ant run
>
> from the command line, but I see no changes in the application. Can you give
> to me any suggestion?
>
> thnx,
>
> Roger.
>
>
> hansbak wrote:
>> Hi Roger,
>> i think i removed these clauses and the vat calculation should work now.
>> Did not do the first point yet though....
>> So please try it..
>>
>> Regards,
>> Hans
>>
>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>> Hans,
>>>
>>> I have the same request from a customer and I consider your approach to
>>> be
>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>> practice to open the java file and just do the needed changes to the
>>> code.
>>>
>>> I read the code in OrderServices.java and I noticed there are several
>>> clauses which ommit the purchase orders while calculating taxes. So I
>>> think
>>> it is just a matter of modifying these clauses, let the taxes be
>>> calculated
>>> for purchase orders too and load these taxes in a account.
>>>
>>> What do you think? would it be enough to modify the code in
>>> OrderServices?
>>>
>>>
>>>
>>> Hans Bakker wrote:
>>>>
>>>> I have a request from a customer to enable the VAT tax calculation on
>>>> purchase orders. I have read the messages in the past about this
>>> subject
>>>> and want to propose the following to implement this feature:
>>>>
>>>> 1. add a second glAccountId for outgoing tax to the
>>>> TaxAuthorityGlAccount.
>>>> 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>> orders the same way as sales orders, but use for the productstoreId a
>>>> blank entry.
>>>>
>>>> Is this a reasonable approach?
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

rogernb
I tried that and it didn't work. The tax is not calculated.

BJ Freeman wrote
try
ant clean
ant run-install


rogernb sent the following on 8/10/2008 5:17 PM:
> Hi Hans,
>
> I have removed the clauses already, but I am not sure of how to compile
> everything again. I run windows so I tried to run:
>
> -ant
> -ant run
>
> from the command line, but I see no changes in the application. Can you give
> to me any suggestion?
>
> thnx,
>
> Roger.
>
>
> hansbak wrote:
>> Hi Roger,
>> i think i removed these clauses and the vat calculation should work now.
>> Did not do the first point yet though....
>> So please try it..
>>
>> Regards,
>> Hans
>>
>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>> Hans,
>>>
>>> I have the same request from a customer and I consider your approach to
>>> be
>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>> practice to open the java file and just do the needed changes to the
>>> code.
>>>
>>> I read the code in OrderServices.java and I noticed there are several
>>> clauses which ommit the purchase orders while calculating taxes. So I
>>> think
>>> it is just a matter of modifying these clauses, let the taxes be
>>> calculated
>>> for purchase orders too and load these taxes in a account.
>>>
>>> What do you think? would it be enough to modify the code in
>>> OrderServices?
>>>
>>>
>>>
>>> Hans Bakker wrote:
>>>>
>>>> I have a request from a customer to enable the VAT tax calculation on
>>>> purchase orders. I have read the messages in the past about this
>>> subject
>>>> and want to propose the following to implement this feature:
>>>>
>>>> 1. add a second glAccountId for outgoing tax to the
>>>> TaxAuthorityGlAccount.
>>>> 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>> orders the same way as sales orders, but use for the productstoreId a
>>>> blank entry.
>>>>
>>>> Is this a reasonable approach?
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

rogernb
Hans,

The solution is compiling successfully, but the application still does not calculate taxes for purchase orders. Do you have any idea of something else that should be changed?

rogernb wrote
I tried that and it didn't work. The tax is not calculated.

BJ Freeman wrote
try
ant clean
ant run-install


rogernb sent the following on 8/10/2008 5:17 PM:
> Hi Hans,
>
> I have removed the clauses already, but I am not sure of how to compile
> everything again. I run windows so I tried to run:
>
> -ant
> -ant run
>
> from the command line, but I see no changes in the application. Can you give
> to me any suggestion?
>
> thnx,
>
> Roger.
>
>
> hansbak wrote:
>> Hi Roger,
>> i think i removed these clauses and the vat calculation should work now.
>> Did not do the first point yet though....
>> So please try it..
>>
>> Regards,
>> Hans
>>
>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>> Hans,
>>>
>>> I have the same request from a customer and I consider your approach to
>>> be
>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>> practice to open the java file and just do the needed changes to the
>>> code.
>>>
>>> I read the code in OrderServices.java and I noticed there are several
>>> clauses which ommit the purchase orders while calculating taxes. So I
>>> think
>>> it is just a matter of modifying these clauses, let the taxes be
>>> calculated
>>> for purchase orders too and load these taxes in a account.
>>>
>>> What do you think? would it be enough to modify the code in
>>> OrderServices?
>>>
>>>
>>>
>>> Hans Bakker wrote:
>>>>
>>>> I have a request from a customer to enable the VAT tax calculation on
>>>> purchase orders. I have read the messages in the past about this
>>> subject
>>>> and want to propose the following to implement this feature:
>>>>
>>>> 1. add a second glAccountId for outgoing tax to the
>>>> TaxAuthorityGlAccount.
>>>> 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>> orders the same way as sales orders, but use for the productstoreId a
>>>> blank entry.
>>>>
>>>> Is this a reasonable approach?
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

kunal aggarwal
Hello all

tax will only be calculated only if order type is "SALES_ORDER".
This condition is checked in TaxAuthorityServices.java . So the above method
wont give u the solutions.


Kunal

On Mon, Aug 11, 2008 at 9:08 PM, rogernb <[hidden email]> wrote:

>
> Hans,
>
> The solution is compiling successfully, but the application still does not
> calculate taxes for purchase orders. Do you have any idea of something else
> that should be changed?
>
>
> rogernb wrote:
> >
> > I tried that and it didn't work. The tax is not calculated.
> >
> >
> > BJ Freeman wrote:
> >>
> >> try
> >> ant clean
> >> ant run-install
> >>
> >>
> >> rogernb sent the following on 8/10/2008 5:17 PM:
> >>> Hi Hans,
> >>>
> >>> I have removed the clauses already, but I am not sure of how to compile
> >>> everything again. I run windows so I tried to run:
> >>>
> >>> -ant
> >>> -ant run
> >>>
> >>> from the command line, but I see no changes in the application. Can you
> >>> give
> >>> to me any suggestion?
> >>>
> >>> thnx,
> >>>
> >>> Roger.
> >>>
> >>>
> >>> hansbak wrote:
> >>>> Hi Roger,
> >>>> i think i removed these clauses and the vat calculation should work
> >>>> now.
> >>>> Did not do the first point yet though....
> >>>> So please try it..
> >>>>
> >>>> Regards,
> >>>> Hans
> >>>>
> >>>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
> >>>>> Hans,
> >>>>>
> >>>>> I have the same request from a customer and I consider your approach
> >>>>> to
> >>>>> be
> >>>>> totally reasonable. Nevertheless, I would like to know if it is a
> good
> >>>>> practice to open the java file and just do the needed changes to the
> >>>>> code.
> >>>>>
> >>>>> I read the code in OrderServices.java and I noticed there are several
> >>>>> clauses which ommit the purchase orders while calculating taxes. So I
> >>>>> think
> >>>>> it is just a matter of modifying these clauses, let the taxes be
> >>>>> calculated
> >>>>> for purchase orders too and load these taxes in a account.
> >>>>>
> >>>>> What do you think? would it be enough to modify the code in
> >>>>> OrderServices?
> >>>>>
> >>>>>
> >>>>>
> >>>>> Hans Bakker wrote:
> >>>>>>
> >>>>>> I have a request from a customer to enable the VAT tax calculation
> on
> >>>>>> purchase orders. I have read the messages in the past about this
> >>>>> subject
> >>>>>> and want to propose the following to implement this feature:
> >>>>>>
> >>>>>> 1. add a second glAccountId for outgoing tax to the
> >>>>>> TaxAuthorityGlAccount.
> >>>>>> 2. adjust the programs to calculate the vat (sales tax) on purchase
> >>>>>> orders the same way as sales orders, but use for the productstoreId
> a
> >>>>>> blank entry.
> >>>>>>
> >>>>>> Is this a reasonable approach?
> >>>>>>
> >>>>>> Regards,
> >>>>>> Hans
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >>>>
> >>>
> >>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p18928237.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Jacques Le Roux
Administrator
This has been discussed many times. You may foud some interesting answers on Nabble or Markamil looking for "purchase tax"

So if you are really interested by this you have 2 solutions
1. Do it yourself
2. Hire an OFBiz consultant

Of course we are open to disussion since in some simple cases (for instance purchased in the same country with "simple" tax system
like VAT) it could be handled quite easily I guess

Jacques

From: "kunal aggarwal" <[hidden email]>

> Hello all
>
> tax will only be calculated only if order type is "SALES_ORDER".
> This condition is checked in TaxAuthorityServices.java . So the above method
> wont give u the solutions.
>
>
> Kunal
>
> On Mon, Aug 11, 2008 at 9:08 PM, rogernb <[hidden email]> wrote:
>
>>
>> Hans,
>>
>> The solution is compiling successfully, but the application still does not
>> calculate taxes for purchase orders. Do you have any idea of something else
>> that should be changed?
>>
>>
>> rogernb wrote:
>> >
>> > I tried that and it didn't work. The tax is not calculated.
>> >
>> >
>> > BJ Freeman wrote:
>> >>
>> >> try
>> >> ant clean
>> >> ant run-install
>> >>
>> >>
>> >> rogernb sent the following on 8/10/2008 5:17 PM:
>> >>> Hi Hans,
>> >>>
>> >>> I have removed the clauses already, but I am not sure of how to compile
>> >>> everything again. I run windows so I tried to run:
>> >>>
>> >>> -ant
>> >>> -ant run
>> >>>
>> >>> from the command line, but I see no changes in the application. Can you
>> >>> give
>> >>> to me any suggestion?
>> >>>
>> >>> thnx,
>> >>>
>> >>> Roger.
>> >>>
>> >>>
>> >>> hansbak wrote:
>> >>>> Hi Roger,
>> >>>> i think i removed these clauses and the vat calculation should work
>> >>>> now.
>> >>>> Did not do the first point yet though....
>> >>>> So please try it..
>> >>>>
>> >>>> Regards,
>> >>>> Hans
>> >>>>
>> >>>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>> >>>>> Hans,
>> >>>>>
>> >>>>> I have the same request from a customer and I consider your approach
>> >>>>> to
>> >>>>> be
>> >>>>> totally reasonable. Nevertheless, I would like to know if it is a
>> good
>> >>>>> practice to open the java file and just do the needed changes to the
>> >>>>> code.
>> >>>>>
>> >>>>> I read the code in OrderServices.java and I noticed there are several
>> >>>>> clauses which ommit the purchase orders while calculating taxes. So I
>> >>>>> think
>> >>>>> it is just a matter of modifying these clauses, let the taxes be
>> >>>>> calculated
>> >>>>> for purchase orders too and load these taxes in a account.
>> >>>>>
>> >>>>> What do you think? would it be enough to modify the code in
>> >>>>> OrderServices?
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> Hans Bakker wrote:
>> >>>>>>
>> >>>>>> I have a request from a customer to enable the VAT tax calculation
>> on
>> >>>>>> purchase orders. I have read the messages in the past about this
>> >>>>> subject
>> >>>>>> and want to propose the following to implement this feature:
>> >>>>>>
>> >>>>>> 1. add a second glAccountId for outgoing tax to the
>> >>>>>> TaxAuthorityGlAccount.
>> >>>>>> 2. adjust the programs to calculate the vat (sales tax) on purchase
>> >>>>>> orders the same way as sales orders, but use for the productstoreId
>> a
>> >>>>>> blank entry.
>> >>>>>>
>> >>>>>> Is this a reasonable approach?
>> >>>>>>
>> >>>>>> Regards,
>> >>>>>> Hans
>> >>>>>>
>> >>>>>>
>> >>>>>>
>> >>>>>>
>> >>>>>>
>> >>>>>>
>> >>>>>>
>> >>>>
>> >>>>
>> >>>
>> >>
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p18928237.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

rogernb
Jacques,

jacques.le.roux wrote
So if you are really interested by this you have 2 solutions
1. Do it yourself
2. Hire an OFBiz consultant
Of course I am willing to do it by myself. I just wanted some guidance from you because you are the experts in OfBiz. I want this to be part of the project because I consider it is a really important issue but I only wanted some push into the right track.

jacques.le.roux wrote
Of course we are open to disussion since in some simple cases (for instance purchased in the same country with "simple" tax system
like VAT) it could be handled quite easily I guess
In my case it is simple. Here in Mexico the taxes need to be calculated in purchase and sales orders and added in different accounts like tax receivable and tax payable, afterwards they have to be compared to determine the actual amount the company has to pay, that's all. But it must be done step by step. First, tax for purchase orders must be calculated and added in a GL account.

kunal,

kunal aggarwal wrote
tax will only be calculated only if order type is "SALES_ORDER".
This condition is checked in TaxAuthorityServices.java . So the above method
wont give u the solutions.
Thanks for your suggestion, I'll review it.
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

BJ Freeman
just a note:
the only thing that adds to a GL is the transaction Journal.
so any transaction must go to the transaction journal as credit debit
for each item.

rogernb sent the following on 8/12/2008 9:37 AM:

> Jacques,
>
>
> jacques.le.roux wrote:
>>
>> So if you are really interested by this you have 2 solutions
>> 1. Do it yourself
>> 2. Hire an OFBiz consultant
>>
>>
>
> Of course I am willing to do it by myself. I just wanted some guidance from
> you because you are the experts in OfBiz. I want this to be part of the
> project because I consider it is a really important issue but I only wanted
> some push into the right track.
>
>
> jacques.le.roux wrote:
>> Of course we are open to disussion since in some simple cases (for
>> instance purchased in the same country with "simple" tax system
>> like VAT) it could be handled quite easily I guess
>>
>
> In my case it is simple. Here in Mexico the taxes need to be calculated in
> purchase and sales orders and added in different accounts like tax
> receivable and tax payable, afterwards they have to be compared to determine
> the actual amount the company has to pay, that's all. But it must be done
> step by step. First, tax for purchase orders must be calculated and added in
> a GL account.
>
> kunal,
>
>
> kunal aggarwal wrote:
>> tax will only be calculated only if order type is "SALES_ORDER".
>> This condition is checked in TaxAuthorityServices.java . So the above
>> method
>> wont give u the solutions.
>>
>
> Thanks for your suggestion, I'll review it.

Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Jacques Le Roux
Administrator
In reply to this post by rogernb
Roger,

Maybe we need to clarify things at this point. Do you mean that your administration forces you to put the amounts of tax that will
be collected by your supplier in purchase orders you send to her/him ?
This is really weird, as it's not something related to ordering but accounting. Only when the order will be fullfilled and items in
your inventories (a lot of things can happen between : some items may missing in supplier inventory, ot may be destroyed during the
transport, you may not ever receive the order sent by the supplier, etc.) the accounting part can take place. So I'm surprise be
such a compulsory act. Could you please confirm and elaborate about that point ?

Thanks

Jacques

From: "rogernb" <[hidden email]>

> In my case it is simple. Here in Mexico the taxes need to be calculated in
> purchase and sales orders and added in different accounts like tax
> receivable and tax payable, afterwards they have to be compared to determine
> the actual amount the company has to pay, that's all. But it must be done
> step by step. First, tax for purchase orders must be calculated and added in
> a GL account.
>
> kunal,
>
>
> kunal aggarwal wrote:
>>
>> tax will only be calculated only if order type is "SALES_ORDER".
>> This condition is checked in TaxAuthorityServices.java . So the above
>> method
>> wont give u the solutions.
>>
>
> Thanks for your suggestion, I'll review it.
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p18948064.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Balaji Sundar
In reply to this post by hans_bakker
Hi,

Even i am having the same requirement...

May i know what are the changes to be made and where

thanks

hansbak wrote
Hi Roger,
i think i removed these clauses and the vat calculation should work now.
Did not do the first point yet though....
So please try it..

Regards,
Hans

On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
> Hans,
>
> I have the same request from a customer and I consider your approach to be
> totally reasonable. Nevertheless, I would like to know if it is a good
> practice to open the java file and just do the needed changes to the code.
>
> I read the code in OrderServices.java and I noticed there are several
> clauses which ommit the purchase orders while calculating taxes. So I think
> it is just a matter of modifying these clauses, let the taxes be calculated
> for purchase orders too and load these taxes in a account.
>
> What do you think? would it be enough to modify the code in OrderServices?
>
>
>
> Hans Bakker wrote:
> >
> >
> > I have a request from a customer to enable the VAT tax calculation on
> > purchase orders. I have read the messages in the past about this subject
> > and want to propose the following to implement this feature:
> >
> > 1. add a second glAccountId for outgoing tax to the
> > TaxAuthorityGlAccount.
> > 2. adjust the programs to calculate the vat (sales tax) on purchase
> > orders the same way as sales orders, but use for the productstoreId a
> > blank entry.
> >
> > Is this a reasonable approach?
> >
> > Regards,
> > Hans
> >
> >
> >
> >
> >
> >
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Jacques Le Roux
Administrator
Balaji,

Did you read my last answer and questions in this thread ?
Is this needed by some laws somewhere ?
As David explained many times, we are not sure there is a generic (global) way of doing that...

Jacques

From: "Balaji Sundar" <[hidden email]>

>
> Hi,
>
> Even i am having the same requirement...
>
> May i know what are the changes to be made and where
>
> thanks
>
>
> hansbak wrote:
>>
>> Hi Roger,
>> i think i removed these clauses and the vat calculation should work now.
>> Did not do the first point yet though....
>> So please try it..
>>
>> Regards,
>> Hans
>>
>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>> Hans,
>>>
>>> I have the same request from a customer and I consider your approach to
>>> be
>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>> practice to open the java file and just do the needed changes to the
>>> code.
>>>
>>> I read the code in OrderServices.java and I noticed there are several
>>> clauses which ommit the purchase orders while calculating taxes. So I
>>> think
>>> it is just a matter of modifying these clauses, let the taxes be
>>> calculated
>>> for purchase orders too and load these taxes in a account.
>>>
>>> What do you think? would it be enough to modify the code in
>>> OrderServices?
>>>
>>>
>>>
>>> Hans Bakker wrote:
>>> >
>>> >
>>> > I have a request from a customer to enable the VAT tax calculation on
>>> > purchase orders. I have read the messages in the past about this
>>> subject
>>> > and want to propose the following to implement this feature:
>>> >
>>> > 1. add a second glAccountId for outgoing tax to the
>>> > TaxAuthorityGlAccount.
>>> > 2. adjust the programs to calculate the vat (sales tax) on purchase
>>> > orders the same way as sales orders, but use for the productstoreId a
>>> > blank entry.
>>> >
>>> > Is this a reasonable approach?
>>> >
>>> > Regards,
>>> > Hans
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19155972.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Balaji Sundar
Yes...  I Understand...

Here in India, tax will be told by the vendor and that will be included when generating purchase orders and we do not enter it manually.
I thought it was global.... but in the end i was wrong..


jacques.le.roux wrote
Balaji,

Did you read my last answer and questions in this thread ?
Is this needed by some laws somewhere ?
As David explained many times, we are not sure there is a generic (global) way of doing that...

Jacques

From: "Balaji Sundar" <ks.sundarrajan@gmail.com>
>
> Hi,
>
> Even i am having the same requirement...
>
> May i know what are the changes to be made and where
>
> thanks
>
>
> hansbak wrote:
>>
>> Hi Roger,
>> i think i removed these clauses and the vat calculation should work now.
>> Did not do the first point yet though....
>> So please try it..
>>
>> Regards,
>> Hans
>>
>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>> Hans,
>>>
>>> I have the same request from a customer and I consider your approach to
>>> be
>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>> practice to open the java file and just do the needed changes to the
>>> code.
>>>
>>> I read the code in OrderServices.java and I noticed there are several
>>> clauses which ommit the purchase orders while calculating taxes. So I
>>> think
>>> it is just a matter of modifying these clauses, let the taxes be
>>> calculated
>>> for purchase orders too and load these taxes in a account.
>>>
>>> What do you think? would it be enough to modify the code in
>>> OrderServices?
>>>
>>>
>>>
>>> Hans Bakker wrote:
>>> >
>>> >
>>> > I have a request from a customer to enable the VAT tax calculation on
>>> > purchase orders. I have read the messages in the past about this
>>> subject
>>> > and want to propose the following to implement this feature:
>>> >
>>> > 1. add a second glAccountId for outgoing tax to the
>>> > TaxAuthorityGlAccount.
>>> > 2. adjust the programs to calculate the vat (sales tax) on purchase
>>> > orders the same way as sales orders, but use for the productstoreId a
>>> > blank entry.
>>> >
>>> > Is this a reasonable approach?
>>> >
>>> > Regards,
>>> > Hans
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19155972.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Jacques Le Roux
Administrator
From: "Balaji Sundar" <[hidden email]>
> Yes...  I Understand...
>
> Here in India, tax will be told by the vendor and that will be included when
> generating purchase orders and we do not enter it manually.

But how is this working PO by PO, if you don't enter it manually ?
Have you an use case (process) to explain us ?

Jacques

> I thought it was global.... but in the end i was wrong..
>
>
>
> jacques.le.roux wrote:
>>
>> Balaji,
>>
>> Did you read my last answer and questions in this thread ?
>> Is this needed by some laws somewhere ?
>> As David explained many times, we are not sure there is a generic (global)
>> way of doing that...
>>
>> Jacques
>>
>> From: "Balaji Sundar" <[hidden email]>
>>>
>>> Hi,
>>>
>>> Even i am having the same requirement...
>>>
>>> May i know what are the changes to be made and where
>>>
>>> thanks
>>>
>>>
>>> hansbak wrote:
>>>>
>>>> Hi Roger,
>>>> i think i removed these clauses and the vat calculation should work now.
>>>> Did not do the first point yet though....
>>>> So please try it..
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>>>> Hans,
>>>>>
>>>>> I have the same request from a customer and I consider your approach to
>>>>> be
>>>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>>>> practice to open the java file and just do the needed changes to the
>>>>> code.
>>>>>
>>>>> I read the code in OrderServices.java and I noticed there are several
>>>>> clauses which ommit the purchase orders while calculating taxes. So I
>>>>> think
>>>>> it is just a matter of modifying these clauses, let the taxes be
>>>>> calculated
>>>>> for purchase orders too and load these taxes in a account.
>>>>>
>>>>> What do you think? would it be enough to modify the code in
>>>>> OrderServices?
>>>>>
>>>>>
>>>>>
>>>>> Hans Bakker wrote:
>>>>> >
>>>>> >
>>>>> > I have a request from a customer to enable the VAT tax calculation on
>>>>> > purchase orders. I have read the messages in the past about this
>>>>> subject
>>>>> > and want to propose the following to implement this feature:
>>>>> >
>>>>> > 1. add a second glAccountId for outgoing tax to the
>>>>> > TaxAuthorityGlAccount.
>>>>> > 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>>> > orders the same way as sales orders, but use for the productstoreId a
>>>>> > blank entry.
>>>>> >
>>>>> > Is this a reasonable approach?
>>>>> >
>>>>> > Regards,
>>>>> > Hans
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19155972.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19157799.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Balaji Sundar
Here is what we follow as PO & hence this is my requirement:

Main Flow:
The process of purchase order is as follows:
1. Here, the Purchase executive requests for quotations with multiple vendors.
2. The request for quotations involves the item, quantity required, price range, VAT, delivery date range, quality expected,payment details like against delivery,after 7 days after delivery etc  and other required features which depends on the item of request.
3. When this quotation is requested, vendors respond with their quotations for the item.
4. Out of n number of responses, only one quotation is accepted which best suits our needs.
5. When a quotation is accepted, a purchase order with the following details is generated – item name, item category, item code, quantity, price, VAT, discounts if any, delivery address, vendor address.
6. This purchase order is then sent to the respective vendor for delivery of the item.

Everyting is fine .--- except the VAT part

jacques.le.roux wrote
From: "Balaji Sundar" <ks.sundarrajan@gmail.com>
> Yes...  I Understand...
>
> Here in India, tax will be told by the vendor and that will be included when
> generating purchase orders and we do not enter it manually.

But how is this working PO by PO, if you don't enter it manually ?
Have you an use case (process) to explain us ?

Jacques

> I thought it was global.... but in the end i was wrong..
>
>
>
> jacques.le.roux wrote:
>>
>> Balaji,
>>
>> Did you read my last answer and questions in this thread ?
>> Is this needed by some laws somewhere ?
>> As David explained many times, we are not sure there is a generic (global)
>> way of doing that...
>>
>> Jacques
>>
>> From: "Balaji Sundar" <ks.sundarrajan@gmail.com>
>>>
>>> Hi,
>>>
>>> Even i am having the same requirement...
>>>
>>> May i know what are the changes to be made and where
>>>
>>> thanks
>>>
>>>
>>> hansbak wrote:
>>>>
>>>> Hi Roger,
>>>> i think i removed these clauses and the vat calculation should work now.
>>>> Did not do the first point yet though....
>>>> So please try it..
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>>>> Hans,
>>>>>
>>>>> I have the same request from a customer and I consider your approach to
>>>>> be
>>>>> totally reasonable. Nevertheless, I would like to know if it is a good
>>>>> practice to open the java file and just do the needed changes to the
>>>>> code.
>>>>>
>>>>> I read the code in OrderServices.java and I noticed there are several
>>>>> clauses which ommit the purchase orders while calculating taxes. So I
>>>>> think
>>>>> it is just a matter of modifying these clauses, let the taxes be
>>>>> calculated
>>>>> for purchase orders too and load these taxes in a account.
>>>>>
>>>>> What do you think? would it be enough to modify the code in
>>>>> OrderServices?
>>>>>
>>>>>
>>>>>
>>>>> Hans Bakker wrote:
>>>>> >
>>>>> >
>>>>> > I have a request from a customer to enable the VAT tax calculation on
>>>>> > purchase orders. I have read the messages in the past about this
>>>>> subject
>>>>> > and want to propose the following to implement this feature:
>>>>> >
>>>>> > 1. add a second glAccountId for outgoing tax to the
>>>>> > TaxAuthorityGlAccount.
>>>>> > 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>>> > orders the same way as sales orders, but use for the productstoreId a
>>>>> > blank entry.
>>>>> >
>>>>> > Is this a reasonable approach?
>>>>> >
>>>>> > Regards,
>>>>> > Hans
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19155972.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19157799.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Jacques Le Roux
Administrator
From: "Balaji Sundar" <[hidden email]>

>
> Here is what we follow as PO & hence this is my requirement:
>
> Main Flow:
> The process of purchase order is as follows:
> 1. Here, the Purchase executive requests for quotations with multiple
> vendors.
> 2. The request for quotations involves the item, quantity required, price
> range, VAT, delivery date range, quality expected,payment details like
> against delivery,after 7 days after delivery etc  and other required
> features which depends on the item of request.
> 3. When this quotation is requested, vendors respond with their quotations
> for the item.
> 4. Out of n number of responses, only one quotation is accepted which best
> suits our needs.
> 5. When a quotation is accepted, a purchase order with the following details
> is generated – item name, item category, item code, quantity, price, VAT,
> discounts if any, delivery address, vendor address.
> 6. This purchase order is then sent to the respective vendor for delivery of
> the item.
>
> Everyting is fine .--- except the VAT part

OK, so if you don't want to enter it manually (which makes sense) do you have to have a VAT rate by product or by product/supplier
couples ?
Does it make sense to have different VAT rates by supplier ? I suppose this does not make much sense, but I prefer to ask the
question...

BTW you might be interested by this page http://docs.ofbiz.org/display/OFBIZ/VAT, notably Purchase order VAT paragraph
Feel free to add any interesting comments

Thanks

Jacques

>
> jacques.le.roux wrote:
>>
>> From: "Balaji Sundar" <[hidden email]>
>>> Yes...  I Understand...
>>>
>>> Here in India, tax will be told by the vendor and that will be included
>>> when
>>> generating purchase orders and we do not enter it manually.
>>
>> But how is this working PO by PO, if you don't enter it manually ?
>> Have you an use case (process) to explain us ?
>>
>> Jacques
>>
>>> I thought it was global.... but in the end i was wrong..
>>>
>>>
>>>
>>> jacques.le.roux wrote:
>>>>
>>>> Balaji,
>>>>
>>>> Did you read my last answer and questions in this thread ?
>>>> Is this needed by some laws somewhere ?
>>>> As David explained many times, we are not sure there is a generic
>>>> (global)
>>>> way of doing that...
>>>>
>>>> Jacques
>>>>
>>>> From: "Balaji Sundar" <[hidden email]>
>>>>>
>>>>> Hi,
>>>>>
>>>>> Even i am having the same requirement...
>>>>>
>>>>> May i know what are the changes to be made and where
>>>>>
>>>>> thanks
>>>>>
>>>>>
>>>>> hansbak wrote:
>>>>>>
>>>>>> Hi Roger,
>>>>>> i think i removed these clauses and the vat calculation should work
>>>>>> now.
>>>>>> Did not do the first point yet though....
>>>>>> So please try it..
>>>>>>
>>>>>> Regards,
>>>>>> Hans
>>>>>>
>>>>>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>>>>>> Hans,
>>>>>>>
>>>>>>> I have the same request from a customer and I consider your approach
>>>>>>> to
>>>>>>> be
>>>>>>> totally reasonable. Nevertheless, I would like to know if it is a
>>>>>>> good
>>>>>>> practice to open the java file and just do the needed changes to the
>>>>>>> code.
>>>>>>>
>>>>>>> I read the code in OrderServices.java and I noticed there are several
>>>>>>> clauses which ommit the purchase orders while calculating taxes. So I
>>>>>>> think
>>>>>>> it is just a matter of modifying these clauses, let the taxes be
>>>>>>> calculated
>>>>>>> for purchase orders too and load these taxes in a account.
>>>>>>>
>>>>>>> What do you think? would it be enough to modify the code in
>>>>>>> OrderServices?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Hans Bakker wrote:
>>>>>>> >
>>>>>>> >
>>>>>>> > I have a request from a customer to enable the VAT tax calculation
>>>>>>> on
>>>>>>> > purchase orders. I have read the messages in the past about this
>>>>>>> subject
>>>>>>> > and want to propose the following to implement this feature:
>>>>>>> >
>>>>>>> > 1. add a second glAccountId for outgoing tax to the
>>>>>>> > TaxAuthorityGlAccount.
>>>>>>> > 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>>>>> > orders the same way as sales orders, but use for the productstoreId
>>>>>>> a
>>>>>>> > blank entry.
>>>>>>> >
>>>>>>> > Is this a reasonable approach?
>>>>>>> >
>>>>>>> > Regards,
>>>>>>> > Hans
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19155972.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19157799.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19158211.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Reply | Threaded
Open this post in threaded view
|

Re: VAT on purchase orders

Jacques Le Roux
Administrator
In reply to this post by Balaji Sundar
From: "Balaji Sundar" <[hidden email]>

>
> Here is what we follow as PO & hence this is my requirement:
>
> Main Flow:
> The process of purchase order is as follows:
> 1. Here, the Purchase executive requests for quotations with multiple
> vendors.
> 2. The request for quotations involves the item, quantity required, price
> range, VAT, delivery date range, quality expected,payment details like
> against delivery,after 7 days after delivery etc  and other required
> features which depends on the item of request.
> 3. When this quotation is requested, vendors respond with their quotations
> for the item.
> 4. Out of n number of responses, only one quotation is accepted which best
> suits our needs.
> 5. When a quotation is accepted, a purchase order with the following details
> is generated – item name, item category, item code, quantity, price, VAT,
> discounts if any, delivery address, vendor address.
> 6. This purchase order is then sent to the respective vendor for delivery of
> the item.
>
> Everyting is fine .--- except the VAT part

OK, so if you don't want to enter it manually (which makes sense) do you have to have a VAT rate by product or by product/supplier
couples ?
Does it make sense to have different VAT rates by supplier ? I suppose this does not make much sense, but I prefer to ask the
question...

BTW you might be interested by this page http://docs.ofbiz.org/display/OFBIZ/VAT, notably Purchase order VAT paragraph. Hans wrote
it, but you should be aware as it's the begining of this thread :o)

Looks like we are turning round and round on this :D

Note this interesting one from Chris Howe though http://www.nabble.com/Re%3A-VAT-and-gross-pricing-p6790865.html

Jacques

>
> jacques.le.roux wrote:
>>
>> From: "Balaji Sundar" <[hidden email]>
>>> Yes...  I Understand...
>>>
>>> Here in India, tax will be told by the vendor and that will be included
>>> when
>>> generating purchase orders and we do not enter it manually.
>>
>> But how is this working PO by PO, if you don't enter it manually ?
>> Have you an use case (process) to explain us ?
>>
>> Jacques
>>
>>> I thought it was global.... but in the end i was wrong..
>>>
>>>
>>>
>>> jacques.le.roux wrote:
>>>>
>>>> Balaji,
>>>>
>>>> Did you read my last answer and questions in this thread ?
>>>> Is this needed by some laws somewhere ?
>>>> As David explained many times, we are not sure there is a generic
>>>> (global)
>>>> way of doing that...
>>>>
>>>> Jacques
>>>>
>>>> From: "Balaji Sundar" <[hidden email]>
>>>>>
>>>>> Hi,
>>>>>
>>>>> Even i am having the same requirement...
>>>>>
>>>>> May i know what are the changes to be made and where
>>>>>
>>>>> thanks
>>>>>
>>>>>
>>>>> hansbak wrote:
>>>>>>
>>>>>> Hi Roger,
>>>>>> i think i removed these clauses and the vat calculation should work
>>>>>> now.
>>>>>> Did not do the first point yet though....
>>>>>> So please try it..
>>>>>>
>>>>>> Regards,
>>>>>> Hans
>>>>>>
>>>>>> On Sun, 2008-08-10 at 11:49 -0700, rogernb wrote:
>>>>>>> Hans,
>>>>>>>
>>>>>>> I have the same request from a customer and I consider your approach
>>>>>>> to
>>>>>>> be
>>>>>>> totally reasonable. Nevertheless, I would like to know if it is a
>>>>>>> good
>>>>>>> practice to open the java file and just do the needed changes to the
>>>>>>> code.
>>>>>>>
>>>>>>> I read the code in OrderServices.java and I noticed there are several
>>>>>>> clauses which ommit the purchase orders while calculating taxes. So I
>>>>>>> think
>>>>>>> it is just a matter of modifying these clauses, let the taxes be
>>>>>>> calculated
>>>>>>> for purchase orders too and load these taxes in a account.
>>>>>>>
>>>>>>> What do you think? would it be enough to modify the code in
>>>>>>> OrderServices?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Hans Bakker wrote:
>>>>>>> >
>>>>>>> >
>>>>>>> > I have a request from a customer to enable the VAT tax calculation
>>>>>>> on
>>>>>>> > purchase orders. I have read the messages in the past about this
>>>>>>> subject
>>>>>>> > and want to propose the following to implement this feature:
>>>>>>> >
>>>>>>> > 1. add a second glAccountId for outgoing tax to the
>>>>>>> > TaxAuthorityGlAccount.
>>>>>>> > 2. adjust the programs to calculate the vat (sales tax) on purchase
>>>>>>> > orders the same way as sales orders, but use for the productstoreId
>>>>>>> a
>>>>>>> > blank entry.
>>>>>>> >
>>>>>>> > Is this a reasonable approach?
>>>>>>> >
>>>>>>> > Regards,
>>>>>>> > Hans
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>> >
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19155972.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19157799.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/VAT-on-purchase-orders-tp18055034p19158211.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>