New Technical Colorant Selection¶

Requirement Overview¶

This feature is designed to support customers operating paint shops by providing them with the ability to select and mix multiple colors into a base color. It is critical for these businesses, as they often need to create custom color mixtures to meet specific customer demands. The system will facilitate the selection of various colorants and ensure accurate inventory management by deducting the used colorants from the inventory.

Database Changes¶

• Introduce a new Setting “EnableColorantinTaxInvoice” where
  • EnableColorantinTaxInvoice=1
    • The Colourant Selection Box should appear.
    • Colorant rate column and color shade column should be included in the sales tax invoice
  • EnableColorantinTaxInvoice=0
    • No change needed, the colorant selection box should not be appeared and colorant rate,color shade column should be hidden from sales tax invoice

Limitation¶

• The amount of colorant can only be specified in liters since the product list cannot be altered.

UI Design¶

https://www.figma.com/design/Qpcw06ioOuKS2GPYs9CoPL/New%7C%7C_Technical?node-id=0-1&t=6BzZqBbgDBCOA3RO-0

Functional Requirement¶

Requirement 1 :Generate the Colorrant Selection Box where setting is enabled for EnableColorantinaxInvoice=1 if setting is 0 then set as default flow. Details of the UI

Color Shade Code :When you click on Color Shade Code then a pop up will open where all the uploaded color shade code will be shown. The color shade will be uploaded from the colorshade master upload(Colorant Master) from Master Configuration.
Color Shade : It is just the name of the finishing color.it will automatically upload once the user selects the color shade code.

Colorant : Colorant is the pigment color used to make color shade. Product selection box should be triggered once the user press (Enter) in the colorant cell. Product Selection Box should show menuitems from the table RMD_TAXCHARGES_CONFIG.
Quantity(ML) : This is a manual entry field for numeric values only. It represents the quantity used for creating a color shade, which the user will input in milliliters (ML) . This value will be used to calculate the Qty in Ltr.
Qty(Ltr) : It shows the quantity in Liter. When a user enters the quantity in quantity (Ml) column then it should automatically calculate ML into Liter ie: 1 ML = (1/1000 )L just for display and to decrease the stock of items as per Liter.
Unit : will be listed as per the product master base unit and it should not be altered.
Sales Rate : The sales rate should be calculated as the Retail Price excluding VAT.The Retail Price will carry forward from RMD_TAXCHARGES_CONFIG of the selected colorant.
Amount : Amount will be calculated after multiplying the Qty( Ltr) with the sales rate.

• When changing the quantity(ml) after entering once, the system should recalculate both the Qty (Ltr) and Amount accordingly.

Requirement 2: Upon clicking Apply:

• The quantity (Ltr) should be stored in the tbl TRNPROD database, but the colorant rate should not be stored for inventory deduction purposes.
• tblTrnColorantDetails should save all the list of colorant details whereas the Colorant_Norms table stores the list of colorants added by users. If a user adds a new colorant to an existing color shade, * the system should update the entry. If there is no corresponding color shade in the Colorant_Norms table, the system should insert the user's input.
• The color shade from the Colorant Selection Box should be updated in the color shade field next to the net amount in the sales tax invoice.The color shade will stored in tblcolormaster database.

Requirement 3: The Colorant Rate displayed in the invoice will be based on the (Total Amount in the Color Selection Box/Quantity mentioned in the invoice ).

• If the user wants to change the colorant after clicking on "Apply," they must go to the Colorant field and press Enter to display the Colorant box for corrections.
• All the flat discount (without vat) should be reflected into the base rate of the product.

Tax Invoice Amendment 2021/07/08¶

Requirement 4: Print Design of the sales invoice accordingly. Attached the format.

Requirement 5 : Please Add the salesman field in the Sales Tax Invoice as per the diagram below :

Application Flow¶

Step 1 : Enable the setting EnableColorantinTaxInvoice = 1.
Step 2 : User will fill all the details in the tax invoice and after filling out the quantity of sales a pop box will appear where the user will select the ‘Color Shade’.Then the user will navigate to colorant, since it is a item selection box will appear then user will select the colorant and then enter the consumed quantity in ml then quantity in Litre will auto loaded as per quantity in ml.unit will be auto loaded and sales rate will be based on the Retail Price excluding VAT.
Step 3: It will generate the total colorant consumption for a single quantity sold, Click on apply.
Step 4 : Colorant Rate will be auto filled as per the (total amount value from the Colourant Selection box/Quantity mentioned in the invoice ) .

Step 5 : The colorant rate will be displayed first. The total rate is then calculated by adding the net rate and the colorant rate. Next, VAT is calculated based on the total amount(Amt), which is determined by multiplying the total rate by the quantity in the sales tax invoice
Note : The "Amt" column's calculation for the taxable amount after discount is not matching.
Check if Total rate *qty is equal to taxable amount

Calculation
i) Individual Rate | Flat Rate should Calculate in Base Item Only. Discount is not apply in Colorant Rate
ii) Net Rate = ((Base Item Rate * Base Item Qty) - Individual Discount - Flat Discount)/Base Item Qty
iii) Total Rate = Net Rate + Colorant Rate
v) Amt = Total Rate * Base Item Qty
vi) Vat = Amt * Vat Rate %
vii) Net Amnt = Amt + Vat