Creating a SOP transaction in TEST Company #2

I am trying to create a SOP transaction, but I keep getting the following 
error message in the TEST company:

A save operation on table 'SOP_HDR_WORK' (45).

I have tried restoring the test company from the live, but I still get this 
error message. I have also run checklinks.

Thanks,

Craig
0
Craig1 (222)
1/6/2009 2:51:01 PM
greatplains 29623 articles. 6 followers. Follow

6 Replies
853 Views

Similar Articles

[PageSpeed] 4

Craig,

Is there a More Info button on the error message?  If so, what does it say? 
What version and service pack of GP?  Is this TEST company on the same SQL 
instance as the live or a different one?

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: www.victoriayudin.com


"Craig" <Craig@discussions.microsoft.com> wrote in message 
news:A3E628B0-F881-4F2A-B14D-2786A1BE884A@microsoft.com...
>I am trying to create a SOP transaction, but I keep getting the following
> error message in the TEST company:
>
> A save operation on table 'SOP_HDR_WORK' (45).
>
> I have tried restoring the test company from the live, but I still get 
> this
> error message. I have also run checklinks.
>
> Thanks,
>
> Craig 

0
victoria (3340)
1/6/2009 3:09:22 PM
Craig,

KB article 871973 outlines the procedures to create a test company from a 
live one. You will need to follow these procedures, which include running a 
script, to be able to get your test company to work properly.

You can access the article at 
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;871973

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"Craig" wrote:

> I am trying to create a SOP transaction, but I keep getting the following 
> error message in the TEST company:
> 
> A save operation on table 'SOP_HDR_WORK' (45).
> 
> I have tried restoring the test company from the live, but I still get this 
> error message. I have also run checklinks.
> 
> Thanks,
> 
> Craig
0
MarianoGomez (3440)
1/6/2009 3:23:01 PM
There is unfortunately not a More Info button. Version GP 10.00.1237 (the 
lateset service pack). Yes, the TEST company is on the same SQL instance.

Thanks!

Craig


"Victoria [MVP]" wrote:

> Craig,
> 
> Is there a More Info button on the error message?  If so, what does it say? 
> What version and service pack of GP?  Is this TEST company on the same SQL 
> instance as the live or a different one?
> 
> -- 
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions - home of GP Reports
> http://www.flex-solutions.com/gpreports.html
> blog: www.victoriayudin.com
> 
> 
> "Craig" <Craig@discussions.microsoft.com> wrote in message 
> news:A3E628B0-F881-4F2A-B14D-2786A1BE884A@microsoft.com...
> >I am trying to create a SOP transaction, but I keep getting the following
> > error message in the TEST company:
> >
> > A save operation on table 'SOP_HDR_WORK' (45).
> >
> > I have tried restoring the test company from the live, but I still get 
> > this
> > error message. I have also run checklinks.
> >
> > Thanks,
> >
> > Craig 
> 
0
Craig1 (222)
1/6/2009 5:16:04 PM
Yes, I have run the script and followed that document. 

Thanks,

Craig


"Mariano Gomez" wrote:

> Craig,
> 
> KB article 871973 outlines the procedures to create a test company from a 
> live one. You will need to follow these procedures, which include running a 
> script, to be able to get your test company to work properly.
> 
> You can access the article at 
> https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;871973
> 
> Best regards,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "Craig" wrote:
> 
> > I am trying to create a SOP transaction, but I keep getting the following 
> > error message in the TEST company:
> > 
> > A save operation on table 'SOP_HDR_WORK' (45).
> > 
> > I have tried restoring the test company from the live, but I still get this 
> > error message. I have also run checklinks.
> > 
> > Thanks,
> > 
> > Craig
0
Craig1 (222)
1/6/2009 5:16:09 PM
I dropped and recreated auto procedures and it worked. 

Thanks for your help though!


"Craig" wrote:

> Yes, I have run the script and followed that document. 
> 
> Thanks,
> 
> Craig
> 
> 
> "Mariano Gomez" wrote:
> 
> > Craig,
> > 
> > KB article 871973 outlines the procedures to create a test company from a 
> > live one. You will need to follow these procedures, which include running a 
> > script, to be able to get your test company to work properly.
> > 
> > You can access the article at 
> > https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;871973
> > 
> > Best regards,
> > --
> > MG.-
> > Mariano Gomez, MIS, MCP, PMP
> > Maximum Global Business, LLC
> > http://www.maximumglobalbusiness.com
> > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > 
> > 
> > "Craig" wrote:
> > 
> > > I am trying to create a SOP transaction, but I keep getting the following 
> > > error message in the TEST company:
> > > 
> > > A save operation on table 'SOP_HDR_WORK' (45).
> > > 
> > > I have tried restoring the test company from the live, but I still get this 
> > > error message. I have also run checklinks.
> > > 
> > > Thanks,
> > > 
> > > Craig
0
Craig1 (222)
1/6/2009 5:22:02 PM
Excellent - thanks for letting us know!

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: www.victoriayudin.com


