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

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

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.

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

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

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

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.

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.

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

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

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

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?

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?

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?

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

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

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

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?

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

Revenue Recognition

Hi When I am running Project --- Revenue Recognition it is picking up 2006 Cost. Regards Thiru

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.

User defined field

How can I get a user-defined field to print on a document, such as SOP or Fulfillment order?

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

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!

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

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!

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

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.

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

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.

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?

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,

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

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.

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

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.

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

integrate with ACT by Sage

Anyone doing this? -- MP

EFT in New Zealand and Australia

Can we use EFT outside of the US and Canada--for companies located in Australia and New Zealand?

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

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

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

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

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

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

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?

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

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!

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

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