Re: why re-entry of description/price while adding invoice item?

[Rajesh Mallah]

Kindly ignore above email.

It appears so because the form does not get pre-filled.
But added items do bear descriptions and prices.

sorry for the noise.

regds
mallah.

On Wed, Aug 30, 2017 at 12:09 PM, Rajesh Mallah 
wrote:

> Hi ,
>
> While creating invoice  on adding an invoice item ,
> Why are we requiring to specify description and price  of items to be
> added , should it not automatically come from product description and
> product pricing , if it has already been specified there ?
>
> thanks.
>
> regds
> mallah.
>
>

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Creating an invoice for a Democustomer in demo data set
does meet most of the expectations.

The point is (at this moment) setting ofbiz is not a cakewalk :-(
I wish there were some blogs that could spoon feed me :-)
and which would cover the entire cycle.
I have customers' waiting for quotes and invoices :P
which  i am not willing to type out using a word processor.

regds
mallah.





On Wed, Aug 30, 2017 at 11:52 AM, Rajesh Mallah 
wrote:

> Hi ,
>
> Can someone point me to a useful documentation on setting up taxation.
>
> Expectations :
>
> (1) tax % should be allowed to be specified at a product / product
>  category level and indicate  the tax authority
>
> (2) There can be multiple kind of taxes having various rates .
>
> (3) When we order the product from eCommerce storefront then the
>   end user is shown the total price including the tax.
>
>
> (4) when we create an invoice for an internally created order
> (non-eCommerce)
>   the tax amount should automatically get added to invoice.
>
> Kindly indicate the best documentation that may help in setting the
> above.
>
> regds
> mallah.
>
>

Re: [Updates] - OFBiz tutorial restructuring & release specific tutorial

[Jacques Le Roux]

Hi Swapnil,

I did not read it all, but sounds like we definitely have something helpful for 
all new comers (not only trunk) :)

Thank you again to all who participated to the effort.

Ah, I  think we need to prune the obsolete comments in trunk version

Should we  not close https://issues.apache.org/jira/browse/OFBIZ-7145 ?

Thanks

Jacques


Le 30/08/2017 à 07:24, Swapnil Mane a écrit :

Thanks Deepak and Jacques. Giving one more try with tiny URLs

*OFBiz Trunk* - https://cwiki.apache.org/confluence/x/cQFk

*OFBiz 16.11* - https://cwiki.apache.org/confluence/x/KA4jB

*OFBiz 13.07, 14.12 and 15.12* - https://cwiki.apache.org/confluence/x/Cw4jB


P.S. Interestingly, all the above links in this mail thread is working fine
for mail client, not sure about the reason :-)


- Best Regards,
Swapnil M Mane

On Tue, Aug 29, 2017 at 10:16 PM, Deepak Dixit <
deepak.di...@hotwaxsystems.com> wrote:


Hi Swapnil,

I think you can share Tiny Link on email,
To get Tiny Link link please go to Page Information  you will be able to
get the tiny url.


Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

On Tue, Aug 29, 2017 at 8:11 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:


Hè Swapnil,

Just got the same, Thunderbird 52.3.0? (32 bits on Win7 for me)

Jacques



Le 29/08/2017 à 16:16, Swapnil Mane a écrit :


Thank you Anil and Pritam.

Sorry for the inconvenience, my mail client is playing with me ;)

Here are the updated links

OFBiz Trunk

OFBiz 16.11

OFBiz 13.07, 14.12 and 15.12


Please have a look.


- Best Regards,
Swapnil M Mane

On Tue, Aug 29, 2017 at 7:39 PM, Pritam Kute <
pritam.k...@hotwaxsystems.com>
wrote:

Yes, I am facing the same issue with *OFBiz 13.07, 14.12 and 15.12,

*here

is the updated link: https://cwiki.apache.org/

confluence/display/OFBIZ/

OFBiz+Tutorial+-+A+Beginners+Development+Guide+for+13.07%
2C+14.12+and+15.12

Other two are working fine.

Thanks and Regards
--
Pritam Kute

On Tue, Aug 29, 2017 at 7:32 PM, Anil Patel <
anil.pa...@hotwaxsystems.com>
wrote:

Hi,

The tutorial URLs are not reachable (Page not found) for me, I am

using

Safari on Mac.

Is anybody else experiencing similar issue?


Thanks and Regards
Anil Patel
COO
HotWax Systems
http://www.hotwaxsystems.com
Cell: + 1 509 398 3120

On Tue, Aug 29, 2017 at 9:57 AM, Swapnil Mane <
swapnil.m...@hotwaxsystems.com> wrote:

Dear Users,

We are glad to present you the release specific tutorials for Apache


OFBiz.


*OFBiz trunk* - https://cwiki.apache.org/confluence/display/OFBIZ/
OFBiz+Tuto
rial+-+A+Beginners+Development+Guide

*OFBiz 16.11* - https://cwiki.apache.org/confluence/display/OFBIZ/
OFBiz+Tuto
rial+-+A+Beginners+Development+Guide+for+16.11

*OFBiz 13.07, 14.12 and 15.12* - https://cwiki.apache.org/confl
uence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development
+Guide+for+13.07%2C+14.12+and+15.12

Thank you everyone who helped in this with your kind inputs and work.
Special thanks @Pranay Pandey for your continuous guidance and help.
And
@Rohit Rai for verifying the latest tutorial for trunk.

We highly appreciate your kind inputs :)


- Best Regards,
Swapnil M Mane,
OFBiz Community


On Tue, Apr 25, 2017 at 10:17 AM, Swapnil Mane <
swapnil.m...@hotwaxsystems.com> wrote:

Hello all,

We are working on release specific tutorial since we have done lots


from
changes in OFBiz from release 15.12 to current trunk (like gradle and

plugin directory structure)

Under this restructuring, https://cwiki.apache.org/confl
uence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide


will
be always synced up with the latest trunk (so this will be always *in

progress* document for us)

And the *child pages* of this document will be release specific


tutorials
like

1.) OFBiz Tutorial - A Beginners Development Guide for 13.07, 14.12


and
15.12




2.) [WIP] OFBiz Tutorial - A Beginners Development Guide for 16.11



Hopefully, this will provide an easy entry route for the new people
joining the community.

Thanks: @Pranay for inputs and continuous support on this.

P.S. We would like to welcome any thoughts or input from the


community on
this.



- Best Regards,
Swapnil M Mane
Sr. Enterprise Software Engineer
www.hotwaxsystems.com

Re: setting up TAX in ofbiz

[Jacques Le Roux]

This http://markmail.org/message/esl5ou2zo4x2lt3l :D

You should do more research in the ML archives ;)

Jacques


Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :

Hi ,

Can someone point me to a useful documentation on setting up taxation.

Expectations :

(1) tax % should be allowed to be specified at a product / product
  category level and indicate  the tax authority

(2) There can be multiple kind of taxes having various rates .

(3) When we order the product from eCommerce storefront then the
   end user is shown the total price including the tax.


(4) when we create an invoice for an internally created order
(non-eCommerce)
   the tax amount should automatically get added to invoice.

Kindly indicate the best documentation that may help in setting the
above.

regds
mallah.

Re: setting up TAX in ofbiz

[Rajesh Mallah]

thanks.

I hope i finally reach the mundane state soon.

regds
mallah.

On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
>
> You should do more research in the ML archives ;)
>
> Jacques
>
>
>
> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
>
>> Hi ,
>>
>> Can someone point me to a useful documentation on setting up taxation.
>>
>> Expectations :
>>
>> (1) tax % should be allowed to be specified at a product / product
>>   category level and indicate  the tax authority
>>
>> (2) There can be multiple kind of taxes having various rates .
>>
>> (3) When we order the product from eCommerce storefront then the
>>end user is shown the total price including the tax.
>>
>>
>> (4) when we create an invoice for an internally created order
>> (non-eCommerce)
>>the tax amount should automatically get added to invoice.
>>
>> Kindly indicate the best documentation that may help in setting the
>> above.
>>
>> regds
>> mallah.
>>
>>
>

Re: [Updates] - OFBiz tutorial restructuring & release specific tutorial

[Swapnil Mane]

Thank you Jacques for your kind words.

Yes, agree, we should prune the old comments.

For https://issues.apache.org/jira/browse/OFBIZ-7145, I was planning to
close this today, with some comments.

Thanks again! :-)

- Best Regards,
Swapnil M Mane

On Wed, Aug 30, 2017 at 12:58 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Swapnil,
>
> I did not read it all, but sounds like we definitely have something
> helpful for all new comers (not only trunk) :)
>
> Thank you again to all who participated to the effort.
>
> Ah, I  think we need to prune the obsolete comments in trunk version
>
> Should we  not close https://issues.apache.org/jira/browse/OFBIZ-7145 ?
>
> Thanks
>
> Jacques
>
>
> Le 30/08/2017 à 07:24, Swapnil Mane a écrit :
>
>> Thanks Deepak and Jacques. Giving one more try with tiny URLs
>>
>> *OFBiz Trunk* - https://cwiki.apache.org/confluence/x/cQFk
>>
>> *OFBiz 16.11* - https://cwiki.apache.org/confluence/x/KA4jB
>>
>> *OFBiz 13.07, 14.12 and 15.12* - https://cwiki.apache.org/confl
>> uence/x/Cw4jB
>>
>>
>>
>> P.S. Interestingly, all the above links in this mail thread is working
>> fine
>> for mail client, not sure about the reason :-)
>>
>>
>> - Best Regards,
>> Swapnil M Mane
>>
>> On Tue, Aug 29, 2017 at 10:16 PM, Deepak Dixit <
>> deepak.di...@hotwaxsystems.com> wrote:
>>
>> Hi Swapnil,
>>>
>>> I think you can share Tiny Link on email,
>>> To get Tiny Link link please go to Page Information  you will be able to
>>> get the tiny url.
>>>
>>>
>>> Thanks & Regards
>>> --
>>> Deepak Dixit
>>> www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Tue, Aug 29, 2017 at 8:11 PM, Jacques Le Roux <
>>> jacques.le.r...@les7arts.com> wrote:
>>>
>>> Hè Swapnil,

 Just got the same, Thunderbird 52.3.0? (32 bits on Win7 for me)

 Jacques



 Le 29/08/2017 à 16:16, Swapnil Mane a écrit :

 Thank you Anil and Pritam.
>
> Sorry for the inconvenience, my mail client is playing with me ;)
>
> Here are the updated links
>
> OFBiz Trunk
>  Tutorial+-+A+Beginners+Development+Guide>
> OFBiz 16.11
>  Tutorial+-+A+Beginners+Development+Guide+for+16.11>
> OFBiz 13.07, 14.12 and 15.12
>  Tutorial+-+A+Beginners+Development+Guide+for+13.07%2C+14.12+and+15.12>
>
> Please have a look.
>
>
> - Best Regards,
> Swapnil M Mane
>
> On Tue, Aug 29, 2017 at 7:39 PM, Pritam Kute <
> pritam.k...@hotwaxsystems.com>
> wrote:
>
> Yes, I am facing the same issue with *OFBiz 13.07, 14.12 and 15.12,
>
 *here
>>>
 is the updated link: https://cwiki.apache.org/
>>
> confluence/display/OFBIZ/
>>>
 OFBiz+Tutorial+-+A+Beginners+Development+Guide+for+13.07%
>> 2C+14.12+and+15.12
>>
>> Other two are working fine.
>>
>> Thanks and Regards
>> --
>> Pritam Kute
>>
>> On Tue, Aug 29, 2017 at 7:32 PM, Anil Patel <
>> anil.pa...@hotwaxsystems.com>
>> wrote:
>>
>> Hi,
>>
>>> The tutorial URLs are not reachable (Page not found) for me, I am
>>>
>> using
>>>
 Safari on Mac.
