Implementing GST tax in Ofbiz - CGST , SGST , IGST

[Rajesh Mallah]

Hi ,

I need help regarding how to apply taxes   broadly based on the
fact whether the supplier and consumer are in same state or not.

We are able to apply taxes based on GEO ID of the customer but
what is really required is the below:

If Supplier.state == Customer.state
      add adjustment SGST @  X%
      add adjustment CGST @  X%
else
      add adjustment IGST  @  X+X%


where:
CGST --> Central Goods & Services Tax
SGST --> State Goods & Services Tax
IGST  --> Integrated Goods & Services Tax


Any help on this regard is solicited.


regds
mallah.

[Rajesh Mallah]

We find that most of logic of Tax is in:

applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
can/should we modify it as per our need or there is a better/easier way?

As GST requirement is very common(universal) now in India , i am curious
how people have implemented
here using OfBiz.

regds
mallah.






On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
wrote:

>
> Hi ,
>
> I need help regarding how to apply taxes   broadly based on the
> fact whether the supplier and consumer are in same state or not.
>
> We are able to apply taxes based on GEO ID of the customer but
> what is really required is the below:
>
> If Supplier.state == Customer.state
>       add adjustment SGST @  X%
>       add adjustment CGST @  X%
> else
>       add adjustment IGST  @  X+X%
>
>
> where:
> CGST --> Central Goods & Services Tax
> SGST --> State Goods & Services Tax
> IGST  --> Integrated Goods & Services Tax
>
>
> Any help on this regard is solicited.
>
>
> regds
> mallah.
>

[Deepak Dixit-3]

Hi Rajesh,

To calculate GST you need to write custom calc tax service, that honor the
shipFrom address as well.
GST is common but how to calculate GST is different, As per Indian context
GST is calculated based on shipFrom and ShipTo address.

You need some changes in calcTax service and getTaxAuthorities methods that
return the taxAuthority.OFBiz has capability to setup different
taxAuthParties. So with proper data setup along with some changes you can
setup GST tax calculation properly.


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

On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <[hidden email]>
wrote:

> We find that most of logic of Tax is in:
>
> applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/
> TaxAuthorityServices.java
> can/should we modify it as per our need or there is a better/easier way?
>
> As GST requirement is very common(universal) now in India , i am curious
> how people have implemented
> here using OfBiz.
>
> regds
> mallah.
>
>
>
>
>
>
> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
> >
> > Hi ,
> >
> > I need help regarding how to apply taxes   broadly based on the
> > fact whether the supplier and consumer are in same state or not.
> >
> > We are able to apply taxes based on GEO ID of the customer but
> > what is really required is the below:
> >
> > If Supplier.state == Customer.state
> >       add adjustment SGST @  X%
> >       add adjustment CGST @  X%
> > else
> >       add adjustment IGST  @  X+X%
> >
> >
> > where:
> > CGST --> Central Goods & Services Tax
> > SGST --> State Goods & Services Tax
> > IGST  --> Integrated Goods & Services Tax
> >
> >
> > Any help on this regard is solicited.
> >
> >
> > regds
> > mallah.
> >
>

[Deepak Dixit-3]

For drop ship order you can setup supplier address with purpose
SHIP_ORIG_LOCATION and shipping from facility you can use facility address
as fromAddress to calculate GST.

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

On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
[hidden email]> wrote:

> Hi Rajesh,
>
> To calculate GST you need to write custom calc tax service, that honor the
> shipFrom address as well.
> GST is common but how to calculate GST is different, As per Indian context
> GST is calculated based on shipFrom and ShipTo address.
>
> You need some changes in calcTax service and getTaxAuthorities methods
> that return the taxAuthority.OFBiz has capability to setup different
> taxAuthParties. So with proper data setup along with some changes you can
> setup GST tax calculation properly.
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
>> We find that most of logic of Tax is in:
>>
>> applications/accounting/src/main/java/org/apache/ofbiz/accou
>> nting/tax/TaxAuthorityServices.java
>> can/should we modify it as per our need or there is a better/easier way?
>>
>> As GST requirement is very common(universal) now in India , i am curious
>> how people have implemented
>> here using OfBiz.
>>
>> regds
>> mallah.
>>
>>
>>
>>
>>
>>
>> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
>> wrote:
>>
>> >
>> > Hi ,
>> >
>> > I need help regarding how to apply taxes   broadly based on the
>> > fact whether the supplier and consumer are in same state or not.
>> >
>> > We are able to apply taxes based on GEO ID of the customer but
>> > what is really required is the below:
>> >
>> > If Supplier.state == Customer.state
>> >       add adjustment SGST @  X%
>> >       add adjustment CGST @  X%
>> > else
>> >       add adjustment IGST  @  X+X%
>> >
>> >
>> > where:
>> > CGST --> Central Goods & Services Tax
>> > SGST --> State Goods & Services Tax
>> > IGST  --> Integrated Goods & Services Tax
>> >
>> >
>> > Any help on this regard is solicited.
>> >
>> >
>> > regds
>> > mallah.
>> >
>>
>
>

[Rajesh Mallah]

Thanks Deepak , Appreciate your response.

I had a glance over

applications/accounting/servicedef/services_tax.xml  &
applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
looks encouraging!

how should the change be managed to survive ofbiz upgrades?

are we expected  to change TaxAuthorityServices.java ?


regds
mallah.


On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
[hidden email]> wrote:

> Hi Rajesh,
>
> To calculate GST you need to write custom calc tax service, that honor the
> shipFrom address as well.
> GST is common but how to calculate GST is different, As per Indian context
> GST is calculated based on shipFrom and ShipTo address.
>
> You need some changes in calcTax service and getTaxAuthorities methods that
> return the taxAuthority.OFBiz has capability to setup different
> taxAuthParties. So with proper data setup along with some changes you can
> setup GST tax calculation properly.
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
> > We find that most of logic of Tax is in:
> >
> > applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/
> > TaxAuthorityServices.java
> > can/should we modify it as per our need or there is a better/easier way?
> >
> > As GST requirement is very common(universal) now in India , i am curious
> > how people have implemented
> > here using OfBiz.
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
> > wrote:
> >
> > >
> > > Hi ,
> > >
> > > I need help regarding how to apply taxes   broadly based on the
> > > fact whether the supplier and consumer are in same state or not.
> > >
> > > We are able to apply taxes based on GEO ID of the customer but
> > > what is really required is the below:
> > >
> > > If Supplier.state == Customer.state
> > >       add adjustment SGST @  X%
> > >       add adjustment CGST @  X%
> > > else
> > >       add adjustment IGST  @  X+X%
> > >
> > >
> > > where:
> > > CGST --> Central Goods & Services Tax
> > > SGST --> State Goods & Services Tax
> > > IGST  --> Integrated Goods & Services Tax
> > >
> > >
> > > Any help on this regard is solicited.
> > >
> > >
> > > regds
> > > mallah.
> > >
> >
>

[Deepak Dixit-3]

Hi Rajesh,

There are two way,

1. You can do changes in applications/accounting/src/
main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java and
create patch and maintain it in your custom component.
2. You can override service calTax and/or related services/method in your
custom component.




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

On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <[hidden email]>
wrote:

> Thanks Deepak , Appreciate your response.
>
> I had a glance over
>
> applications/accounting/servicedef/services_tax.xml  &
> applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/
> TaxAuthorityServices.java
> looks encouraging!
>
> how should the change be managed to survive ofbiz upgrades?
>
> are we expected  to change TaxAuthorityServices.java ?
>
>
> regds
> mallah.
>
>
> On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
> [hidden email]> wrote:
>
> > Hi Rajesh,
> >
> > To calculate GST you need to write custom calc tax service, that honor
> the
> > shipFrom address as well.
> > GST is common but how to calculate GST is different, As per Indian
> context
> > GST is calculated based on shipFrom and ShipTo address.
> >
> > You need some changes in calcTax service and getTaxAuthorities methods
> that
> > return the taxAuthority.OFBiz has capability to setup different
> > taxAuthParties. So with proper data setup along with some changes you can
> > setup GST tax calculation properly.
> >
> >
> > Thanks & Regards
> > --
> > Deepak Dixit
> > www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <[hidden email]>
> > wrote:
> >
> > > We find that most of logic of Tax is in:
> > >
> > > applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/
> > > TaxAuthorityServices.java
> > > can/should we modify it as per our need or there is a better/easier
> way?
> > >
> > > As GST requirement is very common(universal) now in India , i am
> curious
> > > how people have implemented
> > > here using OfBiz.
> > >
> > > regds
> > > mallah.
> > >
> > >
> > >
> > >
> > >
> > >
> > > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]
> >
> > > wrote:
> > >
> > > >
> > > > Hi ,
> > > >
> > > > I need help regarding how to apply taxes   broadly based on the
> > > > fact whether the supplier and consumer are in same state or not.
> > > >
> > > > We are able to apply taxes based on GEO ID of the customer but
> > > > what is really required is the below:
> > > >
> > > > If Supplier.state == Customer.state
> > > >       add adjustment SGST @  X%
> > > >       add adjustment CGST @  X%
> > > > else
> > > >       add adjustment IGST  @  X+X%
> > > >
> > > >
> > > > where:
> > > > CGST --> Central Goods & Services Tax
> > > > SGST --> State Goods & Services Tax
> > > > IGST  --> Integrated Goods & Services Tax
> > > >
> > > >
> > > > Any help on this regard is solicited.
> > > >
> > > >
> > > > regds
> > > > mallah.
> > > >
> > >
> >
>

[Rajesh Mallah]

Thanks it helps. Shall give it a shot.

regds
mallah.

On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
[hidden email]> wrote:

> Hi Rajesh,
>
> There are two way,
>
> 1. You can do changes in applications/accounting/src/
> main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java and
> create patch and maintain it in your custom component.
> 2. You can override service calTax and/or related services/method in your
> custom component.
>
>
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
> > Thanks Deepak , Appreciate your response.
> >
> > I had a glance over
> >
> > applications/accounting/servicedef/services_tax.xml  &
> > applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/
> > TaxAuthorityServices.java
> > looks encouraging!
> >
> > how should the change be managed to survive ofbiz upgrades?
> >
> > are we expected  to change TaxAuthorityServices.java ?
> >
> >
> > regds
> > mallah.
> >
> >
> > On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
> > [hidden email]> wrote:
> >
> > > Hi Rajesh,
> > >
> > > To calculate GST you need to write custom calc tax service, that honor
> > the
> > > shipFrom address as well.
> > > GST is common but how to calculate GST is different, As per Indian
> > context
> > > GST is calculated based on shipFrom and ShipTo address.
> > >
> > > You need some changes in calcTax service and getTaxAuthorities methods
> > that
> > > return the taxAuthority.OFBiz has capability to setup different
> > > taxAuthParties. So with proper data setup along with some changes you
> can
> > > setup GST tax calculation properly.
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Dixit
> > > www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <[hidden email]
> >
> > > wrote:
> > >
> > > > We find that most of logic of Tax is in:
> > > >
> > > > applications/accounting/src/main/java/org/apache/ofbiz/
> accounting/tax/
> > > > TaxAuthorityServices.java
> > > > can/should we modify it as per our need or there is a better/easier
> > way?
> > > >
> > > > As GST requirement is very common(universal) now in India , i am
> > curious
> > > > how people have implemented
> > > > here using OfBiz.
> > > >
> > > > regds
> > > > mallah.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
> [hidden email]
> > >
> > > > wrote:
> > > >
> > > > >
> > > > > Hi ,
> > > > >
> > > > > I need help regarding how to apply taxes   broadly based on the
> > > > > fact whether the supplier and consumer are in same state or not.
> > > > >
> > > > > We are able to apply taxes based on GEO ID of the customer but
> > > > > what is really required is the below:
> > > > >
> > > > > If Supplier.state == Customer.state
> > > > >       add adjustment SGST @  X%
> > > > >       add adjustment CGST @  X%
> > > > > else
> > > > >       add adjustment IGST  @  X+X%
> > > > >
> > > > >
> > > > > where:
> > > > > CGST --> Central Goods & Services Tax
> > > > > SGST --> State Goods & Services Tax
> > > > > IGST  --> Integrated Goods & Services Tax
> > > > >
> > > > >
> > > > > Any help on this regard is solicited.
> > > > >
> > > > >
> > > > > regds
> > > > > mallah.
> > > > >
> > > >
> > >
> >
>

[Deepak Dixit-3]

Sure ,

Please let us know if you face any issue. :)

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

On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <[hidden email]>
wrote:

> Thanks it helps. Shall give it a shot.
>
> regds
> mallah.
>
> On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
> [hidden email]> wrote:
>
> > Hi Rajesh,
> >
> > There are two way,
> >
> > 1. You can do changes in applications/accounting/src/
> > main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java and
> > create patch and maintain it in your custom component.
> > 2. You can override service calTax and/or related services/method in your
> > custom component.
> >
> >
> >
> >
> > Thanks & Regards
> > --
> > Deepak Dixit
> > www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <[hidden email]>
> > wrote:
> >
> > > Thanks Deepak , Appreciate your response.
> > >
> > > I had a glance over
> > >
> > > applications/accounting/servicedef/services_tax.xml  &
> > > applications/accounting/src/main/java/org/apache/ofbiz/accounting/tax/
> > > TaxAuthorityServices.java
> > > looks encouraging!
> > >
> > > how should the change be managed to survive ofbiz upgrades?
> > >
> > > are we expected  to change TaxAuthorityServices.java ?
> > >
> > >
> > > regds
> > > mallah.
> > >
> > >
> > > On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
> > > [hidden email]> wrote:
> > >
> > > > Hi Rajesh,
> > > >
> > > > To calculate GST you need to write custom calc tax service, that
> honor
> > > the
> > > > shipFrom address as well.
> > > > GST is common but how to calculate GST is different, As per Indian
> > > context
> > > > GST is calculated based on shipFrom and ShipTo address.
> > > >
> > > > You need some changes in calcTax service and getTaxAuthorities
> methods
> > > that
> > > > return the taxAuthority.OFBiz has capability to setup different
> > > > taxAuthParties. So with proper data setup along with some changes you
> > can
> > > > setup GST tax calculation properly.
> > > >
> > > >
> > > > Thanks & Regards
> > > > --
> > > > Deepak Dixit
> > > > www.hotwaxsystems.com
> > > > www.hotwax.co
> > > >
> > > > On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
> [hidden email]
> > >
> > > > wrote:
> > > >
> > > > > We find that most of logic of Tax is in:
> > > > >
> > > > > applications/accounting/src/main/java/org/apache/ofbiz/
> > accounting/tax/
> > > > > TaxAuthorityServices.java
> > > > > can/should we modify it as per our need or there is a better/easier
> > > way?
> > > > >
> > > > > As GST requirement is very common(universal) now in India , i am
> > > curious
> > > > > how people have implemented
> > > > > here using OfBiz.
> > > > >
> > > > > regds
> > > > > mallah.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
> > [hidden email]
> > > >
> > > > > wrote:
> > > > >
> > > > > >
> > > > > > Hi ,
> > > > > >
> > > > > > I need help regarding how to apply taxes   broadly based on the
> > > > > > fact whether the supplier and consumer are in same state or not.
> > > > > >
> > > > > > We are able to apply taxes based on GEO ID of the customer but
> > > > > > what is really required is the below:
> > > > > >
> > > > > > If Supplier.state == Customer.state
> > > > > >       add adjustment SGST @  X%
> > > > > >       add adjustment CGST @  X%
> > > > > > else
> > > > > >       add adjustment IGST  @  X+X%
> > > > > >
> > > > > >
> > > > > > where:
> > > > > > CGST --> Central Goods & Services Tax
> > > > > > SGST --> State Goods & Services Tax
> > > > > > IGST  --> Integrated Goods & Services Tax
> > > > > >
> > > > > >
> > > > > > Any help on this regard is solicited.
> > > > > >
> > > > > >
> > > > > > regds
> > > > > > mallah.
> > > > > >
> > > > >
> > > >
> > >
> >
>

[Rajesh Mallah]

Hello Deepak / Everyone ,

We have been able to achieve the selective application of taxes by
modifying the service calcTax ( java function: rateProductTaxCalc )
it works as expected.

The logic works by removing those taxes which are not applicable as per
the situation (ie based on Shipping addresses)

However we would want the implement it in a more generic manner,
rite now the code checks specific PartyIDs associated with the TaxAuthority,
is there any way to indicate that this specific handling of taxes should be
limited to certain kind of taxauthorities ?

Is there way of setting some meta-data on TaxAuthority or some kind of
classification.

regds
mallah.








On Tue, Oct 10, 2017 at 12:34 AM, Deepak Dixit <
[hidden email]> wrote:

> Sure ,
>
> Please let us know if you face any issue. :)
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <[hidden email]>
> wrote:
>
> > Thanks it helps. Shall give it a shot.
> >
> > regds
> > mallah.
> >
> > On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
> > [hidden email]> wrote:
> >
> > > Hi Rajesh,
> > >
> > > There are two way,
> > >
> > > 1. You can do changes in applications/accounting/src/
> > > main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
> and
> > > create patch and maintain it in your custom component.
> > > 2. You can override service calTax and/or related services/method in
> your
> > > custom component.
> > >
> > >
> > >
> > >
> > > Thanks & Regards
> > > --
> > > Deepak Dixit
> > > www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <
> [hidden email]>
> > > wrote:
> > >
> > > > Thanks Deepak , Appreciate your response.
> > > >
> > > > I had a glance over
> > > >
> > > > applications/accounting/servicedef/services_tax.xml  &
> > > > applications/accounting/src/main/java/org/apache/ofbiz/
> accounting/tax/
> > > > TaxAuthorityServices.java
> > > > looks encouraging!
> > > >
> > > > how should the change be managed to survive ofbiz upgrades?
> > > >
> > > > are we expected  to change TaxAuthorityServices.java ?
> > > >
> > > >
> > > > regds
> > > > mallah.
> > > >
> > > >
> > > > On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
> > > > [hidden email]> wrote:
> > > >
> > > > > Hi Rajesh,
> > > > >
> > > > > To calculate GST you need to write custom calc tax service, that
> > honor
> > > > the
> > > > > shipFrom address as well.
> > > > > GST is common but how to calculate GST is different, As per Indian
> > > > context
> > > > > GST is calculated based on shipFrom and ShipTo address.
> > > > >
> > > > > You need some changes in calcTax service and getTaxAuthorities
> > methods
> > > > that
> > > > > return the taxAuthority.OFBiz has capability to setup different
> > > > > taxAuthParties. So with proper data setup along with some changes
> you
> > > can
> > > > > setup GST tax calculation properly.
> > > > >
> > > > >
> > > > > Thanks & Regards
> > > > > --
> > > > > Deepak Dixit
> > > > > www.hotwaxsystems.com
> > > > > www.hotwax.co
> > > > >
> > > > > On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
> > [hidden email]
> > > >
> > > > > wrote:
> > > > >
> > > > > > We find that most of logic of Tax is in:
> > > > > >
> > > > > > applications/accounting/src/main/java/org/apache/ofbiz/
> > > accounting/tax/
> > > > > > TaxAuthorityServices.java
> > > > > > can/should we modify it as per our need or there is a
> better/easier
> > > > way?
> > > > > >
> > > > > > As GST requirement is very common(universal) now in India , i am
> > > > curious
> > > > > > how people have implemented
> > > > > > here using OfBiz.
> > > > > >
> > > > > > regds
> > > > > > mallah.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
> > > [hidden email]
> > > > >
> > > > > > wrote:
> > > > > >
> > > > > > >
> > > > > > > Hi ,
> > > > > > >
> > > > > > > I need help regarding how to apply taxes   broadly based on the
> > > > > > > fact whether the supplier and consumer are in same state or
> not.
> > > > > > >
> > > > > > > We are able to apply taxes based on GEO ID of the customer but
> > > > > > > what is really required is the below:
> > > > > > >
> > > > > > > If Supplier.state == Customer.state
> > > > > > >       add adjustment SGST @  X%
> > > > > > >       add adjustment CGST @  X%
> > > > > > > else
> > > > > > >       add adjustment IGST  @  X+X%
> > > > > > >
> > > > > > >
> > > > > > > where:
> > > > > > > CGST --> Central Goods & Services Tax
> > > > > > > SGST --> State Goods & Services Tax
> > > > > > > IGST  --> Integrated Goods & Services Tax
> > > > > > >
> > > > > > >
> > > > > > > Any help on this regard is solicited.
> > > > > > >
> > > > > > >
> > > > > > > regds
> > > > > > > mallah.
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

