Great Plains Date and Time

What time is Great Plains using in Service Call Time sensitive field? if we 
have different time zones and Each Time Zones is using a specifice Server, 
whihc date/time is used by Great Plains. Is it the User Profile time or the 
SQL Server System time.


esage (22)
12/22/2008 12:51:00 AM
greatplains 29623 articles. 3 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 42

When a new service call is created, the time zone will be defaulted to the 
base time zone stored in the SVC_Master_Defaults table (SVC00998) and defined 
in the Service Setup window (Microsoft Dynamics GP > Tools > Setup > Project 
> Service). However, when the customer is selected, the Service Call will 
change time zone to that of the customer if one has been defined under the 
Customer Extensions window (Cards > Service Calls > Customer Extensions) for 
that customer. 

The time however, seems to be read directly off the user's system time and 
not off the server. 

Best regards,
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at

"esage" wrote:

> What time is Great Plains using in Service Call Time sensitive field? if we 
> have different time zones and Each Time Zones is using a specifice Server, 
> whihc date/time is used by Great Plains. Is it the User Profile time or the 
> SQL Server System time.
> Thanks
> ems
MarianoGomez (3440)
12/22/2008 3:26:01 PM

Similar Artilces:

Why do my MS Project 2007 dates revert to circa 1984 dates?
Hi, For some reason my project start and finish dates keep reverting to '1984' based dates...e.g '1/2/1984' Anyone know why this is happening? I've seen this behaviour in previous versions of the product (like MSP 98) but thought this would have been resolved in 2007. To recreate this error. 1. Create a new task in MSP and do not specify a start and finish date 2. Attach a precedessor to the task 3. Click save 4. Delete the predecessor and voila! Dates revert to xx/xx/1984. I've notice that this behaviour appears for some users and not others, ...

Date last filled...
Hi all :-) Access 2007, Vista Ultimate SP2 32 bit I have a data entry form for entering prescription information. In need = to be able to enter the date that the existing prescription was last = filled. . I am in need of a means to look up the name of the prescription selected = in the combo box for that field, and display the date that prescription = was last filled for the new entry before it is saved. I am not sure how = best to have it look up the data in the table.=20 Field name in the table is LastFilled and is a Date/Time data type. The = current ControlSource is the ...

X Axis date
Excel 2000 I have a chart with the dates of the month on the top row. the next two rows have figures that are totalled on the 4th row (two types of the same size product). The fifth and 6th row have data on different sizes product. DATE 1 2 3 4 5 6 7... 2X8C 2 1 4 5 1 2X8S 1 6 4 1 3 TOT 3 7 8 6 4 2X6 1 1 1 1 1 2X4 2 2 2 2 2 I want the date to show on the X axis and the last 3 rows to be the plot area. I've tried hiding rows 2 and 3, but that didn't work. Any ideas? TIA, Carole O Assuming your sample data ...

