I need to code an invoice to a beginning date and an ending date but this is connected to another form Journal which will keep track of the amount. How should I be coding this?
Not sure what you mean?<br>Code an Invoice to a beginning Date?<br>How can an Invoice have 2 dates?<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
The Invoice has an InvOpen Date and an InvClose date that way when the person pays off the particular bill it closes.<br><br>If curDebit =0 and curCredit = 0 then<br> InvClose = Date()<br>End if<br>
I think you mean in the Expression Builder may be something like this would work<br><br> IIf([curDebit]=0 and [curCredit]=0,[InvClose]= Date()<br><br>It seems that InvClosed would be a y/n field.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.