GP 10 Payroll YE issue?
I am searching to find out if there is an issue with GP 10 Payroll and I have
been on Partnersource looking for information.
My client successfully closed the PR year end.
We installed the update for 2010 payroll and are now entering PR for the
first pay run for 2010
15 Employees had previously been setup with a Garnishment deduction and each
of these employees met the “lifetime” amount (the amount was reached in 2008
for the lifetime deduction for all the employees in question).
The summary screen on the employee card for this deductions reflects this as
We build a ba...Lock a Table
Is there a convenient way to programatically allow the current user to have
full access to a table in the current db, while preventing other users from
accessing it until the program releases it?
I should probably be more specific. The table is used for temp storage of
records that will be accessed by another application (MsWord via merge
mailing). A form in the database is bound to the table. When the form opens
it invokes a public procedure that deletes all records in the table and
rebuilds it from scratch. After that proc returns, the form requi...Pivot Table
I've got a Pivot Table with a dimension called GLGroup placed in the row
position. Within GLGroup, I've got the descriptions Sales, COS, Expenses,
Is it possible to create a calculated item based on your selections within
GLGroup? For example, I would want a calculated item called GrossMargin for
the GLGroup(Sales) less GLGroup(COS). Is this possible?
Maybe a visit to Debra Dalgleish's site:
I often add extra columns to the original data and add formulas there. Then I
use those extra columns in my pivottable.
K...Outlook 2003 / Exchange Find issue with Shared Calendar
Here is the set-up and the issue:
There is an Exchange 2003 server (with RPCoHTTP). There are 3 users
accessing the Exchange server with Outlook 2003 on Windows XP SP2. One
user has a calendar, which is shared, and owned by the two other users
(The users do _not_ want to use a public folder calendar, since some
PDA software they use cannot sync with a public folder, don't ask).
Since the calendar is owned by everyone, everyone can make changes.
Issue: If the user whose calendar is shared tries searching his
calendar for, say, all entries with 'xyz' in name, he sees all of...Could not delete from specified tables. (Error 3086)
I have a delete query that works as select query, but will errors when
changed to a delete query. As part of the query I have the table I am
deleting the records from as well as a query limits to records to be deleted.
The main table contains invoice attributes with a multi-field primary key
(invoice number & revenue category). The query may list multiple invoice
numbers, but always unique. So the relationship is always many to one. I
ran into a similar situation with update queries, but once I converted the
limiting query into a Make Table Query and used the results of the new...setfocus between the datasheet and form on a split form
I have a textbox on my form and using the split form view. I would like to
switch the focus in vba.
Is there a way to do this?
...help needed in printing contents of a form view
I am working with formview . I want to put all the content that i am
displaying on the formview to the clipboard so that i can print it from
I tried to put contents into clipboard but
problem is that all the screen is now get printed. i only want the view area
to be get printed.
sorry for my english.
can any one help me .
I'm sure I have answered this one :-)
To recapitulate: If you looked at the code on Joe Newcomber's site, notice
that you select the window from which you create your bitmap, so:
void toClipboard(CWnd * wnd, BOOL F...Login Issue to CRM
We've enabled access to our CRM server from an external IP address, but when
people try to login, they are forced to put in the domain (domain\username).
Is there a way to ONLY sign in with a username & password?
...Pivot Table ... Stacked Col & Area Graph
Excel2003 ... I have a Pivot Table "Stacked Col" Chart reflecting operators &
the time they charged to a part ... Sometimes an operation is completed by 1
operator (sometimes multiple operators) ... So far this part of the Chart
works fine ...
Now I would like to add the "time" the operation "should take" ... & I am
thinking I could do this as an "Area" Graph behind the Stacked Cols. (note:
if my operations were completed by a single operator then I can put the Area
Graph behind a Col Graph & all is fine. However, when I hav...Linking tables with forms
Hi, I'm still a relative beginner with Access, but I've not done too
However, I'm finding one thing very confusing.
Here's the scenario: I am writing a multi table db, and I need to link
them all up via an index, so one form can easily display data from the
For example: I need to display a name, located from one table, and
then in a seperate table, store values from yet other tables.
For some reason, I am finding this a little bit of a pain to do - I
can't seem to get the values loaded correctly. It's no problem if
they are simply from a table, but t...Date Major issue
If we have one data base for everything how do users enter the dates?
In Americas they use mm/dd/yy in the rest of the World dd/mm/yy.
If the data is in the data base and I want to enter a parameter into a query
of 12/2/06 what date does the data base give me? Feb 12, 2006 or Dec 2, 2006.
I think it depends on the date format specified in Organization Settings.
That should reflect across the system.
> If we have one data base for everything how do users enter the dates?
> In Americas they use mm/dd/yy in the rest of the World dd/mm/yy.
>...Camapign tracking issues
Hi this is my problem:
I send off a campaign email and everything goes off well. campaign responses
get tracked etc.
However if I send off an external email (not incl in campaign invite) and
that individual replys to it, it gets tracked with the campaign token...why
is this happeniing.
If I exit outlook straight after sending the campaign invite, this doesnt
...GP Setup Checklists or Forms
Is there a good source somewhere for help in getting an implementation
started? I'm looking specifically for forms or checklists that can be given
to the customer for Vendor Setup or Customer Setup or any other module setup.
My customer showed me some input forms she got from an MBS competitor when
they went through that implementation and she thought it was helpful. I've
been creating my own but it's time consuming. Thanks!
Look for this on PartnerSource: Microsoft Dynamics GP Consultant Toolkit
There's a lot in there. If you're looking for a specific thing you...Why aren't dates always available to group in pivot tables?
I download data that gives me sales number by individual day. I build a
pivot table to get total sales by day and then group the process day by month
or quarter. Sometimes this works perfectly, while other times I get the
message 'Cannot group that selection'. Has this happened to anyone else? Is
there a limit to the number of rows or columns that can be grouped?
You'll see that error message if the date field contains a blank cell,
or text entry. There's a bit more information, and some workarounds, here:
JLM wr...Combobox populated
Before I print a report by clicking a command button [btnPrintRpt] I select
a record from a combobox list [cboCandidates].
This is then the basis of the report.
Firstly: How do I make the command button check to make sure that a record
Secondly: Is it possible to make the combobox empty again when the command
button is clicked to print to prevent the user accidentally printing off
Private sub cmd_Print_Click
if LEN(me.cbo_YourComboName & "") = 0 then
msgbox "Select an item from th...How to dynamically populate series for an XY chart?
Here's what I'm trying to do, and if you can help me get it to work, well,
I'll be thrilled...
I have a sheet in which users enter up to 48 tasks. Each task is
prioritized as 1, 2, or 3 (Column A), and has specific X-Y information
(Columns B and C) for plotting the task on an XY chart. I would like to
graph these as separate series such that all the 1's are one series, all the
2's are another, etc., so I can use separate markers to differentiate them.
The problem is that *any* given task can be a 1, 2, or 3, and there is no
limit or expectation around how many of ea...Calendar issue?
I have a user who's outlook locks up while accepting a
meeting request. We have Exchange 5.5 server. He is
currently using Office XP (so Outlook 2002) but we also
tested by putting his email profile on another PC with
outlook 2000 on it (like most of the rest of the users)
with the same result. This only happens when dealing with
meeting requests. After either outlook is terminated or
the request finally goes through (sometimes taking 40-50
minutes), things work pretty much normally. He may have
to exit and go back into outlook to work in the calendar
OK. It is only for thi...how to create a chart in a form of a triangle
OK, I need to visualise a composition of a mixture of three
components. I need an isosceles triangle, each side from 0 to 100% of
A, B and C. Then a point inside to mark (visualise) cmposition of
Doable in Excel?
Thanks in advance for advice.
Here are some links, from previous postings, on ternary plots.
http://www.agri.upm.edu.my/~chris/ta...Gift Voucher issues
We just had (yet another)POS crash when trying to tender a sale.
Normally we can make the adjustment for cash/credit/debit at closing
but this time it was on a Gift Certificate and the system doesn't grok
that and even though it shows the items as sold, it did not subtract
the sale from the GC and now shows the GC balance as 164.54 higher
than it should be.
Also I just realized that Gift Certificates seem to be double entering
in Sales, as Sales includes the GC being sold initially AND then again
when the GC is used. Meaning that our Total Sales Volume could be
thousands of $$$ off.
Any ...Temp Tables in FUTA/SUTA Reports
Since the FUTA and SUTA reports are built on temp tables, is it possible to
modify them in Report Writer?
The client would like to add the employees' department to the FUTA and SUTA
monthly and quarterly reports. But, I cannot build the necessary
relationships in Report Writer--it won't let me. This is probably because
the reports are built on temp tables.
Would Crystal have to be used?
Nevermind! I figured it out! Sorry for the bother!
> Since the FUTA and SUTA reports are built on te...Help Needed with a Tricky Validation Issue
I have a text field in a database that the only formats that can be entered
are as follows:
v99.9 , 999.9 v99, v99.99, 999, 999.99
the 9’s can be any number
ex: v34.6 or 234.5 or v45 or v34.55 etc
what is not acceptable is 79.90
How can I check the data being input to make sure it is in one of the
The data is entered in a textbox on a form in an Access 2007 database
The simplest way would be to use this as the Validation Rule on the
appropriate column in the table:
Like "v##.#" Or Like "###.#&...Load Excel data in a SQL Server table
what's the simple way to read an Excel file (always in the same format and
name) in my WinForm and pass this data to a SQL Server stored procedure?
Thanks in advance.
"Luigi" <Luigi@discussions.microsoft.com> wrote in message
> What's the simplest way to read an Excel file (always in the same format
> name) in my WinForm and pass this data to a SQL Server stored procedure?
...Find and Replace against set of rules in 2nd table/worksheet
Looking for a tool, or code that does the following.
Edit [partial cell data] in Sheet1, if [partial cell data] meets criteria in
Sheet2, COL1. Sheet2, COL2 has the REPLACE WITH information.
Presently there are 59 criteria on Sheet 2, and I have to perform this
against 19 sites. So doing this manual via Find and Replace takes forever.
VBA code, or something similar would be great.
(Wanted to write an Update Query Access, but Access sent me here.)
Thanks in Advance
I've got everything in place for a static splitter window. The left pane
has a CLeftView, and the right pane has a CRightView. Everything works
great so far (i.e., both views display what they are supposed to and they
interact accordingly). My question is about the original CView referenced
in the app's InitInstance() method. It's not used but I'm not sure what to
do with it, if anything. Any ideas?
David Crow [MCSD] wrote:
> I've got everything in place for a static splitter window. The left pane
> has a CLeftView, and the right pane has a CRigh...Linking many EXCEL tables into a long WORD document
Would anyone have direct experience with linking lots of
Excel tables into complicated Word reports - say 100
tables into a 100 page document?
I tried this years ago shortly after OLE came out, but the
document's links got confused, with Excel occasionally
getting confused about which worksheet tab and range
belonged in which Word table. This was not a case of my
error, nor of corrupted files due to crashes, but was
confirmed as a problem with Excel by a person knowledgable
of its codes and bugs back then.
Needless to say, I stopped aiming at having these live
links in my docum...