Can you elaborate on this with some examples? I have an invoices table and a payment table but my concern is when the payment is a partial payment and does not cover the entirety of one invoice - how do i still show a remainder on that order?
Can you explain this further? The split application of payments is pretty regular for me so i dont know if the third table option is a viable solution.
Is there a way to use this same formula and only base this just off the time and not the date? For Example I am trying to create the logic: If an order is submitted before 2pm on any day, then that day counts toward the orders turn around time. If an...