"Craig" <Craig@discussions.microsoft.com> wrote in message 
news:6756BA0D-8AE5-488B-8D64-2ADC0B4134B6@microsoft.com...
>I dropped and recreated auto procedures and it worked.
>
> Thanks for your help though!
>
>
> "Craig" wrote:
>
>> Yes, I have run the script and followed that document.
>>
>> Thanks,
>>
>> Craig
>>
>>
>> "Mariano Gomez" wrote:
>>
>> > Craig,
>> >
>> > KB article 871973 outlines the procedures to create a test company from 
>> > a
>> > live one. You will need to follow these procedures, which include 
>> > running a
>> > script, to be able to get your test company to work properly.
>> >
>> > You can access the article at
>> > https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;871973
>> >
>> > Best regards,
>> > --
>> > MG.-
>> > Mariano Gomez, MIS, MCP, PMP
>> > Maximum Global Business, LLC
>> > http://www.maximumglobalbusiness.com
>> > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
>> >
>> >
>> > "Craig" wrote:
>> >
>> > > I am trying to create a SOP transaction, but I keep getting the 
>> > > following
>> > > error message in the TEST company:
>> > >
>> > > A save operation on table 'SOP_HDR_WORK' (45).
>> > >
>> > > I have tried restoring the test company from the live, but I still 
>> > > get this
>> > > error message. I have also run checklinks.
>> > >
>> > > Thanks,
>> > >
>> > > Craig 

0
victoria (3340)
1/6/2009 5:57:24 PM
Reply:

Similar Artilces:

How do you make a combination chart with 2 axis.
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do I put both on same chart? Plot them both like they would be using the same Y axis. Select the one that you want on the secondary axis and format the data series. On the AXIS tab, you can select a secondary axis. "smw" <smw@discussions.microsoft.com> wrote in message news:8469123E-4ED5-443F-AA22-82360D04BD7F@microsoft.com... > I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do > I > put both on same chart? ...

Getting value from 2 cols right, 1 row down
Hi, I guess this is a simple question but I couldn't figure out how to ge around it. Code ------------------- A B C D E F 1 Worker 100 100 100 100 2 110 110 3 Worker 120 120 120 4 130 130 13 ------------------- Sheet above is a work schedule and 100, 110, 120 and 130 are jus predefined work shifts. Row 1 is a morning shift row and Row 2 is night shift row for the first worker. Now what I want to do is to create another sheet with workers names t m...

Chart: 2 lines and a bar
I have searched here and in the help file with no luck. I see it is easy to have a graph with 2 bars and a line because it i one of the standards already set up. But I need 2 lines and a bar and I cant figure out how to do it. I'm sure it is something easy, but maybe this is a brain cramp o something -- Kep ----------------------------------------------------------------------- Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3061 View this thread: http://www.excelforum.com/showthread.php?threadid=50744 Hi, Create line chart based on all three set...

Is it possible to have 2 excel version in one computer?
hi everyone i just installed a 2003 version office... i liked the new features but when i wanted to open an excel file that has been created by 2002 version excel, i was shocked that i can't open the file successfully. When i opened and enabled the built in macros in the file, an error message popped out and said that the data may have been lost. After I have closed the error message, i checked the file. the data is still in the worksheet but all the words, format, buttons, and other information have all disappeared. However, if I open it in another version other than 2003, the file work...

HTML formatting #2
One of my clients sends me email in HTML format, but it comes through in plain text. I tried going to Format>HTML, but all of the options under format are unavailable in said email. Can anyone help me? Thanks, A.Funk ...

Public Folder Permissions #2
I am having trouble removing or deleting old items from public folders and calendars. Even the Author of the files or events cannot modify or remove them. The calendar events that are problems were created months ago. All users have read write permissions for all folders and calendars.,Some have Editor or Owner and Author rights. However there are some recurring calendar items that just cannot be removed or modified by anyone. Even as Administrator with full access rights I cannot delete these events. I did upgrade from Exchange 2000 to Exchange 2003 within the last few months but I cannot s...

