You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Hans Bakker <ma...@antwebsystems.com> on 2013/09/17 04:04:36 UTC

Re: Why calculation of Sales tax or VAT service (CalcTax) need ProductId?

Hi Adrian,

sorry to come back on this but we need this for invoices not related to 
orders but related to time entries which are generated by the project 
manager or scrum component.

Sure they will work, because it will use the general default which is in 
general fine for us. If not good enough it can easiliy be adjusted on 
the generated entry.

This is a user problem, now the user has to calculate it manually which 
is prone for errors.

Let me know if you have further objections.

Regards,
Hans

On 07/30/2013 07:06 PM, Adrian Crum wrote:
> It would be best to leave the tax calculation service as-is. If a user 
> enters a line item that is not a product, then they can also enter a 
> tax amount.
>
> Without a product ID or product category, your proposals have no way 
> to determine a tax rate - therefore they will not work.
>
> Btw, this discussion should be on the dev mailing list.
>
> -Adrian
>
>
> On 7/29/2013 8:46 PM, Hans Bakker wrote:
>> Opinions needed....
>>
>> Problem:
>> ------------
>> At an purchase order or invoice, when the item product Id is blank, 
>> tax is not calculated and/or often give a screen error.
>>
>> The reason:
>> ----------------
>> Currently the CalcTax service has the productid as mandatory field in 
>> the input and uses this as a key in the Item sequence.
>>
>> However:
>> 1. on the purchase order it is possible to enter order items without 
>> a productId (Bulk)
>> 2. when creating an invoice, it is possible to leave the productId 
>> blank on the invoiceItem.
>>
>> And an invoice or order can have a mixed list of items with and 
>> without a productId.
>>
>> Proposed solution:
>> -------------------------
>> 1. add an optional Item sequence number list to the CalcTax service 
>> and make the productItem list also optional.
>> 2. check in the CalcTax service that least one on the two lists 
>> (sequence or product) is provided for compatibility.
>> 3. change the service that it works with a missing productId 
>> selecting the tax percentage from the entity TaxAuthorityRateProduct 
>> where the productId is null.
>>
>> When no major objections i will create a Jira for this.
>>
>> Regards,
>> Hans
>>
>> AntWebsystems.com quality services for competitive rates.
>


Re: Why calculation of Sales tax or VAT service (CalcTax) need ProductId?

Posted by Hans Bakker <ma...@antwebsystems.com>.
valid point, will look into this.
thanks,
Regards,
Hans

On 09/17/2013 09:12 AM, Adrian Crum wrote:
> In that case, the product you are selling is a service - so it should 
> have a product ID.
>
> Adrian Crum
> Sandglass Software
> www.sandglass-software.com
>
> On 9/16/2013 7:04 PM, Hans Bakker wrote:
>> Hi Adrian,
>>
>> sorry to come back on this but we need this for invoices not related to
>> orders but related to time entries which are generated by the project
>> manager or scrum component.
>>
>> Sure they will work, because it will use the general default which is in
>> general fine for us. If not good enough it can easiliy be adjusted on
>> the generated entry.
>>
>> This is a user problem, now the user has to calculate it manually which
>> is prone for errors.
>>
>> Let me know if you have further objections.
>>
>> Regards,
>> Hans
>>
>> On 07/30/2013 07:06 PM, Adrian Crum wrote:
>>> It would be best to leave the tax calculation service as-is. If a user
>>> enters a line item that is not a product, then they can also enter a
>>> tax amount.
>>>
>>> Without a product ID or product category, your proposals have no way
>>> to determine a tax rate - therefore they will not work.
>>>
>>> Btw, this discussion should be on the dev mailing list.
>>>
>>> -Adrian
>>>
>>>
>>> On 7/29/2013 8:46 PM, Hans Bakker wrote:
>>>> Opinions needed....
>>>>
>>>> Problem:
>>>> ------------
>>>> At an purchase order or invoice, when the item product Id is blank,
>>>> tax is not calculated and/or often give a screen error.
>>>>
>>>> The reason:
>>>> ----------------
>>>> Currently the CalcTax service has the productid as mandatory field in
>>>> the input and uses this as a key in the Item sequence.
>>>>
>>>> However:
>>>> 1. on the purchase order it is possible to enter order items without
>>>> a productId (Bulk)
>>>> 2. when creating an invoice, it is possible to leave the productId
>>>> blank on the invoiceItem.
>>>>
>>>> And an invoice or order can have a mixed list of items with and
>>>> without a productId.
>>>>
>>>> Proposed solution:
>>>> -------------------------
>>>> 1. add an optional Item sequence number list to the CalcTax service
>>>> and make the productItem list also optional.
>>>> 2. check in the CalcTax service that least one on the two lists
>>>> (sequence or product) is provided for compatibility.
>>>> 3. change the service that it works with a missing productId
>>>> selecting the tax percentage from the entity TaxAuthorityRateProduct
>>>> where the productId is null.
>>>>
>>>> When no major objections i will create a Jira for this.
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>> AntWebsystems.com quality services for competitive rates.
>>>
>>


Re: Why calculation of Sales tax or VAT service (CalcTax) need ProductId?

Posted by Adrian Crum <ad...@sandglass-software.com>.
In that case, the product you are selling is a service - so it should 
have a product ID.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 9/16/2013 7:04 PM, Hans Bakker wrote:
> Hi Adrian,
>
> sorry to come back on this but we need this for invoices not related to
> orders but related to time entries which are generated by the project
> manager or scrum component.
>
> Sure they will work, because it will use the general default which is in
> general fine for us. If not good enough it can easiliy be adjusted on
> the generated entry.
>
> This is a user problem, now the user has to calculate it manually which
> is prone for errors.
>
> Let me know if you have further objections.
>
> Regards,
> Hans
>
> On 07/30/2013 07:06 PM, Adrian Crum wrote:
>> It would be best to leave the tax calculation service as-is. If a user
>> enters a line item that is not a product, then they can also enter a
>> tax amount.
>>
>> Without a product ID or product category, your proposals have no way
>> to determine a tax rate - therefore they will not work.
>>
>> Btw, this discussion should be on the dev mailing list.
>>
>> -Adrian
>>
>>
>> On 7/29/2013 8:46 PM, Hans Bakker wrote:
>>> Opinions needed....
>>>
>>> Problem:
>>> ------------
>>> At an purchase order or invoice, when the item product Id is blank,
>>> tax is not calculated and/or often give a screen error.
>>>
>>> The reason:
>>> ----------------
>>> Currently the CalcTax service has the productid as mandatory field in
>>> the input and uses this as a key in the Item sequence.
>>>
>>> However:
>>> 1. on the purchase order it is possible to enter order items without
>>> a productId (Bulk)
>>> 2. when creating an invoice, it is possible to leave the productId
>>> blank on the invoiceItem.
>>>
>>> And an invoice or order can have a mixed list of items with and
>>> without a productId.
>>>
>>> Proposed solution:
>>> -------------------------
>>> 1. add an optional Item sequence number list to the CalcTax service
>>> and make the productItem list also optional.
>>> 2. check in the CalcTax service that least one on the two lists
>>> (sequence or product) is provided for compatibility.
>>> 3. change the service that it works with a missing productId
>>> selecting the tax percentage from the entity TaxAuthorityRateProduct
>>> where the productId is null.
>>>
>>> When no major objections i will create a Jira for this.
>>>
>>> Regards,
>>> Hans
>>>
>>> AntWebsystems.com quality services for competitive rates.
>>
>