Selecting manufacturer of brand at each item in sales invoice

Hello Everyone,

I need to select brand or manufacturer at each item of the sales invoice or delivery note.
Scenario:
I have same product from different brands and different variants. I need to select the brand or manufacturer of the item on each line of the sales invoice also need to maintain stock for each item with different manufacturer.

Also Not able to add a column in item table of sales invoice.

Please help with possible solution.

Regards

ERPNext does have feature to create Item Variants based on manufacturer. Would that work ?

https://docs.erpnext.com/docs/user/manual/en/stock/item-variants

Search for Manufacturer List, add manufacturer, then create Item with variants based on Manufacturer and select when preparing Sales Invoice.