Division Mapping of Product¶

Requirement Overview¶

This feature enables the mapping of specific product groups and products to different divisions. It ensures that one division can access certain products, while another division cannot select those products if it is mapped. This functionality helps manage product access across divisions.

Database Changes¶

This feature is controlled by setting divisionWiseItemFilter.

• If divisionWiseItemFilter = 0,
  • Division Mapping field should be hidden when creating a product or product group.
• If divisionWiseItemFilter = 1,
  • Division Mapping field should be displayed when creating a product or product group.

Functional Requirement¶

Requirement1: When a user creates or edits a product group, the division mapping field should be displayed within the product group where the user can mapped the desirable division for the product.

Requirement 2: When a user creates a product under a mapped division product group:

• The main group division must be shown in the product's division field if there is no subgroup.
• If a subgroup is mapped to a division, the corresponding subgroup division should be displayed in the product's division field instead of the main group division.
• The mapped division can be adjusted based on client needs.
• If the product group mapping differs from the selected division for the product, the selected division will take priority and be designated as the product division.

Requirement 3: The user can map divisions using a dropdown while creating or editing the product group or product.

• If no division is mapped, all divisions will have access to the created product group or product . In this case, the database will save the value as NULL in Menuitem.divisions.
• If the user maps a specific division, the product group or product will be visible only to that mapped division, and the mapped division ID will be stored in Menuitem.divisions.
• If multiple divisions are selected, the product group or product will be accessible to all the mapped divisions. The mapped division IDs will be stored as a comma-separated list in the database table Menuitem.divisions
  Requirement 4: This feature is intended for implementation across all modules, but it is currently applied only in the sales module. Products Selection Box should be filtered by division mapping in the product.

Application Flow:¶

• Step 1 : Create a product group and map the division to the created product group.
• Step 2: After saving the product group, create the product list within that product group. The mapped division should be stored in Menuitem.divisions.
• Step 3 : When a user creates a product under the division mapped product group then the division mapped in the group should be reflected in the product division field.
• Step 4 : Users can alter division as per the requirements and save it then the mapped division will be stored in Menuitem.divisions.
• Step 5: When the user creates any transaction form, the products should be filtered by mapped outlets in the system.