Suggested Discount Date Dimension

Modified on Mon, 27 Jul at 9:42 PM

Calendar Summary

The Suggested Discount Date Dimension organizes invoices and bills by the discount date derived from their payment terms. It supports analysis of available payment discounts by day, week, month, quarter, or year.

Calendar Type

Terms-based discount date

Date Represents

Suggested payment-discount deadline

QuickBooks Source

Transaction payment terms

Primary Use

Payment-discount analysis

Included Data Models

Customers: Sales, Accounts Receivable

Operations: Purchases, Accounts Payable, Inventory, Job Cost Details

Finance: Cash Position

QuickBooks Source

The suggested discount date is derived from the payment terms assigned to an applicable QuickBooks transaction.

Source Transactions

Invoice
Bill

Source Example

QuickBooks transaction payment terms used to derive the suggested discount date

Available Fields

The following fields are included in the Suggested Discount Date Dimension.

Display Order	Field Name
1	Sug Disc Date
2	Sug Disc Date Day Holiday Name
3	Sug Disc Date Day is Holiday
4	Sug Disc Date Day is Weekend Day
5	Sug Disc Date Day is Working Day
6	Sug Disc Date Day Number in Month
7	Sug Disc Date Day Number in Quarter
8	Sug Disc Date Day Number in Week
9	Sug Disc Date Day Number in Year
10	Sug Disc Date Day of Week
11	Sug Disc Date Day of Week Abbr
12	Sug Disc Date Formal Date
13	Sug Disc Date Month Abbr
14	Sug Disc Date Month Begin Date
15	Sug Disc Date Month End Date
16	Sug Disc Date Month Name
17	Sug Disc Date Month Number
18	Sug Disc Date Month-Year
19	Sug Disc Date Quarter
20	Sug Disc Date Quarter Begin Date
21	Sug Disc Date Quarter End Date
22	Sug Disc Date Quarter Number
23	Sug Disc Date Quarter-Year
24	Sug Disc Date Week Begin Date
25	Sug Disc Date Week End Date
26	Sug Disc Date Year
27	Sug Disc Date Year Begin Date
28	Sug Disc Date Year End Date
29	Sug Disc Date Year Number