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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Altering the payment schedule on the fly upon invoice creation.

Status
Not open for further replies.

bstricklin

IS-IT--Management
Oct 24, 2012
1
US
I am trying to assign the 3 scheduled paydates for an invoice as well as the initial due date as shown below, the due date part is working but the paydates part which populates the scheduled payments that print on the bottom of the invoice is not. Has anyone ever tried something like this before?

IF MONTH(ttInvcHead.InvoiceDate) < 8 THEN ASSIGN
ttInvcHead.DueDate = DATE(8, 15, iInvYear)
ttInvcHead.PayDates = "5705~5736~5766".
ELSE IF MONTH(ttInvcHead.InvoiceDate) > 7 AND MONTH(ttInvcHead.InvoiceDate) < 10 THEN ASSIGN
ttInvcHead.DueDate = DATE(MONTH(ttInvcHead.InvoiceDate), DAY(ttInvcHead.InvoiceDate) + 90, YEAR(ttInvcHead.InvoiceDate)).
ELSE ASSIGN
ttInvcHead.DueDate = DATE(8, 15, iInvYear + 1).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top