GP Forum

Computer Checks Edit List report

Fri, 20 Nov 2009 19:30:01 Z

I want to post this to the Dynamics GP forum, but that's not an option?

Our company is on GP 10.0. When the AP Clerk selects checks for payment, the Controller reviews the Computer Checks Edit List report (printable from the Edit Payables Check Batch window) before the AP Clerk actually generates the checks.

However, the Controller finds this report hard to read and would prefer a very different report, basically the Check Distribution report, only for checks that have been selected for payment but not yet been generated.

I didn't see any easy way to set this up with Report Writer. Can anyone offer advice on how to do this?

7.5 Pervasive SQL tvables to GP

Fri, 20 Nov 2009 02:41:01 Z

I have GP 7.5 pervasive SQL data and the migration tool. I have migrated all the standard data to MS SQL but I have some custom tables that did not come over. How do I get the custom tables from the s28xxxxx.btr (10 tables) into the MS SQL. I have tried to bring in with SQL import and some other tools with no luck. Does anyone have a ideas how to do this?

a product installed on your computer is on a different version than the database version

Tue, 17 Nov 2009 21:47:03 Z

I have installed gp9 sp4 on a client and I get the message "a product installed on your computer is on a different version than the database version", I have other clients that are working fine, but this one is not. I have tried to remove Smart List Builder, but I still have the same error. Also I cannot locate the gp_loginerror.log anywhre on the client machine, so I don;t know what cause that failure.

GP Report Writer

Thu, 12 Nov 2009 01:03:21 Z

I have been playing with the Microsoft Dynamics GP Report Writer. All I have done is added our Logo and phone number to our invoices. I save and the go back into GP. The problem is when I go to call up my invoicing batch that i am ready to print or post, it calls up all invoicing batches that are open in the system. If I try to post one batch, it will post them all. We were already using the modified report, i just went in and touched it up a little. But now it is all messed up and I cant get it back to normal. I have the standard invoice form set to them right now and it is working fine. Does anyone one know why this is happening?

Windows 7 with Solomon 7.0 FP1 and Business Portal

Fri, 06 Nov 2009 15:26:21 Z

Have there been many issues installing SL 7.0 with FP1 and BP with FP1 on a Windows 7 OS? Thank you!

Item ABC Analysis Routine in Inventory Module

Mon, 26 Oct 2009 20:19:30 Z

In Dynamics GP version 10, when trying to run the Item ABC Analysis Routine in the Inventory Module, we received an error stating "You cannot complete this process while invoices are being posted". Since no invoices were being posted, I looked up this error on Microsoft's Knowledgebase. I found KB article 865739 and followed its instructions. The report ran without a problem. After we closed the report and tried to run it again, the same error came up again. Has anyone encountered this problem? Obviously, I could run the KB fix everytime I wanted to run the report, but there must be another error causing this that needs to be fixed. Any help would be greatly appreciated. Thank you!

Great Plains is creating duplicate keys....can we avoid this?

Fri, 09 Oct 2009 22:39:24 Z

We have 4 companies defined in GP, which means we have 4 unique databases with unique key generation routines.
The key generation routine builds the key as the first 5 characters of the company name and a 4 digit sequence.

We have two companies in two different companies of ours with the same 5 characters in the company name. Since the companies are in different databases the keygen is coming up with duplicate keys. With our synchronization back to CRM this cause the first company to have it's name changed to the second company name. (not good.)

We would like to alter the key generation so that the company prefix is added to the end of the key. Thus in the previous example we'd get compa0001phx and compa0001sct which would avoid the duplicate key issue.

My questions:
1) Can I do this and how do I change the keygen algorithm?
2) Would there be an impact for existing accounts to change the keygen algorithm?

I'd appreciate any assistance someone can give me....I'm walking into this as a noobie taking over the companies system work in GP.

Thanks.

BTW -- when I selected Dynamics to post my question I could only post to CRM forums...NOT GP.

Voided Check

Wed, 07 Oct 2009 20:32:18 Z

I have a client that wrote a payables check in May 2009 then voided this check in August 2009. It is still showing in his Bank Reconciliation. He is unable to void it in Bank Transaction (void trx) due to it was done in payables. However, the check no longer shows in pm void open/history. Client is on Dyn v 10. Any suggestions? Thank you!