[Jacques Le Roux]

Hi Rajesh,

What you need does not exist. If it could be generalised and used all over the world that would be perfect.

This need to be discussed in dev ML in order for everybody to agree (or at least get a consensus) and so avoid wasting time

Then we can create a Jira and if possible attach a patch

Thanks

Jacques


Le 11/10/2017 à 13:15, Rajesh Mallah a écrit :

> Hello Deepak / Everyone ,
>
> We have been able to achieve the selective application of taxes by
> modifying the service calcTax ( java function: rateProductTaxCalc )
> it works as expected.
>
> The logic works by removing those taxes which are not applicable as per
> the situation (ie based on Shipping addresses)
>
> However we would want the implement it in a more generic manner,
> rite now the code checks specific PartyIDs associated with the TaxAuthority,
> is there any way to indicate that this specific handling of taxes should be
> limited to certain kind of taxauthorities ?
>
> Is there way of setting some meta-data on TaxAuthority or some kind of
> classification.
>
> regds
> mallah.
>
>
>
>
>
>
>
>
> On Tue, Oct 10, 2017 at 12:34 AM, Deepak Dixit <
> [hidden email]> wrote:
>
>> Sure ,
>>
>> Please let us know if you face any issue. :)
>>
>> Thanks & Regards
>> --
>> Deepak Dixit
>> www.hotwaxsystems.com
>> www.hotwax.co
>>
>> On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <[hidden email]>
>> wrote:
>>
>>> Thanks it helps. Shall give it a shot.
>>>
>>> regds
>>> mallah.
>>>
>>> On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
>>> [hidden email]> wrote:
>>>
>>>> Hi Rajesh,
>>>>
>>>> There are two way,
>>>>
>>>> 1. You can do changes in applications/accounting/src/
>>>> main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
>> and
>>>> create patch and maintain it in your custom component.
>>>> 2. You can override service calTax and/or related services/method in
>> your
>>>> custom component.
>>>>
>>>>
>>>>
>>>>
>>>> Thanks & Regards
>>>> --
>>>> Deepak Dixit
>>>> www.hotwaxsystems.com
>>>> www.hotwax.co
>>>>
>>>> On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <
>> [hidden email]>
>>>> wrote:
>>>>
>>>>> Thanks Deepak , Appreciate your response.
>>>>>
>>>>> I had a glance over
>>>>>
>>>>> applications/accounting/servicedef/services_tax.xml  &
>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>> accounting/tax/
>>>>> TaxAuthorityServices.java
>>>>> looks encouraging!
>>>>>
>>>>> how should the change be managed to survive ofbiz upgrades?
>>>>>
>>>>> are we expected  to change TaxAuthorityServices.java ?
>>>>>
>>>>>
>>>>> regds
>>>>> mallah.
>>>>>
>>>>>
>>>>> On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
>>>>> [hidden email]> wrote:
>>>>>
>>>>>> Hi Rajesh,
>>>>>>
>>>>>> To calculate GST you need to write custom calc tax service, that
>>> honor
>>>>> the
>>>>>> shipFrom address as well.
>>>>>> GST is common but how to calculate GST is different, As per Indian
>>>>> context
>>>>>> GST is calculated based on shipFrom and ShipTo address.
>>>>>>
>>>>>> You need some changes in calcTax service and getTaxAuthorities
>>> methods
>>>>> that
>>>>>> return the taxAuthority.OFBiz has capability to setup different
>>>>>> taxAuthParties. So with proper data setup along with some changes
>> you
>>>> can
>>>>>> setup GST tax calculation properly.
>>>>>>
>>>>>>
>>>>>> Thanks & Regards
>>>>>> --
>>>>>> Deepak Dixit
>>>>>> www.hotwaxsystems.com
>>>>>> www.hotwax.co
>>>>>>
>>>>>> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
>>> [hidden email]
>>>>>> wrote:
>>>>>>
>>>>>>> We find that most of logic of Tax is in:
>>>>>>>
>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>> accounting/tax/
>>>>>>> TaxAuthorityServices.java
>>>>>>> can/should we modify it as per our need or there is a
>> better/easier
>>>>> way?
>>>>>>> As GST requirement is very common(universal) now in India , i am
>>>>> curious
>>>>>>> how people have implemented
>>>>>>> here using OfBiz.
>>>>>>>
>>>>>>> regds
>>>>>>> mallah.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
>>>> [hidden email]
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi ,
>>>>>>>>
>>>>>>>> I need help regarding how to apply taxes   broadly based on the
>>>>>>>> fact whether the supplier and consumer are in same state or
>> not.
>>>>>>>> We are able to apply taxes based on GEO ID of the customer but
>>>>>>>> what is really required is the below:
>>>>>>>>
>>>>>>>> If Supplier.state == Customer.state
>>>>>>>>        add adjustment SGST @  X%
>>>>>>>>        add adjustment CGST @  X%
>>>>>>>> else
>>>>>>>>        add adjustment IGST  @  X+X%
>>>>>>>>
>>>>>>>>
>>>>>>>> where:
>>>>>>>> CGST --> Central Goods & Services Tax
>>>>>>>> SGST --> State Goods & Services Tax
>>>>>>>> IGST  --> Integrated Goods & Services Tax
>>>>>>>>
>>>>>>>>
>>>>>>>> Any help on this regard is solicited.
>>>>>>>>
>>>>>>>>
>>>>>>>> regds
>>>>>>>> mallah.
>>>>>>>>

[Rajesh Mallah]

Hi Jacques ,

The patch is quite simple and we would readily contribute.
I am sure many Indian adopters would have already developed it
for their installations.

But without generalising it , it is difficult to  convert it to a  patch
for OOTB feature set.

At the same time GST is too important here(in India) and will possibly
stay.

Any  accounting system that does not handle GST here is *not* usable.
The recent GST rollout ( since 1st Apr 2017) has itself created a huge
(short-term) market of  migrations and accounting software upgrades.

I just hope this requirement gets its due attention and some way
is found  to either cleanly extend Ofbiz accounting to handle such
taxation methods OR make it possible for adopters to have user-defined
handling for a class/category of  TaxAuthorities.

I feel if we are simply able to categorize TaxAuthorities  in user
defined Categories the logic can be cleanly developed and applied.
Assuming that such a facility exists,  the work flow for enduser to
implement GST would be.


(1) Create a new TaxAuthorityCategory --> say "India GST"
(2) Place the TaxAuthority in the new category "India GST"
(2) In calcTax

if ( taxAuth.Category contains "India GST")   // assuming
TaxAuthorityCategory is 1-to-many relation.
{
// apply Custom logic for  GST
}

=========================

essentially we(end-user) shall be in a position to apply any custom logic
to a given
category of taxAuthority.  as Mr Deepak says ,

"GST is common but how to calculate GST is different"

I concur here and feel that generalizing it may be too difficult a task and
will not even find
too many matching candidates. instead if the framework provides a
categorization
(or equivalent ) people can write their custom logic (however complicated)
based on
their local rules.



regds
mallah.




On Wed, Oct 11, 2017 at 7:59 PM, Jacques Le Roux <
[hidden email]> wrote:

> Hi Rajesh,
>
> What you need does not exist. If it could be generalised and used all over
> the world that would be perfect.
>
> This need to be discussed in dev ML in order for everybody to agree (or at
> least get a consensus) and so avoid wasting time
>
> Then we can create a Jira and if possible attach a patch
>
> Thanks
>
> Jacques
>
>
>
> Le 11/10/2017 à 13:15, Rajesh Mallah a écrit :
>
>> Hello Deepak / Everyone ,
>>
>> We have been able to achieve the selective application of taxes by
>> modifying the service calcTax ( java function: rateProductTaxCalc )
>> it works as expected.
>>
>> The logic works by removing those taxes which are not applicable as per
>> the situation (ie based on Shipping addresses)
>>
>> However we would want the implement it in a more generic manner,
>> rite now the code checks specific PartyIDs associated with the
>> TaxAuthority,
>> is there any way to indicate that this specific handling of taxes should
>> be
>> limited to certain kind of taxauthorities ?
>>
>> Is there way of setting some meta-data on TaxAuthority or some kind of
>> classification.
>>
>> regds
>> mallah.
>>
>>
>>
>>
>>
>>
>>
>>
>> On Tue, Oct 10, 2017 at 12:34 AM, Deepak Dixit <
>> [hidden email]> wrote:
>>
>> Sure ,
>>>
>>> Please let us know if you face any issue. :)
>>>
>>> Thanks & Regards
>>> --
>>> Deepak Dixit
>>> www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <[hidden email]
>>> >
>>> wrote:
>>>
>>> Thanks it helps. Shall give it a shot.
>>>>
>>>> regds
>>>> mallah.
>>>>
>>>> On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
>>>> [hidden email]> wrote:
>>>>
>>>> Hi Rajesh,
>>>>>
>>>>> There are two way,
>>>>>
>>>>> 1. You can do changes in applications/accounting/src/
>>>>> main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
>>>>>
>>>> and
>>>
>>>> create patch and maintain it in your custom component.
>>>>> 2. You can override service calTax and/or related services/method in
>>>>>
>>>> your
>>>
>>>> custom component.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>> www.hotwax.co
>>>>>
>>>>> On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <
>>>>>
>>>> [hidden email]>
>>>
>>>> wrote:
>>>>>
>>>>> Thanks Deepak , Appreciate your response.
>>>>>>
>>>>>> I had a glance over
>>>>>>
>>>>>> applications/accounting/servicedef/services_tax.xml  &
>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>>>>
>>>>> accounting/tax/
>>>
>>>> TaxAuthorityServices.java
>>>>>> looks encouraging!
>>>>>>
>>>>>> how should the change be managed to survive ofbiz upgrades?
>>>>>>
>>>>>> are we expected  to change TaxAuthorityServices.java ?
>>>>>>
>>>>>>
>>>>>> regds
>>>>>> mallah.
>>>>>>
>>>>>>
>>>>>> On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
>>>>>> [hidden email]> wrote:
>>>>>>
>>>>>> Hi Rajesh,
>>>>>>>
>>>>>>> To calculate GST you need to write custom calc tax service, that
>>>>>>>
>>>>>> honor
>>>>
>>>>> the
>>>>>>
>>>>>>> shipFrom address as well.
>>>>>>> GST is common but how to calculate GST is different, As per Indian
>>>>>>>
>>>>>> context
>>>>>>
>>>>>>> GST is calculated based on shipFrom and ShipTo address.
>>>>>>>
>>>>>>> You need some changes in calcTax service and getTaxAuthorities
>>>>>>>
>>>>>> methods
>>>>
>>>>> that
>>>>>>
>>>>>>> return the taxAuthority.OFBiz has capability to setup different
>>>>>>> taxAuthParties. So with proper data setup along with some changes
>>>>>>>
>>>>>> you
>>>
>>>> can
>>>>>
>>>>>> setup GST tax calculation properly.
>>>>>>>
>>>>>>>
>>>>>>> Thanks & Regards
>>>>>>> --
>>>>>>> Deepak Dixit
>>>>>>> www.hotwaxsystems.com
>>>>>>> www.hotwax.co
>>>>>>>
>>>>>>> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
>>>>>>>
>>>>>> [hidden email]
>>>>
>>>>> wrote:
>>>>>>>
>>>>>>> We find that most of logic of Tax is in:
>>>>>>>>
>>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>>>>>>
>>>>>>> accounting/tax/
>>>>>
>>>>>> TaxAuthorityServices.java
>>>>>>>> can/should we modify it as per our need or there is a
>>>>>>>>
>>>>>>> better/easier
>>>
>>>> way?
>>>>>>
>>>>>>> As GST requirement is very common(universal) now in India , i am
>>>>>>>>
>>>>>>> curious
>>>>>>
>>>>>>> how people have implemented
>>>>>>>> here using OfBiz.
>>>>>>>>
>>>>>>>> regds
>>>>>>>> mallah.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
>>>>>>>>
>>>>>>> [hidden email]
>>>>>
>>>>>> wrote:
>>>>>>>>
>>>>>>>> Hi ,
>>>>>>>>>
>>>>>>>>> I need help regarding how to apply taxes   broadly based on the
>>>>>>>>> fact whether the supplier and consumer are in same state or
>>>>>>>>>
>>>>>>>> not.
>>>
>>>> We are able to apply taxes based on GEO ID of the customer but
>>>>>>>>> what is really required is the below:
>>>>>>>>>
>>>>>>>>> If Supplier.state == Customer.state
>>>>>>>>>        add adjustment SGST @  X%
>>>>>>>>>        add adjustment CGST @  X%
>>>>>>>>> else
>>>>>>>>>        add adjustment IGST  @  X+X%
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> where:
>>>>>>>>> CGST --> Central Goods & Services Tax
>>>>>>>>> SGST --> State Goods & Services Tax
>>>>>>>>> IGST  --> Integrated Goods & Services Tax
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Any help on this regard is solicited.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> regds
>>>>>>>>> mallah.
>>>>>>>>>
>>>>>>>>>
>

[Deepak Dixit-3]

I think we can make it configurable, we can get the tax calculation service
dynamically and it can be configured based on store, like
ProductStoreTaxSetting (or better name) this will contains tax calculation
service name for specific store if its not configured system will use
rateProductTaxCalc as default tax calculation.


It will allow us to use different tax calculation service as per business
need.

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

On Wed, Oct 11, 2017 at 11:26 PM, Rajesh Mallah <[hidden email]>
wrote:

> Hi Jacques ,
>
> The patch is quite simple and we would readily contribute.
> I am sure many Indian adopters would have already developed it
> for their installations.
>
> But without generalising it , it is difficult to  convert it to a  patch
> for OOTB feature set.
>
> At the same time GST is too important here(in India) and will possibly
> stay.
>
> Any  accounting system that does not handle GST here is *not* usable.
> The recent GST rollout ( since 1st Apr 2017) has itself created a huge
> (short-term) market of  migrations and accounting software upgrades.
>
> I just hope this requirement gets its due attention and some way
> is found  to either cleanly extend Ofbiz accounting to handle such
> taxation methods OR make it possible for adopters to have user-defined
> handling for a class/category of  TaxAuthorities.
>
> I feel if we are simply able to categorize TaxAuthorities  in user
> defined Categories the logic can be cleanly developed and applied.
> Assuming that such a facility exists,  the work flow for enduser to
> implement GST would be.
>
>
> (1) Create a new TaxAuthorityCategory --> say "India GST"
> (2) Place the TaxAuthority in the new category "India GST"
> (2) In calcTax
>
> if ( taxAuth.Category contains "India GST")   // assuming
> TaxAuthorityCategory is 1-to-many relation.
> {
> // apply Custom logic for  GST
> }
>
> =========================
>
> essentially we(end-user) shall be in a position to apply any custom logic
> to a given
> category of taxAuthority.  as Mr Deepak says ,
>
> "GST is common but how to calculate GST is different"
>
> I concur here and feel that generalizing it may be too difficult a task and
> will not even find
> too many matching candidates. instead if the framework provides a
> categorization
> (or equivalent ) people can write their custom logic (however complicated)
> based on
> their local rules.
>
>
>
> regds
> mallah.
>
>
>
>
> On Wed, Oct 11, 2017 at 7:59 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
> > Hi Rajesh,
> >
> > What you need does not exist. If it could be generalised and used all
> over
> > the world that would be perfect.
> >
> > This need to be discussed in dev ML in order for everybody to agree (or
> at
> > least get a consensus) and so avoid wasting time
> >
> > Then we can create a Jira and if possible attach a patch
> >
> > Thanks
> >
> > Jacques
> >
> >
> >
> > Le 11/10/2017 à 13:15, Rajesh Mallah a écrit :
> >
> >> Hello Deepak / Everyone ,
> >>
> >> We have been able to achieve the selective application of taxes by
> >> modifying the service calcTax ( java function: rateProductTaxCalc )
> >> it works as expected.
> >>
> >> The logic works by removing those taxes which are not applicable as per
> >> the situation (ie based on Shipping addresses)
> >>
> >> However we would want the implement it in a more generic manner,
> >> rite now the code checks specific PartyIDs associated with the
> >> TaxAuthority,
> >> is there any way to indicate that this specific handling of taxes should
> >> be
> >> limited to certain kind of taxauthorities ?
> >>
> >> Is there way of setting some meta-data on TaxAuthority or some kind of
> >> classification.
> >>
> >> regds
> >> mallah.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> On Tue, Oct 10, 2017 at 12:34 AM, Deepak Dixit <
> >> [hidden email]> wrote:
> >>
> >> Sure ,
> >>>
> >>> Please let us know if you face any issue. :)
> >>>
> >>> Thanks & Regards
> >>> --
> >>> Deepak Dixit
> >>> www.hotwaxsystems.com
> >>> www.hotwax.co
> >>>
> >>> On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <
> [hidden email]
> >>> >
> >>> wrote:
> >>>
> >>> Thanks it helps. Shall give it a shot.
> >>>>
> >>>> regds
> >>>> mallah.
> >>>>
> >>>> On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
> >>>> [hidden email]> wrote:
> >>>>
> >>>> Hi Rajesh,
> >>>>>
> >>>>> There are two way,
> >>>>>
> >>>>> 1. You can do changes in applications/accounting/src/
> >>>>> main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
> >>>>>
> >>>> and
> >>>
> >>>> create patch and maintain it in your custom component.
> >>>>> 2. You can override service calTax and/or related services/method in
> >>>>>
> >>>> your
> >>>
> >>>> custom component.
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> Thanks & Regards
> >>>>> --
> >>>>> Deepak Dixit
> >>>>> www.hotwaxsystems.com
> >>>>> www.hotwax.co
> >>>>>
> >>>>> On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <
> >>>>>
> >>>> [hidden email]>
> >>>
> >>>> wrote:
> >>>>>
> >>>>> Thanks Deepak , Appreciate your response.
> >>>>>>
> >>>>>> I had a glance over
> >>>>>>
> >>>>>> applications/accounting/servicedef/services_tax.xml  &
> >>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
> >>>>>>
> >>>>> accounting/tax/
> >>>
> >>>> TaxAuthorityServices.java
> >>>>>> looks encouraging!
> >>>>>>
> >>>>>> how should the change be managed to survive ofbiz upgrades?
> >>>>>>
> >>>>>> are we expected  to change TaxAuthorityServices.java ?
> >>>>>>
> >>>>>>
> >>>>>> regds
> >>>>>> mallah.
> >>>>>>
> >>>>>>
> >>>>>> On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
> >>>>>> [hidden email]> wrote:
> >>>>>>
> >>>>>> Hi Rajesh,
> >>>>>>>
> >>>>>>> To calculate GST you need to write custom calc tax service, that
> >>>>>>>
> >>>>>> honor
> >>>>
> >>>>> the
> >>>>>>
> >>>>>>> shipFrom address as well.
> >>>>>>> GST is common but how to calculate GST is different, As per Indian
> >>>>>>>
> >>>>>> context
> >>>>>>
> >>>>>>> GST is calculated based on shipFrom and ShipTo address.
> >>>>>>>
> >>>>>>> You need some changes in calcTax service and getTaxAuthorities
> >>>>>>>
> >>>>>> methods
> >>>>
> >>>>> that
> >>>>>>
> >>>>>>> return the taxAuthority.OFBiz has capability to setup different
> >>>>>>> taxAuthParties. So with proper data setup along with some changes
> >>>>>>>
> >>>>>> you
> >>>
> >>>> can
> >>>>>
> >>>>>> setup GST tax calculation properly.
> >>>>>>>
> >>>>>>>
> >>>>>>> Thanks & Regards
> >>>>>>> --
> >>>>>>> Deepak Dixit
> >>>>>>> www.hotwaxsystems.com
> >>>>>>> www.hotwax.co
> >>>>>>>
> >>>>>>> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
> >>>>>>>
> >>>>>> [hidden email]
> >>>>
> >>>>> wrote:
> >>>>>>>
> >>>>>>> We find that most of logic of Tax is in:
> >>>>>>>>
> >>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
> >>>>>>>>
> >>>>>>> accounting/tax/
> >>>>>
> >>>>>> TaxAuthorityServices.java
> >>>>>>>> can/should we modify it as per our need or there is a
> >>>>>>>>
> >>>>>>> better/easier
> >>>
> >>>> way?
> >>>>>>
> >>>>>>> As GST requirement is very common(universal) now in India , i am
> >>>>>>>>
> >>>>>>> curious
> >>>>>>
> >>>>>>> how people have implemented
> >>>>>>>> here using OfBiz.
> >>>>>>>>
> >>>>>>>> regds
> >>>>>>>> mallah.
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
> >>>>>>>>
> >>>>>>> [hidden email]
> >>>>>
> >>>>>> wrote:
> >>>>>>>>
> >>>>>>>> Hi ,
> >>>>>>>>>
> >>>>>>>>> I need help regarding how to apply taxes   broadly based on the
> >>>>>>>>> fact whether the supplier and consumer are in same state or
> >>>>>>>>>
> >>>>>>>> not.
> >>>
> >>>> We are able to apply taxes based on GEO ID of the customer but
> >>>>>>>>> what is really required is the below:
> >>>>>>>>>
> >>>>>>>>> If Supplier.state == Customer.state
> >>>>>>>>>        add adjustment SGST @  X%
> >>>>>>>>>        add adjustment CGST @  X%
> >>>>>>>>> else
> >>>>>>>>>        add adjustment IGST  @  X+X%
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> where:
> >>>>>>>>> CGST --> Central Goods & Services Tax
> >>>>>>>>> SGST --> State Goods & Services Tax
> >>>>>>>>> IGST  --> Integrated Goods & Services Tax
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> Any help on this regard is solicited.
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> regds
> >>>>>>>>> mallah.
> >>>>>>>>>
> >>>>>>>>>
> >
>