>>>
>>> Is anybody else experiencing similar issue?
>>>
>>>
>>> Thanks and Regards
>>> Anil Patel
>>> COO
>>> HotWax Systems
>>> http://www.hotwaxsystems.com
>>> Cell: + 1 509 398 3120
>>>
>>> On Tue, Aug 29, 2017 at 9:57 AM, Swapnil Mane <
>>> swapnil.m...@hotwaxsystems.com> wrote:
>>>
>>> Dear Users,
>>>
 We are glad to present you the release specific tutorials for Apache

 OFBiz.
>>>
>>> *OFBiz trunk* - https://cwiki.apache.org/confluence/display/OFBIZ/
 OFBiz+Tuto
 rial+-+A+Beginners+Development+Guide

 *OFBiz 16.11* - https://cwiki.apache.org/confluence/display/OFBIZ/
 OFBiz+Tuto
 rial+-+A+Beginners+Development+Guide+for+16.11

 *OFBiz 13.07, 14.12 and 15.12* - https://cwiki.apache.org/confl
 uence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development
 +Guide+for+13.07%2C+14.12+and+15.12

 Thank you everyone who helped in this with your kind inputs and
 work.
 Special thanks @Pranay Pandey for your continuous guidance and help.
 And
 @Rohit Rai for verifying the latest tutorial for trunk.

 We highly appreciate your kind inputs :)


 - Best Regards,
 Swapnil M Mane,
 OFBiz Community


 On Tue, Apr 25, 2017 at 10:17 AM, Swapnil Mane <
 swapnil.m...@hotwaxsystems.com> wrote:

 Hello all,

> We are working on release specific tutorial since we have done lots
>
> from
 changes in OFBiz from relea

Our New OFBiz Website is Live!

[Sharan Foga]

Hi Everyone

A quick note to let you all know that our new OFBiz website is live! Huge, huge 
thanks and kudos to everyone who contributed ideas, gave feedback and supported 
the effort.

:-)

Thanks
Sharan

Live Ship Estimates

[james]

Team - I am trying to figure out live shipping estimates with Ofbiz.  I
see that I can set up the system to use live estimates from UPS and
Fedex.  In the store set up I can define what I want the uplift to be. 
I have a few questions.  1. Typically we do not have weight or
dimensions at the time of order so it seems this wouldn't work.  I would
only have this information at the time of packing the order.  I see
there is an estimate shipping button when packing the order.  Does this
button take the package dimensions and estimate the total shipment.  So
my question...does the system allow me to estimate shipping on the sales
order based on other parameters like order total, quantity of products
etc and then allow me to get a live estimate when packing.  At the time
of packing I can see what we estimated vs actual estimates with weights
and dimensions and then choose which estimate to utilize?  What about
other parameters like insurance, hazmat requirements, etc

Thanks in advance

James

Re: setting up TAX in ofbiz

[Jacques Le Roux]

You are doing very well comparing to some others ;)

Jacques


Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :

thanks.

I hope i finally reach the mundane state soon.

regds
mallah.

On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:


This http://markmail.org/message/esl5ou2zo4x2lt3l :D

You should do more research in the ML archives ;)

Jacques



Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :


Hi ,

Can someone point me to a useful documentation on setting up taxation.

Expectations :

(1) tax % should be allowed to be specified at a product / product
   category level and indicate  the tax authority

(2) There can be multiple kind of taxes having various rates .

(3) When we order the product from eCommerce storefront then the
end user is shown the total price including the tax.


(4) when we create an invoice for an internally created order
(non-eCommerce)
the tax amount should automatically get added to invoice.

Kindly indicate the best documentation that may help in setting the
above.

regds
mallah.

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Thanks ,  Paul's reply did help , and I saw taxes getting
automatically added  after the product was  included  in
a extra category of type *Tax* . I named to the category
as "Taxable Products" for time being (as suggested).

regds
mallah.


On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> You are doing very well comparing to some others ;)
>
> Jacques
>
>
>
> Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
>
>> thanks.
>>
>> I hope i finally reach the mundane state soon.
>>
>> regds
>> mallah.
>>
>> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
>> jacques.le.r...@les7arts.com> wrote:
>>
>> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
>>>
>>> You should do more research in the ML archives ;)
>>>
>>> Jacques
>>>
>>>
>>>
>>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
>>>
>>> Hi ,

 Can someone point me to a useful documentation on setting up taxation.

 Expectations :

 (1) tax % should be allowed to be specified at a product / product
category level and indicate  the tax authority

 (2) There can be multiple kind of taxes having various rates .

 (3) When we order the product from eCommerce storefront then the
 end user is shown the total price including the tax.


 (4) when we create an invoice for an internally created order
 (non-eCommerce)
 the tax amount should automatically get added to invoice.

 Kindly indicate the best documentation that may help in setting the
 above.

 regds
 mallah.



>

Re: setting up TAX in ofbiz

[Deepak Nigam]

Hi Rajesh,

Most of the mentioned requirements can be fulfilled by setting up data in
entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
OFBiz tax engine internally uses data from these entities to perform tax
calculations.

Please refer to the following set of demo data. It can help you.





















Please revert in case of any doubt.

HTH!


Thanks & Regards
--
Deepak Nigam
Technical Consultant/Team Lead
HotWax Systems
www.hotwaxsystems.com

On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
wrote:

> Thanks ,  Paul's reply did help , and I saw taxes getting
> automatically added  after the product was  included  in
> a extra category of type *Tax* . I named to the category
> as "Taxable Products" for time being (as suggested).
>
> regds
> mallah.
>
>
> On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> jacques.le.r...@les7arts.com> wrote:
>
> > You are doing very well comparing to some others ;)
> >
> > Jacques
> >
> >
> >
> > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> >
> >> thanks.
> >>
> >> I hope i finally reach the mundane state soon.
> >>
> >> regds
> >> mallah.
> >>
> >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> >> jacques.le.r...@les7arts.com> wrote:
> >>
> >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
> >>>
> >>> You should do more research in the ML archives ;)
> >>>
> >>> Jacques
> >>>
> >>>
> >>>
> >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
> >>>
> >>> Hi ,
> 
>  Can someone point me to a useful documentation on setting up taxation.
> 
>  Expectations :
> 
>  (1) tax % should be allowed to be specified at a product / product
> category level and indicate  the tax authority
> 
>  (2) There can be multiple kind of taxes having various rates .
> 
>  (3) When we order the product from eCommerce storefront then the
>  end user is shown the total price including the tax.
> 
> 
>  (4) when we create an invoice for an internally created order
>  (non-eCommerce)
>  the tax amount should automatically get added to invoice.
> 
>  Kindly indicate the best documentation that may help in setting the
>  above.
> 
>  regds
>  mallah.
> 
> 
> 
> >
>

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Hi Deepak ,

Thanks for the useful demo data. I went through it and could
understand mostly, although perfect assimilation will take some
time owing to my current level in the learning curve. :-)

my current hurdle is follows and would appreciate help.

I have configured  a new product upto a stage that if it is  invoiced
it to "Demo Customer" the taxes of Utah state & County gets applied.
I observe that DemoCustomer's postalAddress is of Utah too.
 (so its probably being  matched via the GeoID)

Trying to setup a analogous configuration

I have setup a new tax authority

Geo: IND
Party: IND_TAX_AUTH_GST

When i attempt to invoice a new party having postal address of India
I am not seeing the same happening when i use the "Add Tax" ui button.

In the product definition I have indicated

Tax Authority Party: IND_TAX_AUTH_GST
Tax Auth Geo ID: IND
Tax In Price: Yes

any help is solicited.

regds
mallah.



On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:

> Hi Rajesh,
>
> Most of the mentioned requirements can be fulfilled by setting up data in
> entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> OFBiz tax engine internally uses data from these entities to perform tax
> calculations.
>
> Please refer to the following set of demo data. It can help you.
>
> 
> 
> 
>
>  taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
>
>  productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> categoryName="5.00 %"/> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
>
>  productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> categoryName="10.00 %"/> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
>
>  productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" quantityIncluded="10"
> introductionDate="2001-01-01 12:00:00.000"/>
>  productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
>
>  primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
>  productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
>
>  taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="5.00"
> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
> Services Tax"/>
>  taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="10.00"
> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
> Services Tax"/>
>
>
> Please revert in case of any doubt.
>
> HTH!
>
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>
> On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
> wrote:
>
> > Thanks ,  Paul's reply did help , and I saw taxes getting
> > automatically added  after the product was  included  in
> > a extra category of type *Tax* . I named to the category
> > as "Taxable Products" for time being (as suggested).
> >
> > regds
> > mallah.
> >
> >
> > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > jacques.le.r...@les7arts.com> wrote:
> >
> > > You are doing very well comparing to some others ;)
> > >
> > > Jacques
> > >
> > >
> > >
> > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > >
> > >> thanks.
> > >>
> > >> I hope i finally reach the mundane state soon.
> > >>
> > >> regds
> > >> mallah.
> > >>
> > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > >> jacques.le.r...@les7arts.com> wrote:
> > >>
> > >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
> > >>>
> > >>> You should do more research in the ML archives ;)
> > >>>
> > >>> Jacques
> > >>>
> > >>>
> > >>>
> > >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
> > >>>
> > >>> Hi ,
> > 
> >  Can someone point me to a useful documentation on setting up
> taxation.
> > 
> >  Expectations :
> > 
> >  (1) tax % should be allowed to be specified at a product / product
> > category level and indicate  the tax authority
> > 
> >  (2) There can be multiple kind of taxes having various rates .
> > 
> >  (3) When we order the product from eCommerce storefront then the
> >  end user is shown the total price including the tax.
> > 
> > 
> >  (4) when we create an invoice for an internally created order
> >  (non-eCommerce)
> >  the tax amount should automatically get added to invoice.
> > 
> >  Kindly indicate the best documentation that may help in setting the
> >  above.
> > 
> >  regds
> >  malla

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Consider the Invoice:

https://demo-trunk.ofbiz.apache.org/accounting/control/invoiceOverview?invoiceId=CI2

The product in question does not belong to any taxable
category , i wanted to know how taxes are being applied
to it.

Product Categories:

https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductCategories?productId=WG-9943-S4-BX2


regds
mallah.

On Wed, Aug 30, 2017 at 3:01 PM, Rajesh Mallah 
wrote:

> Hi Deepak ,
>
> Thanks for the useful demo data. I went through it and could
> understand mostly, although perfect assimilation will take some
> time owing to my current level in the learning curve. :-)
>
> my current hurdle is follows and would appreciate help.
>
> I have configured  a new product upto a stage that if it is  invoiced
> it to "Demo Customer" the taxes of Utah state & County gets applied.
> I observe that DemoCustomer's postalAddress is of Utah too.
>  (so its probably being  matched via the GeoID)
>
> Trying to setup a analogous configuration
>
> I have setup a new tax authority
>
> Geo: IND
> Party: IND_TAX_AUTH_GST
>
> When i attempt to invoice a new party having postal address of India
> I am not seeing the same happening when i use the "Add Tax" ui button.
>
> In the product definition I have indicated
>
> Tax Authority Party: IND_TAX_AUTH_GST
> Tax Auth Geo ID: IND
> Tax In Price: Yes
>
> any help is solicited.
>
> regds
> mallah.
>
>
>
> On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam  com> wrote:
>
>> Hi Rajesh,
>>
>> Most of the mentioned requirements can be fulfilled by setting up data in
>> entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
>> OFBiz tax engine internally uses data from these entities to perform tax
>> calculations.
>>
>> Please refer to the following set of demo data. It can help you.
>>
>> 
>> 
>> 
>>
>> > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
>>
>> > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
>> categoryName="5.00 %"/>> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
>>
>> > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
>> categoryName="10.00 %"/>> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
>>
>> > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
>> internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
>> weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
>> Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" quantityIncluded="10"
>> introductionDate="2001-01-01 12:00:00.000"/>
>> > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
>>
>> > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
>> productName="Aceclofenac Tab 2" internalName="Aceclofenac +
>> Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
>> productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
>> 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
>> quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
>> > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
>>
>> > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="5.00"
>> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
>> Services Tax"/>
>> > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="10.00"
>> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
>> Services Tax"/>
>>
>>
>> Please revert in case of any doubt.
>>
>> HTH!
>>
>>
>> Thanks & Regards
>> --
>> Deepak Nigam
>> Technical Consultant/Team Lead
>> HotWax Systems
>> www.hotwaxsystems.com
>>
>> On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
>> wrote:
>>
>> > Thanks ,  Paul's reply did help , and I saw taxes getting
>> > automatically added  after the product was  included  in
>> > a extra category of type *Tax* . I named to the category
>> > as "Taxable Products" for time being (as suggested).
>> >
>> > regds
>> > mallah.
>> >
>> >
>> > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
>> > jacques.le.r...@les7arts.com> wrote:
>> >
>> > > You are doing very well comparing to some others ;)
>> > >
>> > > Jacques
>> > >
>> > >
>> > >
>> > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
>> > >
>> > >> thanks.
>> > >>
>> > >> I hope i finally reach the mundane state soon.
>> > >>
>> > >> regds
>> > >> mallah.
>> > >>
>> > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
>> > >> jacques.le.r...@les7arts.com> wrote:
>> > >>
>> > >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
>> > >>>
>> > >>> You should do more research in the ML archives ;)
>> > >>>
>> > >>> Jacques
>> > >>>
>> > >>>
>> > >>>
>> > >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
>> > >>>
>> > >>> Hi ,
>> > 
>> >  Can someone point me to a useful documentation on setting up
>> taxation.
>> > 
>> >  Expectations :
>> > 
>> >  (1) tax % should be allowed to be specified at a product / product
>> > category level and indicate  the tax

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Some more progress:

I was able to apply taxes to demo products using new tax
authority .  The incremental steps i did were:

(1) setup "Categories" , "Association" , "Product Rates" for the new
 tax authority in  Accounting --> Tax Auth .

Rite now the problem is when i add "Items" in invoice using product id
the added items do not pick the correct price. As a result (i feel) "Add
taxes" is
also calculating taxes on 0 .(=0)


regds
mallah.











On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:

> Hi Rajesh,
>
> Most of the mentioned requirements can be fulfilled by setting up data in
> entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> OFBiz tax engine internally uses data from these entities to perform tax
> calculations.
>
> Please refer to the following set of demo data. It can help you.
>
> 
> 
> 
>
>  taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
>
>  productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> categoryName="5.00 %"/> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
>
>  productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> categoryName="10.00 %"/> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
>
>  productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" quantityIncluded="10"
> introductionDate="2001-01-01 12:00:00.000"/>
>  productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
>
>  primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
>  productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
>
>  taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="5.00"
> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
> Services Tax"/>
>  taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="10.00"
> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
> Services Tax"/>
>
>
> Please revert in case of any doubt.
>
> HTH!
>
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>
> On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
> wrote:
>
> > Thanks ,  Paul's reply did help , and I saw taxes getting
> > automatically added  after the product was  included  in
> > a extra category of type *Tax* . I named to the category
> > as "Taxable Products" for time being (as suggested).
> >
> > regds
> > mallah.
> >
> >
> > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > jacques.le.r...@les7arts.com> wrote:
> >
> > > You are doing very well comparing to some others ;)
> > >
> > > Jacques
> > >
> > >
> > >
> > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > >
> > >> thanks.
> > >>
> > >> I hope i finally reach the mundane state soon.
> > >>
> > >> regds
> > >> mallah.
> > >>
> > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > >> jacques.le.r...@les7arts.com> wrote:
> > >>
> > >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
> > >>>
> > >>> You should do more research in the ML archives ;)
> > >>>
> > >>> Jacques
> > >>>
> > >>>
> > >>>
> > >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
> > >>>
> > >>> Hi ,
> > 
> >  Can someone point me to a useful documentation on setting up
> taxation.
> > 
> >  Expectations :
> > 
> >  (1) tax % should be allowed to be specified at a product / product
> > category level and indicate  the tax authority
> > 
> >  (2) There can be multiple kind of taxes having various rates .
> > 
> >  (3) When we order the product from eCommerce storefront then the
> >  end user is shown the total price including the tax.
> > 
> > 
> >  (4) when we create an invoice for an internally created order
> >  (non-eCommerce)
> >  the tax amount should automatically get added to invoice.
> > 
> >  Kindly indicate the best documentation that may help in setting the
> >  above.
> > 
> >  regds
> >  mallah.
> > 
> > 
> > 
> > >
> >
>

Theme Language and Timezone Video tutorial

[Deepak Dixit]

We have uploaded new video related to "Theme Language and Timezone"
prepared by Pranay Pandey.

Description:
Learn how to navigate through Apache OFBiz application for setting user
preferences for application UI theme, language, time zone and locate, view
user/party profile.

Here is the youtube and vimeo link for the

https://youtu.be/TDJpVQRVTvI
https://vimeo.com/231685386

Thank you Pranay for your effort.

Thanks & Regards
--
Deepak Dixit
https://ofbiz.apache.org/

Re: Theme Language and Timezone Video tutorial

[Pranay Pandey]

Thanks for your help Deepak.

Best regards,
Pranay Pandey
www.hotwaxsystems.com
www.hotwax.co

On Wed, Aug 30, 2017 at 5:23 PM, Deepak Dixit  wrote:

> We have uploaded new video related to "Theme Language and Timezone"
> prepared by Pranay Pandey.
>
> Description:
> Learn how to navigate through Apache OFBiz application for setting user
> preferences for application UI theme, language, time zone and locate, view
> user/party profile.
>
> Here is the youtube and vimeo link for the
>
> https://youtu.be/TDJpVQRVTvI
> https://vimeo.com/231685386
>
> Thank you Pranay for your effort.
>
> Thanks & Regards
> --
> Deepak Dixit
> https://ofbiz.apache.org/
>

Re: setting up TAX in ofbiz

[Pranay Pandey]

Hi Deepak,

Thanks for providing these details. It's good material to go in a document
on OFBiz Wiki if doesn't exist already.

Best regards,
Pranay Pandey

On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:

> Hi Rajesh,
>
> Most of the mentioned requirements can be fulfilled by setting up data in
> entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> OFBiz tax engine internally uses data from these entities to perform tax
> calculations.
>
> Please refer to the following set of demo data. It can help you.
>
> 
> 
> 
>
>  taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
>
>  productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> categoryName="5.00 %"/> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
>
>  productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> categoryName="10.00 %"/> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
>
>  productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" quantityIncluded="10"
> introductionDate="2001-01-01 12:00:00.000"/>
>  productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
>
>  primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
>  productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
>
>  taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="5.00"
> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
> Services Tax"/>
>  taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="10.00"
> taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods and
> Services Tax"/>
>
>
> Please revert in case of any doubt.
>
> HTH!
>
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>
> On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
> wrote:
>
> > Thanks ,  Paul's reply did help , and I saw taxes getting
> > automatically added  after the product was  included  in
> > a extra category of type *Tax* . I named to the category
> > as "Taxable Products" for time being (as suggested).
> >
> > regds
> > mallah.
> >
> >
> > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > jacques.le.r...@les7arts.com> wrote:
> >
> > > You are doing very well comparing to some others ;)
> > >
> > > Jacques
> > >
> > >
> > >
> > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > >
> > >> thanks.
> > >>
> > >> I hope i finally reach the mundane state soon.
> > >>
> > >> regds
> > >> mallah.
> > >>
> > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > >> jacques.le.r...@les7arts.com> wrote:
> > >>
> > >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
> > >>>
> > >>> You should do more research in the ML archives ;)
> > >>>
> > >>> Jacques
> > >>>
> > >>>
> > >>>
> > >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
> > >>>
> > >>> Hi ,
> > 
> >  Can someone point me to a useful documentation on setting up
> taxation.
> > 
> >  Expectations :
> > 
> >  (1) tax % should be allowed to be specified at a product / product
> > category level and indicate  the tax authority
> > 
> >  (2) There can be multiple kind of taxes having various rates .
> > 
> >  (3) When we order the product from eCommerce storefront then the
> >  end user is shown the total price including the tax.
> > 
> > 
> >  (4) when we create an invoice for an internally created order
> >  (non-eCommerce)
> >  the tax amount should automatically get added to invoice.
> > 
> >  Kindly indicate the best documentation that may help in setting the
> >  above.
> > 
> >  regds
> >  mallah.
> > 
> > 
> > 
> > >
> >
>

Re: setting up TAX in ofbiz

[Deepak Nigam]

Hi Rajesh,

I think you try with a different product also. It is possible that
ProductPrice data is not correct/sufficient for the selected product and
system is not picking the correct price.

Thanks & Regards
--
Deepak Nigam
Technical Consultant/Team Lead
HotWax Systems
www.hotwaxsystems.com

On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah 
wrote:

> Some more progress:
>
> I was able to apply taxes to demo products using new tax
> authority .  The incremental steps i did were:
>
> (1) setup "Categories" , "Association" , "Product Rates" for the new
>  tax authority in  Accounting --> Tax Auth .
>
> Rite now the problem is when i add "Items" in invoice using product id
> the added items do not pick the correct price. As a result (i feel) "Add
> taxes" is
> also calculating taxes on 0 .(=0)
>
>
> regds
> mallah.
>
>
>
>
>
>
>
>
>
>
>
> On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> deepak.ni...@hotwaxsystems.com> wrote:
>
> > Hi Rajesh,
> >
> > Most of the mentioned requirements can be fulfilled by setting up data in
> > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> > OFBiz tax engine internally uses data from these entities to perform tax
> > calculations.
> >
> > Please refer to the following set of demo data. It can help you.
> >
> > 
> > 
> > 
> >
> >  > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> >
> >  > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > categoryName="5.00 %"/> > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> >
> >  > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > categoryName="10.00 %"/> > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> >
> >  > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > billOfMaterialLevel="0" quantityIncluded="10"
> > introductionDate="2001-01-01 12:00:00.000"/>
> >  > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> >
> >  > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> >  > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> >
> >  fromDate="2017-06-01
> > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="5.00"
> > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> and
> > Services Tax"/>
> >  fromDate="2017-06-01
> > 00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
> > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="10.00"
> > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> and
> > Services Tax"/>
> >
> >
> > Please revert in case of any doubt.
> >
> > HTH!
> >
> >
> > Thanks & Regards
> > --
> > Deepak Nigam
> > Technical Consultant/Team Lead
> > HotWax Systems
> > www.hotwaxsystems.com
> >
> > On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
> > wrote:
> >
> > > Thanks ,  Paul's reply did help , and I saw taxes getting
> > > automatically added  after the product was  included  in
> > > a extra category of type *Tax* . I named to the category
> > > as "Taxable Products" for time being (as suggested).
> > >
> > > regds
> > > mallah.
> > >
> > >
> > > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > > jacques.le.r...@les7arts.com> wrote:
> > >
> > > > You are doing very well comparing to some others ;)
> > > >
> > > > Jacques
> > > >
> > > >
> > > >
> > > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > > >
> > > >> thanks.
> > > >>
> > > >> I hope i finally reach the mundane state soon.
> > > >>
> > > >> regds
> > > >> mallah.
> > > >>
> > > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > > >> jacques.le.r...@les7arts.com> wrote:
> > > >>
> > > >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
> > > >>>
> > > >>> You should do more research in the ML archives ;)
> > > >>>
> > > >>> Jacques
> > > >>>
> > > >>>
> > > >>>
> > > >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
> > > >>>
> > > >>> Hi ,
> > > 
> > >  Can someone point me to a useful documentation on setting up
> > taxation.
> > > 
> > >  Expectations :
> > > 
> > >  (1) tax % should be allowed to be specified at a product / product
> > > category level and indicate  the tax authority
> > > 
> > >  (2) There can be multiple kind of taxes having various rates .
> > > 
> > >  (3) When we order the product from eCommerce storefront then the
> > >  end us

