Great Plains SOP Table Date Fields

I looking for clarification on what DOCDATE and ORDRDATE are in the SOP 
tables.  I believe that DOCDATE is the date the line was entered and that the 
ORDRDATE is the date that the date that the Order goes into effect.  Could 
anyone clarify this for me?
0
Hornung (1)
3/31/2006 3:48:03 PM
greatplains 29623 articles. 5 followers. Follow

1 Replies
879 Views

Similar Articles

[PageSpeed] 57

Go to the SDK and look at SOPTRX.RTF. It is the Sales Order Transaction flow 
by table and field.

"Chris Hornung" wrote:

> I looking for clarification on what DOCDATE and ORDRDATE are in the SOP 
> tables.  I believe that DOCDATE is the date the line was entered and that the 
> ORDRDATE is the date that the date that the Order goes into effect.  Could 
> anyone clarify this for me?
0
3/31/2006 5:55:02 PM
Reply:

Similar Artilces:

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...

I don't see the Pivot table field list window
Hi, I am trying to generate a chart from an excell file which contains my data. After selecting all rows and columns, I go to Data > Pivot table and pivot chart report. Wizard show that I ahve selected the Excell list and Pivot table. But when I click Finish button, it does not show the Pivot table field list window. How can I view this window to drag data for the rows and columns in order to get the report/chart. This works on my wife's computer but does not work on my computer at my work. Thanks, Zafar Hi Zafar, Most likely it has been turned off. Display the Pivot Table to...

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...

Joint Pivot Table
Can someone help, I have 2 sets of data and I prepared 2 Pivot Tables. Is there any way I can join thest 2 Pivot Tables and form 1 Pivot Table (but not joining 2 sets of data together). Thank you. Not easily no. You can always use the 'Multiple consolidation ranges' option to choose both sets of data as your source, but you probably won't like the result. Is there any reason you cant just create a third combined table if you don't want to touch the other two, and then use that as the source data for the Pivot Table -- Regards Ken....................... ...

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......? ...

Pivot Table Refresh Changes Color Scheme for Some Cells
Office 2007 XP SP3 I want to display a Pivot Table output in a certain (blue) format. When I refresh a Pivot Table, the color scheme on some cells changes, in my case from blue to orange. Any ideas? Your help is greatly appreciated. 8^> ...

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 -- ...

HLOOKUP: specify table array in a cell
I am looking to specify the range of cells for the table_array in a cell. For example: =HLOOKUP("ABC", A1, 5, 0) where A1 would contain the info on my range of cells in a different notebook. How would I do this? Thanks >where A1 would contain the info on my >range of cells in a different notebook. What do you mean by: in a different notebook? You can try it like this but if a different notebook means a different workbook (file) then that workbook (file) must be open for this to work. =HLOOKUP("ABC",INDIRECT(A1),5,0) -- Biff Microsoft Excel MVP "Melanie...

Copying All Records from a Query to a Table
Hi All, Here is another one! I have a code which copies one record from a query(TODAY CHARGES) to another table(RESPEL TEST ALL CHARGES). I want the code to copy all the records in the current query to the table. Here is the code I have: Private Sub Toggle1_Click() Dim PoseidonHotelProgram As Database Dim rsta As DAO.Recordset Dim frm As Form Dim Msg, Style, Title, Response, MyString DoCmd. Set db1 = CurrentDb() Set Myset = db1.OpenRecordset("TODAY CHARGES") Set Myset2 = db1.OpenRecordset("RESPEL TEST ALL CHARGE") Myset2.AddNew Myset2![Date] = Myset![Dat...

how to print document note on SOP history invoice
Hi; I found a KB document KB862207 to instruct me how to print document note on SOP Blank invoice form but how can I do the same for SOP History Blank Invoice form? I tried to use the same instruction to work it on SOP_HDR_HIST table but when I tried to print, no document note printed out. I cannot locate any KB document from the knowledge base. Can anyone help me? ...

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 - http://www.slovaktech.com/attachmentoptions.html --� 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 google.groups.com and finding no answer, Jacob asked: | Does some one now if th...

great
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 http://spiritualnowbusiness.blogspot.com/ --- MAF Anti-Spam ID: 20070608110655W6g5FqZ2 ---- Posted via Pronews.com - Premium Corporate Usenet News Provider ---- http://www.pronews.com offers corporate packages that have access to 100,000+ newsgroups ...

RBS and other custom fields are not in olap cubes
HI all I added RBS and other custom fields to olap cube configuration, rebuilted a cube, but those fields do not appear in any of olap cubes. Please help!!!!!!!!!!! They should, make sure they are added into the Project, Task and Assignment cubes to be sure... -- Regards, Ben. "Rimcha" wrote: > HI all > I added RBS and other custom fields to olap cube configuration, > rebuilted a cube, but those fields do not appear in any of olap cubes. > Please help!!!!!!!!!!! > . > ...

Updating tables in GP10
Hi: We need to update address tables in GP10. All of the Fields on the tables are set to null = N. Some of the address fields in our input source has nulls. What can we do to be able to get our data into the tables What is your source? CSV? TXT? a SQL table? an XML file? What tool will you be using to integrate the data? eConnect? Integration Manager? a SQL update statement? Usually, if your address has nulls in the source, you should be able to replace with a blank character ("", or '' depending on the source) not a space. Best regards, -- MG.- Mariano Gomez, MI...

SQL statement/joining tables when unequal
I'd like to join two tables, but I don't have the option to display only those entires that are not in the second table. I've been trying without any success to write an SQL statement to produce only those entries that are in one table and not the other. I've tried just modifying an inner join to be "not equal" instead of "equal": SELECT FROM [Media Outlet] INNER JOIN [Local Media Outlets] ON [Media Outlet].[Media Outlet] <> [Local Media Outlets].[Local Media Outlets]; And I get this error message: The SELECT statement includes a reserved word...

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...

Serial number field too short
We use serial numbers on a few items. We have a new item that the serial number is 2 characters longer than the field in RMS. Is there a way to increase the field length? ALTER TABLE serial ALTER COLUMN serialnumber NVARCHAR(30) ALTER TABLE serial ALTER COLUMN serialnumber2 NVARCHAR(30) ALTER TABLE serial ALTER COLUMN serialnumber2 NVARCHAR(30) "CVOswalt" wrote: > We use serial numbers on a few items. We have a new item that the serial > number is 2 characters longer than the field in RMS. Is there a way to > increase the field length? > >...

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...

Rearrange data columns in Pivot Table
In a pivot table, how do you rearrange the column order in the data section? Right now I show columns named A, B, C, and Grand Total. I want to be able to rearrange them as follows (for example): Grand Total, B, A, C. I am using Excel 2000. TIA Hi i'm not sure if you can move the "grand total" column, but the others can be easily re-arranged by just typing the names in the order you want (ensure that you don't make any typing errors though), what i mean is, click on the A heading and type B once you press enter B will now come first and A will be moved continue as req...