(I was unable to post to GP forum)

How to add Microsoft Dexterity Componants 10.0 ?

Tue, 06 Oct 2009 06:43:33 Z

Dear All,

I downloaded GP 10.0 Trial Version. When i am installating, MS Dexterity Componants 10.0 is missing. Where can i find these componants. Kindly give me the download region.

Note: I am installing on my laptop itself having Sql sever 2005 and .NET Framework 2.0 with win xp with service pack 3 and 2GD RAM.

BR,
NAG

AP Distribution Reports

Fri, 02 Oct 2009 18:45:09 Z

I am just starting to get into all the out-of-the-box GP reports in a new position, so this may seem a dumb question.

Our company wants to be able to enter a GL account (typically an expense account) and get a report or inquiry screen showing all entries into that acount, which will typically be AP entries. so they want detail like vendor name, invoice #, and invoice description.

We are using batches, and the GL trial balance reports only show batch detail, so unless there is a single invoice in a batch, these reports don't give the info needed.

There is the Distribution History-Detail report in Purchasing, which you think would give this info, except that I want all data, not just history - but I can't get ANY data on this report.

Any ideas? This seems to be a really basic request that should come out of the box.

Is there an audit trail for deleted lines on an SOP? (This is for GP - I wasn't given the option to post to the GP forum...)

Thu, 01 Oct 2009 13:35:02 Z

Here's the scenario.

An order goes to a backorder
Someone goes into the backorder in the GP client and deletes a line from the order detail

What happens to the data that was deleted? I don't see the line anywhere in the SOP10200 or SOP30300 tables? Is there a place where that action is recorded?

Thanks in advance for your help!

Dan

Dynamics GP Test Environment

Thu, 01 Oct 2009 12:34:34 Z

I'd like set up a test environment alongside a GP Installation in order to test patches, upgrades, customizations, etc. A test company on the production server isn't enough separation, so I'd like to run the test environment on it's own virtual server. Does this require the purchase of an additional GP license?

Microsoft Dynamics GP

Tue, 01 Sep 2009 01:56:15 Z

Hi,

One of my client use Microsoft dynamics GP which sends data of their webservice. We have our webservice and web application of our own in our company, My question is how do to make our webservice interactive to their Dynamics GP. Should I have to install Dynamics Gp in my system? If so what are the process of steps?

GP Users Group

Mon, 31 Aug 2009 15:15:46 Z

I am looking for a great plains users group. I am in Rochester NY and my company has been using GP for 3 years. We are looking for more input on how others are using GP

AP & Cash posting

Thu, 27 Aug 2009 20:37:44 Z

Our company is looking into posting AP and Cash in summary to the GL, versus detail. We also are looking at batching AP once a week versus daily. One concern is losing the detail for cash we get now when posting detail - the cash disbursements journal does not seem to pick up wires, and voids do not display right for the month, so the total of the report is not the true cash disbursements

How are others posting AP and cash to GL (summary versus detail, and how often you batch/post to gl)? Please also explain your pros and cons

Thanks

Dynamics GP 10. - National accounts - Child account customer payment summary - last statement date

Wed, 05 Aug 2009 20:13:14 Z

National accounts - After running statements with the Consolidate National account selected and the Individual Child Statements check the statements ran and you can see them under reprint statements. The Customer Payment Summary inquiry window did not update the last statement date, the previous month last statement date is in that window.

Fargoese for "Check Number" ?

Thu, 30 Jul 2009 16:53:40 Z

Hi,

I'm sure we are all familiar with what is commonly known in payables as the "Check Number". Well, at least in v8 GP, sometimes this is called "Voucher/Payment Number”. (Even just plain "Payment Number" would have made more sense to me).

A customer wanted a payables SmartList that included the check number for payments. Turns out, it seems like that "Voucher/Payment Number” is the only payables field that is missing as a choice.

Humm . . .

Regards,
Bret

Btw, There is no "Select the Forum" option for plain old GP today, even though I asking this question from the GP forum. So, guess I'll have to select "Midrosoft Dynamics AX/NAV/CRM" and let you worry about how to get it into the GP forum for me please.

Dinamycs GP

Wed, 08 Jul 2009 17:49:04 Z

Hi thanks for read it!

I have a scroll window with several fields on it, one of them is a check box, the problem is when I am check in record by record, the first, second, third are ok, but in the sixth or seventh record, the rest of the fields are changed of record, the first are now the third, the third are now the sixth, etc..that measn the scrool window loss the focus or something

I appreciate your help.

Best regards.

econnect GP10 taIVCreateUOFMScheduleLine does not import in decimal places on EQUOMQTY?

Mon, 06 Jul 2009 07:27:46 Z

Here is my Xml at the econnect.Entry_point:

 <?xml version="1.0" encoding="utf-8" ?> 
- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <IVCreateUOFMScheduleType>
  <eConnectProcessInfo xsi:nil="true" /> 
  <taRequesterTrxDisabler_Items xsi:nil="true" /> 
- <taIVCreateUOFMScheduleLine_Items>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Hour</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>1</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Day</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>7.5</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Week</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>37.5</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Month</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>232.5</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
  </taIVCreateUOFMScheduleLine_Items>
- <taIVCreateUOFMScheduleHeader>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UMSCHDSC>Conversion</UMSCHDSC> 
  <BASEUOFM>Hour</BASEUOFM> 
  <UMDPQTYS>2</UMDPQTYS> 
  </taIVCreateUOFMScheduleHeader>
  </IVCreateUOFMScheduleType>
  </eConnect>

As you can see, my data has the decimal places indicated, e.g., <EQUOMQTY>232.5</EQUOMQTY>.
But look at the results I get from this import, (no errors from econnect either):

select * from iv40201 a
	join iv40202 b on a.uomschdl = b.uomschdl
	where a.uomschdl = 'conv-001'

Results:

CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Hour     	16384	Hour     	1.00000	1.00000	Used for Conversions                                                                                                                                                                                                                                           	45
CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Day      	32768	Hour     	7.00000	7.00000	Used for Conversions                                                                                                                                                                                                                                           	46
CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Week     	49152	Hour     	37.00000	37.00000	Used for Conversions                                                                                                                                                                                                                                           	47
CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Month    	65536	Hour     	232.00000	232.00000	Used for Conversions                                                                                                                                                                                                                                           	48

Should I report this as an "Issue" and where would I report it? <== Trick question... BTW, apparently, this doesn't go into the forum I'm trying to put it in, so can someone please move it to: Microsoft Developer Network > Forums Home > Dynamics GP

Greg Kowieski The World On-Line

Dynamics 10, SQL Server 2005, Trying to be able to edit and author SRS Reports on the remote server

Fri, 26 Jun 2009 18:15:28 Z

I have full capability to edit an author new report serer objects on the server itself but I am having trouble getting the same capability on my client notebook.

I am trying to run the MS SQL Server Reporting Services Wizard (from the business intelligence folder in my MS Dynamics Program Group)

Page 1:
Name of the MS Dynamics GP Server: I use the real name
SQL Log on credentials: sa & the sa password

Page 2:
Selece the Database to deploy reports for: I am able to pull up a list of all databases, I choose my live database
Modules: I choose "Select All"

Page 3:
Target Server URL: http://ssp/reportserver

X Failed to map the path '/reportserver'
---------------------------------------------

If I use the fully qualified name, same error.
If I remove "reportserver" I get "Client response content type of 'text/html', but expected 'text/xml'

-----------------------------------------------
When I go to the SQL server itself and check the configuration properties
Deployment-
OverwriteDataSources: False
TargetDataSourceFolder: Data Sources
TargetReportFoder: Custom
TargetServerURL: http://ssp/reportserver

I CAN'T FIGURE OUT HOW TO GET THS SETUP, IT IS DRIVING ME NUTS.
Any ideas??

Great \plains print to excell in foreign currency verbage

Thu, 18 Jun 2009 13:20:19 Z

When I print to a file from Great Plains and import to excell, the currency verbage is included(Ksh12,100.00). You can then not and the column. How do you get rid of the currency verbage so you add the columns? \i have done a =mid to get rid of the sysbols and the =value to get into numbers.

Automating File Upload into GP 10

Thu, 11 Jun 2009 19:03:42 Z

Hi,
I am trying to integrate my companies job application process with GP 10.0. Currently all positions are created within the HR module of GP, and received resumes are uploaded to an applicant's card. I want to automate the process from the companies website with a series of "Apply Online" web pages and the ability to upload a resume (all data and resume pulled into GP in batch).

My question is this specifically. How do I automate the resume upload into the GP application. I have found numerous ways to pull the data itself in (Integration Manager), but don't see any info anywhere regarding file upload or attachment.

Thanks,
Jdog

GP Workflow - user email keeps disappearing from db.user info table

Tue, 02 Jun 2009 18:24:14 Z

Is there any reason why the user's email address keeps disappearing from the db.user info table in GP 10 workflow? His user preferences are still there to receive emails but somehow, something is triggering it to drop the email address altogether.

Thank you!

GP Manufacturing - report on quantities required for purchasing

Tue, 02 Jun 2009 18:18:04 Z

GP Manufacturing question - Is there a report or window that will calculate how many quantities is required for each component of a finished goods (base component quantity minus available on hand) given the required finished goods quantity? This question is to anticipate the component items that need to be purchased.

Thanks!

Printer Icon Missing from some Workstations but not all

Wed, 27 May 2009 23:48:47 Z

Why would the Printer Icon be missing from some of the workstations in the Inventory Item Maintenance Window but not on other workstations?

Payment Terms Net Days Changing

Wed, 27 May 2009 23:59:29 Z

Has anyone heard of an issue where the payment terms net days changes say from 30 to 1. Only a few people have access to the window and those users are saying they have not changed it. He is not sure someone is not manually changing it but I wanted to see if anyone knows of an issue with the field.

Thanks,
Angie

Can't delete RMAs after status changed to Ready to Close

Mon, 18 May 2009 07:22:59 Z

Hi,

Is there any way of deleting an RMA after its status has been changed to "Ready to Close"?

Thanks,

Calvin

IV10402 - All records deleted???

Tue, 02 Jun 2009 00:11:11 Z

Hi,

Does anyone know how or why occasionally, the IV10402 table gets cleared of all entries? It's pretty frustrating as I have to restore a previous backup & then insert the records back in.

Is there a way of stopping this? There are no customisations on the pricing side, except for the "Delete" button being disabled.

Cheers,

Calvin

Import Asset Data at GP 10

Tue, 02 Jun 2009 04:28:41 Z

When I starting to import data asset into GP 10, its show an error with "Field on window is inactive or disable. (Line # 10)"

Please Advise on what kind of error being state on the above message.

Fixed Asset ID - Auto-assign Next Number

Tue, 26 May 2009 23:08:12 Z

Is there a way to have the Fixed Asset Management system assign the next Asset ID without the user having to look at the last number used? This seems to be a frequent request for Fixed Asset implementations as a setup option to allow the system to auto assign the Asset id.

Thanks!
Carol

Office accounting inventory integration into GP 10

Thu, 28 May 2009 01:02:23 Z

We have several office locations that are all connecting to GP 10 through a terminal server. 4 of our sattlite locations have need to keep invitory on hand. I understand that GP 10 has a module that can be used for Invitory control and what not however we are not talking huge warehouses. So the cost of this module is to much. basicly all I realy need is a system that can move the expense from invitory, to the job the part was used on in great plains. Office accounting seems to do this well. But will it do this with GP 10 Accounts? Can I intergrate these two systems? Perhaps there is a more cost effective and easier method. Could anyone provide me with information on intergrating Office accounting in to the GP 10 system or point me back into an easier solution.

Thanks

Workstation Information Missing or Damaged

Thu, 21 May 2009 14:40:39 Z

A client is running GP 7.5 on Windows 2000 Server running Terminal Services.

The hard drive crashed so Windows 2000 was installed and GP 7.5 was installed.

When you try to log into GP, you get the message "workstation information is missing or damaged."

We've tried putting the dex.ini in the Windows folder under the user's profile as well as trying to use the dex.ini in the GP folder.

What am I missing?

Thanks

Project Timesheet Information date format to be DD/MM/YYYY

Thu, 28 May 2009 05:37:14 Z

Hi,

Does anyone know how to change the date in the Webpage dialog, Project Timesheet Information to be in the format of DD/MM/YYYY? Currently it is set to MM/DD/YYYY.

The regional settings have all been changed to Australia & to DD/MM/YYYY but it still shows as MM/DD/YYYY.

Also, in the Project Timesheet Entry page, if I select the 25/05/2009, it starts from Tuesday the 19th of May instead...why does it not start at Monday 25th May?

Thanks,

Calvin

Shipment Matching: Dynamics GP

Mon, 25 May 2009 14:28:33 Z

Dear Sir / Madam

Kindly note that below inquiry:

We have an invoice sent by a supplier and was originated from a purchase order. The goods did not arrive yet, however we need to book the invoice in the system.

Is it possible to do invoice matching without having a shipment received in the first place, later on, we will match the shipment to the invoice.

Kindly note that we need this to be implemented on Microsoft Dynamics GP 9 & 10 having the latest service packs installed. This is really a high priority and we kindly require the best practical way noting that we know already that the process works the other way around in which we receive the shipment first, then we match the invoice to it.

Your reply is highly appreciated

Thank you in advance

Regards

Joseph Abou Nader

Joseph Abou Nader Dynamics GP Senior Consultant MCT,MCTS,MCBMSS,MCSA You will never know what power you have until you take decisions in a hard time.

Reconcile to GL

Tue, 26 May 2009 16:54:16 Z

I want to get a better understanding of how the Reconcile to GL spreadsheet
should be used.

What is the purpose of intersperced white and blue shaded rows. The color is
not alternating. There may be two white rows then three blue then one white
and one blue. What is the meaning?

All of our transactions appear as potentially matched. However, we have a
"difference" of .30. We don't know how to identify the source of the .30
differene.

A row may contain a dollar amount from the GL that is totally different from
the AP source. On the next line the same two amounts appear from the opposite
sources. Why would that be?

Thank you for your help.

Additional Sort

Mon, 25 May 2009 19:01:44 Z

Hi,

At the time of installing GP, I didnt select additional sorts.

Is that possible to do this after installing and start using the system ??

please advise

thanks

Syed

64 Bit Server when Installing FRx on client and Sysdata is on the server.

Thu, 21 May 2009 01:02:15 Z

I have a customer changing server. One question we have is whether the server can be 32 Bit or 64 Bit. I understand 64 Bit is ok with Windows 2003 and windows 2008. I understand 64 Bit works with Dynamics GP Service Pack two, three, or four.

My Question is regarding FRx. The system Requirements for Frx say to use a 32 bit machine. Do they mean client or server? FRx Sysdata would be the only folders or files on the Server. All the Frx Code would be installed at each client using FRx.

Can we have a 64 Bit server with Dynamics GP SP4 and FRx Sysdata on the Server?

Thank you.

Purchase Receipt Posting Error

Thu, 28 May 2009 20:31:19 Z

When posting on purchase receipts for one particular purchase receipt, we received the following error on Receivings Posting Journal:

Error: Posting to table IV10001. Restore from a backup if possible.

We cannot restore from a backup. Kindly suggest how to handle this error and resolve it. Our GP version is 9.0

Thank you.

Purchase Requisition Error

Thu, 28 May 2009 20:26:25 Z

On GP 10, when converting purchase requisitions to purchase orders, at times we get a red cross above "Select All" button stating Query Error.

Steps are:

a. User goes to convert purchase requisition window in Business Portal
b. Select the vendor in Filter By
c. Click Green arrow.
d. Instead of seeing purchase requisition, we get this red X saying Query Error.
e. Error happens for all users. Reset IIS and the error goes away.

Thank you.

Payroll - Vacation/Sick Time Accrual Register message

Tue, 05 May 2009 23:14:46 Z

Hi,

Re: GP 10--What does the following message (denoted by 4 asterisks) on Vacation/Sick
Time Accrual Register mean? 'Multiple or no vacation/sick pay records exist'?

Thanks very much,
--
Michele Durkin
415-298-1773