Search results for query: *

Thanks MajP, I will try to use the function. Thanks for your time.

Thanks for your responses. All variables are declared even the myProdID. Sorry for the delay in reply. MajP, I would prefer not to use the IIfs in queries but I have never build custom function. Would you be able to give one example? Thank you for your time.

Set rsCommRec = db.OpenRecordset("qry_comm_Data", dbopensnapshot) Do Unitl rsCommRec.EOF GoSub NewVars ' this sub routine set all variables to zero before the next product ID If myPreProdID <> myProdID Then myProdID = rsCommRec("ProductID") myInvAmt = myInvAmt + (rsCommRec("Qty")*...

I am opening query as recordset and looping through the records, doing calculation with the some of the data and appending the record to another table. These are the product quantity, cost, sales price and profit margin records for half month say 1/1 through 1/15. Generally, there is only one...

Thanks Jymm for your reply. I had looked at DB_Upgrade table but did not see anything. We had called MS and the Tech person asked to reapply the service pack that we had already tried three times. The issue was that patch was not updating the Dynamics.dic file. We copied the file from client...

We are at Version 9.0 for Dynamics GP. We installed service pack 2 on server, it installed fine and updated tables through GP Utilities. After updating tables, when we launch the GP on server it writes all new code but when we log in to the Dynamics, it gives error that client version is...

Thank you EBGreen and SkipVought for your prompt response. After I posted here, I realised my mistake that I am declaring as an integer. I just changed it and it worked. What confused me was that other two were increasing and SkipVought cleared that confusion. Thank you both for your time. I...

Hi all! Hope somebody can help me with this. I have given the Code below. I am trying to increase a varible in loop based on condition and case with 1 or 0.50. For some reason, AmtRP is not increasing by 0.50. It goes to that line of code but it will not increase it by 0.50. If I change the...

Thanks Victoria, I appreciate your reply. I will try to write a script using the information and post here if I am successfull. Thank you,

I am trying to do the Bank transaction entry integration to bring in non-AP checks and direct debits information. Can I bring the Bank transactions information in batch like AP and AR module so that I can look at it and decide if I want to post the batch or not? Also if anybody has done any...

Hi Scott, I am having the same problem but not on different workstations. If I try to log in through SQL Query Analyzer, it will not connect with same password that I log in through Dynamics. I used the same password for both before upgrading to GP 9.0. Could you please let me know how to run...

We upgraded from IM 7.5 to 9.0 as we upgraded to GP9. I have one integration which is calling SQL stored procedure and I can't get this integration to work after upgrade. When I run the integration, it does the connection but does not integrate any documents and gives the error Establishing...

I had posted the problem about voucher number but it is fixed and integration is working now. Luvsql, thanks once again for your help. This is a grate forum. Thank you all.

In integration I kept Voucher Number as default. When I run integration it assigns different voucher number for each transaction though my document number is same for all transctions. Do I need to give voucher number in integration? I tried to use same source field as Document number, as we have...

Thanks a bunch. I had created two sources and did the way you told for credit account. It did work and took AP control account from Vendor Card. but it just applies first debit amount to credit as I have only debit transaction amount and not invoice total. Let me give you some information...

I had problem with my userID, I used "sa" at this point just to check if I can connect and I did. I can see my columns. Thanks for the solution. This integration is for expense invoices and I am giving Amount as Purchases and the Distribution account for debit. Do I need to give the credit...

Luvsql, Thanks for your reply. I tried but got an error connection failed. For SERVER, do I need to give path to the database? Do I need to change Locale Identifier? if yes how would I get that? I appreciat your help. Thanks,

I have SQL stored procedure for expense invoices that I need to integrate in Great Plains. Can I call it through Integration Manager? Any reply is highly appreciated. Thanks in advance for your time.

Thanks PHV, Yes I did compiled successfully. I closed the application and started again and I can see the date. Thanks to all for your time. This is a grate forum. I get answers all the time browsing through it. This is my second post to this forum. Thanks to LittleSmudge and rubbernilly...

I had started import process on my machine and was also trying different passwords and finally one worked. Thank you for your help. I checked the references and missing one was Acrobat Control for ActiveX. I fixed that and not getting any error. But still I can't see the date. I checked for...