Microsoft Dynamics GP 9.0 Budgets

I'm on Dynamics GP Version 9.00.0281, SQL 2000 (8.00.2039).  A user deleted a 
Budget ID (Cards, Financial, Budgets).  I restored a backup from last night 
into the TEST company (Development Database) using knowledgebase article 
871973 (How to set up a company with a copy of live data using SQL 2000).  I 
want to use DTS to copy the data in the budget tables from TEST to the live 
company.  I need to know the tables that hold the budget data.

-- 
Thanks
Titan
0
Titan (14)
10/2/2007 11:15:02 PM
greatplains 29623 articles. 4 followers. Follow

2 Replies
527 Views

Similar Articles

[PageSpeed] 15

GL00200 contains header info, GL00201 contains the budget details.

Frank Hamelly, MCP-GP
NOVA Solutions, LLC
Melbourne, FL


0
fhamelly (399)
10/3/2007 11:49:17 AM
You could just export the budget from the test company to Excel, then import 
the Excel spreadsheet into the live company.

"Titan" wrote:

> I'm on Dynamics GP Version 9.00.0281, SQL 2000 (8.00.2039).  A user deleted a 
> Budget ID (Cards, Financial, Budgets).  I restored a backup from last night 
> into the TEST company (Development Database) using knowledgebase article 
> 871973 (How to set up a company with a copy of live data using SQL 2000).  I 
> want to use DTS to copy the data in the budget tables from TEST to the live 
> company.  I need to know the tables that hold the budget data.
> 
> -- 
> Thanks
> Titan
0
10/4/2007 9:32:02 AM
Reply:

Similar Artilces:

Microsoft.Crm.ObjectModel.MultiCurrencyPlugin + The given key was
I am working with MS CRM 4.0. I have made a custom entity which is having some money fields. Everything was working fine. Suddenly while saving the entity below message coming from applicaton: "The given key was not present in the dictionary" If i click ok then entity is not saving. I go to application server event viewer log and saw below error details. Do any body face this issue, please let me know, it is getting me too much trouble. I know it is related with money field. I have to use money field in my entity. I have added some also. Web Service Plug-in failed in Organiz...

Great Plains 9 Restore
Hi, I am trying to upgrade from great plains 9 to great plains 9 sp2. So, we have setup up a test server where I have installed GP 9 and restored the data. At the moment I am just reading the KB923671 from customer source and one of the prequisites that you need to do before installing the service pack deals with Reports.dic and Forms.dic My question is when you install GP on such a scanario does one have to copy/restore the Reports.dic and Forms.dic files from the live system [or from the backups]. Or are they irrelevant? Thanks Sanjay, The FORMS.DIC and REPORTS.DIC are irreleva...

convert DVD to play on Microsoft iPhone Video player
[quote][/quote]Many friends ask me how to convert DVD to play on Microsoft iPhone Video player. I always recommend them Cucusoft DVD to iPhone Converter. It backup  convert almost any type of DVD to play on Microsoft iPhone Video player. Moreover ,It?s a powerful DVD to iPhone converter with very fast conversion speed. The output also supports full screen viewing.I think it is very useful and easy to use too.So , I recommend this useful software to convert DVD to play on Microsoft iPhone Video player. Hope it can help you.I download it here: http://www.92download.com/wiki/Cucusoft_DVD...

Visual Studio Toolkit for GP and external apps
Can the VS toolkit be used to develop external applications? We've tried to develop one that will run while GP is running (for good ole retrieveglobals9.dll) but we keep getting odd "file not found" errors that somehow relate to the dynamics.dll that DAG.exe generated. However, we can take the same code, do it as a GP add-in and it works fine. I'm just wondering if anyone else has tried an external app using the toolkit. Thanks, Steven V. I tired VSK too, but I had no luck devloping mine. I was told dexerity was need to do what I wanted. David "svallarian@gmail.c...

microsoft
weghtgh ...

Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
HI, I'm in a confusion that some of my apps.exe wont work with VC++6 but they do work on VS2005. Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6? So to install VS2005, prior to that do i need to uninstall VC++6?? ARe there much changes in .dll of VC++6 & VS2005? Thanks, vinutapb@gmail.com wrote: > HI, > I'm in a confusion that some of my apps.exe wont work with VC++6 but > they do work on VS2005. > Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6? > So to install VS2005, prior to that do i need to uninstall VC++6?? > AR...