[Jacques Le Roux]

Thanks Rajesh, Deepak,

Please guys open a thread on dev ML to continue there

Thanks

Jacques


Le 11/10/2017 à 20:07, Deepak Dixit a écrit :

> I think we can make it configurable, we can get the tax calculation service
> dynamically and it can be configured based on store, like
> ProductStoreTaxSetting (or better name) this will contains tax calculation
> service name for specific store if its not configured system will use
> rateProductTaxCalc as default tax calculation.
>
>
> It will allow us to use different tax calculation service as per business
> need.
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Oct 11, 2017 at 11:26 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
>> Hi Jacques ,
>>
>> The patch is quite simple and we would readily contribute.
>> I am sure many Indian adopters would have already developed it
>> for their installations.
>>
>> But without generalising it , it is difficult to  convert it to a  patch
>> for OOTB feature set.
>>
>> At the same time GST is too important here(in India) and will possibly
>> stay.
>>
>> Any  accounting system that does not handle GST here is *not* usable.
>> The recent GST rollout ( since 1st Apr 2017) has itself created a huge
>> (short-term) market of  migrations and accounting software upgrades.
>>
>> I just hope this requirement gets its due attention and some way
>> is found  to either cleanly extend Ofbiz accounting to handle such
>> taxation methods OR make it possible for adopters to have user-defined
>> handling for a class/category of  TaxAuthorities.
>>
>> I feel if we are simply able to categorize TaxAuthorities  in user
>> defined Categories the logic can be cleanly developed and applied.
>> Assuming that such a facility exists,  the work flow for enduser to
>> implement GST would be.
>>
>>
>> (1) Create a new TaxAuthorityCategory --> say "India GST"
>> (2) Place the TaxAuthority in the new category "India GST"
>> (2) In calcTax
>>
>> if ( taxAuth.Category contains "India GST")   // assuming
>> TaxAuthorityCategory is 1-to-many relation.
>> {
>> // apply Custom logic for  GST
>> }
>>
>> =========================
>>
>> essentially we(end-user) shall be in a position to apply any custom logic
>> to a given
>> category of taxAuthority.  as Mr Deepak says ,
>>
>> "GST is common but how to calculate GST is different"
>>
>> I concur here and feel that generalizing it may be too difficult a task and
>> will not even find
>> too many matching candidates. instead if the framework provides a
>> categorization
>> (or equivalent ) people can write their custom logic (however complicated)
>> based on
>> their local rules.
>>
>>
>>
>> regds
>> mallah.
>>
>>
>>
>>
>> On Wed, Oct 11, 2017 at 7:59 PM, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>>> Hi Rajesh,
>>>
>>> What you need does not exist. If it could be generalised and used all
>> over
>>> the world that would be perfect.
>>>
>>> This need to be discussed in dev ML in order for everybody to agree (or
>> at
>>> least get a consensus) and so avoid wasting time
>>>
>>> Then we can create a Jira and if possible attach a patch
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>>
>>>
>>> Le 11/10/2017 à 13:15, Rajesh Mallah a écrit :
>>>
>>>> Hello Deepak / Everyone ,
>>>>
>>>> We have been able to achieve the selective application of taxes by
>>>> modifying the service calcTax ( java function: rateProductTaxCalc )
>>>> it works as expected.
>>>>
>>>> The logic works by removing those taxes which are not applicable as per
>>>> the situation (ie based on Shipping addresses)
>>>>
>>>> However we would want the implement it in a more generic manner,
>>>> rite now the code checks specific PartyIDs associated with the
>>>> TaxAuthority,
>>>> is there any way to indicate that this specific handling of taxes should
>>>> be
>>>> limited to certain kind of taxauthorities ?
>>>>
>>>> Is there way of setting some meta-data on TaxAuthority or some kind of
>>>> classification.
>>>>
>>>> regds
>>>> mallah.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Tue, Oct 10, 2017 at 12:34 AM, Deepak Dixit <
>>>> [hidden email]> wrote:
>>>>
>>>> Sure ,
>>>>> Please let us know if you face any issue. :)
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>> www.hotwax.co
>>>>>
>>>>> On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <
>> [hidden email]
>>>>> wrote:
>>>>>
>>>>> Thanks it helps. Shall give it a shot.
>>>>>> regds
>>>>>> mallah.
>>>>>>
>>>>>> On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
>>>>>> [hidden email]> wrote:
>>>>>>
>>>>>> Hi Rajesh,
>>>>>>> There are two way,
>>>>>>>
>>>>>>> 1. You can do changes in applications/accounting/src/
>>>>>>> main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
>>>>>>>
>>>>>> and
>>>>>> create patch and maintain it in your custom component.
>>>>>>> 2. You can override service calTax and/or related services/method in
>>>>>>>
>>>>>> your
>>>>>> custom component.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Thanks & Regards
>>>>>>> --
>>>>>>> Deepak Dixit
>>>>>>> www.hotwaxsystems.com
>>>>>>> www.hotwax.co
>>>>>>>
>>>>>>> On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <
>>>>>>>
>>>>>> [hidden email]>
>>>>>> wrote:
>>>>>>> Thanks Deepak , Appreciate your response.
>>>>>>>> I had a glance over
>>>>>>>>
>>>>>>>> applications/accounting/servicedef/services_tax.xml  &
>>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>>>>>>
>>>>>>> accounting/tax/
>>>>>> TaxAuthorityServices.java
>>>>>>>> looks encouraging!
>>>>>>>>
>>>>>>>> how should the change be managed to survive ofbiz upgrades?
>>>>>>>>
>>>>>>>> are we expected  to change TaxAuthorityServices.java ?
>>>>>>>>
>>>>>>>>
>>>>>>>> regds
>>>>>>>> mallah.
>>>>>>>>
>>>>>>>>
>>>>>>>> On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
>>>>>>>> [hidden email]> wrote:
>>>>>>>>
>>>>>>>> Hi Rajesh,
>>>>>>>>> To calculate GST you need to write custom calc tax service, that
>>>>>>>>>
>>>>>>>> honor
>>>>>>> the
>>>>>>>>> shipFrom address as well.
>>>>>>>>> GST is common but how to calculate GST is different, As per Indian
>>>>>>>>>
>>>>>>>> context
>>>>>>>>
>>>>>>>>> GST is calculated based on shipFrom and ShipTo address.
>>>>>>>>>
>>>>>>>>> You need some changes in calcTax service and getTaxAuthorities
>>>>>>>>>
>>>>>>>> methods
>>>>>>> that
>>>>>>>>> return the taxAuthority.OFBiz has capability to setup different
>>>>>>>>> taxAuthParties. So with proper data setup along with some changes
>>>>>>>>>
>>>>>>>> you
>>>>>> can
>>>>>>>> setup GST tax calculation properly.
>>>>>>>>>
>>>>>>>>> Thanks & Regards
>>>>>>>>> --
>>>>>>>>> Deepak Dixit
>>>>>>>>> www.hotwaxsystems.com
>>>>>>>>> www.hotwax.co
>>>>>>>>>
>>>>>>>>> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
>>>>>>>>>
>>>>>>>> [hidden email]
>>>>>>> wrote:
>>>>>>>>> We find that most of logic of Tax is in:
>>>>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>>>>>>>>
>>>>>>>>> accounting/tax/
>>>>>>>> TaxAuthorityServices.java
>>>>>>>>>> can/should we modify it as per our need or there is a
>>>>>>>>>>
>>>>>>>>> better/easier
>>>>>> way?
>>>>>>>>> As GST requirement is very common(universal) now in India , i am
>>>>>>>>> curious
>>>>>>>>> how people have implemented
>>>>>>>>>> here using OfBiz.
>>>>>>>>>>
>>>>>>>>>> regds
>>>>>>>>>> mallah.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
>>>>>>>>>>
>>>>>>>>> [hidden email]
>>>>>>>> wrote:
>>>>>>>>>> Hi ,
>>>>>>>>>>> I need help regarding how to apply taxes   broadly based on the
>>>>>>>>>>> fact whether the supplier and consumer are in same state or
>>>>>>>>>>>
>>>>>>>>>> not.
>>>>>> We are able to apply taxes based on GEO ID of the customer but
>>>>>>>>>>> what is really required is the below:
>>>>>>>>>>>
>>>>>>>>>>> If Supplier.state == Customer.state
>>>>>>>>>>>         add adjustment SGST @  X%
>>>>>>>>>>>         add adjustment CGST @  X%
>>>>>>>>>>> else
>>>>>>>>>>>         add adjustment IGST  @  X+X%
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> where:
>>>>>>>>>>> CGST --> Central Goods & Services Tax
>>>>>>>>>>> SGST --> State Goods & Services Tax
>>>>>>>>>>> IGST  --> Integrated Goods & Services Tax
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Any help on this regard is solicited.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> regds
>>>>>>>>>>> mallah.
>>>>>>>>>>>
>>>>>>>>>>>

