i want to insert invoice values into databade invoice amount limit and split into multiple row if amount is grater than limit and insert it indicia or group

Because you are not giving a lot of information, I cannot provide a specific solution.
Try to use a case when inserting or a trigger or use a stored procedure that handles this to insert .
Alternatively post your insert code, the db type and what is the program that will do the insert and we can probably help you to figure this out.