how to pass a password to crystal report 9.0 from vb6.0??!
Is there any way passing a password to crystal report 9.0 from Visual Basic 6.0. so that when loading the report in vb6.0., it can connect to the database access file and show the report? Thanks a lot. No idea. But I use this in VB.Net to do it: Public Sub SetConnectionForReports(ByVal ReportDoc As ReportDocument) Dim crTable As Table Dim crTables As Tables Dim crDatabase As Database Dim crTableLogOnInfo As TableLogOnInfo Dim crConnectionInfo As New ConnectionInfo Try crDatabase = ReportDoc.Database crTables = crDatabase.Tables With crConnecti...

charts #9
Hi, I need some help creating a chart with two lines and one column. I have already created a Line - column on 2 axis, but i cannot figure out how to do 2 lines with 1 column on the same chart. An example of data i need charted: Q1 Q2 Q3 Q4 volume(units) 100 200 250 300 price1($) 10.00 11.00 11.25 11.45 price2($) 11.00 10.80 10.65 From this data i already have the volume and price1, but when i try to add price2 the data for price1 doesn't remain a line. Can anyone help? thanks... ...

Cannot access mine CRM (3.0) Contacts from Outlook 2003 Address Book
I have imported over 700 contacts into CRM (3.0). I have installed the CRM using Outlook 2003 client. When I look in my Address book in the Show names from list, I can see the CRM contacts option but I get an information message. Message reads "The Address list could not be displayed. The action could not be completed". What do I need to do to have my CRM contacts accessable from Outlook for addressing mail? ...

Microsoft Outlook to Microsoft Entourage
Hello All, I just got my Mac and started using Entourage (by Microsoft) and cannot seem to find how to get my PST to Entourage. There is support for Microsoft Outlook Express but not Outlook... Any hints? Thanks, Fred Landreville Maybe export to OE first? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Ti...

restricting the company drop-down list in BP 3.0
Hello: A GP 9.0/Business Portal 3.0 client of ours wants to know how to configure the company drop-down list to just show the live company. What is the security setting that restricts this drop-down list? Thanks! childofthe1980s Childofthe1980s, Thanks for using the newsgroups. If your desire is to make sure they only see the appropriate company information, I would suggest only assigning company specific roles (Account Specialist for only company A, etc.). There also is an option to assign a default company per user. When a user browses BP, it will default to the assigned comp...

Microsoft Promo
It says on the microsoft website that "Super Suite Deal. Buy Office 2004 and get Office 2008 Special Media Edition for FREE". I accessed it before and it said that even if you buy a student and teacher edition now, you get an Office 2008 Special Media Edition for free. But then I clicked on this link from apple: http://store.apple.com/Catalog/US/Images/Office2008Coupon.pdf and it says that when you purchase an office 2004 mac student and teacher edition you JUST get a office 2008 for Mac Home and Student Edition. What's happening there? Plus, on the mactopia website, the supe...

Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
I have windows XP and this update fails to install tried it various times..Can anyone help. Microsoft XML Core Services 4.0 Service Pack 2 (KB973688) www.futuretekonline.com Security updates for Microsoft XML Core Services 4.0 Service Pack 2 may repeatedly appear in the update list on Microsoft Update or on Windows Update See <http://support.microsoft.com/default.aspx/kb/941729/> for possible help. If you can not rename msxml4.dll in normal Windows mode, than boot to Safe Mode <http://support.microsoft.com/kb/315222>...

Problem with the HR Accrue Attendance Transaction in GP 10.0
Hello! I am using GP 10.0.0, HR with Payroll. I have setup the Accrual process for Paid Time Off (PTO) accruals. I am using the Hr/Yr method to accrue time. I am in the process of running payroll for the employees (500 or so employees) that has worked this past 2 wks. All should be earning or accruing Vacation and Sick time, when the accrue transaction is ran. Once this is ran some of the employees earn Vacation or Sick time, Some earning nothing, some earn just vacation, and some earn just sick time. I do not understand why this is happening. Its inconsistent as to what is happe...

Diff between microsoft.public.outlook and microsoft.public.outlook.general
Unfortunately, I can't download the "descriptions" that goes with each newsgroup carried by my ISP. The names of the forums described in the subject line above sound similar, but there must be a difference. Any idea? J J <sonrisa322@comcast.net> wrote: > Unfortunately, I can't download the "descriptions" that goes with each > newsgroup carried by my ISP. The names of the forums described in > the subject line above sound similar, but there must be a difference. At one time there was, but there is no longer. Just choose one. -- Brian Ti...