[innate Genius]

+1 This is a must and would help a lot in terms of ease of adoption for new users.

Regards,

Pratiek

> On 12-Oct-2017, at 3:01 AM, Jacques Le Roux <[hidden email]> wrote:
>
> Thanks Rajesh, Deepak,
>
> Please guys open a thread on dev ML to continue there
>
> Thanks
>
> Jacques
>
>
> Le 11/10/2017 à 20:07, Deepak Dixit a écrit :
>> I think we can make it configurable, we can get the tax calculation service
>> dynamically and it can be configured based on store, like
>> ProductStoreTaxSetting (or better name) this will contains tax calculation
>> service name for specific store if its not configured system will use
>> rateProductTaxCalc as default tax calculation.
>>
>>
>> It will allow us to use different tax calculation service as per business
>> need.
>>
>> Thanks & Regards
>> --
>> Deepak Dixit
>> www.hotwaxsystems.com
>> www.hotwax.co
>>
>> On Wed, Oct 11, 2017 at 11:26 PM, Rajesh Mallah <[hidden email]>
>> wrote:
>>
>>> Hi Jacques ,
>>>
>>> The patch is quite simple and we would readily contribute.
>>> I am sure many Indian adopters would have already developed it
>>> for their installations.
>>>
>>> But without generalising it , it is difficult to  convert it to a  patch
>>> for OOTB feature set.
>>>
>>> At the same time GST is too important here(in India) and will possibly
>>> stay.
>>>
>>> Any  accounting system that does not handle GST here is *not* usable.
>>> The recent GST rollout ( since 1st Apr 2017) has itself created a huge
>>> (short-term) market of  migrations and accounting software upgrades.
>>>
>>> I just hope this requirement gets its due attention and some way
>>> is found  to either cleanly extend Ofbiz accounting to handle such
>>> taxation methods OR make it possible for adopters to have user-defined
>>> handling for a class/category of  TaxAuthorities.
>>>
>>> I feel if we are simply able to categorize TaxAuthorities  in user
>>> defined Categories the logic can be cleanly developed and applied.
>>> Assuming that such a facility exists,  the work flow for enduser to
>>> implement GST would be.
>>>
>>>
>>> (1) Create a new TaxAuthorityCategory --> say "India GST"
>>> (2) Place the TaxAuthority in the new category "India GST"
>>> (2) In calcTax
>>>
>>> if ( taxAuth.Category contains "India GST")   // assuming
>>> TaxAuthorityCategory is 1-to-many relation.
>>> {
>>> // apply Custom logic for  GST
>>> }
>>>
>>> =========================
>>>
>>> essentially we(end-user) shall be in a position to apply any custom logic
>>> to a given
>>> category of taxAuthority.  as Mr Deepak says ,
>>>
>>> "GST is common but how to calculate GST is different"
>>>
>>> I concur here and feel that generalizing it may be too difficult a task and
>>> will not even find
>>> too many matching candidates. instead if the framework provides a
>>> categorization
>>> (or equivalent ) people can write their custom logic (however complicated)
>>> based on
>>> their local rules.
>>>
>>>
>>>
>>> regds
>>> mallah.
>>>
>>>
>>>
>>>
>>> On Wed, Oct 11, 2017 at 7:59 PM, Jacques Le Roux <
>>> [hidden email]> wrote:
>>>
>>>> Hi Rajesh,
>>>>
>>>> What you need does not exist. If it could be generalised and used all
>>> over
>>>> the world that would be perfect.
>>>>
>>>> This need to be discussed in dev ML in order for everybody to agree (or
>>> at
>>>> least get a consensus) and so avoid wasting time
>>>>
>>>> Then we can create a Jira and if possible attach a patch
>>>>
>>>> Thanks
>>>>
>>>> Jacques
>>>>
>>>>
>>>>
>>>> Le 11/10/2017 à 13:15, Rajesh Mallah a écrit :
>>>>
>>>>> Hello Deepak / Everyone ,
>>>>>
>>>>> We have been able to achieve the selective application of taxes by
>>>>> modifying the service calcTax ( java function: rateProductTaxCalc )
>>>>> it works as expected.
>>>>>
>>>>> The logic works by removing those taxes which are not applicable as per
>>>>> the situation (ie based on Shipping addresses)
>>>>>
>>>>> However we would want the implement it in a more generic manner,
>>>>> rite now the code checks specific PartyIDs associated with the
>>>>> TaxAuthority,
>>>>> is there any way to indicate that this specific handling of taxes should
>>>>> be
>>>>> limited to certain kind of taxauthorities ?
>>>>>
>>>>> Is there way of setting some meta-data on TaxAuthority or some kind of
>>>>> classification.
>>>>>
>>>>> regds
>>>>> mallah.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Oct 10, 2017 at 12:34 AM, Deepak Dixit <
>>>>> [hidden email]> wrote:
>>>>>
>>>>> Sure ,
>>>>>> Please let us know if you face any issue. :)
>>>>>>
>>>>>> Thanks & Regards
>>>>>> --
>>>>>> Deepak Dixit
>>>>>> www.hotwaxsystems.com
>>>>>> www.hotwax.co
>>>>>>
>>>>>> On Tue, Oct 10, 2017 at 12:21 AM, Rajesh Mallah <
>>> [hidden email]
>>>>>> wrote:
>>>>>>
>>>>>> Thanks it helps. Shall give it a shot.
>>>>>>> regds
>>>>>>> mallah.
>>>>>>>
>>>>>>> On Tue, Oct 10, 2017 at 12:01 AM, Deepak Dixit <
>>>>>>> [hidden email]> wrote:
>>>>>>>
>>>>>>> Hi Rajesh,
>>>>>>>> There are two way,
>>>>>>>>
>>>>>>>> 1. You can do changes in applications/accounting/src/
>>>>>>>> main/java/org/apache/ofbiz/accounting/tax/TaxAuthorityServices.java
>>>>>>>>
>>>>>>> and
>>>>>>> create patch and maintain it in your custom component.
>>>>>>>> 2. You can override service calTax and/or related services/method in
>>>>>>>>
>>>>>>> your
>>>>>>> custom component.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Thanks & Regards
>>>>>>>> --
>>>>>>>> Deepak Dixit
>>>>>>>> www.hotwaxsystems.com
>>>>>>>> www.hotwax.co
>>>>>>>>
>>>>>>>> On Mon, Oct 9, 2017 at 11:56 PM, Rajesh Mallah <
>>>>>>>>
>>>>>>> [hidden email]>
>>>>>>> wrote:
>>>>>>>> Thanks Deepak , Appreciate your response.
>>>>>>>>> I had a glance over
>>>>>>>>>
>>>>>>>>> applications/accounting/servicedef/services_tax.xml  &
>>>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>>>>>>>
>>>>>>>> accounting/tax/
>>>>>>> TaxAuthorityServices.java
>>>>>>>>> looks encouraging!
>>>>>>>>>
>>>>>>>>> how should the change be managed to survive ofbiz upgrades?
>>>>>>>>>
>>>>>>>>> are we expected  to change TaxAuthorityServices.java ?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> regds
>>>>>>>>> mallah.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Mon, Oct 9, 2017 at 11:31 PM, Deepak Dixit <
>>>>>>>>> [hidden email]> wrote:
>>>>>>>>>
>>>>>>>>> Hi Rajesh,
>>>>>>>>>> To calculate GST you need to write custom calc tax service, that
>>>>>>>>>>
>>>>>>>>> honor
>>>>>>>> the
>>>>>>>>>> shipFrom address as well.
>>>>>>>>>> GST is common but how to calculate GST is different, As per Indian
>>>>>>>>>>
>>>>>>>>> context
>>>>>>>>>
>>>>>>>>>> GST is calculated based on shipFrom and ShipTo address.
>>>>>>>>>>
>>>>>>>>>> You need some changes in calcTax service and getTaxAuthorities
>>>>>>>>>>
>>>>>>>>> methods
>>>>>>>> that
>>>>>>>>>> return the taxAuthority.OFBiz has capability to setup different
>>>>>>>>>> taxAuthParties. So with proper data setup along with some changes
>>>>>>>>>>
>>>>>>>>> you
>>>>>>> can
>>>>>>>>> setup GST tax calculation properly.
>>>>>>>>>>
>>>>>>>>>> Thanks & Regards
>>>>>>>>>> --
>>>>>>>>>> Deepak Dixit
>>>>>>>>>> www.hotwaxsystems.com
>>>>>>>>>> www.hotwax.co
>>>>>>>>>>
>>>>>>>>>> On Mon, Oct 9, 2017 at 9:45 PM, Rajesh Mallah <
>>>>>>>>>>
>>>>>>>>> [hidden email]
>>>>>>>> wrote:
>>>>>>>>>> We find that most of logic of Tax is in:
>>>>>>>>>>> applications/accounting/src/main/java/org/apache/ofbiz/
>>>>>>>>>>>
>>>>>>>>>> accounting/tax/
>>>>>>>>> TaxAuthorityServices.java
>>>>>>>>>>> can/should we modify it as per our need or there is a
>>>>>>>>>>>
>>>>>>>>>> better/easier
>>>>>>> way?
>>>>>>>>>> As GST requirement is very common(universal) now in India , i am
>>>>>>>>>> curious
>>>>>>>>>> how people have implemented
>>>>>>>>>>> here using OfBiz.
>>>>>>>>>>>
>>>>>>>>>>> regds
>>>>>>>>>>> mallah.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <
>>>>>>>>>>>
>>>>>>>>>> [hidden email]
>>>>>>>>> wrote:
>>>>>>>>>>> Hi ,
>>>>>>>>>>>> I need help regarding how to apply taxes   broadly based on the
>>>>>>>>>>>> fact whether the supplier and consumer are in same state or
>>>>>>>>>>>>
>>>>>>>>>>> not.
>>>>>>> We are able to apply taxes based on GEO ID of the customer but
>>>>>>>>>>>> what is really required is the below:
>>>>>>>>>>>>
>>>>>>>>>>>> If Supplier.state == Customer.state
>>>>>>>>>>>>        add adjustment SGST @  X%
>>>>>>>>>>>>        add adjustment CGST @  X%
>>>>>>>>>>>> else
>>>>>>>>>>>>        add adjustment IGST  @  X+X%
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> where:
>>>>>>>>>>>> CGST --> Central Goods & Services Tax
>>>>>>>>>>>> SGST --> State Goods & Services Tax
>>>>>>>>>>>> IGST  --> Integrated Goods & Services Tax
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Any help on this regard is solicited.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> regds
>>>>>>>>>>>> mallah.
>>>>>>>>>>>>
>>>>>>>>>>>>
>