Re: setting up TAX in ofbiz

[Deepak Nigam]

Thanks, Pranay.
Sure I'll have a look into OFBiz Wiki for the same.

Thanks & Regards
--
Deepak Nigam
Technical Consultant/Team Lead
HotWax Systems
www.hotwaxsystems.com

On Wed, Aug 30, 2017 at 5:37 PM, Pranay Pandey <
pranay.pan...@hotwaxsystems.com> wrote:

> Hi Deepak,
>
> Thanks for providing these details. It's good material to go in a document
> on OFBiz Wiki if doesn't exist already.
>
> Best regards,
> Pranay Pandey
>
> On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> deepak.ni...@hotwaxsystems.com> wrote:
>
> > Hi Rajesh,
> >
> > Most of the mentioned requirements can be fulfilled by setting up data in
> > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> > OFBiz tax engine internally uses data from these entities to perform tax
> > calculations.
> >
> > Please refer to the following set of demo data. It can help you.
> >
> > 
> > 
> > 
> >
> >  > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> >
> >  > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > categoryName="5.00 %"/> > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> >
> >  > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > categoryName="10.00 %"/> > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> >
> >  > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > billOfMaterialLevel="0" quantityIncluded="10"
> > introductionDate="2001-01-01 12:00:00.000"/>
> >  > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> >
> >  > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> >  > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> >
> >  fromDate="2017-06-01
> > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="5.00"
> > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> and
> > Services Tax"/>
> >  fromDate="2017-06-01
> > 00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
> > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST" taxPercentage="10.00"
> > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> and
> > Services Tax"/>
> >
> >
> > Please revert in case of any doubt.
> >
> > HTH!
> >
> >
> > Thanks & Regards
> > --
> > Deepak Nigam
> > Technical Consultant/Team Lead
> > HotWax Systems
> > www.hotwaxsystems.com
> >
> > On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah 
> > wrote:
> >
> > > Thanks ,  Paul's reply did help , and I saw taxes getting
> > > automatically added  after the product was  included  in
> > > a extra category of type *Tax* . I named to the category
> > > as "Taxable Products" for time being (as suggested).
> > >
> > > regds
> > > mallah.
> > >
> > >
> > > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > > jacques.le.r...@les7arts.com> wrote:
> > >
> > > > You are doing very well comparing to some others ;)
> > > >
> > > > Jacques
> > > >
> > > >
> > > >
> > > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > > >
> > > >> thanks.
> > > >>
> > > >> I hope i finally reach the mundane state soon.
> > > >>
> > > >> regds
> > > >> mallah.
> > > >>
> > > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > > >> jacques.le.r...@les7arts.com> wrote:
> > > >>
> > > >> This http://markmail.org/message/esl5ou2zo4x2lt3l :D
> > > >>>
> > > >>> You should do more research in the ML archives ;)
> > > >>>
> > > >>> Jacques
> > > >>>
> > > >>>
> > > >>>
> > > >>> Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :
> > > >>>
> > > >>> Hi ,
> > > 
> > >  Can someone point me to a useful documentation on setting up
> > taxation.
> > > 
> > >  Expectations :
> > > 
> > >  (1) tax % should be allowed to be specified at a product / product
> > > category level and indicate  the tax authority
> > > 
> > >  (2) There can be multiple kind of taxes having various rates .
> > > 
> > >  (3) When we order the product from eCommerce storefront then the
> > >  end user is shown the total price including the tax.
> > > 
> > > 
> > >  (4) when we create an invoice for an internally created order
> > >  (non-eCommerce)
> > >  the tax amount should automatically get added to invoice.
> > > 
> > >  Kindly indicate the best documentation that may help in setting
> the
> > >  above.
> > > 
> > >  regds
> > >  mallah.
> > > 
> > >

Re: setting up TAX in ofbiz

[Rajesh Mallah]

>
> Hi Rajesh,
>
> I think you try with a different product also. It is possible that
> ProductPrice data is not correct/sufficient for the selected product and
> system is not picking the correct price.


Hi Deepak ,

I saw a currency related issue. I added a price with USD currency the price
was being picked correctly  and so were the taxes being calculated.

regds
mallah.






On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:

> Hi Rajesh,
>
> I think you try with a different product also. It is possible that
> ProductPrice data is not correct/sufficient for the selected product and
> system is not picking the correct price.
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>
> On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah 
> wrote:
>
> > Some more progress:
> >
> > I was able to apply taxes to demo products using new tax
> > authority .  The incremental steps i did were:
> >
> > (1) setup "Categories" , "Association" , "Product Rates" for the new
> >  tax authority in  Accounting --> Tax Auth .
> >
> > Rite now the problem is when i add "Items" in invoice using product id
> > the added items do not pick the correct price. As a result (i feel) "Add
> > taxes" is
> > also calculating taxes on 0 .(=0)
> >
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> > deepak.ni...@hotwaxsystems.com> wrote:
> >
> > > Hi Rajesh,
> > >
> > > Most of the mentioned requirements can be fulfilled by setting up data
> in
> > > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> > > OFBiz tax engine internally uses data from these entities to perform
> tax
> > > calculations.
> > >
> > > Please refer to the following set of demo data. It can help you.
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> > >
> > >  > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > > categoryName="5.00 %"/> > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> > >
> > >  > > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > > categoryName="10.00 %"/> > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> > >
> > >  > > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > > billOfMaterialLevel="0" quantityIncluded="10"
> > > introductionDate="2001-01-01 12:00:00.000"/>
> > >  > > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> > >
> > >  > > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > > productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> > > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> > >  > > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> > >
> > >  > fromDate="2017-06-01
> > > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> taxPercentage="5.00"
> > > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> > and
> > > Services Tax"/>
> > >  > fromDate="2017-06-01
> > > 00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
> > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> taxPercentage="10.00"
> > > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> > and
> > > Services Tax"/>
> > >
> > >
> > > Please revert in case of any doubt.
> > >
> > > HTH!
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Nigam
> > > Technical Consultant/Team Lead
> > > HotWax Systems
> > > www.hotwaxsystems.com
> > >
> > > On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah <
> mallah.raj...@gmail.com>
> > > wrote:
> > >
> > > > Thanks ,  Paul's reply did help , and I saw taxes getting
> > > > automatically added  after the product was  included  in
> > > > a extra category of type *Tax* . I named to the category
> > > > as "Taxable Products" for time being (as suggested).
> > > >
> > > > regds
> > > > mallah.
> > > >
> > > >
> > > > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > > > jacques.le.r...@les7arts.com> wrote:
> > > >
> > > > > You are doing very well comparing to some others ;)
> > > > >
> > > > > Jacques
> > > > >
> > > > >
> > > > >
> > > > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > > > >
> > > > >> thanks.
> > > > >>
> > > > >> I hope i finally reach the mundane state soon.
> > > > >>
> > > > >> regds
> > > > >> mallah.
> > > > >>
> > > > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > > 

Re: Theme Language and Timezone Video tutorial

[Todd Thorner]

Thanks very much for helping to make OFBiz more accessible to the world.


On 17-08-30 04:53 AM, Deepak Dixit wrote:

We have uploaded new video related to "Theme Language and Timezone"
prepared by Pranay Pandey.

Description:
Learn how to navigate through Apache OFBiz application for setting user
preferences for application UI theme, language, time zone and locate, view
user/party profile.

Here is the youtube and vimeo link for the

https://youtu.be/TDJpVQRVTvI
https://vimeo.com/231685386

Thank you Pranay for your effort.

Thanks & Regards
--
Deepak Dixit
https://ofbiz.apache.org/

Re: setting up TAX in ofbiz

[Rishi Solanki]

Rajesh,

IMO, what Deepak is suggesting seems correct, please try with different
product or share the xml data setup you did for the product you are trying
to add tax.

May some extra setup/price override the behavior or incorrect setup for
tax. Data will help us to diagnose and reply.



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Wed, Aug 30, 2017 at 8:26 PM, Rajesh Mallah 
wrote:

> >
> > Hi Rajesh,
> >
> > I think you try with a different product also. It is possible that
> > ProductPrice data is not correct/sufficient for the selected product and
> > system is not picking the correct price.
>
>
> Hi Deepak ,
>
> I saw a currency related issue. I added a price with USD currency the price
> was being picked correctly  and so were the taxes being calculated.
>
> regds
> mallah.
>
>
>
>
>
>
> On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
> deepak.ni...@hotwaxsystems.com> wrote:
>
> > Hi Rajesh,
> >
> > I think you try with a different product also. It is possible that
> > ProductPrice data is not correct/sufficient for the selected product and
> > system is not picking the correct price.
> >
> > Thanks & Regards
> > --
> > Deepak Nigam
> > Technical Consultant/Team Lead
> > HotWax Systems
> > www.hotwaxsystems.com
> >
> > On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah 
> > wrote:
> >
> > > Some more progress:
> > >
> > > I was able to apply taxes to demo products using new tax
> > > authority .  The incremental steps i did were:
> > >
> > > (1) setup "Categories" , "Association" , "Product Rates" for the new
> > >  tax authority in  Accounting --> Tax Auth .
> > >
> > > Rite now the problem is when i add "Items" in invoice using product id
> > > the added items do not pick the correct price. As a result (i feel)
> "Add
> > > taxes" is
> > > also calculating taxes on 0 .(=0)
> > >
> > >
> > > regds
> > > mallah.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> > > deepak.ni...@hotwaxsystems.com> wrote:
> > >
> > > > Hi Rajesh,
> > > >
> > > > Most of the mentioned requirements can be fulfilled by setting up
> data
> > in
> > > > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as
> the
> > > > OFBiz tax engine internally uses data from these entities to perform
> > tax
> > > > calculations.
> > > >
> > > > Please refer to the following set of demo data. It can help you.
> > > >
> > > > 
> > > > 
> > > > 
> > > >
> > > >  > > > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> > > >
> > > >  > > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > > > categoryName="5.00 %"/> > > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> > > >
> > > >  > > > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > > > categoryName="10.00 %"/> > > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> > > >
> > > >  > > > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > > > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > > > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > > > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > > > billOfMaterialLevel="0" quantityIncluded="10"
> > > > introductionDate="2001-01-01 12:00:00.000"/>
> > > >  > > > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> > > >
> > > >  > > > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > > > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > > > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > > > productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> > > > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > > > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> > > >  > > > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> > > >
> > > >  > > fromDate="2017-06-01
> > > > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> > taxPercentage="5.00"
> > > > taxPromotions="N" taxShipping="N" description="IGST - Integrated
> Goods
> > > and
> > > > Services Tax"/>
> > > >  > > fromDate="2017-06-01
> > > > 00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
> > > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> > taxPercentage="10.00"
> > > > taxPromotions="N" taxShipping="N" description="IGST - Integrated
> Goods
> > > and
> > > > Services Tax"/>
> > > >
> > > >
> > > > Please revert in case of any doubt.
> > > >
> > > > HTH!
> > > >
> > > >
> > > > Thanks & Regards
> > > > --
> > > > Deepak Nigam
> > > > Technical Consultant/Team Lead
> > > > HotWax Systems
> > > > www.hotwaxsystems.com
> > > >
> > > > On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah <
> > mallah.raj...@gmail.com>
> > > > wrote:
> > > >
> > > > > Thanks ,  Paul'

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Hi Everyone ,

