Customizing OpenERP Internal Reference

General information for the business: OpenERP customizations
Kind of development: Customization of existing program
Platform: OpenERP
Num. of modules: 1
Description of every module: Module: IDT Internal Reference Field

Requirement:

1. When adding or modifying a product in OpenERP Internal Reference (default_code) must be unique. Inherit product_product, add sql-constraint



2. When adding a new product in OpenERP Internal Reference must be in the format: AAA-BBBB-C where
a. AAA: first three digits (integer) of the assigned product category, readonly field
b. BBB: propose next available integer number (sequence from 1 to 9999) within the AAA category in the menu automatically. Read-write field
c. C: character A-Z, default is A, read-write field
3. When adding a new product in OpenERP also set the external ID equal to the Internal Reference. (same default_code for external_id)
Description of requirements/functionality: Module: IDT Internal Reference Field

Requirement:

1. When adding or modifying a product in OpenERP Internal Reference (default_code) must be unique. Inherit product_product, add sql-constraint



2. When adding a new product in OpenERP Internal Reference must be in the format: AAA-BBBB-C where
a. AAA: first three digits (integer) of the assigned product category, readonly field
b. BBB: propose next available integer number (sequence from 1 to 9999) within the AAA category in the menu automatically. Read-write field
c. C: character A-Z, default is A, read-write field
3. When adding a new product in OpenERP also set the external ID equal to the Internal Reference. (same default_code for external_id)
Extra notes: