Proposal to add company related legal numbers

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

Proposal to add company related legal numbers

aswath narayana
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
Reply | Threaded
Open this post in threaded view
|

Re: Proposal to add company related legal numbers

David E. Jones-2

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