I am referring to old thread message:

http://markmail.org/message/kwygn6w2tmfzvtbv

In my case also i see that the

Base Currency: USD in screen
IN :  Applications > Accounting > Organization GL Settings > Setup
with no means of updating it.

In said thread it is suggested to update it by hand , but do we really need
to
do so ? I am generally averse to an hackish approach

regds
mallah.






On Wed, Aug 30, 2017 at 8:26 PM, Rajesh Mallah 
wrote:

> Hi Rajesh,
>>
>> I think you try with a different product also. It is possible that
>> ProductPrice data is not correct/sufficient for the selected product and
>> system is not picking the correct price.
>
>
> Hi Deepak ,
>
> I saw a currency related issue. I added a price with USD currency the
> price
> was being picked correctly  and so were the taxes being calculated.
>
> regds
> mallah.
>
>
>
>
>
>
> On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam  com> wrote:
>
>> Hi Rajesh,
>>
>> I think you try with a different product also. It is possible that
>> ProductPrice data is not correct/sufficient for the selected product and
>> system is not picking the correct price.
>>
>> Thanks & Regards
>> --
>> Deepak Nigam
>> Technical Consultant/Team Lead
>> HotWax Systems
>> www.hotwaxsystems.com
>>
>> On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah 
>> wrote:
>>
>> > Some more progress:
>> >
>> > I was able to apply taxes to demo products using new tax
>> > authority .  The incremental steps i did were:
>> >
>> > (1) setup "Categories" , "Association" , "Product Rates" for the new
>> >  tax authority in  Accounting --> Tax Auth .
>> >
>> > Rite now the problem is when i add "Items" in invoice using product id
>> > the added items do not pick the correct price. As a result (i feel) "Add
>> > taxes" is
>> > also calculating taxes on 0 .(=0)
>> >
>> >
>> > regds
>> > mallah.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
>> > deepak.ni...@hotwaxsystems.com> wrote:
>> >
>> > > Hi Rajesh,
>> > >
>> > > Most of the mentioned requirements can be fulfilled by setting up
>> data in
>> > > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
>> > > OFBiz tax engine internally uses data from these entities to perform
>> tax
>> > > calculations.
>> > >
>> > > Please refer to the following set of demo data. It can help you.
>> > >
>> > > 
>> > > 
>> > > 
>> > >
>> > > > > > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
>> > >
>> > > > > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
>> > > categoryName="5.00 %"/>> > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
>> > >
>> > > > > > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
>> > > categoryName="10.00 %"/>> > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
>> > >
>> > > > > > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
>> > > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
>> > > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
>> > > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
>> > > billOfMaterialLevel="0" quantityIncluded="10"
>> > > introductionDate="2001-01-01 12:00:00.000"/>
>> > > > > > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
>> > >
>> > > > > > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
>> > > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
>> > > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
>> > > productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
>> > > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
>> > > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
>> > > > > > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
>> > >
>> > > > > fromDate="2017-06-01
>> > > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
>> > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
>> taxPercentage="5.00"
>> > > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
>> > and
>> > > Services Tax"/>
>> > > > > fromDate="2017-06-01
>> > > 00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
>> > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
>> taxPercentage="10.00"
>> > > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
>> > and
>> > > Services Tax"/>
>> > >
>> > >
>> > > Please revert in case of any doubt.
>> > >
>> > > HTH!
>> > >
>> > >
>> > > Thanks & Regards
>> > > --
>> > > Deepak Nigam
>> > > Technical Consultant/Team Lead
>> > > HotWax Systems
>> > > www.hotwaxsystems.com
>> > >
>> > > On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah <
>> mallah.raj...@gmail.com>
>> > > wrote:
>> > >
>> > > > Thanks ,  Paul's reply did help , and I saw taxes getting
>> > > > automatically added  after the product was  included  in
>> > > > a extra category of type *Tax* . I named to the category
>> > > > as "Taxable Products"

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Hi Rishi ,

I am doing almost all functions using the UI only
Is it possible to export selected entities created
using Web-UI to xml ?

I am going to create a new product now and see how it
does.


regds
mallah.




On Wed, Aug 30, 2017 at 9:14 PM, Rishi Solanki 
wrote:

> Rajesh,
>
> IMO, what Deepak is suggesting seems correct, please try with different
> product or share the xml data setup you did for the product you are trying
> to add tax.
>
> May some extra setup/price override the behavior or incorrect setup for
> tax. Data will help us to diagnose and reply.
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Aug 30, 2017 at 8:26 PM, Rajesh Mallah 
> wrote:
>
> > >
> > > Hi Rajesh,
> > >
> > > I think you try with a different product also. It is possible that
> > > ProductPrice data is not correct/sufficient for the selected product
> and
> > > system is not picking the correct price.
> >
> >
> > Hi Deepak ,
> >
> > I saw a currency related issue. I added a price with USD currency the
> price
> > was being picked correctly  and so were the taxes being calculated.
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> > On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
> > deepak.ni...@hotwaxsystems.com> wrote:
> >
> > > Hi Rajesh,
> > >
> > > I think you try with a different product also. It is possible that
> > > ProductPrice data is not correct/sufficient for the selected product
> and
> > > system is not picking the correct price.
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Nigam
> > > Technical Consultant/Team Lead
> > > HotWax Systems
> > > www.hotwaxsystems.com
> > >
> > > On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah <
> mallah.raj...@gmail.com>
> > > wrote:
> > >
> > > > Some more progress:
> > > >
> > > > I was able to apply taxes to demo products using new tax
> > > > authority .  The incremental steps i did were:
> > > >
> > > > (1) setup "Categories" , "Association" , "Product Rates" for the new
> > > >  tax authority in  Accounting --> Tax Auth .
> > > >
> > > > Rite now the problem is when i add "Items" in invoice using product
> id
> > > > the added items do not pick the correct price. As a result (i feel)
> > "Add
> > > > taxes" is
> > > > also calculating taxes on 0 .(=0)
> > > >
> > > >
> > > > regds
> > > > mallah.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> > > > deepak.ni...@hotwaxsystems.com> wrote:
> > > >
> > > > > Hi Rajesh,
> > > > >
> > > > > Most of the mentioned requirements can be fulfilled by setting up
> > data
> > > in
> > > > > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as
> > the
> > > > > OFBiz tax engine internally uses data from these entities to
> perform
> > > tax
> > > > > calculations.
> > > > >
> > > > > Please refer to the following set of demo data. It can help you.
> > > > >
> > > > > 
> > > > > 
> > > > > 
> > > > >
> > > > >  > > > > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> > > > >
> > > > >  > > > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > > > > categoryName="5.00 %"/> > > > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> > > > >
> > > > >  > > > > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > > > > categoryName="10.00 %"/> > > > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> > > > >
> > > > >  > > > > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > > > > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > > > > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > > > > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > > > > billOfMaterialLevel="0" quantityIncluded="10"
> > > > > introductionDate="2001-01-01 12:00:00.000"/>
> > > > >  > > > > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> > > > >
> > > > >  > > > > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > > > > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > > > > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > > > > productWeight="0.01" description="Aceclofenac + Paracetamol (100
> mg +
> > > > > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > > > > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> > > > >  > > > > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> > > > >
> > > > >  > > > fromDate="2017-06-01
> > > > > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > > > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> > > taxPercentage="5.00"
> > > > > taxPromotions="N" taxShipping="N" description="IGST - Integrated
> > Goods
> > > > and
> > > > > Services Tax"/>
> > > > >  > > > fromDate="2017-06-01
> > > > > 00:00:00.000" productCategoryId="TAX_SLAB

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Hi Rishi / List ,

I did create a new product in same category and set its price
and average price in INR . I took care to select the currency as
INR . (everything using the UI only)

still the price is picked a 0 which i try to add the new product as
an invoice item.

regds
mallah.





On Wed, Aug 30, 2017 at 9:14 PM, Rishi Solanki 
wrote:

> Rajesh,
>
> IMO, what Deepak is suggesting seems correct, please try with different
> product or share the xml data setup you did for the product you are trying
> to add tax.
>
> May some extra setup/price override the behavior or incorrect setup for
> tax. Data will help us to diagnose and reply.
>
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Aug 30, 2017 at 8:26 PM, Rajesh Mallah 
> wrote:
>
> > >
> > > Hi Rajesh,
> > >
> > > I think you try with a different product also. It is possible that
> > > ProductPrice data is not correct/sufficient for the selected product
> and
> > > system is not picking the correct price.
> >
> >
> > Hi Deepak ,
> >
> > I saw a currency related issue. I added a price with USD currency the
> price
> > was being picked correctly  and so were the taxes being calculated.
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> > On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
> > deepak.ni...@hotwaxsystems.com> wrote:
> >
> > > Hi Rajesh,
> > >
> > > I think you try with a different product also. It is possible that
> > > ProductPrice data is not correct/sufficient for the selected product
> and
> > > system is not picking the correct price.
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Nigam
> > > Technical Consultant/Team Lead
> > > HotWax Systems
> > > www.hotwaxsystems.com
> > >
> > > On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah <
> mallah.raj...@gmail.com>
> > > wrote:
> > >
> > > > Some more progress:
> > > >
> > > > I was able to apply taxes to demo products using new tax
> > > > authority .  The incremental steps i did were:
> > > >
> > > > (1) setup "Categories" , "Association" , "Product Rates" for the new
> > > >  tax authority in  Accounting --> Tax Auth .
> > > >
> > > > Rite now the problem is when i add "Items" in invoice using product
> id
> > > > the added items do not pick the correct price. As a result (i feel)
> > "Add
> > > > taxes" is
> > > > also calculating taxes on 0 .(=0)
> > > >
> > > >
> > > > regds
> > > > mallah.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> > > > deepak.ni...@hotwaxsystems.com> wrote:
> > > >
> > > > > Hi Rajesh,
> > > > >
> > > > > Most of the mentioned requirements can be fulfilled by setting up
> > data
> > > in
> > > > > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as
> > the
> > > > > OFBiz tax engine internally uses data from these entities to
> perform
> > > tax
> > > > > calculations.
> > > > >
> > > > > Please refer to the following set of demo data. It can help you.
> > > > >
> > > > > 
> > > > > 
> > > > > 
> > > > >
> > > > >  > > > > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> > > > >
> > > > >  > > > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > > > > categoryName="5.00 %"/> > > > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> > > > >
> > > > >  > > > > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > > > > categoryName="10.00 %"/> > > > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> > > > >
> > > > >  > > > > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > > > > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > > > > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > > > > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > > > > billOfMaterialLevel="0" quantityIncluded="10"
> > > > > introductionDate="2001-01-01 12:00:00.000"/>
> > > > >  > > > > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> > > > >
> > > > >  > > > > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > > > > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > > > > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > > > > productWeight="0.01" description="Aceclofenac + Paracetamol (100
> mg +
> > > > > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > > > > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> > > > >  > > > > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> > > > >
> > > > >  > > > fromDate="2017-06-01
> > > > > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > > > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> > > taxPercentage="5.00"
> > > > > taxPromotions="N" taxShipping="N" description="IGST - Integrated
> > Goods
> > > > and
> > > > > Services Tax"/>
> > > > >  > > >

