Currency, Date & Time Display

AyaNova does not decide how to display currency symbols or how many digits are shown in currency, or what format of Date or Time to use.

AyaNova instead “asks” your computer’s operating system, Windows, what to use immediately before the AyaNova program opens and displays exactly as Windows “tells” it to.

If the currency symbol and format, or your Date or Time are not displaying how you want them to in the AyaNova program the change needs to be made in your Windows Control Panel's Regional Settings

If the currency symbol, or date or time is displaying incorrectly in a report, it may be due to your Windows Control Panel setting – check first – or it may be that the symbol is preset in the report template, and you just need to customize the setting in the report template for that specific data field in that report template. Refer also to the AyaNova Support Forum section on report templates.

NOTE: Your Regional Settings for Time should include seconds so that you can select specific date/time when filtering on such columns as the Service Date in a workorder, the Labor's Service Start Date & Time, a PO's Ordered Date, a PO Receipt's Received Date, etc

•	Certain date fields are automatically pre-entered for you when you perform something.

•

For example - when you create a new service workorder, the Service Date defaults to today's date and time (including seconds); or when you place a PO on order, the Ordered Date is automatically taken from today's date and time (including seconds); or when you receive parts from a PO, the Received Date is automatically taken from today's data and time (including seconds)

•	Because the date and time are stored internally in the database including seconds, for you to be able to select a specific date/time to filter by, you must be showing the seconds so that the filter results include the specific record date.

•	Otherwise, if you do not have seconds displaying, your filter results may show nothing.

Time zones and their relation to how you have connected to the AyaNova database:

All dates/times in AyaNova are stored in the AyaNova database in GMT. How they display to the user depends on the time zone of that users computer if connecting via a direct network connection configuration. If connecting via anything else (WBI, MBI, data portal) than the time zone of the server where the database resides is used.

•	The AyaNova database is configured for network use in an office in California (Pacific Time Zone).

•	The time right now is 12:00PM (noon) Pacific Time Zone on the server where the AyaNova database resides.

•	Bob the dispatcher is connecting to the AyaNova database from within the local area network of this office using the network SQL connection configuration in his config.txt file.

•	His workstation also says 12:00PM as he is of course on the same time time zone and the same time as the server being in the same local area network.

•	Bob creates a new workorder and enters the Request Date/Time as today 12:00PM (noon) and saves the workorder.

•	Do note that although Bob has entered 12:00PM into this field, it is actually saved in the AyaNova database as 7:00PM GMT so that it can be converted from GMT to whatever time zone used.

•	Ryan another AyaNova user is in New York (Eastern Time Zone) where it is 3:00PM right now on his computer

•	Ryan connects to the AyaNova database in California via a data portal connection configuration in his config.txt file

•	Although at Ryan's computer it is actually 3:00PM, the Request Date/Time will show as 12:00PM to him.

•	Sally another AyaNova user is also in New York (Eastern Time Zone) where it is 3:00PM right now on her computer

•	Sally connects directly to the AyaNova database in California via a high speed VPN network connection using the network SQL connection configuration in her config.txt file.

•	This is because Sally is connecting via a network connection configuration, and therefore the time zone of Sally's computer dictates what time zone to use for display.