Bill-of-Material and Assembly Posting for Dynamics GP Business Rea
I wanted to get some feedback on the need to provide bill-of-material
maintenance functionality with a simplified assembly posting capability for
Dynamics GP Business Ready software. I know the functionality is there in
As a developer, does it make sense to provide this as 3rd party
functionality at the Business Ready level?
...Small Business Server 2003
Is Great Plains 7.5 compatible with Small Business Server
Microsoft MVP - Great Plains
"James" <email@example.com> wrote in message
> Is Great Plains 7.5 compatible with Small Business Server
...Table Exists issue.
I am trying to regenerate my database. I have an issue with ONE of my
table, when I remove it. First time I run this command, all is fine:
IF EXISTS(SELECT * FROM sys.objects WHERE TYPE='U' AND
DROP TABLE court_appearance
But then, I run it again, and get this:
Msg 3701, Level 11, State 5, Line 2
Cannot drop the table 'court_appearance', because it does not exist or
you do not have permission.
However, the table does NOT exist in my database, that I can see.
Because if I create the database, it works fine.
So, I run thi...Make table from recordset
Make table from recordset
I=92m attempting to make a table based of a union parameter query, all
I have this code which prints the results in the immediate window, but
I can=92t figure out how to make a simple table with one column of
RecordNumbers (make table =96 deleted/made every time code executes):
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
Dim strLName As String
strLName =3D InputBox("Last Name?")
Dim strFName As String
s...Help with my tables
Three tables....Employee Information, Employee Hours, Employee PTO
Employee Id (key)
Hours ID (key)
PTO Id (key)
Vacation Hours Used
Sick/Personal Hours Used
All seem to link fine in my tables. I open Employee Information table I get
a + to add those employee Hours and if needed a + to open their PTO (paid
time off) for that particular week.
Than I c...how to write to database tables in Excel 2004
I need to write to a database using Excel 2004 (Mac, OS X, 10.4). What are
"jolly" <firstname.lastname@example.org> wrote in message
>I need to write to a database using Excel 2004 (Mac, OS X, 10.4). What are
> my options?
"Norman Jones" wrote:
Are you suggesting that I can use adodb in Excel 2004? Near as ...Business Portal #19
The company directory feature in Business Portal displays information on work
telephone numbers, email address, etc. However, I cannot find in the actual
Dynamcis application where this data is stored. I cannot find it anywhere on
the Employee Maintenance card in the HR module. Is this data in Business
Portal being pulled from the Dynamics or is it storing this info separately?
If in Dynamics where?
Thanks for using the newsgroups. This information is found in a company
database in the Hrm_WorkContactDetails table.
Software Quality Assurance
M...Locating a Table object
I am having a problem with the following code:
Dim obj As AccessObject, dbs As Object
Set dbs = Application.CurrentData
For Each obj In dbs.AllTables
If obj.IsLoaded = True Then
If TblObj.Name = strHoldTableName Then
MsgBox "Another user is viewing this record"
intBeingViewed = 1
This code is intended to check if a table with the (string) name
strHoldTableName exists, but it's not working. Am I missing a reference, or
is there another set of cod...Business Card Reader / Scanner
Can anybody recommend / has experience with a Business Card Scanner to
integrate with Outlook / CRM.
You could try the solution of CardScan, this company has an add-on for CRM 3.0
I don't have experience with this add-on at the moment.
> Can anybody recommend / has experience with a Business Card Scanner to
> integrate with Outlook / CRM.
We'll report back what we find.
Boolean1...Pivot table not totaling
I am having problems getting a pivot table to total data together. The table
looks great for what I am doing but will not add the items together. It has
lines that say total but does not add the numbers up. The table appears like
Item # Quantity
I would like the table to add the quantity of each item # together. It would
be REALLY nice if I...Using Business Unit
How I can set each Oportunity to specific Business Unit doesn't matter the
Ower from Opportunity?
I need creat a user that can see (only read) specific Oppotunities.
...Creating Report on two tables that are linked
I am a novice access user who is looking at someone else's application.
They have a Post Table and a Comments table. There is an id field in the
Post table that links to a Post_Id field in the comments table. When I open
the Post table, there is a blank field on the far left that has a plus or
minus sign. If I click on the plus sign, it appears to open values from the
Comments based on these two fields. In the Post table there is a Body field
that has information that people have typed in. In the Comments table is
also a Body field that has information. This access databa...Another Question Regarding Business Cards...
First off, I have Windows XP, SP3 and Publisher 2003.
I have created a business card using one of the predesigned templates in
Publisher. I am actually following instructions in a book that I purchased.
So now it tells me to apply a Background, which I do, and it looks great in
the publication window. But when I go to print preview, the background
extends to beyond the top of the card and a little below too I think. The
height with of the background is 2.25", not 2"? I also applied the
background to the Master Page, and the same happens. I have been down this
ro...Small Business: Categorizing depreciating expenses
Hello small business edition users,
Record keeping issue: How do you all categorize expenses that are
*depreciable*? Do you create your own category(ies) under "Other business
expense?" The reason I ask is because you don't necessarily want the full
value of depreciated assets to show up in something like the profit and loss
report. i.e. you don't really want your $3000 computer lumped in with this
year's "Office expenses" since you don't get to deduct the whole thing, right?
I was wondering if there are any clever ways other folks out there
categori...Business Portal 2.5 FP
I am having no end of problems installing Business Portal 2.5 FP
Towards the end of the installation, the Creating Web Items reaches 40%
and stays there. I have waited for 2hours and still no progress. So
stopped the installation, removed, rebooted, and repeat the process again.
The Server is a Small Business Server 2003. I am at my wit ends, has
Business Portal 2.5 FP been tested on SBS2003 server? I am at the customer
site and i am trying to decided if i should leave the installation to run
over night (but i will be back at my office tmw)
I have raised a call ...relationships between tables
I have about 5 tables that I cannot enforce referential integrity
on... 3 of them have a common field, but the error messages I am
receiving are way above my head technically. Any suggestions? Or
even documentation on relationships (from the very beginning) would
help a lot!
First suggestion is to post the error messages you are getting.
It could be that you can't enforce referential integrity for a variety of
reasons. To name two off the top.
-- No unique index on field in the table on the one side
-- Fields in many side already have values and there are no related val...Deleted table
I deleted a table out of my database... i know need it back. I still have
the database open, is there anyway to get the table back?
"Access SS" <AccessSS@discussions.microsoft.com> wrote in message
>I deleted a table out of my database... i know need it back. I still have
> the database open, is there anyway to get the table back?
If you haven't compacted or done anything else, this might work:
'------ start of code ------
Dim db As DAO.Datab...Access 2000 Link to SQL Server db tables
I have a Access 2000 database that has approximately 100 tables. I would
like to link the Access tables to SQL Server database tables to give better
access to the report and forms in Access. Please let me know the best way to
link Access tables to SQL Server database tables.
On Thu, 28 Feb 2008 12:36:03 -0800, Joe K. <Joe K.@discussions.microsoft.com>
>I have a Access 2000 database that has approximately 100 tables. I would
>like to link the Access tables to SQL Server database tables to give better
>access to the report and forms in Access. Plea...Pivot table keeps dupping to another linked pivot table
I have two pivot tables, they use same source of data so i make pivot table B
link with pivot table A, not only the save size but also they can be
refreshed together. It usually works well but today don't know why pivot
table B becomes a "mirror" of pivot table A: When i change one the another
one changes in the same way, so I cannot make them to analyse with different
Did I setup something by accident or what?
This content works individualy, how can i make it work? is it any way to
count the values between A1> and <B1?
The simplest is
> This content works individualy, how can i make it work? is it any way to
> count the values between A1> and <B1?
If your version of Excel uses the semi-colon as a separator, replace
commas with semi-colons.
Hope this helps!
In art...Business Portal Order Entry Discount Price Option
This is crucial for Order entry clients that we work with using business portal
Microsoft Dynamics Incident Number: 8638390 Incident Type: Technical Support
Subject: price override
Occurs At: All Workstations
Current Status: Open - Solution Delivered Not Confirmed
Originated: 8/14/2006 4:58:00 PM PDT
Originated by: Rose Business Solutions Inc.
Authorized number: 8587949403
Regarding Customer: Emerald Publications
Team: NA GP Dist_Mfg_Proj
Support Region: North America
Agent: Kelly Dettmann
Current Contact: Jake
Product Line: Microsoft Dynamics GP
Topic: Business Portal Order Management Appl...Printing Multipule Business Cards Per Sheet
I have Publisher 2000 and when I choice Multipule Cards it
only prints out 4 per sheet. I am trying to print the
standard Avery format of 10 per sheet. Can anyone help me
out on how to set this up.
From memory (just came flooding back) in Publisher 2000 you actually go to
the menu File then Print and there is a button in the bottom left hand side
that allows you to change the number per sheet. Yes, it is a bizarre place
to have put it.
Post back if I am not correct.
A few messages down the list is this replay I gave to another.
In Publisher 2000:
Page Options But...Returning a value from a table with multiple entries
I have a table that has start times and finish times for different
people. I need to be able to return the value for the latest finish
time if there are multiple instances of that agent.
name start time finish time
agent 1 07:00 15:00
agent 2 08:00 08:15
agent 2 08:15 16:00
agent 3 09:00 17:00
In the above table i need to be able to return the value for agent 2
latest finish time. The vlookup formula i use returns the first value
it finds which is fine if there are only single entries.
I've made a massive pivot table.. however i want all rows which is 0 in
one column to be hidden. Is there a setting for this, or do I have to
make a macro to go and hide all rows which has 0 in a certain column ?
Ctech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27745
View this thread: http://www.excelforum.com/showthread.php?threadid=538405
First enter this small macro:
Dim r As Range
For Each r In Selection
If r.Value = 0 Then
...Change of SA password and relation to Business Portal
We are trying to connect to the Business Portal after changing the SA
password and now we are getting an error in BP "Not connected to the
Any suggestion. Thanks...
Versions...GP 8.0 BP 2.5
Cooper, thanks for using the newsgroup.
I reproduced your issue, and I was able to fix it following the steps below.
1. Go to Sharepoint Central Administration.
2. Click " Set configuration database server" below Server Configuration.
3. Enter the new sa password, check the box "Connect to existing
configuration database", and click OK
4. Click on &quo...