Re: setting up TAX in ofbiz

[Jacques Le Roux]

Yes, look in webtools for export

Jacques


Le 30/08/2017 à 18:02, Rajesh Mallah a écrit :

Hi Rishi ,

I am doing almost all functions using the UI only
Is it possible to export selected entities created
using Web-UI to xml ?

I am going to create a new product now and see how it
does.


regds
mallah.




On Wed, Aug 30, 2017 at 9:14 PM, Rishi Solanki 
wrote:


Rajesh,

IMO, what Deepak is suggesting seems correct, please try with different
product or share the xml data setup you did for the product you are trying
to add tax.

May some extra setup/price override the behavior or incorrect setup for
tax. Data will help us to diagnose and reply.



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Wed, Aug 30, 2017 at 8:26 PM, Rajesh Mallah 
wrote:


Hi Rajesh,

I think you try with a different product also. It is possible that
ProductPrice data is not correct/sufficient for the selected product

and

system is not picking the correct price.


Hi Deepak ,

I saw a currency related issue. I added a price with USD currency the

price

was being picked correctly  and so were the taxes being calculated.

regds
mallah.






On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:


Hi Rajesh,

I think you try with a different product also. It is possible that
ProductPrice data is not correct/sufficient for the selected product

and

system is not picking the correct price.

Thanks & Regards
--
Deepak Nigam
Technical Consultant/Team Lead
HotWax Systems
www.hotwaxsystems.com

On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah <

mallah.raj...@gmail.com>

wrote:


Some more progress:

I was able to apply taxes to demo products using new tax
authority .  The incremental steps i did were:

(1) setup "Categories" , "Association" , "Product Rates" for the new
  tax authority in  Accounting --> Tax Auth .

Rite now the problem is when i add "Items" in invoice using product

id

the added items do not pick the correct price. As a result (i feel)

"Add

taxes" is
also calculating taxes on 0 .(=0)


regds
mallah.











On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:


Hi Rajesh,

Most of the mentioned requirements can be fulfilled by setting up

data

in

entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as

the

OFBiz tax engine internally uses data from these entities to

perform

tax

calculations.

Please refer to the following set of demo data. It can help you.



Tax"/>










ANALGESIC"

productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
billOfMaterialLevel="0" quantityIncluded="10"
introductionDate="2001-01-01 12:00:00.000"/>



mg +

325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>



fromDate="2017-06-01

00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"

taxPercentage="5.00"

taxPromotions="N" taxShipping="N" description="IGST - Integrated

Goods

and

Services Tax"/>

fromDate="2017-06-01

00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"

taxPercentage="10.00"

taxPromotions="N" taxShipping="N" description="IGST - Integrated

Goods

and

Services Tax"/>


Please revert in case of any doubt.

HTH!


Thanks & Regards
--
Deepak Nigam
Technical Consultant/Team Lead
HotWax Systems
www.hotwaxsystems.com

On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah <

mallah.raj...@gmail.com>

wrote:


Thanks ,  Paul's reply did help , and I saw taxes getting
automatically added  after the product was  included  in
a extra category of type *Tax* . I named to the category
as "Taxable Products" for time being (as suggested).

regds
mallah.


On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:


You are doing very well comparing to some others ;)

Jacques



Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :


thanks.

I hope i finally reach the mundane state soon.

regds
mallah.

On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

This http://markmail.org/message/esl5ou2zo4x2lt3l :D

You should do more research in the ML archives ;)

Jacques



Le 30/08/2017 à 08:22, Rajesh Mallah a écrit :

Hi ,

Can someone point me to a useful documentation on setting up

taxation.

Expectations :

(1) tax % should be allowed to be specified at a product /

product

category level and indicate  the tax authority

(2) There can be multiple kind of taxes having various

rates .

(3) When we order the product from eCommerce storefront then

the

 end user is shown

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Hi Deepak ,

as specifically asked  the,  ProductPrice dump is below grepped
for the said productID

 



Please note that the pricing for entity2 is being picked up when we attempt
to
add the item (productID=1) to invoice.

Pls suggest which other entity dump shall be useful for debugging the
situation.

regds
mallah.






On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:

> Hi Rajesh,
>
> I think you try with a different product also. It is possible that
> ProductPrice data is not correct/sufficient for the selected product and
> system is not picking the correct price.
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>
> On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah 
> wrote:
>
> > Some more progress:
> >
> > I was able to apply taxes to demo products using new tax
> > authority .  The incremental steps i did were:
> >
> > (1) setup "Categories" , "Association" , "Product Rates" for the new
> >  tax authority in  Accounting --> Tax Auth .
> >
> > Rite now the problem is when i add "Items" in invoice using product id
> > the added items do not pick the correct price. As a result (i feel) "Add
> > taxes" is
> > also calculating taxes on 0 .(=0)
> >
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
> > deepak.ni...@hotwaxsystems.com> wrote:
> >
> > > Hi Rajesh,
> > >
> > > Most of the mentioned requirements can be fulfilled by setting up data
> in
> > > entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the
> > > OFBiz tax engine internally uses data from these entities to perform
> tax
> > > calculations.
> > >
> > > Please refer to the following set of demo data. It can help you.
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
> > >
> > >  > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > > categoryName="5.00 %"/> > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
> > >
> > >  > > productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
> > > categoryName="10.00 %"/> > > taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
> > >
> > >  > > productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
> > > internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
> > > weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
> > > Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
> > > billOfMaterialLevel="0" quantityIncluded="10"
> > > introductionDate="2001-01-01 12:00:00.000"/>
> > >  > > productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
> > >
> > >  > > primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
> > > productName="Aceclofenac Tab 2" internalName="Aceclofenac +
> > > Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
> > > productWeight="0.01" description="Aceclofenac + Paracetamol (100 mg +
> > > 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
> > > quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
> > >  > > productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
> > >
> > >  > fromDate="2017-06-01
> > > 00:00:00.000" productCategoryId="TAX_SLAB_1" taxAuthGeoId="_NA_"
> > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> taxPercentage="5.00"
> > > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> > and
> > > Services Tax"/>
> > >  > fromDate="2017-06-01
> > > 00:00:00.000" productCategoryId="TAX_SLAB_2" taxAuthGeoId="_NA_"
> > > taxAuthPartyId="IGST" taxAuthorityRateTypeId="IGST"
> taxPercentage="10.00"
> > > taxPromotions="N" taxShipping="N" description="IGST - Integrated Goods
> > and
> > > Services Tax"/>
> > >
> > >
> > > Please revert in case of any doubt.
> > >
> > > HTH!
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Nigam
> > > Technical Consultant/Team Lead
> > > HotWax Systems
> > > www.hotwaxsystems.com
> > >
> > > On Wed, Aug 30, 2017 at 2:02 PM, Rajesh Mallah <
> mallah.raj...@gmail.com>
> > > wrote:
> > >
> > > > Thanks ,  Paul's reply did help , and I saw taxes getting
> > > > automatically added  after the product was  included  in
> > > > a extra category of type *Tax* . I named to the category
> > > > as "Taxable Products" for time being (as suggested).
> > > >
> > > > regds
> > > > mallah.
> > > >
> > > >
> > > > On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux <
> > > > jacques.le.r...@les7arts.com> wrote:
> > > >
> > > > > You are doing very well comparing to some others ;)
> > > > >
> > > > > Jacques
> > > > >
> > > > >
> > > > >
> > > > > Le 30/08/2017 à 09:36, Rajesh Mallah a écrit :
> > > > >
> > > > >> thanks.
> > > > >>
> > > > >> I hope i finally reach the mundane state soon.
> > > > >>
> > > > >> regds
> > > > >> mallah.
> > > > >>
> > > > >> On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux <
> > > > >> jacques.le.r...@les7arts.com> wrote:
> > > >

Re: setting up TAX in ofbiz

[Rajesh Mallah]

thanks Jacques , i used it just now.

On Wed, Aug 30, 2017 at 9:57 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Yes, look in webtools for export
>
> Jacques
>
>
>
> Le 30/08/2017 à 18:02, Rajesh Mallah a écrit :
>
>> Hi Rishi ,
>>
>> I am doing almost all functions using the UI only
>> Is it possible to export selected entities created
>> using Web-UI to xml ?
>>
>> I am going to create a new product now and see how it
>> does.
>>
>>
>> regds
>> mallah.
>>
>>
>>
>>
>> On Wed, Aug 30, 2017 at 9:14 PM, Rishi Solanki 
>> wrote:
>>
>> Rajesh,
>>>
>>> IMO, what Deepak is suggesting seems correct, please try with different
>>> product or share the xml data setup you did for the product you are
>>> trying
>>> to add tax.
>>>
>>> May some extra setup/price override the behavior or incorrect setup for
>>> tax. Data will help us to diagnose and reply.
>>>
>>>
>>>
>>> Rishi Solanki
>>> Sr Manager, Enterprise Software Development
>>> HotWax Systems Pvt. Ltd.
>>> Direct: +91-9893287847
>>> http://www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Wed, Aug 30, 2017 at 8:26 PM, Rajesh Mallah 
>>> wrote:
>>>
>>> Hi Rajesh,
>
> I think you try with a different product also. It is possible that
> ProductPrice data is not correct/sufficient for the selected product
>
 and
>>>
 system is not picking the correct price.
>

 Hi Deepak ,

 I saw a currency related issue. I added a price with USD currency the

>>> price
>>>
 was being picked correctly  and so were the taxes being calculated.

 regds
 mallah.






 On Wed, Aug 30, 2017 at 6:10 PM, Deepak Nigam <
 deepak.ni...@hotwaxsystems.com> wrote:

 Hi Rajesh,
>
> I think you try with a different product also. It is possible that
> ProductPrice data is not correct/sufficient for the selected product
>
 and
>>>
 system is not picking the correct price.
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>
> On Wed, Aug 30, 2017 at 4:46 PM, Rajesh Mallah <
>
 mallah.raj...@gmail.com>
>>>
 wrote:
>
> Some more progress:
>>
>> I was able to apply taxes to demo products using new tax
>> authority .  The incremental steps i did were:
>>
>> (1) setup "Categories" , "Association" , "Product Rates" for the new
>>   tax authority in  Accounting --> Tax Auth .
>>
>> Rite now the problem is when i add "Items" in invoice using product
>>
> id
>>>
 the added items do not pick the correct price. As a result (i feel)
>>
> "Add

> taxes" is
>> also calculating taxes on 0 .(=0)
>>
>>
>> regds
>> mallah.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam <
>> deepak.ni...@hotwaxsystems.com> wrote:
>>
>> Hi Rajesh,
>>>
>>> Most of the mentioned requirements can be fulfilled by setting up
>>>
>> data

> in
>
>> entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as
>>>
>> the

> OFBiz tax engine internally uses data from these entities to
>>>
>> perform
>>>
 tax