Need help to identify if a specific date falls within a date range
Hello, Using Excel 97 on WINNT. Column C contains a start date (for example 20/12/2004 ) and column an end date (for example 31/12/2004) for about 3000 entries. Is there a formula or function I can apply to identify if the dat 30/12/2004 falls within this range, please? I have looked at Chi Pearson's and David McRitchie's sites but am unable to see anythin which applies to this problem (or maybe I'm just thick ... hmmm .. could be something in that). Any assistance would be greatly appreciated. TIA. Lee Jeffery : -- Lee Jeffer ----------------------------------------------...

Calculating elapsed time
What is the best way to store a time value in a text file and then use that data to determine the amount of time elapsed since a particular operation was performed? I am also wondering if the following applies to my situation. It is not recommended that you add and subtract values from the SYSTEMTIME structure to obtain relative times. Instead, you should a.. Convert the SYSTEMTIME structure to a FILETIME structure. b.. Copy the resulting FILETIME structure to a LARGE_INTEGER structure. c.. Use normal 64-bit arithmetic on the LARGE_INTEGER value. I am not referring to GetTickCo...

Date and hourly time of use
I have the start date, start time and end time for procedures throughout each day for 13 procedure rooms. I need to come up with an average number of rooms that are being used for every hour of the day for each week over a period of three months. Knowing the start and end times I have the duration of each procedure in a room. I can indicate the hour of the procedure starting but how to indicate the additional hours as being in use is where I am stuck. Ex. Start date is 12/5/07 start time is 2247 and duration is either 276 minutes or 4.6 hours. How would I indicate that the 2300 hour,...

DATE.DIFF results in French
I am use the DATE.DIFF function to return the time elapsed between two dates and the results come back in years, months, days. But not in English, the results say "1 an 2 mois 3 jour". Is there any way to fix this? Thanks. Hi jenhow Maybe you use a function from a Add-in ? Try this one from Norman Harker with the dates in B5 and C5 You can add text yourself =DATEDIF(B5,C5,"y") & " y " & DATEDIF(B5,C5,"ym") & " m " & DATEDIF(B5,C5,"md") & " d" -- Regards Ron de Bruin &...

charts with date...
Had a question in training today... I have a chart as a separate worksheet. When I print this chart, I want to see the date it was printed ON THE CHART. How do I put the system date (something like =today()...) on the chart itself so that it updates to the current date for printing, etc.? preview the chart for printing use SETUP | HEADER/FOOTER use CUSTOM HEADER (or FOOTER) option to include date is available. >-----Original Message----- >Had a question in training today... > >I have a chart as a separate worksheet. When I print this >chart, I want to see the date it w...

Replacating successive dates a week at a time?
My work week starts on Tuesday. I would like to have my worksheet show column A-1 row starting with the date 05/25/04, the A-2 cell immediately below it 06/01/04 and so on. Can I replicate this with out having to type the date for each successive Tuesday through the year? With appreciation Jerry (newbie to Excel) Hi Jerry, Assuming, A1=05/25/04 Put this formula in A2 and copy it down as far as you need to: =A1+7 Hope this helps! In article <unNAalPREHA.3528@TK2MSFTNGP09.phx.gbl>, "JER" <jer@home> wrote: > My work week starts on Tuesday. I would like to h...

Great Plains and RMS
I've upgraded our RMS systems to service pack 3. We now have the option of selecting the GP accounting option. It looks like we have to download an add-on for Great Plains.. Is this true ? The one out there only says for import to GP 7.5 We are currently running GP 8.0. Will it work for this version? Do I even need this add-on, now that you can select the GP accounting option? Scot, KB 893330 discusses integration with GP 8.0, but the links are broken for the download. If my memory is correct, there was talk about a 10/01/05 release date. -- * "Scot S" <ScotS@discussio...

Count dates until complete or Cancel
(Excel 2003) Is there a way to calculate the days and then stop the counting when you have entered a completion date and/or cancelled appears in the "Status column? I want the duration column to keep calculating the days until either a date is enter into the "Completion Date" Column or the "Status" Column has cancelled or completed in it. Start Date Completion Date Status Duration 3/24/10 9 3/15/10 3/20/10 Cancelled 5 -- ...

What is this great plains?
The website is down and i want to install CRM but find everywhere links to greatplains. Is the essential, just an add-on......? ...

Include 1-x columns in @Sum depending on date
I have 12 columns, one per month The formula for the Total Column should include only the columns to represent a year-to-date total. How would I do this? Jan Feb Mar Apr May 1 1 1 1 1 In March the total would be 3, in April the total would be 4. ...

Outlook 2002 server time out
Network Setup: DC = NT 4.0 SBS with Exchange 5.5 Internet E-mail = Outside Host Workstations = 3 Windows 2000 5 Windows 98 Machine at Question Windows XP Professional Equipment list On XP Machine: AMD XP 2000 CPU ABIT Motherboard 2 x 256 DDR 2100 OS = XP Professional SP-1 Office XP Standard SP-1, SP-2 3com Nic Problem: When opening outlook checking mail, everything is ok untill you have a file with a 1 meg+ attachment, At that point the machine seems to stall and you must hit cancel -> at that point you can hit send and receive again and you will get all the same...

Collection management Time Zone Setup
It appears that when you install the CM module, you have to manually update the Collection info screen per customer for the time zone. Anyone have an easier way? I would think that seeing as this looks at RM tables, wouldn't it be wonderful to have the system KNOW what time zone the customer is in based on the state. What happens to customers who have several hundred or thousands of customers? Am I missing something? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I...

plain text #6
Does some one now if there is an option in Outlook XP to read messages by default in plain text? In Outlook express there is such an option but I can not find it in Microsoft Outlook. Thank you There is an add-in that allows this - --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching and finding no answer, Jacob asked: | Does some one now if th...

How do I calculate the # of business days between two dates?
I know absolutely nothing about coding. Trying to use calculations in a report or query to accomplish this. Everything else I have found seems to include "coding" that goes way beyond my capabilities. Anything a novice can use? You need to use code: You can call this function in a query 1. make the function a Public Function In the query have a column like this WorkDaysCalc: Work_Days([StartDate],[EndDate]) where [StartDate] and [EndDate] are actual fields in your query. Everyone starts out a "Novice" but the m...

This is a great newsgroup glad I found it. hope to learn a lot here and natrally also to contribute. There are more things in heven and earth tan we know --- MAF Anti-Spam ID: 20070608110655W6g5FqZ2 ---- Posted via - Premium Corporate Usenet News Provider ---- offers corporate packages that have access to 100,000+ newsgroups ...

It takes SO LONG TIME to open a query in design mode
Why does it take SO LONG TIME to open a query in design mode? I can understand that it takes a long time to run a query that returns millions of records. But why won't it quickly open in design mode? (MS Access 2003 on Windows XP) What type of query? All queries or just some queries or just one specific query? Where is the data physically located? On your computer? On a network server? If you are talking about a query that is using a crosstab query as a source then Access has to figure out what fields are generated by the crosstab before it can open the query usin...

Back Dating (Counting Backwards)
I was trying to use the following formula to come up with a date 40 work days prior to the date specified in cell AN2. The following formula works great except I work 4X10's (Mon - Thur) and this formaula is counting Friday. =IF(AN2="","",WORKDAY(AN2+(WEEKDAY(AN2)=5),-40,holidays)) Is there a variation of this formula that will do the same thing except just count Mon thru Fri? Or is there a better formula that will take care of my problem? Thank you, Aviator Aviator, Simplest would be to add every Friday to your list of holidays.... HTH, Bernie MS Excel MVP ...

Good morning, My brain is in drain mode today, so I am asking for your expert help. Spreadsheet : Column F contains dates in each row - dates vary from any date in 2009 to any date in 2011. Column U ~ BO Header row contains dates to the first of each month ( U = 09/11, W = 09/12, X = 1/10 ) formated to show m/y. I have played with the IF - statement, but I'm not getting what I need. I would like to have the cell under each m/y to place that date in, IF it falls within that month/year... or IF it falls between the m/y of the column to the left and the column to the right - ...

Great Plains
Hello, I have a report made in Crystal for purchase orders. I want to open this report when I click on print button from "Purchase Order Entry" window. Any help is welcome. Radu. The easiest thing would be to purchase one of the third-party modules that are available. One tool is from Accountable Software called Forms Printer. Another tool is Crystallizer. I cannot remember who makes it, though. -- Charles Allen, MVP "Radu LP" wrote: > Hello, > I have a report made in Crystal for purchase orders. I want to open this > report when I click on print butto...

Date and time in a backup file name
Hi, I have the small T-SQL script below to backup my databases: Here is a snippet: BACKUP DATABASE [model] TO DISK = N'G:\SAVE\SQLSRV\MSSQL10.MSSQLSERVER\MSSQL\Backup\model\model_backup_2010_07_05_212931.bak' WITH NOFORMAT, NOINIT, NAME = N'model_backup_2010_07_05_212931', SKIP, REWIND, NOUNLOAD, STATS = 10 how to get timestamp automatically generated on execution ? Thanks in advance > how to get timestamp automatically generated on execution ? You can build the desired filename in a variable for use in the BACKUP command: DECLARE @Bac...

Implemeting Portals in Great Plains?
Hi All, What are the requierments to implement Portals for Great Plains for other branchs to be able to access it online through the internet? Does Microsoft provide a While Papers for Portals Deployements Guide ? Thanks, Habibalby There are a few white papers concerning Business Portal, a Sharepoint-based portal. You may want to log into CustomerSource and review them. "MS GPS" <> wrote in message news:eM4O6bTxFHA.3856@tk2msftngp13.phx.gbl... > Hi All, > > What are the requierments to implement Portals for Great Plains for other > br...

Faxing via desktop from Great Plains (customer invoices,etc.)
We have the need to fax from our desktops. We are on Great Plains 8.0. Examples are customer invoices. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.