How the Invoice Date is Generated

Back to Better Together - Revenue Interface

1 Invoice Day
2 Invoice Date Construction

REVU066 generates the invoice date as follows:

Invoice Day

For payables transactions, the value for invoice day is obtained from the system default REV_INT_PAYABLE_INVC_DAY. If this value is NULL, the value of 13 is used. For receivables transactions, the value for invoice day is obtained from the system default REV_INT_RECEIVABLE_INVC_DAY. If this value is NULL, the value of 13 is used.

Invoice Date Construction

System Default: REV_INT_INVOICE_DATE_SOURCE	YEAR	MONTH	DAY

System Default: REV_INT_INVOICE_DATE_SOURCE	YEAR	MONTH	DAY
Blank	Use today’s date on all invoices.	Use today’s date on all invoices.	Use today’s date on all invoices.
PROD_DATE	YY – PROD_DATE on interface file	MMM = PROD_DATE on interface file	DD = Invoice Day (as above)
ACCT_PER_DATE	YY – Accounting Period Date	MM – Accounting Period Date	DD = Invoice Day (as above)
ACCT_PER_PLUS_nn (where nn = any integer)	YY – Accounting Period Date	MM – Accounting Period Date plus nn months *	DD = Invoice Day (as above)
ACCT_PER_MINUS_nn (where nn = any integer)	YY – Accounting Period Date	MM – Accounting Period Date minus nn months *	DD = Invoice Day (as above)