charisse Posted February 28, 2016 Posted February 28, 2016 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!
comment Posted February 28, 2016 Posted February 28, 2016 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?
Lee Smith Posted February 28, 2016 Posted February 28, 2016 Or do you mean all of them that has been printed so you can omit them from the current print job?
comment Posted February 28, 2016 Posted February 28, 2016 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).
charisse Posted February 28, 2016 Author Posted February 28, 2016 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.
Recommended Posts
This topic is 3181 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now