Cannot create credit card account
I have a credit card account with a bank. I'm trying to set up an additional credit card account with the same bank, but Money won't allow it. I get the following message: ================ The service that allows you to download transactions from MSN Money My Accounts has been disabled. Close and reopen Money. If the problem persists then try turning the service off and then re-enabling it. If the problem still persists you will need to re-enable the service with a new Windows Live ID. ================ Naturally, restarting Money has no effect. Nor does restarting Windows. I...

Find and Replace #2
Hello, I am facing a problem regarding finding and replacing, i want to change a value ":10:20" to "00:10:20". Or in other words just want to add a leading zero before the colon. I have used the wild card to locate the value but in replce it chages the value with wild card. Please Help me in this. Find > Replace > Repl;ace what: :1 Replace with: '00:1 > Replace all Vaya con Dios, Chuck, CABGx3 "Muhammad Hassan (New Excel User)" <Muhammad Hassan (New Excel User)@discussions.microsoft.com> wrote in message news:89F2F7DB-4DA9-4823-B572-E9D...

excel passwords #2
I need to know how to set up a password and change a password to prevent access to my workbook.TIA Use workbook/sheet protection. Select tools menu>protection. There you can select the type of protection you want and include a password Regards, F.I. >-----Original Message----- >I need to know how to set up a password and change a >password to prevent access to my workbook.TIA >. > ...

Order Entry #2
We have set up a password to allow price changes when entering orders because we don't want to allow everyone access to this field. I have three customers that request the password even when the salesperson isn't trying to change the price. I have checked the customer cards of these companies and I can't figure out why these three produce this message. Is there something in particular I need to be looking at? Thanks Angie Angie, What's the exact message you are getting? Are you sure you are not being prompted to override price below cost? -- MG.- Mariano Gomez,...

Publisher file #2
I am preparing (as I do every month) a magazine formatted in booklet style. Whenever I close and reopen, it's turned itself into a web page! I can reconvert it via Page setup, but when I return to work some more, it's back in web page format. Any idea why? and what can I do to stop it, please? -- -------------------------------------------- Protected by Norton Antivirus What version Publisher? -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.mvps.org/msauer/ news://msnews.microsoft.com "Lorna Dodd" <lorna.dodd@virgin.net> wrote in message news:ulvrWxi...

SMTP authentication #2
I have the Office XP (2002) Small Business Edition (it came with my Dell PC). My Internet provider requires that I check the option "My outgoing server (SMTP) requires authentication" in the Internet Mail settings. I check that option, but when I close Outlook and reopen it, that option is unchecked. I have reinstalled the Office XP SBE twice, updated it with all the updates offered in Microsoft Office Web Page but the problem persists. This problem started after I formatted the hard disk because the PC was too slow. Before there was no problem. Also some of the windows to ...

Migrate Contact Address Data from CRM 1.2 to 3.0
We are upgrading from CRM 1.2 to CRM 3.0. In order to migrate the existing data, we are using the CRM web services (in "../crmservice.asmx"). CRM 1.2 stores the contact data in the ContactBase table; I create a data source, create an instance of the "contact" object from the CRM web service, set each of the contact properties from the field values in the DataRows of the DataSet source, and then use the contact object's Create() method to add each contact to the CRM 3.0 database -- all of this works very well. However, CRM 1.2 stores the contact's address d...

creating a macro that will paste a value and then move
Please, help! I am trying to recreate a macro that opens a workbook, goes to Sheet 1, pastes clipboard info into A1, then moves to B1, then saves and closes the file. I know how to make the file automatic and how to get it to open and close (Auto_Open), but I cannot remember how to get the macro to move from cell to cell (left-to right). What happens is that when I do a recorded macro and then try to rerun it; it will paste into A1 and then will tab over to B1. Then upon the next time that I call up the spreadsheet, it will even paste to B1, but will not move further from that spot. I then...

MB5-537 Test:
anyone care to share with me the expected questions for the MB5-737 test for POS Store Operations ? I’m good in the system and I’m planning to apply to the test soon. issamfe@hotmail.com Thank you Hi, If you've been using the system on a daily basis and would consider yourself good with it, you won't have any problems at all. Now that said, I still go blank occassionally with the more complex aspects, but you won't get asked about these on the exam. I got 97% and 98% on Store Ops and HQ respectively. Good luck! T. "ISSAM" wrote: > > anyone care to sh...

