Calendar Summary
The Fiscal Year Date Dimension organizes dates according to the fiscal-year settings stored in the QuickBooks company file. It supports detailed QQube data models and flexible-period financial statements.
Calendar Type Combined calendar and fiscal date | Date Represents Company fiscal-year date |
QuickBooks Source Company Report Information | Scope Detail and flexible-period models |
Included Data Models Customers: Sales, Open Sales Orders, Accounts Receivable Operations: Purchases, Open Purchase Orders, Accounts Payable, Inventory, Job Cost Details, Time Tracking, Payroll Finance: General Ledger Detail, Profit and Loss Detail, Cash Position, Profit and Loss Flexible Period, Balance Sheet Flexible Period, Profit and Loss by Class Flexible Period Auditing: Audit Trail | |
QuickBooks Source
The fiscal-year settings come from the Company Report Information in QuickBooks.
Combined Calendar Dimension
Beginning with QQube Version 10, the Fiscal Year Date and Calendar Date structures are combined into one calendar dimension.
Monthly-period financial models use the company fiscal-year information automatically.
Available Fields
The following fields are included in the Fiscal Year Date Dimension.
| Display Order | Field Name |
|---|---|
| 1 | FiscalYr Txn Date |
| 2 | FiscalYr Formal Date |
| 3 | FiscalYr Day of Week |
| 4 | FiscalYr Day of Week Abbr |
| 5 | FiscalYr Day is Weekend Day |
| 6 | FiscalYr Day is Holiday |
| 7 | FiscalYr Day Holiday Name |
| 8 | FiscalYr Day is Working Day |
| 9 | FiscalYr Day Number in Week |
| 10 | FiscalYr Day Number in Month |
| 11 | FiscalYr Day Number in Quarter |
| 12 | FiscalYr Day Number in Year |
| 13 | FiscalYr Week Begin Date |
| 14 | FiscalYr Week End Date |
| 15 | FiscalYr Month Name |
| 16 | FiscalYr Month Abbr |
| 17 | FiscalYr Month Begin Date |
| 18 | FiscalYr Month End Date |
| 19 | FiscalYr Month Year |
| 20 | FiscalYr Fiscal Month Number |
| 21 | FiscalYr Month Number in Quarter |
| 22 | FiscalYr Calendar Month Number |
| 23 | FiscalYr Quarter Begin Date |
| 24 | FiscalYr Quarter End Date |
| 25 | FiscalYr Quarter Number |
| 26 | FiscalYr Quarter (FQ) |
| 27 | FiscalYr Quarter (Q) |
| 28 | FiscalYr Quarter-Year (FQ) |
| 29 | FiscalYr Quarter-Year (Q) |
| 30 | FiscalYr Year Begin Date |
| 31 | FiscalYr Year End Date |
| 32 | FiscalYr Year Number |
| 33 | FiscalYr Year (FY) |
| 34 | FiscalYr Calendar Year Number |
| 35 | FiscalYr Year (Y) |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article