Re: Proposal to add company related legal numbers

[aswath narayana]

Per David's suggestion, I looked into PartyTaxAuthInfo and related entities.
Currently the tables having *tax* are strictly related to tax authorities
and participate in the business transactions

SALESTAX_NUBMER - Used while paying the sales tax back to the government
This will fit into the PartyTaxAuthInfo

PAN_NUMBER - Used while paying TDS (Tax deducted at source) to government.
This is not applicable during sales and service.
I am not sure whether this belongs to PartyTaxAuthInfo

The following number is not related to taxes.
ROC NUMBER - Used while filing a yearly fee to the government

Hence, I believe, the new entities and relationships mentioned by me are
needed for the following reasons.
* Not all the required legal numbers for the company are for Tax purposes.

Please suggest

Thanks
-Aswath


On Wed, Jun 10, 2009 at 2:25 PM, David E Jones <[hidden email]> wrote:

>
> This email should go on the dev list since it seems to involve an extension
> to OFBiz itself.
>
> Please write an email to that list on the topic. This email will do,
> although I suggest some changes to take into consideration the existing
> "PartyTaxAuthInfo" entity (look at the entity def and demo data especially,
> as well as the Tax Authority docs on docs.ofbiz.org).
>
> -David
>
>
>
> On Jun 10, 2009, at 2:02 AM, aswath narayana wrote:
>
>  Hello All,
>>
>> Proposal to add company related legal numbers.
>> When setting up an internal organization/company, the company requires few
>> legal numbers.
>> For example, for an Indian company, the following are required.
>> 1. PAN number
>> 2. Sales Tax Registration number
>> 3. ROC - Registrar of companies registration Number
>>
>> Use cases
>> * Used while filing forms and returns
>> * Useful while reporting
>> * It is also handy for accountants to look up the various numbers in the
>> system,
>> rather than going to papers and then finding the numbers.
>>
>> Entities required:
>> LegalNumberType Table
>> * LegalNumberTypeId - varchar (50)
>> * description
>> Example of rows:
>> SALESTAX_NUMBER, Sales Tax Number
>> PAN_NUMBER, Pan number
>>
>>
>> PartyLegalNumber Table
>> * PartyId
>> * LegalNumberTypeId
>> * Number - varchar (255)
>>
>> PartyLegalNumber has 1-many LegalNumberType relation
>> Example of rows:
>> Company, SALESTAX_NUMBER, 234543
>> Company, PAN_NUMBER, AZ09-76
>>
>>
>> Screens modifications:
>> Add a section PartyLegalNumber in the Party Profile screen.
>>
>> Please send your input.
>>
>> Thanks
>> -Aswath
>>
>
>

[aswath narayana]

Can someone please lookinto this.  PAN_NUMBER is a must for the
internalorganization/vendor/supplier/customer in India.


Thanks
-Aswath

On Thu, Jun 11, 2009 at 1:46 PM, aswath narayana <[hidden email]
> wrote:

> Per David's suggestion, I looked into PartyTaxAuthInfo and related
> entities.
> Currently the tables having *tax* are strictly related to tax authorities
> and participate in the business transactions
>
> SALESTAX_NUBMER - Used while paying the sales tax back to the government
> This will fit into the PartyTaxAuthInfo
>
> PAN_NUMBER - Used while paying TDS (Tax deducted at source) to government.
> This is not applicable during sales and service.
> I am not sure whether this belongs to PartyTaxAuthInfo
>
> The following number is not related to taxes.
> ROC NUMBER - Used while filing a yearly fee to the government
>
> Hence, I believe, the new entities and relationships mentioned by me are
> needed for the following reasons.
> * Not all the required legal numbers for the company are for Tax purposes.
>
> Please suggest
>
> Thanks
> -Aswath
>
>
>
> On Wed, Jun 10, 2009 at 2:25 PM, David E Jones <[hidden email]> wrote:
>
>>
>> This email should go on the dev list since it seems to involve an
>> extension to OFBiz itself.
>>
>> Please write an email to that list on the topic. This email will do,
>> although I suggest some changes to take into consideration the existing
>> "PartyTaxAuthInfo" entity (look at the entity def and demo data especially,
>> as well as the Tax Authority docs on docs.ofbiz.org).
>>
>> -David
>>
>>
>>
>> On Jun 10, 2009, at 2:02 AM, aswath narayana wrote:
>>
>>  Hello All,
>>>
>>> Proposal to add company related legal numbers.
>>> When setting up an internal organization/company, the company requires
>>> few
>>> legal numbers.
>>> For example, for an Indian company, the following are required.
>>> 1. PAN number
>>> 2. Sales Tax Registration number
>>> 3. ROC - Registrar of companies registration Number
>>>
>>> Use cases
>>> * Used while filing forms and returns
>>> * Useful while reporting
>>> * It is also handy for accountants to look up the various numbers in the
>>> system,
>>> rather than going to papers and then finding the numbers.
>>>
>>> Entities required:
>>> LegalNumberType Table
>>> * LegalNumberTypeId - varchar (50)
>>> * description
>>> Example of rows:
>>> SALESTAX_NUMBER, Sales Tax Number
>>> PAN_NUMBER, Pan number
>>>
>>>
>>> PartyLegalNumber Table
>>> * PartyId
>>> * LegalNumberTypeId
>>> * Number - varchar (255)
>>>
>>> PartyLegalNumber has 1-many LegalNumberType relation
>>> Example of rows:
>>> Company, SALESTAX_NUMBER, 234543
>>> Company, PAN_NUMBER, AZ09-76
>>>
>>>
>>> Screens modifications:
>>> Add a section PartyLegalNumber in the Party Profile screen.
>>>
>>> Please send your input.
>>>
>>> Thanks
>>> -Aswath
>>>
>>
>>
>

