Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invoice taking partial payment

Status
Not open for further replies.

Ninabunny

Programmer
Jul 24, 2000
70
US
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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;InvClose = Date()<br>End if<br>
 
I think you mean in the Expression Builder may be something like this would work<br><br>&nbsp;IIf([curDebit]=0 and [curCredit]=0,[InvClose]= Date()<br><br>It seems that InvClosed would be a y/n field.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top