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 <[email protected]
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 <[email protected]> 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





Reply via email to