XML serialization problem #2
Hi all, I'm a .NET beginner and I've got a problem on a program where I try to do an XML serialization. I get the following error : "An unmanaged exception of type 'System.IO.FileNotFoundException' occured in mscorlib.dll Additonal information : the file or asssembly named n9gu4-bo.dll or one of its dependencies cannot be found" Here is the code : (I've uploaded the complete project at this url http://netorld.free.fr/Interface2.zip) public class Form1 : System.Windows.Forms.Form { .... .... public Form1() { InitializeComponent(); try { TextReader reade...

Recievable transaction inquiry slow
Hi All, When I click inquiry(receivables transaction inquiry), it runs too slowly. Only this inquiry, others work fine. It happened from last week. My Sql server had crashed before this happened. I thought something wrong with the table rm00401, i reindex this table. But can not fix it. Who knows how to solve this problem? Thanks Nancy Are you running SQL 2000 or SQL 2005? When you re indexed did you drop and re-create or just use the dbreindex command? Drop and re-create is the best method for rebuilding an index completely but it's best to do this when users are log out and it...

SQL Optimized
Integration Manager - SQL Optimized - GL Transaction Adapter only allows functional currency transactions to be integrated. To integrate Multi currency transactions you cannot use this and have to use the standrad adapter, which is extremly slow. ...

HTML Signatures #2
We are creating signatures for all employees and using a template it has to be html, can't use a simple GIF. Is there a way to embed the graphic into the html file or into the e-mail itself so whenever it is sent it isn't being sent as an attachment? John, You can use a little bit of CGI as part of the employee's signature. This CGI can retrieve the HTML from a Web server. For instance, you could have a signature like: <a href="http://www.kanoodle.com/"><img src="http://path-to-some-cgi?sender=johns" border="0"></a> Then yo...

Access 2.0 to 2000 or XP
Has anyone tried to convert an Access 2.0 database to a 2000 or XP database. I tried it and I also modified all of the code that seemed to be incompatible, it works, but it still acts like there are some bugs. When clicking on the icon it will open, but after closing once or twice that same icon will start showing the properties instead of launching the program or highlight other icons around it and open other files all at once. I'm running windows 2000 pro and the database I need to convert is still being used daily. I've tried importing the tables and reports, converting, ...

Money 2007. Transaction Download and Bill Summary Tool Conflict
I think I'm looking for some best practice advice on the use of MS Money. Currently using Money 2007. I bank and billpay with NetBank. I use the Money Bill Summary tool to schedule reoccurring payments and transfers, but I make these payments using the Bill Pay feature of my bank's website. When I run the Money Update Online Information tool to download cleared transactions, it does not match the Netbank payments and transfers with the Bill Summary tool ledger entries. This results in duplicate entries. I could stop using the Bill Summary tool, but I would still have the prob...

add another lane to microsoft pos 2.0
Im having trouble connecting the second lane to the database. We have the port set correctly but it then ask for a administrator name and password to the computer with the database on it. I put the administrator name and password but it says its not correct. Can anybody help me. thanks This is probably the administrator name (usually "sa") and password for the sql database, are you using these and not the ones for the pc? "wtpshop@gmail.com" wrote: > Im having trouble connecting the second lane to the database. We have > the port set correctly but it then ask...

How can I create a report of 2 pages in access?
I want to create a report for each record, but i want a two page report. I've try to do this but it just goes completely blank. Can anyone help me? Put a Page Break control (from toolbox) at the bottom of the detail section after all your data. Steve santus@penn.com "Melz" <Melz@discussions.microsoft.com> wrote in message news:A8B4A81B-2FB4-4EEF-AE50-5DB9B8E93656@microsoft.com... >I want to create a report for each record, but i want a two page report. >I've > try to do this but it just goes completely blank. Can anyone help me? &q...

How do i number a template so that it will increase 1,2,3 etc?
Like the date. so every time i open a new one the numbers will increase eg: 1 2 3 Dreamworks, have a look here, http://www.mcgimpsey.com/excel/udfs/sequentialnums.html and if you are new to macros you may also what to have a look here on getting started with macros http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dreamworks" <Dreamworks@discussions.microsoft.com> w...

import pst file #2
yet, another problem with importing a pst file: When I have chosen the file to import I get the message: 'Properties for this information service must be defined prior to use' But I cannot find anywhere to define it when importing??? I obviously made a definition naming the pst file when exporting it. But how do I import the file? How did you create this PST file? Was it ever on a CD? If so, remove its read only attribute. -- Russ Valentine [MVP-Outlook] "carsten" <anonymous@discussions.microsoft.com> wrote in message news:0dad01c3c034$48890ec0$a001280a@phx.gbl....