[Vaibhav Jain]

Hello Rajesh/Everyone,

GST(India) can be implemented in OFBiz as follow:

After GST tax will apply on the basis of HSN code of product not on the
product directly. So we can associate HSN code with tax slab in
ProductCategoryRollup entity like

<ProductCategoryRollup productCategoryId="HSN_XXXXXX"
parentProductCategoryId="TAX_SLAB" fromDate="2017-07-01 12:00:00.0"
sequenceNum="1"/>

As we need to define tax slab, ProductCategory entity can be used to
categorise the tax slabs like

<ProductCategory productCategoryId="TAX_SLAB"
productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
categoryName="5.00 %"/>

Now tax slab is associated with HSN. So, product will be associated with
HSN code in ProductCategoryMember entity like

<ProductCategoryMember productCategoryId="HSN_300310" productId="XXXXXXXX"
fromDate="2001-01-01 12:00:00.000"/>

 All the HSN code can be stored in ProductCategory entity

<ProductCategory productCategoryId="HSN_XXXXXX"
productCategoryTypeId="HSN_CATEGORY" categoryName="XXXXXX"
description="Cheese and curd"/>

Tax authority can be stored in PartyTaxAuthInfo entity like

<PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="_NA_"
taxAuthPartyId="IGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
partyTaxId="XXXXXGSTINXXXXXXX"/>
<PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IND"
taxAuthPartyId="CGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
partyTaxId="XXXXXGSTINXXXXXXX"/>
<PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AN"
taxAuthPartyId="IN-AN_UTGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
partyTaxId="XXXXXGSTINXXXXXXX"/>
<PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AP"
taxAuthPartyId="IN-AP_SGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
partyTaxId="XXXXXGSTINXXXXXXX"/>

GST can be configurable in OFBiz using ProductStoreTaxSetting entity
We can write a separate service to calculate GST and configure at
ProductStore level using taxServiceName attribute of ProductStoreTaxSetting
entity.

Just for Info
Right now In PO and SO OFBiz does not entertain both SHIP_ORIG_LOCATION and
SHIP_DESTINATION_LOCATION. We need to introduce this as well to calculate
the GST.

Thanks & Regards

Vaibhav Jain
Hotwax Systems,
[hidden email]

On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
wrote:

> Hi ,
>
> I need help regarding how to apply taxes   broadly based on the
> fact whether the supplier and consumer are in same state or not.
>
> We are able to apply taxes based on GEO ID of the customer but
> what is really required is the below:
>
> If Supplier.state == Customer.state
>       add adjustment SGST @  X%
>       add adjustment CGST @  X%
> else
>       add adjustment IGST  @  X+X%
>
>
> where:
> CGST --> Central Goods & Services Tax
> SGST --> State Goods & Services Tax
> IGST  --> Integrated Goods & Services Tax
>
>
> Any help on this regard is solicited.
>
>
> regds
> mallah.
>

[Rajesh Mallah]

Thanks Vaibhav for the notes regarding the HSN . Currently we are not
handling
HSN in our installation as most of our products are under same hsn.
Although
The handling of  ORIG_LOCATION and DEST_LOCATION has been done.

As we know GST in India is based on ORIG_LOCATION and DEST_LOCATION
and is currently it is the only tax.

But in a general situation where you have "GST like" taxes and some other
taxes
also  say "Education Cess" (now defunct,i think) there needs to be an
option to
have custom logic association with different kind of taxes and was the
concern which
i had raised.

regds
mallah






On Thu, Oct 12, 2017 at 11:25 AM, Vaibhav Jain <
[hidden email]> wrote:

> Hello Rajesh/Everyone,
>
> GST(India) can be implemented in OFBiz as follow:
>
> After GST tax will apply on the basis of HSN code of product not on the
> product directly. So we can associate HSN code with tax slab in
> ProductCategoryRollup entity like
>
> <ProductCategoryRollup productCategoryId="HSN_XXXXXX"
> parentProductCategoryId="TAX_SLAB" fromDate="2017-07-01 12:00:00.0"
> sequenceNum="1"/>
>
> As we need to define tax slab, ProductCategory entity can be used to
> categorise the tax slabs like
>
> <ProductCategory productCategoryId="TAX_SLAB"
> productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> categoryName="5.00 %"/>
>
> Now tax slab is associated with HSN. So, product will be associated with
> HSN code in ProductCategoryMember entity like
>
> <ProductCategoryMember productCategoryId="HSN_300310" productId="XXXXXXXX"
> fromDate="2001-01-01 12:00:00.000"/>
>
>  All the HSN code can be stored in ProductCategory entity
>
> <ProductCategory productCategoryId="HSN_XXXXXX"
> productCategoryTypeId="HSN_CATEGORY" categoryName="XXXXXX"
> description="Cheese and curd"/>
>
> Tax authority can be stored in PartyTaxAuthInfo entity like
>
> <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="_NA_"
> taxAuthPartyId="IGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> partyTaxId="XXXXXGSTINXXXXXXX"/>
> <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IND"
> taxAuthPartyId="CGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> partyTaxId="XXXXXGSTINXXXXXXX"/>
> <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AN"
> taxAuthPartyId="IN-AN_UTGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> partyTaxId="XXXXXGSTINXXXXXXX"/>
> <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AP"
> taxAuthPartyId="IN-AP_SGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> partyTaxId="XXXXXGSTINXXXXXXX"/>
>
> GST can be configurable in OFBiz using ProductStoreTaxSetting entity
> We can write a separate service to calculate GST and configure at
> ProductStore level using taxServiceName attribute of ProductStoreTaxSetting
> entity.
>
> Just for Info
> Right now In PO and SO OFBiz does not entertain both SHIP_ORIG_LOCATION and
> SHIP_DESTINATION_LOCATION. We need to introduce this as well to calculate
> the GST.
>
> Thanks & Regards
>
> Vaibhav Jain
> Hotwax Systems,
> [hidden email]
>
> On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
> > Hi ,
> >
> > I need help regarding how to apply taxes   broadly based on the
> > fact whether the supplier and consumer are in same state or not.
> >
> > We are able to apply taxes based on GEO ID of the customer but
> > what is really required is the below:
> >
> > If Supplier.state == Customer.state
> >       add adjustment SGST @  X%
> >       add adjustment CGST @  X%
> > else
> >       add adjustment IGST  @  X+X%
> >
> >
> > where:
> > CGST --> Central Goods & Services Tax
> > SGST --> State Goods & Services Tax
> > IGST  --> Integrated Goods & Services Tax
> >
> >
> > Any help on this regard is solicited.
> >
> >
> > regds
> > mallah.
> >
>

[Vaibhav Jain]

Please check inline

On Thu, Oct 12, 2017 at 8:43 PM, Rajesh Mallah <[hidden email]>
wrote:

> Thanks Vaibhav for the notes regarding the HSN . Currently we are not
> handling
> HSN in our installation as most of our products are under same hsn.
>
I am just curious to know how you can calculate tax without using HSN code.
Is there any way to calculate tax without HSN code.

> Although
> The handling of  ORIG_LOCATION and DEST_LOCATION has been done.
>
Great

>
> As we know GST in India is based on ORIG_LOCATION and DEST_LOCATION
> and is currently it is the only tax.
>
> But in a general situation where you have "GST like" taxes and some other
> taxes
> also  say "Education Cess" (now defunct,i think) there needs to be an
> option to
>
Thanks for the make me remeber about about "CESS". Yes we need to entertain
"CESS" as well.