>
>> calculations.
>>>
>>> Please refer to the following set of demo data. It can help you.
>>>
>>> 
>>> 
>>
>>> 
>>>
>>> >> taxIdFormatPattern="\d{2}[A-Z]{5}\d{4}[A-Z]\d[A-z]\d"/>
>>>
>>> >> productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
>>> categoryName="5.00 %"/>>> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_1"/>
>>>
>>> >> productCategoryTypeId="TAX_CATEGORY" description="10.00 %"
>>> categoryName="10.00 %"/>>> taxAuthPartyId="IGST" productCategoryId="TAX_SLAB_2"/>
>>>
>>> >>>
> productTypeId="FINISHED_GOOD" productName="Aceclofenac Tab"
>>> internalName="Aceclofenac + Paracetamol (100 mg + 325mg) Tab"
>>> weightUomId="WT_kg" productWeight="0.01" description="Aceclofenac +
>>> Paracetamol (100 mg + 325mg) Tab" isVirtual="N" isVariant="N"
>>> billOfMaterialLevel="0" quantityIncluded="10"
>>> introductionDate="2001-01-01 12:00:00.000"/>
>>> >> productId="ACE_PARA_TAB" fromDate="2001-01-01 12:00:00.000"/>
>>>
>>> >> primaryProductCategoryId="ANALGESIC" productTypeId="FINISHED_GOOD"
>>> productName="Aceclofenac Tab 2" internalName="Aceclofenac +
>>> Paracetamol (100 mg + 325mg) Tab 2" weightUomId="WT_kg"
>>> productWeight="0.01" description="Aceclofenac + Paracetamol (100
>>>
>> mg +
>>>
 325mg) Tab 2" isVirtual="N" isVariant="N" billOfMaterialLevel="0"
>>> quantityIncluded="10" introductionDate="2001-01-01 12:00:00.000"/>
>>> >> productId="ACE_PARA_TAB2" fromDate="2001-01-01 12:00:00.000"/>
>>>
>>> >>
>> fromDate="2017-06-01
>>

Re: UI improvement for tables in OFBiz

[Jacques Le Roux]

Le 28/08/2017 à 08:24, Rajesh Mallah a écrit :

Hi Nitish ,

I feel bootstrap  is a mobile first framework and is
primarily meant for creating ui that looks great in
large and small screens.

Given the kind of application Ofbiz is , it is difficult
to imagine much core usage in mobile space as most of
the screens requires an elaborate input from users and
also display quite many details.

Definitely bootstrap provides elegant UI/UX but most
of the (bootstrap based) designs that i have come across
are not dense in terms of information content .  The forms
created by default bootstrap styles waste too much space,
IMHO.

I am not sure how much value it is going to add in comparison
to the effort made in customizing the bootstrap styles to
accommodate the screens of Ofbiz which generally have quite
many fields in  forms or tables.

I feel if with relatively less effort the the proposed UI improvement
can done its worth !.

regds
mallah.


Hi Rajesh,

This is interesting and I agree.

Despite recognising Bootstrap value I have always thought that there is some 
cargo cult around it.
Notably, as you outline, for applications like ERP. Even if nowadays you often 
have access to them also from smartphones.
Of course a CSS framework is more interesting if you look for ecommerce 
solutions, where mobile is ubiquitous

I have been working with the ilscipio team who is mostly providing ecommerce 
solutions.
They initialled picked Bootstrap but are finally using Foundation.
I never used a CSS framework, but I read that Foundation is more flexible 
regarding tables, that OFBiz uses  a lot!

Anyway rather than blindly using a CSS framework, we could get inspired from 
them.
To indeed improve what we have already and where a lot of thoughts has already 
been put.

Jacques

Re: setting up TAX in ofbiz

[Rajesh Mallah]

@Deepak , @Rishi  / List ,

Additional SQL tracing reveals that the ProductPricing
entities are being queried with  CURRENCY_UOM_ID=USD
and hence the USD pricing is being picked up. I am not sure
why USD currency is being picked. I have changed in almost
all places including properties file.

-- ./framework/common/config/general.properties

# -- unique instance id (20 char max)
unique.instanceId=ofbiz1
# -- the default currency to use for prices, etc
currency.uom.id.default=INR
# These values override the _NA_ DEFAULT values in user preferences for the
GLOBAL_PREFERENCES userPrefGroupTypeId
# -- the default organizationPartyId for used in dropdowns and reports


2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO
|T| Ran query in 1 milli-seconds:  EntityName: ProductPrice
Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID,
 CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE,
TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX,
TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE,
 CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE WHERE
((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR
PRODUCT_PRICE_PURPOSE_ID IS NULL)
 AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?))
ORDER BY FROM_DATE DESC

 where clause:[PRODUCT_ID=1, PRODUCT_PRICE_PURPOSE_ID=PURCHASE,
CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_]

Full Log:
https://pastebin.com/raw/smdQX84B


Looking forward to further comments and
 guidance.

​regds
mallah.

Re: setting up TAX in ofbiz

[Rajesh Mallah]

looks like too many messages has already been
exchanged in past  at various point in time.

http://ofbiz.markmail.org/search/?q=changing+default+currency#query:changing%20default%20currency

it will be beneficial to new users  if it is given attention .

regds
mallah.


On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah 
wrote:

>
>
>
> @Deepak , @Rishi  / List ,
>
> Additional SQL tracing reveals that the ProductPricing
> entities are being queried with  CURRENCY_UOM_ID=USD
> and hence the USD pricing is being picked up. I am not sure
> why USD currency is being picked. I have changed in almost
> all places including properties file.
>
> -- ./framework/common/config/general.properties
>
> # -- unique instance id (20 char max)
> unique.instanceId=ofbiz1
> # -- the default currency to use for prices, etc
> currency.uom.id.default=INR
> # These values override the _NA_ DEFAULT values in user preferences for
> the GLOBAL_PREFERENCES userPrefGroupTypeId
> # -- the default organizationPartyId for used in dropdowns and reports
>
>
> 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO
> |T| Ran query in 1 milli-seconds:  EntityName: ProductPrice
> Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID,
>  CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE,
> TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, PRICE_WITH_TAX,
> TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_IN_PRICE,
>  CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
> LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE WHERE
> ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR 
> PRODUCT_PRICE_PURPOSE_ID IS NULL)
>  AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?))
> ORDER BY FROM_DATE DESC
>
>  where clause:[PRODUCT_ID=1, PRODUCT_PRICE_PURPOSE_ID=PURCHASE,
> CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_]
>
> Full Log:
> https://pastebin.com/raw/smdQX84B
>
>
> Looking forward to further comments and
>  guidance.
>
> ​regds
> mallah.
>

Re: UI improvement for tables in OFBiz

[Rajesh Mallah]

Hi Jacques/List ,

Further,  for mini/micro applications that absorb relatively less update
information from teams on move  (say e.g. opportunity status update from
front-line sales team, status update from delivery courier fleet etc) it
makes
sense to use bootstrap/equivalent .

But i feel such application development can mostly by done
by teams implementing ofbiz in organisations rather than being
a part of ofbiz itself as Ofbiz already provides excellent framework
for interfacing.

regds
mallah.




On Thu, Aug 31, 2017 at 12:48 AM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Le 28/08/2017 à 08:24, Rajesh Mallah a écrit :
>
>> Hi Nitish ,
>>
>> I feel bootstrap  is a mobile first framework and is
>> primarily meant for creating ui that looks great in
>> large and small screens.
>>
>> Given the kind of application Ofbiz is , it is difficult
>> to imagine much core usage in mobile space as most of
>> the screens requires an elaborate input from users and
>> also display quite many details.
>>
>> Definitely bootstrap provides elegant UI/UX but most
>> of the (bootstrap based) designs that i have come across
>> are not dense in terms of information content .  The forms
>> created by default bootstrap styles waste too much space,
>> IMHO.
>>
>> I am not sure how much value it is going to add in comparison
>> to the effort made in customizing the bootstrap styles to
>> accommodate the screens of Ofbiz which generally have quite
>> many fields in  forms or tables.
>>
>> I feel if with relatively less effort the the proposed UI improvement
>> can done its worth !.
>>
>> regds
>> mallah.
>>
>> Hi Rajesh,
>
> This is interesting and I agree.
>
> Despite recognising Bootstrap value I have always thought that there is
> some cargo cult around it.
> Notably, as you outline, for applications like ERP. Even if nowadays you
> often have access to them also from smartphones.
> Of course a CSS framework is more interesting if you look for ecommerce
> solutions, where mobile is ubiquitous
>
> I have been working with the ilscipio team who is mostly providing
> ecommerce solutions.
> They initialled picked Bootstrap but are finally using Foundation.
> I never used a CSS framework, but I read that Foundation is more flexible
> regarding tables, that OFBiz uses  a lot!
>
> Anyway rather than blindly using a CSS framework, we could get inspired
> from them.
> To indeed improve what we have already and where a lot of thoughts has
> already been put.
>
> Jacques
>
>

UI improvement scope for excessively wide rows.

[Rajesh Mallah]

In many screens it is observed that there are series of
non-breakable UI elements that occupy aggregate horizontal
space exceeding the available space on screen.

As a result the right-most columns are seen only on scrolling
the content to left.

the problem is more pronounced in themes that have a left
navigation area like tomhawk .

An example of it is when we add items to invoice.
( a comprehensive list can be prepared )

Mostly the select drop downs eat away the horizontal
space in table rows.

I feel this can also be an area of UI improvement.
One quick solution that comes in mind is to place some of the
elements (particularly the  dropdowns) below the other
elements in the *same* row.

regds
mallah.

Re: setting up TAX in ofbiz

[Arun Patidar]

Hello Rajesh,

ProductStore and PartyAcctgPreference entities also have fields to store
currency UOM.

-- 
Thanks & Regards
---
Arun Patidar
Manager, Enterprise Software Development

HotWax Systems Pvt Ltd.

www.hotwaxsystems.com


On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah 
wrote:

> looks like too many messages has already been
> exchanged in past  at various point in time.
>
> http://ofbiz.markmail.org/search/?q=changing+default+
> currency#query:changing%20default%20currency
>
> it will be beneficial to new users  if it is given attention .
>
> regds
> mallah.
>
>
> On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah 
> wrote:
>
> >
> >
> >
> > @Deepak , @Rishi  / List ,
> >
> > Additional SQL tracing reveals that the ProductPricing
> > entities are being queried with  CURRENCY_UOM_ID=USD
> > and hence the USD pricing is being picked up. I am not sure
> > why USD currency is being picked. I have changed in almost
> > all places including properties file.
> >
> > -- ./framework/common/config/general.properties
> >
> > # -- unique instance id (20 char max)
> > unique.instanceId=ofbiz1
> > # -- the default currency to use for prices, etc
> > currency.uom.id.default=INR
> > # These values override the _NA_ DEFAULT values in user preferences for
> > the GLOBAL_PREFERENCES userPrefGroupTypeId
> > # -- the default organizationPartyId for used in dropdowns and reports
> >
> >
> > 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO
> > |T| Ran query in 1 milli-seconds:  EntityName: ProductPrice
> > Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID,
> >  CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE,
> > TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX,
> PRICE_WITH_TAX,
> > TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID,
> TAX_IN_PRICE,
> >  CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
> > LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE WHERE
> > ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR
> PRODUCT_PRICE_PURPOSE_ID IS NULL)
> >  AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?))
> > ORDER BY FROM_DATE DESC
> >
> >  where clause:[PRODUCT_ID=1, PRODUCT_PRICE_PURPOSE_ID=PURCHASE,
> > CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_]
> >
> > Full Log:
> > https://pastebin.com/raw/smdQX84B
> >
> >
> > Looking forward to further comments and
> >  guidance.
> >
> > ​regds
> > mallah.
> >
>

Re: setting up TAX in ofbiz

[Rajesh Mallah]

