Is there anyway of generated a new row based on a condition in another row.
I have an Ordering App, when the user creates an order they input an Order No which is formatted as the following
PORXXXXXX-XXX i.e. POR123456-001
The following “001” represents the delivery number, so if any items are short the same POR number can be created but it will be delivery 2 i.e. POR123456-002. This process continues until the order has been completed.
The current process is as follows:
POR123456-001 is created with requests assigned.
The delivery is received and items are marked as short, and the delivery is marked as “Incomplete” .
The buyer needs to be informed so the second delivery can be created.
Once the buyer is informed, the copy the requests and input the follow up qty.
They copy the Order and change the delivery number and ETA.
This all takes significant communication, so we introduced some reports to collate the orders that require any follow up e.g. the orders marked as incomplete.
But I was wondering would it be possible to either automatically create the follow up if the order is marked as incomplete or a way to know that another delivery is created so the buyer can ignore the report issues raised?