[Ashish Vijaywargiya-5]

If you are asking question then Yes PAN_NUMBER is a must for a companies
filling the income tax return in India.

--
Ashish

aswath narayana wrote:
> Can someone please lookinto this.  PAN_NUMBER is a must for the
> internalorganization/vendor/supplier/customer in India.
>
>
> Thanks
> -Aswath
>
>
>  

[David E. Jones-2]

I'd recommend using the TaxAuthority and related entities for all of  
these. If the ROC number is not related to taxes then think of the  
"TaxAuthority" as a general "GovernmentAuthority"... either way the  
data model would look about the same so you can almost certainly use  
these existing entities.

-David


On Jun 12, 2009, at 1:02 AM, aswath narayana wrote:

> Can someone please lookinto this.  PAN_NUMBER is a must for the
> internalorganization/vendor/supplier/customer in India.
>
>
> Thanks
> -Aswath
>
> On Thu, Jun 11, 2009 at 1:46 PM, aswath narayana <[hidden email]
>> wrote:
>
>> Per David's suggestion, I looked into PartyTaxAuthInfo and related
>> entities.
>> Currently the tables having *tax* are strictly related to tax  
>> authorities
>> and participate in the business transactions
>>
>> SALESTAX_NUBMER - Used while paying the sales tax back to the  
>> government
>> This will fit into the PartyTaxAuthInfo
>>
>> PAN_NUMBER - Used while paying TDS (Tax deducted at source) to  
>> government.
>> This is not applicable during sales and service.
>> I am not sure whether this belongs to PartyTaxAuthInfo
>>
>> The following number is not related to taxes.
>> ROC NUMBER - Used while filing a yearly fee to the government
>>
>> Hence, I believe, the new entities and relationships mentioned by  
>> me are
>> needed for the following reasons.
>> * Not all the required legal numbers for the company are for Tax  
>> purposes.
>>
>> Please suggest
>>
>> Thanks
>> -Aswath
>>
>>
>>
>> On Wed, Jun 10, 2009 at 2:25 PM, David E Jones <[hidden email]> wrote:
>>
>>>
>>> This email should go on the dev list since it seems to involve an
>>> extension to OFBiz itself.
>>>
>>> Please write an email to that list on the topic. This email will do,
>>> although I suggest some changes to take into consideration the  
>>> existing
>>> "PartyTaxAuthInfo" entity (look at the entity def and demo data  
>>> especially,
>>> as well as the Tax Authority docs on docs.ofbiz.org).
>>>
>>> -David
>>>
>>>
>>>
>>> On Jun 10, 2009, at 2:02 AM, aswath narayana wrote:
>>>
>>> Hello All,
>>>>
>>>> Proposal to add company related legal numbers.
>>>> When setting up an internal organization/company, the company  
>>>> requires
>>>> few
>>>> legal numbers.
>>>> For example, for an Indian company, the following are required.
>>>> 1. PAN number
>>>> 2. Sales Tax Registration number
>>>> 3. ROC - Registrar of companies registration Number
>>>>
>>>> Use cases
>>>> * Used while filing forms and returns
>>>> * Useful while reporting
>>>> * It is also handy for accountants to look up the various numbers  
>>>> in the
>>>> system,
>>>> rather than going to papers and then finding the numbers.
>>>>
>>>> Entities required:
>>>> LegalNumberType Table
>>>> * LegalNumberTypeId - varchar (50)
>>>> * description
>>>> Example of rows:
>>>> SALESTAX_NUMBER, Sales Tax Number
>>>> PAN_NUMBER, Pan number
>>>>
>>>>
>>>> PartyLegalNumber Table
>>>> * PartyId
>>>> * LegalNumberTypeId
>>>> * Number - varchar (255)
>>>>
>>>> PartyLegalNumber has 1-many LegalNumberType relation
>>>> Example of rows:
>>>> Company, SALESTAX_NUMBER, 234543
>>>> Company, PAN_NUMBER, AZ09-76
>>>>
>>>>
>>>> Screens modifications:
>>>> Add a section PartyLegalNumber in the Party Profile screen.
>>>>
>>>> Please send your input.
>>>>
>>>> Thanks
>>>> -Aswath
>>>>
>>>
>>>
>>