Date Details

Version 30

Date Details

CLEARIFY ®

Published: 3/5/2012

CLEARIFY ®

Updated: 4/28/2017

0
17472

Avg: 0 / 5 (0votes)

Handling Dates

Calendar Image

QQube Technology contains special Date DIMENSIONS that allows for multiple variations of a single date, e.g. Weekday name, Month name, day in year, day in quarter.

Beginning in Version 6.1 QQube adds single date fields, because tools like Microsoft Excel and Microsoft PowerBI have added dimension-like features directly in their tools, thereby lessening the need for the QQube Date DIMENSION fields.

QQube 6.1 Single Date Folders

However, QQube still includes the Date DIMENSIONS, for legacy purposes, and for times when the application does not have the date dimensioning capability.

DATE / DATE DIMENSION	ANALYTIC	WHERE USED
52/53 Tax Year Dates	Sales Purchasing Inventory Management General Ledger Detail Profit and Loss Detail Audit Trail	QQube created
Asset Purchase Date Asset Sales Date Asset Warranty Date	Fixed Assets	Fixed Asset
Audit Trail Date	Audit Trail	Audit Trail
Billed Date	Sales Accounts Receivable Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Audit Trail	Statement Charge
Due Date	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position Audit Trail Sales Tax (USA)	Bills Credit Memo Statement Charge Estimate Invoice Purchase Order Sales Order Sales Receipt Vendor Credits
Effective Payroll Date	Payroll	Paycheck Payroll YTD Adjustments Liability Adjustments Payroll Liability Check
Estimate Date	Job Cost Details	Estimates
Expected Date	Purchasing Open Purchase Orders Inventory Management Job Cost Details Audit Trail	Purchase Orders
Fiscal Year Dates	Sales Purchasing Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Audit Trail
Forecast Date	Inventory Management	Combination Sales Order Ship Date Purchase Order Expected Date
Fully Paid Date	Sales Purchasing Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Sales Tax (USA)	Invoice Statement Charge Bill
Job End Date Job Projected End Date Job Start Date	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail Sales Tax (USA)	Job Information
Liability Period End Date Liability Period Start Date	Payroll	Payroll Liability Check
Pay Period End Date Pay Period Start Date	Job Cost Details Payroll	Paycheck Payroll YTD Adjustment Liability Adjustment Liability Check
Service Date (Line)	Sales Accounts Receivable Purchasing Open Purchase Orders Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position Sales Tax (USA)	Invoice Credit Memo Sales Receipt Purchase Order
Ship Date	Sales Open Sales Orders Accounts Receivable Inventory Management Job Cost Details Cash Position	Invoice Credit Memo Sales Receipt Sales Order
Suggested Discount Date	Sales Accounts Receivable Purchasing Accounts Payable Inventory Management Job Cost Details Cash Position	Invoice Bill
Transaction Date	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail Sales Tax (USA)	ALL except Vehicle Mileage and Fixed Assets
Trip End Date Trip Start Date	Job Cost Details Vehicle Mileage	Vehicle Mileage

Attachments

Comments (no comments yet)

Add a new comment

Date Details | CLEARIFY

How-To Guides

Date Details

Handling Dates

Comments (no comments yet)

Search How-To Guides

Pages

Analytics

Solutions

Resources

Questions?

The company

Date Details | CLEARIFY

How-To Guides

Date Details

Share

Handling Dates

Comments (no comments yet)

Search How-To Guides

Pages

Analytics

Solutions

Resources

Questions?

The company

Loading ...