The code for FRx sp11 has been re released and we have tested this in house. We are happy to report it does what it says on the packet and we are now happy for our clients to install this service pack.
Friday, 22 January 2010
Thursday, 21 January 2010
Dynamics (GP) 2010 early findings
Hi folks.
We have a couple of clients on the early adopters program from Microsoft for Dynamics (GP) 2010.
We have hit our first issue, this only effects non U.S. installs and is a re occurrence of an issue from version 10.
The problem is installing Business portal. It won’t install on non U.S. regional settings. You need to change your regional settings to U.S., install BP and then change them back to U.K. or where ever else you are in the world. This was a problem in BP4 for version 10 and its still there in BP5 for version 2010 (beta).
We have a couple of clients on the early adopters program from Microsoft for Dynamics (GP) 2010.
We have hit our first issue, this only effects non U.S. installs and is a re occurrence of an issue from version 10.
The problem is installing Business portal. It won’t install on non U.S. regional settings. You need to change your regional settings to U.S., install BP and then change them back to U.K. or where ever else you are in the world. This was a problem in BP4 for version 10 and its still there in BP5 for version 2010 (beta).
Tuesday, 19 January 2010
How to Create SQL Scripts in Integration Manager without hardcoding the database
Here is a handy bit of code. Have you ever wanted to run a sql script in Integration manager after the task completes but you don't want to hard code the company database so you can use it against multiple companies?
Well here is the code to do this (in version 10), in the script window within Integration manager start off by setting the ADODB connection.
set MyCon = CreateObject("ADODB.Connection")
Then use the connection string to bring back the inter company ID
MyCon.Connectionstring = "database=" + GPConnection.GPConnInterCompanyID
Open your connection
GPConnection.Open(MyCon)
You can then construct your SQL statement, the below is an update statement
updatecommand = "update PM00200 "
updatecommand = updatecommand & " set PHNUMBR1 = 'xxxxx',"
updatecommand = updatecommand & " PHNUMBR2 = 'xxxxx',"
updatecommand = updatecommand & " PHONE3 = 'xxxx',"
updatecommand = updatecommand & " FAXNUMBR = 'xxxx'"
Then close the record set and exercute the command
recset = MyCon.Execute(updatecommand )
This becomes a very powerful tool when you combine it with before scripts which will enable you to fill out blank fields with place holders etc and then remove the place holders after the integration completes.
Well here is the code to do this (in version 10), in the script window within Integration manager start off by setting the ADODB connection.
set MyCon = CreateObject("ADODB.Connection")
Then use the connection string to bring back the inter company ID
MyCon.Connectionstring = "database=" + GPConnection.GPConnInterCompanyID
Open your connection
GPConnection.Open(MyCon)
You can then construct your SQL statement, the below is an update statement
updatecommand = "update PM00200 "
updatecommand = updatecommand & " set PHNUMBR1 = 'xxxxx',"
updatecommand = updatecommand & " PHNUMBR2 = 'xxxxx',"
updatecommand = updatecommand & " PHONE3 = 'xxxx',"
updatecommand = updatecommand & " FAXNUMBR = 'xxxx'"
Then close the record set and exercute the command
recset = MyCon.Execute(updatecommand )
This becomes a very powerful tool when you combine it with before scripts which will enable you to fill out blank fields with place holders etc and then remove the place holders after the integration completes.
Monday, 18 January 2010
Top 5 New features Dynamics (GP) 2010 (Beta release)
The beta release of Dynamics (GP) 2010 is here.
Our Dynamics (GP) Product Manager is currently in the process of testing this new code so its to early to give you our findings as yet. However I thought I would take this opportunity to wet your appetites with some of the New features that caught our attention.
2010 is rich in new features so we thought we would do our top 5 and as is traditional with these count downs we will start at 5 and work our way up to 1.
So coming in at number 5
5.Collections Management: View unposted cash amounts
This has been one of those annoying little over sites for credit controllers , well from version 2010 unposted cash amounts are now displayed in the collections main window.
Another new entry (quite literally) at number 4
4.Receivables Management: Enter negative cash receipts
You can now decrease a deposit by entering a negative cash receipt. This shows as a deposit with a negative amount (we have had a few support cases in the past that would have been easier to resolve with this functionality).
A simple piece of functionality at number 3 , however it is one that will make a lot of people happy.
3.Exclude inactive accounts/customers/creditors/sales people etc. from lookups
If your bogged down in active accounts etc. this should make lookups and data entry so much quicker.
At number 2, the word template comes of age
2.Word templates
Predefined word templates come with 2010 from purchase orders to invoices, I have included the list below of the Report writer reports that can now be done with word templates. Good bye to those clunky report writer reports.
Report Writer report name:
SOP Blank History Options Quote Form
SOP Blank History Quote Form
SOP Blank Options Quote Form
SOP Blank Quote Form
SOP Blank History Options Order Form
SOP Blank History Order Form
SOP Blank Options Order Form
SOP Blank Order Form
SOP Blank History Options Invoice Form
SOP Blank History Invoice Form
SOP Blank Options Invoice Form
SOP Blank Invoice Form
SOP Blank Packing Slip Form
RM Statement on Blank Paper
MC Statement Blank Form
Receivables Sales/Invoices
Receivables Debit Memos
Receivables Finance Charges
Receivables Service/Repairs
Receivables Warranties
Receivables Credit Memo
Receivables Returns
POP Purchase Order Blank Form
POP History Purchase Order Blank Form
POP Purchase Order Rollup Blank Form
POP History Purchase Order Rollup Blank Form
Payable Invoices
Payable Finance Charges
Payable Miscellaneous Charges
Payable Credit Memo
Payable Returns
Check Remittance
and we have saved the best till last top of the new features list is:
1. E-mail Functionality
The new email functionality allows you to embed documents into the body of an email or send as attachments. You can send single documents , batches or multiple document types using lists.
The following document types can be sent in an email and you have the choice of HTML, XPS, PDF or DOCx formats.
Documents:
Sales quote
Receivables finance charges
Sales order
Receivables warranty
Sales fulfillment order
Receivables service/repair
Sales invoice
Standard purchase order
Receivables invoice
Blanket purchase order
Receivables return
Drop-ship purchase order
Receivables debit memo
Vendor remittances
Receivables credit memo
If this has wet your appetite then keep watching this blog as we will be posting the initial findings of our testing on 2010 soon.
Our Dynamics (GP) Product Manager is currently in the process of testing this new code so its to early to give you our findings as yet. However I thought I would take this opportunity to wet your appetites with some of the New features that caught our attention.
2010 is rich in new features so we thought we would do our top 5 and as is traditional with these count downs we will start at 5 and work our way up to 1.
So coming in at number 5
5.Collections Management: View unposted cash amounts
This has been one of those annoying little over sites for credit controllers , well from version 2010 unposted cash amounts are now displayed in the collections main window.
Another new entry (quite literally) at number 4
4.Receivables Management: Enter negative cash receipts
You can now decrease a deposit by entering a negative cash receipt. This shows as a deposit with a negative amount (we have had a few support cases in the past that would have been easier to resolve with this functionality).
A simple piece of functionality at number 3 , however it is one that will make a lot of people happy.
3.Exclude inactive accounts/customers/creditors/sales people etc. from lookups
If your bogged down in active accounts etc. this should make lookups and data entry so much quicker.
At number 2, the word template comes of age
2.Word templates
Predefined word templates come with 2010 from purchase orders to invoices, I have included the list below of the Report writer reports that can now be done with word templates. Good bye to those clunky report writer reports.
Report Writer report name:
SOP Blank History Options Quote Form
SOP Blank History Quote Form
SOP Blank Options Quote Form
SOP Blank Quote Form
SOP Blank History Options Order Form
SOP Blank History Order Form
SOP Blank Options Order Form
SOP Blank Order Form
SOP Blank History Options Invoice Form
SOP Blank History Invoice Form
SOP Blank Options Invoice Form
SOP Blank Invoice Form
SOP Blank Packing Slip Form
RM Statement on Blank Paper
MC Statement Blank Form
Receivables Sales/Invoices
Receivables Debit Memos
Receivables Finance Charges
Receivables Service/Repairs
Receivables Warranties
Receivables Credit Memo
Receivables Returns
POP Purchase Order Blank Form
POP History Purchase Order Blank Form
POP Purchase Order Rollup Blank Form
POP History Purchase Order Rollup Blank Form
Payable Invoices
Payable Finance Charges
Payable Miscellaneous Charges
Payable Credit Memo
Payable Returns
Check Remittance
and we have saved the best till last top of the new features list is:
1. E-mail Functionality
The new email functionality allows you to embed documents into the body of an email or send as attachments. You can send single documents , batches or multiple document types using lists.
The following document types can be sent in an email and you have the choice of HTML, XPS, PDF or DOCx formats.
Documents:
Sales quote
Receivables finance charges
Sales order
Receivables warranty
Sales fulfillment order
Receivables service/repair
Sales invoice
Standard purchase order
Receivables invoice
Blanket purchase order
Receivables return
Drop-ship purchase order
Receivables debit memo
Vendor remittances
Receivables credit memo
If this has wet your appetite then keep watching this blog as we will be posting the initial findings of our testing on 2010 soon.
Monday, 21 December 2009
2010 EU Tax changes/update
As any of you who trade in Europe should know there are tax changes being brought in for 2010.
Simply put if you are trading/providing services in Europe (The EU) then you need to submit a sales listing along side your VAT100 report.
Microsoft have now released extra code to allow you to do this in the VAT daybook and Advanced intrastat modules.
You can use the below link to download the code for versions 9 and 10 :
https://mbs.microsoft.com/customersource/downloads/releases/MDGP10_9_VAT2010
If you have any questions please contact helpdesk@touchstone.co.uk
Simply put if you are trading/providing services in Europe (The EU) then you need to submit a sales listing along side your VAT100 report.
Microsoft have now released extra code to allow you to do this in the VAT daybook and Advanced intrastat modules.
You can use the below link to download the code for versions 9 and 10 :
https://mbs.microsoft.com/customersource/downloads/releases/MDGP10_9_VAT2010
If you have any questions please contact helpdesk@touchstone.co.uk
Bug In FRx SP11 core code (Please do not install)
Service Pack 11 was recently pulled due to a core FRx bug found. The last update from Microsoft's Development is that it should be available for release in 4 weeks.
To roll back to SP9 you can follow KB 861724 "How to remove a Service Pack for FRx". The link is provided below. If you can not access the link please contact helpdesk@touchstone.co.uk
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;861724
To roll back to SP9 you can follow KB 861724 "How to remove a Service Pack for FRx". The link is provided below. If you can not access the link please contact helpdesk@touchstone.co.uk
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;861724
Wednesday, 16 December 2009
FRX and Windows 7
Hi Folks, a quick update to the whole windows 7 compatibility status. FRx 6.7 is now compatible with windows 7 as long as the recently released Service Pack 11 is installed.
for more information on SP11 for FRx 6.7 please contact the helpdesk@touchstone.co.uk
for more information on SP11 for FRx 6.7 please contact the helpdesk@touchstone.co.uk
Subscribe to:
Posts (Atom)
Posts
