Hi,
I need help in identifying overlaps in the invoice data I have entered.
In my scenario, I have an invoice data entry form with invoice no period from, period to and amount. My table structure is
Now when I submit the data I have data successfully going in.
However I need help with another flow where when user Submits the form the data goes in and also flags an Overlapping error message if there are other invoices within Same Period From and Period To date ranges for that customer only
Any help will be highly appreciated.
Thanks in advance