New Attributes not showing in mail merge fields
When I try to at newly created attributes to a mail merge I cannot see them. Custom attributes are not available for a Mail Merge with the out of the box functionality. We will consider this feature for a future release. An Issue has been entered into our tracking database. -- Jason -- This posting is provided "AS IS" with no warranties, and confers no rights. "Simon" <Simon@discussions.microsoft.com> wrote in message news:EBD6B56B-F45A-4DFA-BA53-5BF03C2244C8@microsoft.com... > When I try to at newly created attributes to a mail merge I cannot see > ...

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" <habibalby@gmail.com> wrote in message news:eM4O6bTxFHA.3856@tk2msftngp13.phx.gbl... > Hi All, > > What are the requierments to implement Portals for Great Plains for other > br...

How do I make the results of a Query into field names on a table?
I have a query with just one row of data - how do I make that row of data as the field names of an existing table? If not existing table can it be done to a new table? Can it be done at all? Regards M Chahal In query design view, choose Append on the Query menu (or in Access 2007, Append on the Design ribbon.) Access adds a row to the design grid where you can map the fields. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "M Chahal" <MChahal@discus...

Suppress Zeros in a Pivot Table
Can I suppress zeros in a Pivot Table? Many of the results are zero, how can I hide the rows without using a macro. thanks Simon Shaw You could add a column of formulas in a hidden part of the pivot table worksheet, then use it to filter the pivot table. For example, if your pivot table is in cells A3:J100, and has two row fields, enter the following formula in cell R2: =AND(A2="",B2<>"",SUM(C2:P2)=0) Copy the formula down to the last row to which the pivot table will potentially reach In cell R1, enter a heading, e.g. Filter Select cell R1, and choose D...

Read only fields based on picklist values
Hi Has anyone managed to change the fields on CRM forms to read only or not visible based on a picklist value? If so, How? Thanks Jakob msnews.microsoft.com wrote: > Has anyone managed to change the fields on CRM forms to read only or not > visible based on a picklist value? > If so, How? JScript may be a solution for that. -- J�rgen Beck MCSD.NET, MCDBA, MCSE, MCT MCP CRM Application/Installation/Customization www.Juergen-Beck.de Hi Jakob, the only event supported for the picklist is the onchange event, so you would only be able to enable/disable fields when a user picks a ...

MS Great Plains
We have Great Plains (PersonnelOracle Version 2002.03.15 3.0.6. and PowerTool 2002.03.19. 3.1.1.) installed. Previously we have used Office 2000 and the Word merge was working perfectly. Upgrading to 2002 or 2003 the Word merge stopped working, I suppose we need new templates for Word 2003 (.dot files). Who shall we contact with? Any suggestion would be appreciated! Where do Oracle and PowerTool come into the equation? Are you trying to use Word with Microsoft Great Plains? How were you doing it with Word 2000? "Zoltan Bacs" <Zoltan Bacs@discussions.microsoft.com> wrote ...