Select Bank Transactions is empty
Hi,
I am using Great Plains 7.5
Have been using it for over 6 years now, but have never seen this problem before. Hope someone can help me.
When I go to Transactions _ Financial _ Reconcile.
I select a Checkbook ID (can see the Ending Balance amount, and dates)
click on Transactions, and the Select Bank Transactions window opens, but no data.
The Adjusted Bank and Book Balances are there, together with the Difference. But no transactions..
Help please..
Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.egghea
|
3/11/2010 8:14:15 PM
|
1
|
N C
|
|
Stop Accrual on Vacation Payouts
First, let me say, we are we are using HR Accrual.
We would like to do a vacation payout for our hourly employees for anything
over 120 hours, but we don't want them to accrue on the hours paid out.
Right now when we do a payout and don't accrue, everything is fine until the
next pay period. At the next pay period when the accrual is done, GP accrues
on the hours paid out. We then have to do a correcting transaction in
attendance.
How can we do payouts for our hourly staff with out accruing on the hours
paid out?
Thanks,
Erin
|
3/11/2010 7:29:01 PM
|
0
|
=?Utf-8?B?ZWxhdmVsbGU=?= <elave...@discussions.microsoft.com>
|
Laser printers that support check printing (MICR?) from Dynamics GP
I am looking for a list of laser printers that can support check printing by
Dynamics GP.
We are using dot-matrix on pre-printed form and got tired of them!
Your help is greatly appreciated.
Bill
|
3/11/2010 7:13:30 PM
|
4
|
"Bill N" <bi...@jaco.com>
|
Smartlist in 10.0
Our smartlist is showing as brown in white in the grid lines. They used to
be blue and white and you could see what line item you were on? We have not
done any upgrades. This is only occuring for some of our users.
Thakns!
|
3/11/2010 6:31:01 PM
|
1
|
=?Utf-8?B?VEJyb29rcw==?= <TBro...@discussions.microsoft.com>
|
Change posting account to fixed allocation account?
Is there a way to change an existing GL posting account into a fixed
allocation account? Trying in a test company but can't make it work. I've
cleared everyting out of the existing account and manually changed the
account type in GL00100 to 3 and then added distribution info to GL00103 but
there still seems to be another missing link. Under fixed allocation
maintenance the original account still says it is not a fixed allocation
account.
GP10, SP3. Thanks.
|
3/11/2010 5:19:01 PM
|
1
|
=?Utf-8?B?aXJpc2hqYW1y?= <irishj...@discussions.microsoft.com>
|
Standard smart list edit
Hi,
Is it possible to edit a standard smart list using smart list builder. I
need to bring in the item comment in the standard sales line item report.
What is the most efficient way of doing it?
Thanks.
|
3/11/2010 3:55:01 PM
|
2
|
=?Utf-8?B?R0c=?= <...@discussions.microsoft.com>
|
Override Limit
Customer credit limit override approval workflow
Hello all, Just wondering if/where we can have the override credit limit
just in effect on either the Order or Invoice and not both. TY
|
3/11/2010 3:47:07 PM
|
1
|
Brian <nixtoo...@hotmail.com>
|
Post Dated Checks
I had to prepare some post dated checks and we did not have fiscal periods
set up yet to match the dates of the checks. Currently the check batches are
waiting to be posted. What is the best way to handle post dated checks? If I
create new fiscal years to match these dates, I will end up having 4 Open
years. Is this the only way to do it?
|
3/11/2010 3:47:01 PM
|
2
|
=?Utf-8?B?U2hlbGxleUI=?= <Shell...@discussions.microsoft.com>
|
Search for Uncommitted PO Quantities From Sales Order Processing
Hello, I need help understanding this option in POP setup. The help
file says:
"Indicate whether you want back-ordered quantities from Sales Order
Processing to be linked to existing purchase order line items with
uncommitted quantities. If you don't mark the selection, new purchase
orders always will be created to fill Sales Order Processing
shortages."
Does this option mean that GP will automatically search out
backordered sales docs and automatically link them to purchase orders
that have available quantities that are not already committed to sales
docs?
Then is says if yo
|
3/11/2010 3:24:41 PM
|
1
|
GiJeet <gij...@yahoo.com>
|
fixed assets and multicurrency
Does anyone know of a resource to properly implement Fixed Assets with a
company that has been setup for various years and use multicurrency? How are
the layers of different currencies treated? Thanks.
--
Patti
|
3/11/2010 3:20:06 PM
|
1
|
=?Utf-8?B?UGF0dGkgRm9v?= <Patti...@discussions.microsoft.com>
|
Electronic Reconcile Management - Date Formula
I have this client that is trying to implement Electronic Reconcile Management however upon setting up the 'ERM Import Setup' using the CSV file type I am required to add in a formula for the DATE field. I add the the length of the various fields and the DATE indicator in the window. Finally I click on the VERIFY button and to get a error message 'SETUP REPORTS'.
The other formula fields work without incident.
Submitted via EggHeadCafe - Software Developer Portal of Choice
More Fun with Fluent NHibernate Automapping
http://www.eggheadcafe.com/tutorials/aspnet/50aa9259-6dbb-4d16-96
|
3/11/2010 8:13:01 AM
|
1
|
Bernadine Baney
|
Applied Material OH
Hello all,
I have an inventory item that is a FIFO Periodic 'buy' item. The standard
cost for this item is made up of Material cost and Material Fixed OH. I have
setup the all the Item Accounts including the Applied Material OH. My
understanding is that the Applied Material OH account is supposed to be
credited with the overhead amount when a purchase order is received. But so
far the receiving distribution transaction is not hitting this account. Does
anyone know why? What should be the correct receiving distribution entry for
a standard cost item with Material OH?
Thank y
|
3/11/2010 1:53:01 AM
|
2
|
=?Utf-8?B?TFI=?= <...@discussions.microsoft.com>
|
Report to Print Checks
How can I determine which report is being used as the one to print our
companies checks? We have a top and bottom check format, and there are four
top and bottom options. I have tried altering them all, but it does not
result in a change in the end product. I have verified that I have set
proper access to these particular modified forms and reports. Therefore, I
am wanting to see if it is pulling from a report that I am not seeing so that
I can get it edited.
|
3/11/2010 12:36:01 AM
|
2
|
=?Utf-8?B?SHV0Y2g=?= <Hu...@discussions.microsoft.com>
|
Windows 7 and Dynamics GP 10 SP1
We are on Dynamics GP 10.0 SP1. We have many users that want to upgrade to
Windows 7, but we are not ready to upgrade Dynamics. Does anyone know of a
way to install Dynamics GP 10 SP1 on a Windows 7 machine? I was told there
is a Feature Pack 1 that will allow the install, but it appears to me that
you have to have SP4 installed before you can install the feature pack.
Thanks
|
3/10/2010 10:54:01 PM
|
2
|
=?Utf-8?B?aW5pbg==?= <i...@discussions.microsoft.com>
|
link to the exchange table is missing
We have had several transactions; receiving and AP apply batches (and
possibly others) in which the link to the exchange table is missing (in
receivings new transactions cannot be saved as the exchange rate can't be
found).
We have been using GP without incident for a long time & no obvious
processes were run prior to this error occurring. I ran Check Links & still
receive the error.
|
3/10/2010 9:42:01 PM
|
1
|
=?Utf-8?B?QWRhbQ==?= <A...@discussions.microsoft.com>
|
Report Writer not Carrying Lines Across Multiple Groups
I have a multi page PA invoice wherein the vertical lines do not display on
pages 2 or 3. The data displays, but no lines. Furthermore, the last page
has only a half page of data & should have vertical lines above the footer,
but there is simply a large white space.
I do not imagine I am the only person with this type of issue. However, It
doesnt appear report writer can easier handle formatting of multi-page
invoices.
|
3/10/2010 9:32:07 PM
|
1
|
=?Utf-8?B?QWRhbQ==?= <A...@discussions.microsoft.com>
|
Hard Coding an FRx report
I'm trying to create a FRx Balance Sheet for the years 2009 & 2008 that match
our audited reports. Sorry to say but some year end adjustments to the year
2008 were made in the year 2009.
Any thoughts on how to "hard code" some adjustments in the reports as if the
entries were made in the correct year? Or maybe there would be another way
to do this?
This would be a (2) column reprot when presented.
Thanks
|
3/10/2010 8:43:01 PM
|
0
|
=?Utf-8?B?TWVybGU=?= <Me...@discussions.microsoft.com>
|
Bank Transfers Carry Default Trx Type of Interest Income?
All of our transactions entered using the Bank Transfer Entry window display
in SmartList with a CM Trx Type of Interest Income. Is there a setting
somewhere that controls this?
--
Pete P.
|
3/10/2010 8:25:02 PM
|
1
|
=?Utf-8?B?UGV0ZSBQaWxsaXR0ZXJp?= <PetePillitt...@discussions.microsoft.com>
|
Questions about system entry indicator
Hello everyone
I don't know much about GP but one of the auditors has asked me this
question. Are there any manual or system entry indicator for GP? This is
where the system automatically posts to the GL's or an indicator that show
the entry was manually entered and not system calculated.
--
villica
|
3/10/2010 7:36:06 PM
|
4
|
=?Utf-8?B?VmlsbGljYQ==?= <Vill...@discussions.microsoft.com>
|
Deductions in Arrears
Hello all, I am looking for any documentation of the process and
functionality of Deductions in Arrears. All I get when on any of the
screens is HRPSuite.chm not found and I looked for any information on
customersource and have yet to find anything useful. TIA
|
3/10/2010 7:15:55 PM
|
1
|
Brian <nixtoo...@hotmail.com>
|
Error Code : 1603
Hi,
while installing SP 4 for GP 10 We are getting Product : Microsoft Dynamics
GP - update 'KB978731' could not be installed. Error Code 1603. We have tried
installing Domain Admin credentails and also using Local Admin credentials.
Any help in this regard will be appreciable.
Thanks
Regards
Sandeep
|
3/10/2010 6:38:04 PM
|
1
|
=?Utf-8?B?U2FuZGVlcA==?= <Sand...@discussions.microsoft.com>
|
What Modifies Document Dates
I am working on a report and came across some errors on document dates. I am
looking at setting up a normal process to double check document dates that
are incorrect as a result. The question I have is what modifies document
dates? Do different SOPTYPES have different parameters for setting up
document dates. I notice more backorders and invoices that have a descripancy
between document date and created dates. Thoughts?
|
3/10/2010 5:25:01 PM
|
1
|
=?Utf-8?B?QWxsZW5NYw==?= <Alle...@discussions.microsoft.com>
|
master posting
I have given a user the appropriate rights to master post and when they
select the batch they want to master post it gives them this error:
You have not marked any batches for posting
If I go in and give the user power user rights it works fine.
Any suggestions?
|
3/10/2010 4:58:01 PM
|
5
|
=?Utf-8?B?TGFycnkgQw==?= <Lar...@discussions.microsoft.com>
|
open GL batches per company
Is there a sql script that I can use to show all the open GL batches for each
company? We have 80 companies and this would make life a lot easier for the
accounting department. I would then put it in SmartList as a view.
|
3/10/2010 2:37:01 PM
|
7
|
=?Utf-8?B?bW9kb25uZWxAa25pZ2h0LmNvbQ==?= <mich...@microsoftinstructor.com>
|
Inter-Match
There is a problem with the inter-match in Great Plains. Cost adjustments to
vendor invoices in the current month are trying to post to the previous
month. It looks like it is trying to tie the cost adjustment to the receipt
date. This is a problem because we frequently receive goods in one month but
do not receive the invoice until the following month. The cost adjustments
need to post in the month the invoice is received. Any ideas how to fix?
|
3/10/2010 1:25:01 PM
|
1
|
=?Utf-8?B?QWxsZW5NYw==?= <Alle...@discussions.microsoft.com>
|
Who Closed PO
Is there a way to know what account processed the closing of a PO?
Also, the user2ent field that is in the SOP and POP tables. Is that the
creating user or the last editing user?
|
3/10/2010 1:21:01 PM
|
2
|
=?Utf-8?B?QWxsZW5NYw==?= <Alle...@discussions.microsoft.com>
|
Journal hung up
One of the staff entered a journal & got a message "The stored procedure
glpBatchCleanup returned the following results: DBMS:0,Microsoft Dynamics GP
:20820."
Another staff posted the entry & it continued to show a status of "posting"
(only 1 debit & 1 credit). He existed GP resulting in the a batch recovery.
Now the batch is hung in Batch Recovery. Any suggestions?
|
3/9/2010 10:16:01 PM
|
5
|
=?Utf-8?B?TWVybGU=?= <Me...@discussions.microsoft.com>
|
Payroll Integration TTGDS Error
We set up a new payroll transaction integration. I can preview the file and
all the data looks good. When we run the integration, we get this error:
The destination could not be initialized due to the following problem:
TTGDS Errors: TTGDS_ITEMALREADYEXISTS
Does anyone know what this means?
|
3/9/2010 8:46:01 PM
|
0
|
=?Utf-8?B?RWxhaW5l?= <Ela...@discussions.microsoft.com>
|
Upgrade to GP10 trans log errors
I recently ran a GP company DB upgrade on SQL05 - 5 companies made it - one
did not. I tried 2 more times and ran into this error each time:
transaction log for company ID full. To find out why the space in the log
cannot be re-used see the log_reuse_wait_desc column in the sys.databases?
How do I open that table in temp DB to view that column?
and it also states to remove the temporary table at the database level.
I opened a case with MBS to assist but still have no answers on how to get
past these errors - has anyone run into this who can help me?
(The database was res
|
3/9/2010 7:19:02 PM
|
1
|
=?Utf-8?B?YWRhdGFzeXM=?= <adata...@discussions.microsoft.com>
|
Analytical accounting
what is the difference between owned by and all combination allowed. We use
AA to track project costs, some projects have multiple locations.
--
jdv
|
3/9/2010 5:36:01 PM
|
1
|
=?Utf-8?B?M2RvbmFtaWdvcw==?= <3donami...@discussions.microsoft.com>
|
Default Purchasing UofM
Hello, when in the POP screen and you enter an item and tab to the
UofM field is there a way to have this automatically populate with a
default purchasing unit of measure like the default selling UofM ?
Thanks.
hd
|
3/9/2010 3:32:18 PM
|
1
|
hdjim <hdji...@yahoo.com>
|
Uncollected FICA
Hi,
I am wondering if anyone has a solution to my question below.
I have employees who have uncollected FICA because they do not have enough
earnings during a period so therefore, they end up with uncollected FICA.
However, we should be able to recover the uncollected amount through out the
year. Is there a way to set up Microsoft Dynamics (9) to collect arrears on
FICA? Or will this require a manual adjustment on my part?
Thanks,
Gabriel
|
3/9/2010 2:51:01 PM
|
1
|
=?Utf-8?B?Z3YgcGF5cm9sbA==?= <gvpayr...@discussions.microsoft.com>
|
Receivings
Upon receipt of merchandise it is determined that some of it is damaged. Is
there a way for us to mark this as damaged merchandise when doing processing
the receipt. If not, how is the best way to handle this - we need to
indicate in our system that some of the merchandise is damaged upon receipt.
We use this information in conjunction with evaluating our vendors.
Thank You
--
HK
|
3/9/2010 2:25:01 PM
|
1
|
=?Utf-8?B?SEs=?= <...@discussions.microsoft.com>
|
Sales void performance
We have an issue that occurs every so often when a sales payment is voided in
the Receivables Posted Transaction Maintenance window on GP 9 that is running
in a Citrix environment. Once Void is clicked, the system locks up and the
only way to continue is to kick the user out using the Task Manager. We then
need to Reconcile the Outstanding Document Amount for that customer and
attempt to void it again - about half the time it works properly.
There aren't any customizations or third parties to this window. Has anyone
seen anything similar or have any thoughts on what may be ca
|
3/8/2010 10:05:01 PM
|
1
|
=?Utf-8?B?ZGpyMDM=?= <dj...@discussions.microsoft.com>
|
Anyone use Promys CRM software integrated with GP Dynamics?
Our company is considering using Promys as a CRM to create quotes and
sales orders for the sales team. I am concerned about the integration
with GP and what the pitfalls may be. Is anyone here currently using
Promys with GP Dynamics?
|
3/8/2010 8:42:09 PM
|
0
|
Barb <barbpolid...@gmail.com>
|
Need some help with Process Server
Can anyone give me some information about process server? I have a client
that really needs this but I am having a hard time finding anything in the
Microsoft knowledge base or on the Partner 3rd party refernce site.
Any information or pointed int he right direction would be very helpful and
very much appreciated.
--
TC
|
3/8/2010 5:56:01 PM
|
1
|
=?Utf-8?B?VExD?= <...@discussions.microsoft.com>
|
Full Payment on SOP Invoice not posted where is payment ?
I create a new customer. Create an SOP Invoice and enter a full
payment with the invoice. Save the invoice to a batch =96 do not post
yet. Now I look up the customer and don=92t see any payment. Looked
all over can=92t find the payment. Payment is only displayed in the SOP
Entry screen in the payment section. When you post, yes then the
invoice and payment show on the customer=92s account. Before you post,
shouldn=92t this payment be recorded and displayed somewhere? Besides
the SOP Entry screen? Thanks
Michelle
|
3/8/2010 5:13:34 PM
|
6
|
mickieparis <mickiepa...@gmail.com>
|
Allocating Tips in Payroll
In one of the forums, someone asked me several questions regarding tip
allocation using GP Payroll. I posted an article to my blog that goes
through the entire calculation, but now I cannot find the thread where the
question was posed.
So, if you are still out there. . . the article was posted to :
http://dynamicsconfessions.blogspot.com/2010/03/allocating-tips-in-payroll-how-and-why.html
Kind regards,
Leslie
|
3/8/2010 3:06:01 PM
|
0
|
=?Utf-8?B?TGVzbGllIFZhaWw=?= <LeslieV...@discussions.microsoft.com>
|
Revenue Recognition
Hi When I am running Project --- Revenue Recognition it is picking up 2006
Cost.
Regards
Thiru
|
3/8/2010 1:16:01 PM
|
1
|
=?Utf-8?B?VGhpcnVtYWw=?= <Thiru...@discussions.microsoft.com>
|
Stock Movement report
Hi
Is there an inventory movement report in GP where it shows all the items
transactions eg. stock in/out, adjustments,..
thank you.
|
3/8/2010 2:31:01 AM
|
1
|
=?Utf-8?B?R1BYY2Vs?= <GPX...@discussions.microsoft.com>
|
Stock report
I am trying to write a report where i need to show the available quantity of
an item along with the expiry dates for a selected range of receipt dates.
For example, i would display the current available quantity of an item which
was received in Dec 2009. The table IV10200 does have the information except
for the expiry date.
Any help is appreciated.
Thanks.
|
3/6/2010 12:19:01 PM
|
2
|
=?Utf-8?B?SmF5S2F5?= <Jay...@discussions.microsoft.com>
|
'run report with name' to a specified printer
I am trying to call the run report with name Dex script and tell it to go to
a specific printer, namely PrintBoss 50. This is a custom report that is not
listed in named printers. I am calling it with:
run report with name "BOL" destination false,true printer 'PrintBoss 50'
This does not work. The doc seems to say that somehow I need to use the
Printer_Define and/or Printer_GetName functions as the printer parameter is
{printer settings}.
Can someone tell me how to do this?
|
3/6/2010 3:14:24 AM
|
2
|
=?Utf-8?B?TWlrZSBHYXJleQ==?= <MikeGa...@discussions.microsoft.com>
|
User defined field
How can I get a user-defined field to print on a document, such as SOP or
Fulfillment order?
|
3/6/2010 12:17:23 AM
|
5
|
=?Utf-8?B?cmNy?= <...@discussions.microsoft.com>
|
RTV Credit - Received but missing Credit Voucher
In my testing, it appears that if you create a RTV Credit and post it in the
RTV Shipping Window, an associated Payable (Credit Voucher) is created and
linked to the RTV. I have an RTV without an associated Credit Voucher and it
appears to be related to the Item. I ran 4 tests...
1. Same Item/Same Vendor=NO Credit Voucher
2. Same Item/Different Vendor=NO Credit Voucher
3. Different Item/Same Vendor=Credit Voucher
4. Different Item/Different Vendor=Credit Voucher
Thus, based on the above scenarios I tested, it appears that the Item is not
allowing the Credit Voucher to be create
|
3/5/2010 9:39:13 PM
|
2
|
=?Utf-8?B?YnJrMjAwMA==?= <brk2...@dynamics.com>
|
No mappings were found for the user or the user was not authorized
I am trying to setup Business Portal with an existing installation of
Dynamics GP Company. Many of the pages in Business Portal are working fine.
But on some pages; I get "An error occurred while retrieving data from
Microsoft Dynamics GP. Administrators, see the server log for more
information" message. The Windows Event Logs say "Could not execute WebMethod
GetSalesReturnList on WebService at
http://gpserver/DynamicsGPWebServices/DynamicsGPService.asmx in App Domain
'/LM/W3SVC/..' The full exception text is: Insufficient authorization to
perform this action..The inner excepti
|
3/5/2010 7:48:01 PM
|
3
|
=?Utf-8?B?S2h1cnJhbSBBeml6?= <KhurramA...@discussions.microsoft.com>
|
Programmatically Modifying Service Contracts
I would like to programmatically change contracts (e.g. increase the annual
billing amount). I have researched eConnect and have found that contracts
aren’t supported by eConnect. Any ideas how this project can be
accomplished? Does anyone know how to provide this functionality or know
someone who can?
|
3/5/2010 5:44:02 PM
|
2
|
=?Utf-8?B?QXJ5ZWggR3JlZW5iZXJn?= <Aryeh Greenb...@discussions.microsoft.com>
|
Smartlist Lines are Brown not Blue
We we pull up a smartlist report to view, the lines are brown and white
alternately, not blue and white. We cannot see where our cursor is on the
report in the window. We are on GP 10. SP3.
Thank you!
|
3/5/2010 5:33:01 PM
|
5
|
=?Utf-8?B?c3B1bmtpZWdpcmw=?= <spunkieg...@discussions.microsoft.com>
|
Project Accounting Invoice for Fixed Price Contract showing quanti
Is there a way to print an invoice for a fixed price contract which shows
actual quantities rather than the % complete?
|
3/5/2010 4:37:01 PM
|
0
|
=?Utf-8?B?SmFuaWNl?= <Jan...@discussions.microsoft.com>
|
FRx lines
Anyone know how to have a financial line that references a category number &
then subtracts out a "full" GL number? Seem FRx doesn't like having the
combination of the different types of GL refenences
Thanks
|
3/5/2010 2:31:01 PM
|
1
|
=?Utf-8?B?TWVybGU=?= <Me...@discussions.microsoft.com>
|
GP10 Freezing during prints
Random problem that started happening with a few users about 2 weeks
ago. One user has GP sometimes freeze when they print sales orders
(modified reports) between the GP report destination screen and the
system print screen.
Another user is having similar issues plus random freezing of GP.
Currently we are on SP3 (version 10.00.1328). I have not upgraded to
SP4 as my VAR has advised me there are still unresolved issues with
it. I'm thinking these issues may be caused by a windows update as no
other changes to GP have been made in the past month. Anyone
experience something like this
|
3/4/2010 10:28:26 PM
|
3
|
vanGP <mhepb...@gmail.com>
|
1099 Reporting
Does anyone have a recommendation on how to separate reimbursable expenses
paid to a independent contractor vs. the fees they charge for their services.
When completing a 1099 at the end of the year, we would want to only show
the services amount. We are aware of the 1099 field within the vendor
set-up, but at this time it seems that it is an all or nothing proposition.
Thanks for any assistance!
|
3/4/2010 7:44:12 PM
|
6
|
=?Utf-8?B?TWVybGU=?= <Me...@discussions.microsoft.com>
|
GP Project Accounting-Support for Multi-Currency and Multi-languag
Hi all, just wondering if anyone has a quick answer:
Is Dynamics GP Project Accounting Multi-Currency and Multi-language enabled??
--
Chris Jarvis, CSM
|
3/4/2010 6:40:05 PM
|
1
|
=?Utf-8?B?Q2hyaXMgSg==?= <Chr...@discussions.microsoft.com>
|
Create new company will old company structure and employees
We need to create a new company from the old company's data. Basically, we
need the new company to have the same structure, COA, and employee and
payroll setup, vendors, etc. The copycompany utility is fine, but it don't
copy over the employee from the old company. So I'm thinking that we could
setup a new company and then copy over the old company's data, clear the
transactions, then use the new company. Any other suggestions?
--
Gary
|
3/4/2010 6:31:01 PM
|
3
|
=?Utf-8?B?R2FyeQ==?= <G...@discussions.microsoft.com>
|
Extra row in header for Integration Manager
Hi,
I have created a couple of Integrations with a Header and then the
Integration. All my headers keep coming up with a blank row between the
column Name and the actual name. The integration will still run but with an
error. Is this possibly the relationship properties of 3 "0 to many" vs
option 4 of 1 to many? How do I fix this?
TIA
|
3/4/2010 4:13:01 PM
|
1
|
=?Utf-8?B?Q29ubmll?= <Con...@discussions.microsoft.com>
|
Multiple Termination Records
Suggestion: Add the function to track multiple terminations.
When working with companies that hire students they have the need to track
multiple terminations on the employees.
They would like the same functionality as the Review - one active and
multiple records in history.
|
3/4/2010 12:27:02 PM
|
1
|
=?Utf-8?B?TlNfRHluYW1pY3MgR1A=?= <NSDynamic...@discussions.microsoft.com>
|
Deduction in Arrears
I ran a payroll that should have included deductions in arrears and they were
not taken. Can anyone point me in the right direction to check why these were
not taken?
I am on GP 10 with the latest Service Pack.
I reviewed the Arrears Transaction on the employees and it shows under
attempted but they were not taken. The employee still had plent of $$ left on
the check that would have allowed the full amount to be taken.
Thanks
|
3/4/2010 12:22:01 PM
|
2
|
=?Utf-8?B?TlNfRHluYW1pY3MgR1A=?= <NSDynamic...@discussions.microsoft.com>
|
Only Transactions that has special characters in Number field show
One of my customers reported that when they are trying to reconcile bank
statement, not all transactions entered in bank transaction window are
displayed, while investigating the issue, I did the following:
1. Checked-links.
2. Changed Regional and Language options language for Unicode characters to
make sure that this is not a collation error.
3. Reinstalled the application.
4. Tried to use another machine.
5. Checked the knowledgebase, the only solution they provided is to compare
CM20200 and CM20500 with no luck.
5. Compared one of the displayed lines with another
|
3/4/2010 11:55:01 AM
|
2
|
=?Utf-8?B?TW9oYW1tYWQgUi4gRGFvdWQ=?= <mohda...@gmail. com>
|
Inactive Items
We have several dormant items which we dont want to delete since we might
activate those in the future. These items by the way have historical data
but no current inventory, allocated, on order, returned or in use quantities.
Kindly advise what is the best way to prevent the users from accidentally
adding transactions to these items.
Thank you.
|
3/4/2010 11:41:01 AM
|
4
|
=?Utf-8?B?WWFuaQ==?= <y...@discussions.microsfot.com>
|
GL accounts - create
I need to create a number of new GL accounts in my GP 9.0. I have the details
in excel sheet. Is there any way i can upload it directly to the system
without entering it one by one.
thanks.
|
3/4/2010 11:33:01 AM
|
4
|
=?Utf-8?B?SmF5S2F5?= <Jay...@discussions.microsoft.com>
|
SOP Returns: how to void correct?
I'm looking for step-by-step instructions on how to void a Sales return
document in GP correctly please.
I'm currently using GPv8 (but this shouldn't matter). I've create and posted
a sales return document in SOP. Now, I discover its incorrectly so I want to
void the document. I dont want to apply the document against any other SOP
documents - I just want to get rid of it.
How do I go about this correctly so that the SOP document in Inquiry
(Inquiry > Sales > Sales documents) is updated to be a voided document? In
which table does this updated information lie?
Thanks in ad
|
3/4/2010 10:25:01 AM
|
3
|
=?Utf-8?B?TG91ZWxsYQ==?= <Loue...@discussions.microsoft.com>
|
64 bit vs 32 bit drivers
One of our clients has attempted to install a 64 bit Vista workstation into a
network consisting of 32 bit Win XP workstations, a 32 bit Win 2003 server,
and a 32 bit SQL Server 2005. Once they could not get anything to work, they
called us. After setting up a 32 bit ODBC connection, we were able to get the
new w/s to talk with GP.
The only remaining issue is that they cannot seem to access the printer
setup, under File, on the new w/s. Could this be due to their having
installed the printers using 64 bit drivers, much like GP not recognizing a
64 bit ODBC connection?
|
3/4/2010 12:51:01 AM
|
1
|
=?Utf-8?B?U3BlY3RydW0=?= <Spect...@discussions.microsoft.com>
|
GP V10 Navigation List and Field Level security
We have a client that has decentralized payables in 1 database. They use
field level security to restrict access to vendors.
They would like to use the Navigation Lists - however these lists ignore
field level security. Does anyone have a solution?
--
RobertShap
|
3/3/2010 9:21:02 PM
|
3
|
=?Utf-8?B?Um9iZXJ0U2hhcA==?= <RobertS...@discussions.microsoft.com>
|
purchase order enhancements and eConnect?
Does anyone know if you can use eConnect, business portal, or some other
product to push approvals on po's into GP for the purchase order enhancements
module? We are going to be using this module, and we don't want to require
the approvers in the field to have to sign into GP to do the approvals?
Thanks,
|
3/3/2010 6:16:03 PM
|
0
|
=?Utf-8?B?anBpcGVy?= <jpi...@discussions.microsoft.com>
|
Invoice paid still shows as open
Hi everybody - in payable transaction inquiry I am showing a payment and
invoice with an 'open' status. I paid the invoice with a check and already
printed and mailed out the check. Both the payment and invoice should have a
'history' status. How do I fix this?
|
3/3/2010 5:53:01 PM
|
9
|
=?Utf-8?B?bW9kb25uZWxAa25pZ2h0LmNvbQ==?= <mich...@microsoftinstructor.com>
|
GP 9 and Crystal Reports XI
I am new to GP + Crystal Reports writing and having an issue. I hope this is
the right forum. I have created an ODBC connection to my GP company database.
When I try to connect from Crystal Reports I am only able to see stored
procedures from the database but none of the tables. Is this normal from GP?
If so what is the best way to create Crystal Reports with GP data?
Thanks in advance,
Victor
|
3/3/2010 4:47:02 PM
|
1
|
=?Utf-8?B?VmljdG9y?= <Vic...@discussions.microsoft.com>
|
GP10 - multicurrency conversion
Our A/P team showed me transactions on the trial balance where it seems that
the system rounds differently for the invoice and the payment, resulting in
one penny difference.
We have multicurrency.
The originating currency of the trxs is Euros.
The functional currency of this company is UK Pounds.
When the same Euros are converted at the same exchange rate we end up with a
penny difference between the invoice and the payment.
It looks like the system "Rounds" one conversion,
and "Round Up" the other.
Does anyone have any suggestions why this might happen (is there a set
|
3/3/2010 4:37:01 PM
|
2
|
=?Utf-8?B?TWFyaWE=?= <Ma...@discussions.microsoft.com>
|
Integration Manager Hanging
When the client runs a Receivables integration in the morning it runs fine.
If she runs it in the afternoon, it hangs. No one else is in GP at the time.
A GL integration runs fine. I can preview the txt files in IM. We recently
took over as the VAR so I am not very familiar with all of their processes.
Does anyone have any suggestions on how to diagnose? Thank you.
|
3/3/2010 3:47:01 PM
|
4
|
=?Utf-8?B?dHJlZTMwOQ==?= <tree...@discussions.microsoft.com>
|
Collections Management
We have just upgraded to Ver 10.0, Collections Management was installed on
the previous version, Ver 8.0, it was on CD 2 as additional software. I am
not seeing CM on CD 2. How can I, where can I get this software? Shouldn't
this have been on the Ver 10.0 CD?
|
3/3/2010 12:35:01 AM
|
2
|
=?Utf-8?B?cmNy?= <...@discussions.microsoft.com>
|
Intercompany Purchase Order
We have an entity that traditionally orders/pays for certain items for one of
our other companies. Is there a way to create an intercompany purchase order
so that when items are received/invoiced in the parent company we can pass
the cost on the the child company?
L
|
3/2/2010 11:23:01 PM
|
3
|
=?Utf-8?B?bGt1bGljaw==?= <lkul...@discussions.microsoft.com>
|
GP10 Mfg - Cannot remove component from Pick Doc
Hello Everybody -
First time we see this -
We have one pick doc with one component on it that seems to be corrupt -
When I select and try to remove the component, GP freezes up -
I can crash the window but I cannot successfully proceed.
Any ideas what to check or how to proceed?
Is there a checklinks or a reconcile I can run?
Thank you,
Maria.
|
3/2/2010 10:40:01 PM
|
1
|
=?Utf-8?B?TWFyaWE=?= <Ma...@discussions.microsoft.com>
|
Item Inquiry (Qty Sold show negative)
http://img176.imageshack.us/img176/7635/20100303itemsoldqtyve.png
Referring to the screenshot about, could you please advise me why the
Quantity Sold is showing incorrectly as negative sign.
Checklink, clear activity, temp and lock and reconcile for
inventory...have all done, but it is not help.
How should I troubleshoot this issue? Many thanks in advance.
|
3/2/2010 9:55:01 PM
|
5
|
wkz0 <william...@gmail.com>
|
Why does change in IV00102 update DEX_ROW_TS in IV00101?
We've had some performance problems since upgrading to GP10. In researching
this problem I discovered that the item quantities table, IV00102, has an
AFTER UPDATE trigger called zDT_IV00102U that updates the item master table,
IV00101 (specifically, it is setting IV00101.DEX_ROW_TS to the current date
and time).
We had auditing set up on IV00101, thinking that auditing changes in a
master table would not have much impact on performance, but because of this
trigger every time a document posts that changes inventory quantities our
auditing on IV00101 fires also. What is the ri
|
3/2/2010 9:28:02 PM
|
2
|
=?Utf-8?B?eW9nYUFkbWlu?= <yogaAd...@discussions.microsoft.com>
|
Windows Error When Printing from Screen Output
Just installed Service Pack 4 for GP 10
When printing posting journals from screen after entering cash reciepts a
Windows error occurs stating that GP has encountered a problem and needs to
close. Anyone have this problem or a solution?
--
Ted Edens
|
3/2/2010 7:51:02 PM
|
2
|
=?Utf-8?B?VGVkIEVkZW5z?= <ted...@absautoservices.com>
|
looking for Human Resources integration with GP
id liek to get some integration with an HR module. I already looked at
Dynamics HR module and it is clumsy and not very useful for us. what HR
modules/programs are being used by Dynamics GP customers. Any
recommendations. thanks very much for your time
|
3/2/2010 6:47:02 PM
|
0
|
=?Utf-8?B?YnJ1dGUgZm9yY2U=?= <brutefo...@discussions.microsoft.com>
|
integrate with ACT by Sage
Anyone doing this?
--
MP
|
3/2/2010 6:32:12 PM
|
0
|
=?Utf-8?B?TVA=?= <...@discussions.microsoft.com>
|
sop issue payment to wrong customer
issue
sales clerk is saying in dec a payment was posted to the wrong customer
we have since closed the modulkes and year
How do we correct the customers and keep everything in balance
|
3/2/2010 5:56:01 PM
|
2
|
=?Utf-8?B?TWFyayBNY01pbGxhbg==?= <Mark McMil...@discussions.microsoft.com>
|
EFT in New Zealand and Australia
Can we use EFT outside of the US and Canada--for companies located in
Australia and New Zealand?
|
3/2/2010 4:51:02 PM
|
3
|
=?Utf-8?B?Q2Fyb2xpbmU=?= <Carol...@community.nospam>
|
Fixed Assets Book Year and Year End Close
My client changed their book year to 2010 and ran depreciation for January
before closing 2009. Now they have a YTD amount in 2010 for assets that have
fully depreciated in 2009. Restoring a backup is not an option. Deleting
data from SQL tables is!
Is there a way to delete the 2010 depreciation from FA tables, change the
book year back to 2009 and close the year? I know they'd have to reverse the
GL posting too!
Is there another way to fix this?
Why does GP allow you to change the book year and run a depreciation before
the year end close is done? (just wondering)
|
3/2/2010 3:50:01 PM
|
1
|
=?Utf-8?B?SmVkIFBlcmxvd2lu?= <...@perlowin.com>
|
Security to Setup Checklist-ver 10 SP 4
Hi Folks
If I only assisgn 'Defaultuser' to a user they automatically have rights to
[Administration / Setup / Setup Checklist] and I do not want them to have
those rights. I have searched through the boxes that are ticked for the
'Defaultuser' and I cannot find which box to untick and so I am asking if
anyone else has found where to untick this please.
Many thanks in advance
Sheila
|
3/2/2010 3:13:01 PM
|
4
|
=?Utf-8?B?U2hlaWxh?= <She...@discussions.microsoft.com>
|
GP 10 Metrics widget bug with Office 2007
HI all:
We have version 10 of GP installed (SP3 10.00.1328) and we recently
upgraded to Office 2007 from Offcie 2003.
This has caused the Metrics "widget" on users' home page to throw an error
message. (The Metrics widget is not able to use the Office 2007 version of
the Microsoft Office chart control.) We can of course get around the error
by not showing this widget. However, does anyone know of a way to resolve
this?
Thanks much.
--
Norman
|
3/2/2010 12:05:01 PM
|
2
|
=?Utf-8?B?Tm9ybWFuIERhbGV5?= <NormanDa...@discussions.microsoft.com>
|
Cannot see new Company when login
I'm using GP10 with SP3 and SQL2008 installed in my laptop for local
environment and test.
And I have created a new company (xyz).
When it almost finish it gives me a message that I did not noted.
I logon to GP as 'sa' but I cannot find this new company.
I check in SSMS I can find the XYZ database.
I have tried to run Grant.sql from this database but still no luck.
I tried to run GP Utilities again, in-case if XYZ company is failed or not.
But it seems the progress for XYZ is working normal. Because there is no
message / information that XYZ database is failed.
Can someone he
|
3/2/2010 6:02:01 AM
|
3
|
=?Utf-8?B?Qmx1ZS05?= <Bl...@discussions.microsoft.com>
|
Inventorying items that are dropshipped
We frequently dropship items from our vendor to our customer. We'd like to
have the material flow thru GP inventory so that we can easily track how much
of a specific item we've sold. We realize that we'd have to receive the
items even though they never arrived at our warehouse.
Is there any way to do this or is there an alternate way to track sales when
some items are inventoried and others are not (i.e., dropshipped)?
Thanks in advance!
Don McCready
GP Version 9.0
|
3/1/2010 7:02:01 PM
|
4
|
=?Utf-8?B?RG9uTWNDUEE=?= <DonMc...@discussions.microsoft.com>
|
Not Enough Memory to Run Excel
Whenever I am trying to access any navigation list I receive a pop-window w/
an error saying "Not enough memory to run Micorsoft Excel. Please close
other applications and try again."
If I click the 'ok' button the error goes away and it eventually returns to
me in Dynamics GP 10 the navigation list.
I have plenty of memory on my computer (2GB), and only have Dynamics and
Outlook running. While accessing a list I have monitored my RAM usage, and
it does not spike up and there is plenty of RAM left. I can manually run
Excel w/o an problem.
Thoughts on how to fix this err
|
3/1/2010 6:46:03 PM
|
7
|
=?Utf-8?B?SHV0Y2g=?= <Hu...@discussions.microsoft.com>
|
SLB on different license, GP10
I have created a new SmartList in SLB on mij partner license. I have tested
this list on my machine at a backup from my customer and it works. I have
imported the layout at this customer. He has his own SLB license. The import
is o.k.
When launching the new report in his SmartList, I get 'Completed' and result
0.
What can cause the problem??
Thanks,
--
Toni
|
3/1/2010 6:35:01 PM
|
6
|
=?Utf-8?B?VG9uaQ==?= <T...@discussions.microsoft.com>
|
Can I import retired Fixed Assets?
I am in the process of importing Fixed Asset data into GP 9.0 Fixed Assets.
I need to know if there is a way to import data for assets that were retired
in our old system. In the documentation for using the Asset Import, I do not
see any fields for proceeds, retired cost, etc. If not, can this be done via
the table import? If so, where can I find documentation on this?
Thanks.
--
DJanson
|
3/1/2010 5:41:01 PM
|
0
|
=?Utf-8?B?REphbnNvbg==?= <DJan...@discussions.microsoft.com>
|
SQL Errors when changing companies
Just today a few users have been getting SQL errors, error creating pass thru
SQL, connection 75, SQL Error 0, and others when trying to change companies.
We also had a posting error in one company, that thought the user had the
trx open, and nothing was in SY00800 with her username.
One user couldn't run a Smartlist Builder report that previously worked.
If they users log out and go back in, it works fine. Any ideas as to what
may have caused this? We are on SQL Server 2008, Dynamics GP 10.
Just thought I'd ask!
|
3/1/2010 5:26:01 PM
|
3
|
=?Utf-8?B?YmFyYm9sYQ==?= <barb...@discussions.microsoft.com>
|
V10 - GL Transaction Correcting Journal
Hi,
I have a customer on V10 who is trying to do a correcting journal in
financials.
The original journal has MDA. However the correcting journal is not
populating the MDA and gives an error message 'There are errors in the
analysis for this transaction. Do you want to save it with the errors?'
You are not able to amend the journal to post the MDA - so the transaction
cannot be posted.
They are trying to do the correcting journal in the test company - the
original transaction was posted in the live company and the test company then
updated.
Is there a table that need
|
3/1/2010 4:51:01 PM
|
0
|
=?Utf-8?B?SkI=?= <...@discussions.microsoft.com>
|
Assigning a macro a function key on the Shortcut bar on Citrix
Is it possible to assign a macro to the same function key for multiple users
on a Citrix server? I assigned a macro to the F2 key for one user. When I
log in as a different user and try to assign the macro to the F2 key, it's
not in the list of available keys. It wants me to select a different function
key.
|
3/1/2010 12:37:01 AM
|
2
|
=?Utf-8?B?RWxhaW5l?= <Ela...@discussions.microsoft.com>
|
Series number to Series name
Hello, I see several tables have a column called SERIES which hold an
integer value. I'd l like to link that back to a lookup table holding
the series name, i.e. Financial, Sales, Purchasing, etc. I looked but
could not find the lookup table. Please let me know the lookup table
(if there is one) and/or how to get this mapping. Thanks
JDM
|
2/28/2010 8:43:04 PM
|
3
|
JimmyDarkMoon <jimmydarkm...@gmail.com>
|
Copy and paste within a macro
I've created macro to copy the value of one field and I want it to paste this
value into another field. However, it's pasting in the value that's stored
in the macro. I tried deleting the TypeTo line after the cmdEditPaste line
but now nothing gets pasted.
How do I get it to paste in what gets copied each time (from the clipboard)?
|
2/28/2010 1:47:01 PM
|
2
|
=?Utf-8?B?RWxhaW5l?= <Ela...@discussions.microsoft.com>
|
Copy (Ctrl C) in a macro
I want to copy the value one field and paste it into another field in a
macro. However, when I run the macro and it gets to the Copy command line
(CommandExec form BuiLtin command cmdEditCopy ), I get "Command Disabled".
Is it possible to copy and paste from within a macro? If so, how do I do it?
|
2/28/2010 12:29:01 PM
|
1
|
=?Utf-8?B?RWxhaW5l?= <Ela...@discussions.microsoft.com>
|
Business Alerts--Report Column Error
I am getting the error message when trying to remove the column from
Select REport Columns Screen of Business Alerts."A Remove Operation On
table 'SY_Rules_Selected_Columns_Temp' Failed because the Record
couldn't be locked" Did anybody have solution for this.
Thanks IN Advance
Mansoor Quadri
|
2/28/2010 6:13:31 AM
|
0
|
Mansoor <sma_qua...@yahoo.com>
|
Req Management Approval Limits Report
Hi,
I am trying to put together a SQL query that will show me a user name and
approval limit so I can create a report to forward to Finance.
I've been looking at the following tables:
[DYNAMICS].[dbo].[ReqMgmtSetupUser]
[WSS_Content_BusinessPortal].[dbo].[UserInfo]
[DYNAMICS].[dbo].[ReqMgmtApprovalTreeNode]
But I cannot find a link that will join the user name and the approval
limit. I can see that the ID field in [ReqMgmtSetupUser] links to the
ResidentID in [ReqMgmtApprovalTreeNode], but I don't think that is the proper
Name\ID table combination.
Any suggestions?
Than
|
2/27/2010 12:47:01 AM
|
1
|
=?Utf-8?B?SmltIExpbmVz?= <lines_ja...@hotmail.com>
|
Check Links and Reconcile
What order should these be run in?
I am using GP10
Should i reconcile Sales, Purchasing then Inventory followed by Check links
on all?
Is there a set Monthly or year end procedure for Reconciling GP10.
Thanks in advance for any help or comments
Rick
|
2/26/2010 7:00:09 PM
|
1
|
=?Utf-8?B?Umljaw==?= <R...@discussions.microsoft.com>
|
EFT Remittance numbers
Is there a way to change the remittance number for EFT payments in GP 9.0?
It's so easy in version 10!
|
2/26/2010 5:21:01 PM
|
0
|
=?Utf-8?B?U3VzYW4=?= <Su...@discussions.microsoft.com>
|
Copy an Integration - no more Save As?
Without the Save As button in IM now, how do I copy an integration without
saving over the previous one?
|
2/26/2010 3:15:01 PM
|
5
|
=?Utf-8?B?YmFyYm9sYQ==?= <barb...@discussions.microsoft.com>
|
Unposted SOP Returns losing lot info when running Checklinks
Hi,
My client is on GP10 SP3. If you do a SOP invoice and post it, and then
afterwards do a SOP Return (either via the Auto return option or just as a
standard SOP Return) - using a line item that is Lot Tracked and save this
unposted SOP return in a batch, then upon running Checklinks on the Sales
Series then the following happens:
'A record for Return 'XXXX' was removed from the Sales Serial/Lot Work and
History Table; no corresponding record was found in the Sales Transaction
Amounts Work table'
Any ideas?
Thank you
Neil Palmer
|
2/26/2010 2:08:01 PM
|
5
|
=?Utf-8?B?TmVpbCBQYWxtZXI=?= <NeilPal...@discussions.microsoft.com>
|
30-day due date report
Hello:
Other than the Cash Requirements report in payables and in the SmartList, is
there any other unmodified report in GP 10.0 that will allow you to see
payables invoices that are due to be paid 30 days from now?
childofthe1980s
|
2/26/2010 1:21:01 PM
|
4
|
=?Utf-8?B?Y2hpbGRvZnRoZTE5ODBz?= <childofthe19...@discussions.microsoft.com>
|
ANTIVIRUS FREE DOWNLOAD 8873
Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free Download
Microsoft best practices in:
http://yourantivirusfreedownloadonthissite.blogspot.com/
Content Site Links:
http://yourantivirusfreedownloadonthissite.blogspot.com/
http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/what-is-antivirus.html
http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/free-download-antivirus-recommended-by.html
http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/antivirus-o
|
2/25/2010 10:32:02 PM
|
0
|
=?Utf-8?B?YW50aXZpcnVzIGdyYXRpcw==?= <antivirusgra...@discussions.microsoft.com>
|
How do I do an outstanding check import for first bank reconciliation
What are the steps that need to be taken within GP to import outstanding checks? I have already written the integration, but cannot recall the process.
|
2/25/2010 7:18:53 PM
|
1
|
amywhetzel <u...@msgroups.net/>
|