Sales Report: current v previous for time period
Does anyone have a way to run sales comparison for a specified time period
ie Dec06 vs Dec05
If you know how to customized the .QRP files then you can easily do this. I
am just giving you an idea:
1. Open the Daily Sales by Sales Rep.QRP
2. In the ProcedureCall make it ""
3. In the TabelQueried type your query criteria how you wanted to do this (
you need to write the group by query to get the resultet. I have tried the
same way on one of the detail report in RMS
You must be good in query writing. It will work.
> Does anyone have a way to r...How to undo Year-End Closing process on GL
My customer did a year-end closing on GL without taking a backup. Now she realises that there were many errors in the transactions. Is there a way to undo the Year-End closing? Hi Saras,
Without a backup, there's no way to undo GL Year end closing. You client
still post transaction to the latest historical year though as an
Please wait for further feedback from uour peers.
Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certif...Setting Up Payroll
How do I set up employee information and deductions to write payroll checks
with out using the paycheck service that money offers? I just want to print
a few checks and it keeps telling me there are no accounts set up????
Money is designed as a personal finance program or for a one man company. If
you have employees you really need a "real" finance program.
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
We have a payroll deduction that will not post to the
correct GL account, but posts to an error account,
instead. I've checked the deduction, posting and employee
set-ups -- all seem correct. What else could be causing
When you went into Setup>>Posting>>Payroll Accts, did you also verify the
department and position fields also? The G/L account is set up, but is the
account marked "inactive"?
> We have a payroll deduction that will not post to the
> correct GL account, but posts to an error account, ...Unable to post a particular question on this site
I have tried several times to post a question this site. I’m not sure if
there is something wrong with that particular question causing the system to
reject it. The point of this post is to first test to see if this message
will actually post and the second is to notify someone of the problem. If
someone at MSDN is able to see this post please contact me via email so I can
get my actual question into the system.
"codeboy" <email@example.com> wrote in message
>I have tried several t...GP 7.5v Year End Close
Does anyone know where I can find information on the steps need to close out
the year for GP 7.5v. Thanks
Customersource knowledgebase has year end closing checklists.
> Does anyone know where I can find information on the steps need to close out
> the year for GP 7.5v. Thanks
...Scheduled Pymts not available to post
I have a Scheduled Payment Schedule that is showing up on the customer
account, but the payments for each month are not showing up in the Post
Scheduled Payments window. What did I miss. The schedule is posted.
...Try Me (Subscribe test, Post thread if able too)
Looking for people to subscribe, just test it out. Use fake or real email
On Mon, 2 Feb 2009 23:39:54 -0500, "No Spam" <firstname.lastname@example.org> wrote:
>Looking for people to subscribe, just test it out. Use fake or real email
And what makes you think anyone sensible would open an unvouched website?
Your "No Spam" is pretty arrogant coming from a spammer.
John W. Vinson [MVP]
Does this even have anythin...Outlook still crashing post Update Rollup 2 being installed
A few of my users, not all, are having Outlook crash on them. The errors
read, "Faulting application outlook.exe, version 11.0.8118.0, stamp 456628bf,
faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault
I have applied update rollup 2 on all my clients. When I look at the
version of crmaddin.dll, it reads 3.0.5300.1558, which I believe is the
I'm not sure what to try next. Has anybody had problems AFTER installing
update rollup 2. Most people say all their Outlook crashing problems were
fixed after installing this update,...Master Posting
I am new to GP - I have entered about 10 transactions in the Sales
Transaction Entry, and posted each one of them. After entering/posting, I
realized I had made a couple of mistakes. Somehow - in looking for the
solution to how to correct the mistakes, the 'Master Posting' was deleted.
So, I have receivables showing the enteries I made, but I can not post to
them all the other accounts that need to be posted to by using the 'Master
Posting' function. Is there some way to delete the posted transactions, or
alternatively, 'manually' do the master posting on the...payroll questions
i need to know the formula to calculate the following:
an employee comes to work of monday at 7:00 am
they clock out for lunch at 11:12 am
they return from lunch at 12:18 pm (12:00 being noon)
they clock out at 4.03 pm to go home for the day.
I need to calculate how many hours and minutes this employee worked o
this monday and them show me the time in decimals.
i also need to know how to calculate the amount of pay for the
currently paid an hourly wage of $11.00 per hour for 40 hours per wee
paid semi-monthly. wha...How to copy specific columns until end of data
I'm trying to import data from 2 workbooks into a summary (combination)
workbook. The trouble I'm having, is I want to import only certain
columns and have excel know to stop at the last row with data.
For example, from Workbook1 I want to import columns A, B, C, F, and G
(from Sheet2). I want it to copy up to the last row containing any
data--right now that's row 1046, but next month it could be row 1267.
In workbook2 I'm fine with it copying the CurrentRegion--all columns
are important. BUT, it doesn't include the title/category heads in the
first row (Salesperson, ...Comparative financials staement/Current Period & Historical Period
I am trying to create a comparative financial statement with 2007 & 2006
info. I have entered the 2006 information in the account history. How do I
get it into a financail statement ?
Are you trying to use FRx (which you should) or the GP financial reports?
Charles Allen, MVP
> I am trying to create a comparative financial statement with 2007 & 2006
> info. I have entered the 2006 information in the account history. How do I
> get it into a financail statement ?
...Detail posting from Purchasing to show in GL
I would like to post my purchasing batches into the GL with Vendor ID details
and not only the Journal entry number. Is there a way I can do that. I am new
to Great Plains. I have created several posted batches in the Purchasing
module but have not brought them into the GL yet because I would like to see
Thanks for any help I can get.
You will need to change your posting settings for the GL. Go to
Setup>Posting>Posting..select the Financial Series and General Entry Option
and select create a Journal Entry per transaction and then save.
>...Where is my post?
Hours ago, I submitted a question but don't see it?
I am guessing it is lost. I don't see it either, only the one below.
"Barbara" <Barbara@discussions.microsoft.com> wrote in message
> Hours ago, I submitted a question but don't see it?
"Barbara" <Barbara@discussions.microsoft.com> wrote in message
> Hours ago, I submitted a question but don't see it?
>...Post URL Action
I've created a rule for New Lead event.
In post URl action, I've specified the url
In the form load of the webform1.aspx , i wrote the following code.
FileInfo fi = new FileInfo(@"D:\CRMDB\CLEAD.txt");
StreamWriter s = fi.AppendText();
s.WriteLine("AccountID: " + Request.Form["accountid"]);
But this is not working
Can anyone help me with this.
Thanks and Regards,
Does it work OK if you just load
http://localhost/WebApplication1/WebForm1.aspx in I...Number series at end of column macro?
Please help...I need an excel macro that will do the following:
For example, I have Column A (contains the word =93ADD=94 repeating),
Column B(alphanumeric id), all filled with data. The data ends in each
of these columns at row x. Column C will contain a number series based
on the date and ends at row y < x. I would like a macro that finds
where Column C ends, and after the last cell in Column C begins
filling it in with a series starting at z, but the series will be
formatted as follows: <current week=92s Monday date in yyyy-mm-dd
format> TEXT-# For example, 2011-11-14 TEXT-0.
By ...I can't post a message in newsgroup
Hi every one;
I am not able to post anu message in newsgroup by MS outlook, here is error
Outlook Express could not post your message......................Protocol:
NNTP, Server Response: '440 Posting not allowed', Port: 119, Secure(SSL): No,
Server Error: 440, Error Number: 0x800CCCA9
any body knows why ?
Sounds like the newsserver in question requires you to log-in or only
accepts posts from users on their own network.
This newsgroup is for support of Outlook 97, 98, 2000, 2002 & 2003 from the
family for Intel PCs. For Outlo...Canadian Payroll Tax update #2
I tried to install Canadian Payroll Tax July update on gp 10. When I
launched the Dynamic Utility (under sa user), it started to update the
dynamic database and then without finnishing this process suggested to update
the company database.
During loggon GP shoews the message about different version of the database.
GP_loginerrors file says:
Product Name: Microsoft Dynamics GP Database Version: 100774 Client
Product Name: Canadian Payroll Database Version: 100774 Client
And SQL Server 2005 logs say:
Login failed for user "dynsa"...Payroll tax year end closing
I can't find the Payroll year end closing document for v 7.5, all I can find
is for v9. Can anyone tell me the TK document number?
Here's the link:
> I can't find the Payroll year end closing document for v 7.5, all I can find
> is for v9. Can anyone tell me the TK document number?
...ending a process frees up more ram than the process was taking?
I had a process that had a Mem Usage of 685,520 K and PF usage of 2.06
GB. I end the process and my PF usage drops to 1.17 GB. That's a
~890,000 K difference - not ~685,000 K.
My question is... why the difference? Why does ending this process
free more RAM than the process was taking up? Is this what's known as
a memory leak?
> I had a process that had a Mem Usage of 685,520 K and PF usage of
> 2.06 GB. I end the process and my PF usage drops to 1.17 GB.
> That's a ~890,000 K difference - not ~685,000 K.
> My question is... why ...Open fiscal period.
How do I open up a fiscal period directly in the
dataabase without going throught the UI?
Thanks a lot in advance.
...what formula do i use to figure payroll in my spredsheet
=Hours * Rate
Or post some details in the large white space as I have done.
Gord Dibben MS Excel MVP
On Thu, 15 Oct 2009 09:29:48 -0700, excel 101 <excel
...Start/End Cells in a Range
Having issues with a range and my searching has turned up nothing. I'm
probably missing something obvious, but I don't feel like beating my head
against the wall anymore.
I have a Range object. I'd like to get the row/column values for the start
and end cells of the range. The range is 'Raw Data'!$V$30:$V$51.
To retrieve $V$30, I can use Range.Row (=30) and Range.Column (=22).
How can I retrieve (or calculate) the row/column values for $V$51?
Any suggestions are appreciated.
Disregard, this is so I can find my post la...Fiscal Period #2
GP 7.5 / SQL 2000
We have added a 13th period to the fiscal period. The message comes up and
states that we should run the reconcile for GL, Payables, and Receivables.
Is there a correct order that these should be ran, and does running Check
Links have a specific order that it needs to be ran ? (before / after
I would run Reconcile first, then Check Links. As far as the order of
modules within either Reconcile or Check Links, I do not think it should
make any difference.
Dynamics GP MVP
Flexible Solutions, Inc.
"Laura Anne" <LauraAnn...