microsoft XL
My version of microsoft office XP (microsoft XL) does not contain the option of showing negative numbers in brackets. The format/number command only allows a minus sign or negative numbers in brackets. Am I missing some other command? Am I missing something in your post? First you say "does not contain the option of showing [negative numbers in brackets]" then you say "The format/number command only allows a minus sign or [negative numbers in brackets]." regardless the format looks like this 0.00_);(0.00) or do you mean 0.00_);(-0.00) -- Regards, Peo Sjoblo...

GP v9 Additional Report Footer Section
We use 'Sent to mail Recipient (PDF) to send order confirmations to our customers. I need to attach a copy of our companys Standard Terms and Conditions to this. One way would be to attach an (external) PDF file to the mail message after GP has generated the PDF. A better solution would be to include these terms and conditions as part of a single SOP document PDF. I am able to create additional header, detail and footer sections in the report writer, but I do not seem to be able to create an additional report footer. Is there a way of creating an additional footer, or alternativ...

Q: Vc6.0 doesn't re-compile source automatically
With Vc6.0, if source or resource is modified, it doesn't re-compile the changed file. the output exe file is older version. Only after switching between debug and release, the modified result is showed in the exe file. I have tried several other project and reinstall vc, the problem above occurs only in this project. I guess this project setting is error. may anyone offer suggestion on this? Best Regards, lomas I would begin with recompiling all. It should clean all files from Debug/Release folders. It should work automatically the way you want it. --- Ajay "lomas" <...

Is Microsoft POS (not Microsoft POS 2009) PCI compliant?
Is Microsoft POS (not Microsoft POS 2009) PCI compliant? This is a multi-part message in MIME format. ------=_NextPart_000_00C2_01CA3853.F4D6CF80 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Andy, 1.0 is not, 2.0 and above are. For a list of compliant applications, = http://tinyurl.com/2lmfgp --=20 Jeff=20 Check Point Software Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3...

Problem installation CRM 3.0
Hi, While installating CRM 3.0 I get half way through installing and it come up with this error: Action Microsoft.CRM.Setup.Server.CreateSetupUserAction failed. Exception from HRESULT: 0x8004415D I have looked through other posts on this but none of the 'workarounds' fix it. I have had a previous installation of which I would like to keep the data for but have uninstallated and am now trying to re-install, I have also removed the license from the dbo.License table. I only had the first installation for one month, so should still have another 2 months left of the trial. Please...

Which version of Microsoft Office #2
I've just bought a PC with Windows XP. I need to upgrade Microsoft Office (I had Office '97). Can anyone confirm that to have a version that will run and send/receive emails I'll need Office 2003? Can't get a straight answer from the shop I go to and I don't want to make a mistake. Cheers. Peter To answer your question, and not try to steer you to options you did NOT inquire about, yes, Office 97 is a qualifying product for Office 2000 through 2003. You may want to look at 2003 as it is the latest version of Office and has the longest support available. Offic...

Microsoft Office 2004
Hi I have been using the microsoft office 2004 on an ibook G4 on panther for the last 6 months. Recently, it is refusing to read some of the excel and powerpoint file created on a PC under the Office 97. I can see the file name but not the icon next to it when I look under Finder. When I click on the file name, the file disappears from view completely. At first I thought it was a software issue so I re-install the Microsoft Office 2004, but the problem persists. Has anyone encountered this problem? Any suggestions to solve it would be much appreciated. Thanks in advance, June In artic...

Synchronizing 2 x Microsoft Outlook 2007 #2
I have MS outlook 2007 on two different PCs. How Can I synchronized the Calendars from boot Outlooks. Thanks. Locksley ...

microsoft outlook and microsoft project
I install MS Outlook 2003, and also MS Project 2007. When I online MS Outlook, any time when there is message come in my mail box. Window display " Microsoft config gathering ms project information" Is it an installer window or a project dialog box? If installer, the Microsoft installer program is corrupt. Try Detect and Repair in Outlook or Project to stop it or just let it run and complete. If it's a project dialog box, you have some addin doing it. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www....

Microsoft SQL...
We are using W23K Server, Exchange 2003 SP1, Backup Exec 10.0. We purchased the Exchange Agent and are using it. Recently, when the backup runs it skips 22 files, which are in use. These are the files for Microsoft SQL. In a disaster recover scenario where we reinstall W23K, Exchange and restore the Exchange data / mailboxes from tape, do we need to have the SQL backed up or would it be reinstalled with Exchange / Backup Exec? Any advice would be appreciated. THANK YOU in advance! you're running SQL and Exchange on the same box? why is that? -- Susan Conkey [MVP] "Allan" ...