Hi Arun ,

I checked PartyAcctgPreference which was USD and changed it to INR
yesterday only. After changes i do logout and login and restart the tomcat
to ensure there are no caching issues.


ofbiz_redgrape=>  SELECT PTYACCPREF.PARTY_ID,
PTYACCPREF.BASE_CURRENCY_UOM_ID, PTYGROUP.GROUP_NAME, PTYROLE.ROLE_TYPE_ID
FROM (ofbiz.PARTY_ACCTG_PREFERENCE PTYACCPREF INNER JOIN ofbiz.PARTY_GROUP
PTYGROUP ON PTYACCPREF.PARTY_ID = PTYGROUP.PARTY_ID) INNER JOIN
ofbiz.PARTY_ROLE PTYROLE ON PTYACCPREF.PARTY_ID = PTYROLE.PARTY_ID WHERE
(((PTYROLE.ROLE_TYPE_ID = 'INTERNAL_ORGANIZATIO')));

-[ RECORD 1 ]+--
party_id | Company
base_currency_uom_id | INR
group_name   | REDGRAPE TECHNOLOGIES PRIVATE LTD
role_type_id | INTERNAL_ORGANIZATIO



The relevant field ProductStore is also INR

https://pastebin.com/raw/mM2j6kiE

..

requirement_method_enum_id|
order_number_prefix   |
default_locale_string | en_US
default_currency_uom_id   | INR
default_time_zone_string  | Asia/Kolkata
default_sales_channel_enum_id |
allow_password| Y

.

regds
mallah.


On Thu, Aug 31, 2017 at 11:05 AM, Arun Patidar <
arun.pati...@hotwaxsystems.com> wrote:

> Hello Rajesh,
>
> ProductStore and PartyAcctgPreference entities also have fields to store
> currency UOM.
>
> --
> Thanks & Regards
> ---
> Arun Patidar
> Manager, Enterprise Software Development
>
> HotWax Systems Pvt Ltd.
>
> www.hotwaxsystems.com
>
>
> On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah 
> wrote:
>
> > looks like too many messages has already been
> > exchanged in past  at various point in time.
> >
> > http://ofbiz.markmail.org/search/?q=changing+default+
> > currency#query:changing%20default%20currency
> >
> > it will be beneficial to new users  if it is given attention .
> >
> > regds
> > mallah.
> >
> >
> > On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah 
> > wrote:
> >
> > >
> > >
> > >
> > > @Deepak , @Rishi  / List ,
> > >
> > > Additional SQL tracing reveals that the ProductPricing
> > > entities are being queried with  CURRENCY_UOM_ID=USD
> > > and hence the USD pricing is being picked up. I am not sure
> > > why USD currency is being picked. I have changed in almost
> > > all places including properties file.
> > >
> > > -- ./framework/common/config/general.properties
> > >
> > > # -- unique instance id (20 char max)
> > > unique.instanceId=ofbiz1
> > > # -- the default currency to use for prices, etc
> > > currency.uom.id.default=INR
> > > # These values override the _NA_ DEFAULT values in user preferences for
> > > the GLOBAL_PREFERENCES userPrefGroupTypeId
> > > # -- the default organizationPartyId for used in dropdowns and reports
> > >
> > >
> > > 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO
> > > |T| Ran query in 1 milli-seconds:  EntityName: ProductPrice
> > > Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID,
> PRODUCT_PRICE_PURPOSE_ID,
> > >  CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE,
> > > TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX,
> > PRICE_WITH_TAX,
> > > TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID,
> > TAX_IN_PRICE,
> > >  CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
> > > LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> > > CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE WHERE
> > > ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR
> > PRODUCT_PRICE_PURPOSE_ID IS NULL)
> > >  AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?))
> > > ORDER BY FROM_DATE DESC
> > >
> > >  where clause:[PRODUCT_ID=1, PRODUCT_PRICE_PURPOSE_ID=PURCHASE,
> > > CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_]
> > >
> > > Full Log:
> > > https://pastebin.com/raw/smdQX84B
> > >
> > >
> > > Looking forward to further comments and
> > >  guidance.
> > >
> > > ​regds
> > > mallah.
> > >
> >
>

Re: setting up TAX in ofbiz

[Rajesh Mallah]

I wonder why a query on a table should be run looking for
rows where the primary key of table is null.

the sole filter on the below query on ProductStore  is:
WHERE ((PRODUCT_STORE_ID IS NULL))

Note: this query is just run *before* looking in the ProductPrice
table.

more context here: https://pastebin.com/raw/sSh1sNWb

BTW: what is the way of altering logging config in OfBiz
   to include Filenames and Line number?

regds
mallah.




2017-08-31 10:45:18,180 |http-nio-8080-exec-5
|GenericDAO|T| Ran query in 3 milli-seconds:
EntityName: ProductStore Sql: SELECT PRODUCT_STORE_ID,
PRIMARY_STORE_GROUP_ID, STORE_NAME, COMPANY_NAME, TITLE, SUBTITLE,
PAY_TO_PARTY_ID, DAYS_TO_CANCEL_NON_PAY, MANUAL_AUTH_IS_CAPTURE,
PRORATE_SHIPPING, PRORATE_TAXES, VIEW_CART_ON_ADD, AUTO_SAVE_CART,
AUTO_APPROVE_REVIEWS, IS_DEMO_STORE, IS_IMMEDIATELY_FULFILLED,
INVENTORY_FACILITY_ID, ONE_INVENTORY_FACILITY, CHECK_INVENTORY,
RESERVE_INVENTORY, RESERVE_ORDER_ENUM_ID, REQUIRE_INVENTORY,
BALANCE_RES_ON_ORDER_CREATION, REQUIREMENT_METHOD_ENUM_ID,
ORDER_NUMBER_PREFIX, DEFAULT_LOCALE_STRING, DEFAULT_CURRENCY_UOM_ID,
DEFAULT_TIME_ZONE_STRING, DEFAULT_SALES_CHANNEL_ENUM_ID, ALLOW_PASSWORD,
DEFAULT_PASSWORD, EXPLODE_ORDER_ITEMS, CHECK_GC_BALANCE,
RETRY_FAILED_AUTHS, HEADER_APPROVED_STATUS, ITEM_APPROVED_STATUS,
DIGITAL_ITEM_APPROVED_STATUS, HEADER_DECLINED_STATUS, ITEM_DECLINED_STATUS,
HEADER_CANCEL_STATUS, ITEM_CANCEL_STATUS, AUTH_DECLINED_MESSAGE,
AUTH_FRAUD_MESSAGE, AUTH_ERROR_MESSAGE, VISUAL_THEME_ID,
STORE_CREDIT_ACCOUNT_ENUM_ID, USE_PRIMARY_EMAIL_USERNAME,
REQUIRE_CUSTOMER_ROLE, AUTO_INVOICE_DIGITAL_ITEMS,
REQ_SHIP_ADDR_FOR_DIG_ITEMS, SHOW_CHECKOUT_GIFT_OPTIONS,
SELECT_PAYMENT_TYPE_PER_ITEM, SHOW_PRICES_WITH_VAT_TAX, SHOW_TAX_IS_EXEMPT,
VAT_TAX_AUTH_GEO_ID, VAT_TAX_AUTH_PARTY_ID, ENABLE_AUTO_SUGGESTION_LIST,
ENABLE_DIG_PROD_UPLOAD, PROD_SEARCH_EXCLUDE_VARIANTS,
DIG_PROD_UPLOAD_CATEGORY_ID, AUTO_ORDER_CC_TRY_EXP,
AUTO_ORDER_CC_TRY_OTHER_CARDS, AUTO_ORDER_CC_TRY_LATER_NSF,
AUTO_ORDER_CC_TRY_LATER_MAX, STORE_CREDIT_VALID_DAYS, AUTO_APPROVE_INVOICE,
AUTO_APPROVE_ORDER, SHIP_IF_CAPTURE_FAILS, SET_OWNER_UPON_ISSUANCE,
REQ_RETURN_INVENTORY_RECEIVE, ADD_TO_CART_REMOVE_INCOMPAT,
ADD_TO_CART_REPLACE_UPSELL, SPLIT_PAY_PREF_PER_SHP_GRP, MANAGED_BY_LOT,
SHOW_OUT_OF_STOCK_PRODUCTS, ORDER_DECIMAL_QUANTITY, ALLOW_COMMENT,
STYLE_SHEET, HEADER_LOGO, HEADER_MIDDLE_BACKGROUND,
HEADER_RIGHT_BACKGROUND, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_STORE WHERE
((PRODUCT_STORE_ID IS NULL)) where clause:[]



On Thu, Aug 31, 2017 at 11:23 AM, Rajesh Mallah 
wrote:

> Hi Arun ,
>
> I checked PartyAcctgPreference which was USD and changed it to INR
> yesterday only. After changes i do logout and login and restart the tomcat
> to ensure there are no caching issues.
>
>
> ofbiz_redgrape=>  SELECT PTYACCPREF.PARTY_ID, PTYACCPREF.BASE_CURRENCY_UOM_ID,
> PTYGROUP.GROUP_NAME, PTYROLE.ROLE_TYPE_ID FROM
> (ofbiz.PARTY_ACCTG_PREFERENCE PTYACCPREF INNER JOIN ofbiz.PARTY_GROUP
> PTYGROUP ON PTYACCPREF.PARTY_ID = PTYGROUP.PARTY_ID) INNER JOIN
> ofbiz.PARTY_ROLE PTYROLE ON PTYACCPREF.PARTY_ID = PTYROLE.PARTY_ID WHERE
> (((PTYROLE.ROLE_TYPE_ID = 'INTERNAL_ORGANIZATIO')));
>
> -[ RECORD 1 ]+--
> party_id | Company
> base_currency_uom_id | INR
> group_name   | REDGRAPE TECHNOLOGIES PRIVATE LTD
> role_type_id | INTERNAL_ORGANIZATIO
>
>
>
> The relevant field ProductStore is also INR
>
> https://pastebin.com/raw/mM2j6kiE
>
> ..
>
> requirement_method_enum_id|
> order_number_prefix   |
> default_locale_string | en_US
> default_currency_uom_id   | INR
> default_time_zone_string  | Asia/Kolkata
> default_sales_channel_enum_id |
> allow_password| Y
>
> .
>
> regds
> mallah.
>
>
> On Thu, Aug 31, 2017 at 11:05 AM, Arun Patidar <
> arun.pati...@hotwaxsystems.com> wrote:
>
>> Hello Rajesh,
>>
>> ProductStore and PartyAcctgPreference entities also have fields to store
>> currency UOM.
>>
>> --
>> Thanks & Regards
>> ---
>> Arun Patidar
>> Manager, Enterprise Software Development
>>
>> HotWax Systems Pvt Ltd.
>>
>> www.hotwaxsystems.com
>>
>>
>> On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah 
>> wrote:
>>
>> > looks like too many messages has already been
>> > exchanged in past  at various point in time.
>> >
>> > http://ofbiz.markmail.org/search/?q=changing+default+
>> > currency#query:changing%20default%20currency
>> >
>> > it will be beneficial to new users  if it is given attention .
>> >
>> > regds
>> > mallah.
>> >
>> >
>> > On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah > >
>> > wrote:
>> >
>> > >
>> > >
>> > >
>> > > @Deepak , @Rishi  / List ,
>> > >
>> > > Additional SQL tracing reveals that the ProductPricing
>> > > entities are being queried with  CURRENCY_UOM_ID=USD
>> > > and hence the USD pricing is being picked up. I am not sure
>> > > why USD currency is being picked. I have