> have custom logic association with different kind of taxes and was the
> concern which
> i had raised.
>
Not able to get your point. Can you please elaborate?

>
> regds
> mallah
>
>
>
>
>
>
> On Thu, Oct 12, 2017 at 11:25 AM, Vaibhav Jain <
> [hidden email]> wrote:
>
> > Hello Rajesh/Everyone,
> >
> > GST(India) can be implemented in OFBiz as follow:
> >
> > After GST tax will apply on the basis of HSN code of product not on the
> > product directly. So we can associate HSN code with tax slab in
> > ProductCategoryRollup entity like
> >
> > <ProductCategoryRollup productCategoryId="HSN_XXXXXX"
> > parentProductCategoryId="TAX_SLAB" fromDate="2017-07-01 12:00:00.0"
> > sequenceNum="1"/>
> >
> > As we need to define tax slab, ProductCategory entity can be used to
> > categorise the tax slabs like
> >
> > <ProductCategory productCategoryId="TAX_SLAB"
> > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > categoryName="5.00 %"/>
> >
> > Now tax slab is associated with HSN. So, product will be associated with
> > HSN code in ProductCategoryMember entity like
> >
> > <ProductCategoryMember productCategoryId="HSN_300310"
> productId="XXXXXXXX"
> > fromDate="2001-01-01 12:00:00.000"/>
> >
> >  All the HSN code can be stored in ProductCategory entity
> >
> > <ProductCategory productCategoryId="HSN_XXXXXX"
> > productCategoryTypeId="HSN_CATEGORY" categoryName="XXXXXX"
> > description="Cheese and curd"/>
> >
> > Tax authority can be stored in PartyTaxAuthInfo entity like
> >
> > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="_NA_"
> > taxAuthPartyId="IGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IND"
> > taxAuthPartyId="CGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AN"
> > taxAuthPartyId="IN-AN_UTGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AP"
> > taxAuthPartyId="IN-AP_SGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> > partyTaxId="XXXXXGSTINXXXXXXX"/>
> >
> > GST can be configurable in OFBiz using ProductStoreTaxSetting entity
> > We can write a separate service to calculate GST and configure at
> > ProductStore level using taxServiceName attribute of
> ProductStoreTaxSetting
> > entity.
> >
> > Just for Info
> > Right now In PO and SO OFBiz does not entertain both SHIP_ORIG_LOCATION
> and
> > SHIP_DESTINATION_LOCATION. We need to introduce this as well to calculate
> > the GST.
> >
> > Thanks & Regards
> >
> > Vaibhav Jain
> > Hotwax Systems,
> > [hidden email]
> >
> > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]>
> > wrote:
> >
> > > Hi ,
> > >
> > > I need help regarding how to apply taxes   broadly based on the
> > > fact whether the supplier and consumer are in same state or not.
> > >
> > > We are able to apply taxes based on GEO ID of the customer but
> > > what is really required is the below:
> > >
> > > If Supplier.state == Customer.state
> > >       add adjustment SGST @  X%
> > >       add adjustment CGST @  X%
> > > else
> > >       add adjustment IGST  @  X+X%
> > >
> > >
> > > where:
> > > CGST --> Central Goods & Services Tax
> > > SGST --> State Goods & Services Tax
> > > IGST  --> Integrated Goods & Services Tax
> > >
> > >
> > > Any help on this regard is solicited.
> > >
> > >
> > > regds
> > > mallah.
> > >
> >
>

[Rajesh Mallah]

Thanks Vaibhav for the reply , Although we have been asked to move this
discussion to dev ML . [ apologies for that ;-) ]

bypassing HSN is just a temporary arrangement as our product line has a
fixed HSN code , so we have keep the rate at flat 9% or 18%.
The ability to have different tax rates for different Product Category
already
exists so it shall be best to bank upon it .
(as you have already done it in the example you gave).

>>
>> As we know GST in India is based on ORIG_LOCATION and DEST_LOCATION
>> and is currently it is the only tax.
>>
>> But in a general situation where you have "GST like" taxes and some other
>> taxes
>> also  say "Education Cess" (now defunct,i think) there needs to be an
>> option to
>>

>Thanks for the make me remeber about about "CESS". Yes we need to entertain
>"CESS" as well.

>> have custom logic association with different kind of taxes and was the
>> concern which
>> i had raised.
>
> Not able to get your point. Can you please elaborate?

Governments of various GEOIDs are free to implement arbitrarily complex or
simple
tax regimes . So i was asking for categorization of taxes so that
appropriate logic
(based on local tax regime) can be applied to various "kinds" (category) of
taxes.

As a person who is adopting ofbiz for first time , my convenience would
have been

(1) ofbiz OOTB UI / Web Tools allowed me to create  some Tax Categories
(2) ofbiz OOTB UI / Web Tools allowed me to associate a TaxAuthority with
one or more Tax Categories
(3) write code in calcTax to provide appropriate treatment to TaxAuthority
based on its  Tax Category.

hope i was able to convey.

kind regards
mallah.



On Fri, Oct 13, 2017 at 12:09 PM, Vaibhav Jain <
[hidden email]> wrote:

> Please check inline
>
> On Thu, Oct 12, 2017 at 8:43 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
> > Thanks Vaibhav for the notes regarding the HSN . Currently we are not
> > handling
> > HSN in our installation as most of our products are under same hsn.
> >
> I am just curious to know how you can calculate tax without using HSN code.
> Is there any way to calculate tax without HSN code.
>
> > Although
> > The handling of  ORIG_LOCATION and DEST_LOCATION has been done.
> >
> Great
>
> >
> > As we know GST in India is based on ORIG_LOCATION and DEST_LOCATION
> > and is currently it is the only tax.
> >
> > But in a general situation where you have "GST like" taxes and some other
> > taxes
> > also  say "Education Cess" (now defunct,i think) there needs to be an
> > option to
> >
> Thanks for the make me remeber about about "CESS". Yes we need to entertain
> "CESS" as well.
>
> > have custom logic association with different kind of taxes and was the
> > concern which
> > i had raised.
> >
> Not able to get your point. Can you please elaborate?
>
> >
> > regds
> > mallah
> >
> >
> >
> >
> >
> >
> > On Thu, Oct 12, 2017 at 11:25 AM, Vaibhav Jain <
> > [hidden email]> wrote:
> >
> > > Hello Rajesh/Everyone,
> > >
> > > GST(India) can be implemented in OFBiz as follow:
> > >
> > > After GST tax will apply on the basis of HSN code of product not on the
> > > product directly. So we can associate HSN code with tax slab in
> > > ProductCategoryRollup entity like
> > >
> > > <ProductCategoryRollup productCategoryId="HSN_XXXXXX"
> > > parentProductCategoryId="TAX_SLAB" fromDate="2017-07-01 12:00:00.0"
> > > sequenceNum="1"/>
> > >
> > > As we need to define tax slab, ProductCategory entity can be used to
> > > categorise the tax slabs like
> > >
> > > <ProductCategory productCategoryId="TAX_SLAB"
> > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %"
> > > categoryName="5.00 %"/>
> > >
> > > Now tax slab is associated with HSN. So, product will be associated
> with
> > > HSN code in ProductCategoryMember entity like
> > >
> > > <ProductCategoryMember productCategoryId="HSN_300310"
> > productId="XXXXXXXX"
> > > fromDate="2001-01-01 12:00:00.000"/>
> > >
> > >  All the HSN code can be stored in ProductCategory entity
> > >
> > > <ProductCategory productCategoryId="HSN_XXXXXX"
> > > productCategoryTypeId="HSN_CATEGORY" categoryName="XXXXXX"
> > > description="Cheese and curd"/>
> > >
> > > Tax authority can be stored in PartyTaxAuthInfo entity like
> > >
> > > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="_NA_"
> > > taxAuthPartyId="IGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> > > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IND"
> > > taxAuthPartyId="CGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y"
> > > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AN"
> > > taxAuthPartyId="IN-AN_UTGST" fromDate="2017-06-01 00:00:00.0"
> isNexus="Y"
> > > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > > <PartyTaxAuthInfo partyId="COMPANY" taxAuthGeoId="IN-AP"
> > > taxAuthPartyId="IN-AP_SGST" fromDate="2017-06-01 00:00:00.0"
> isNexus="Y"
> > > partyTaxId="XXXXXGSTINXXXXXXX"/>
> > >
> > > GST can be configurable in OFBiz using ProductStoreTaxSetting entity
> > > We can write a separate service to calculate GST and configure at
> > > ProductStore level using taxServiceName attribute of
> > ProductStoreTaxSetting
> > > entity.
> > >
> > > Just for Info
> > > Right now In PO and SO OFBiz does not entertain both SHIP_ORIG_LOCATION
> > and
> > > SHIP_DESTINATION_LOCATION. We need to introduce this as well to
> calculate
> > > the GST.
> > >
> > > Thanks & Regards
> > >
> > > Vaibhav Jain
> > > Hotwax Systems,
> > > [hidden email]
> > >
> > > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <[hidden email]
> >
> > > wrote:
> > >
> > > > Hi ,
> > > >
> > > > I need help regarding how to apply taxes   broadly based on the
> > > > fact whether the supplier and consumer are in same state or not.
> > > >
> > > > We are able to apply taxes based on GEO ID of the customer but
> > > > what is really required is the below:
> > > >
> > > > If Supplier.state == Customer.state
> > > >       add adjustment SGST @  X%
> > > >       add adjustment CGST @  X%
> > > > else
> > > >       add adjustment IGST  @  X+X%
> > > >
> > > >
> > > > where:
> > > > CGST --> Central Goods & Services Tax
> > > > SGST --> State Goods & Services Tax
> > > > IGST  --> Integrated Goods & Services Tax
> > > >
> > > >
> > > > Any help on this regard is solicited.
> > > >
> > > >
> > > > regds
> > > > mallah.
> > > >
> > >
> >
>