I have a layout in which invoices can be marked via a radio button selection "Paid" or "Unpaid." I am trying to write a script that will only print the invoice if it has been marked as paid, if unpaid send a message to the user (custom dialog box) that the invoice is not yet paid, but I do not know the correct syntax. I have been trying to use an "if" statement, but that is not working for me. Any help would be appreciated. Thanks!

6 minutes ago, charisse said:

I am trying to write a script that will only print the invoice if it has been marked as paid, if unpaid send a message to the user (custom dialog box) that the invoice is not yet paid

Do you mean the current invoice?

Or do you mean all of them that has been printed so you can omit them from the current print job?

Yes, I mean the current invoice.

Ok, then why wouldn't a simple:

If [Invoices::PaidStatus = "Paid"]
  # DO YOUR PRINT HERE
Else
  Show Custom Dialog [..]
End If

work for you?

--
P.S. IMHO, the status of an invoice as paid should be a result of recording the actual payment (or payments).

I will give that a try. Thanks!

P.S. I agree about the invoice status. Unfortunately, that is just a small part of a much larger problem. We have one solution for inventory management and a separate (independent) solution for each "sales event." They do not seem to communicate with each other very well. The invoices live with the event. The invoice status lives with the inventory, I am assuming because the inventory would not know where to go to get the status because of the many "events." I am sure this is all very confusing, I find it quite overwhelming at times myself.

I inherited this solution, I did not design it.