RE: [Axapta-Knowledge-Village] delete_from vs loop delete

advice: use delete_from wherever you can but, as with all database access, make sure you have suitable indexes. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf

RE: [Axapta-Knowledge-Village] delete_from vs loop delete

suitable index for my table, but sometimes still returns me lock error. If I use batch helpers, for sure I get more lock issue in activity monitor. If this is the case, is loop delete the righteous solution ? Thanks and Regards, Afin On Wed, Sep 1, 2010 at 4:07 PM, Malcolm Burtt malcolm.bu

RE: [Axapta-Knowledge-Village] when to use Index and index hint

reason to use “Index” at all. It simply ensures that the data is returned sorted in the index order which you can already achieve with the “Order By” clause with the important advantage that the sort order would not change if someone altered the index definition in some way. Regards Malcolm

RE: [Axapta-Knowledge-Village] Re: Select Sum slow performance

plan must be based on average statistics. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Donny Wu Sent: 09 July 2010 03:42 To: Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] AOS crash

object servers that remain active then delete the axdat.udb file form the Ax appl/standard directory (or whatever your application directory is called). Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta

RE: [Axapta-Knowledge-Village] AX With different Locations

for those that are remote. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Amgad Toma Sent: 04 February 2010 09:23 To: development-axa...@yahoogroups.com; Axapta

[Axapta-Knowledge-Village] RE: [development-axapta] Reg Is there way to send reports via email automatically

notification emails as AX uses the same mechanism for that. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: development-axa...@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of trinadh sura Sent: 13 October 2009 11:37 To: Axapta-Knowledge

RE: [Axapta-Knowledge-Village] Client to AOS

Hi James Connecting to object servers over a WAN worked okay in version 3 but since AX 4 it's a complete no-no. Your only option from AX 4 onwards is one of the many remote desktop solutions (e.g. RDP, Citrix, etc). Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions

RE: [Axapta-Knowledge-Village] Section of report on back side

is concerned it's just printing page 2 but the printer is placing this on the reverse side. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of naveed ali Sent: 27

RE: [Axapta-Knowledge-Village] send mail via axapta

organisation. Local emails will work fine but emails to another domain will be rejected by the mail server. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of sameerak6

RE: [Axapta-Knowledge-Village] Hide AOT/Project Icons on toolbar

Hi John Yes, you can simply remove their access to these by setting the Development security key to No Access for the user groups that these users are members of. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com

RE: [Axapta-Knowledge-Village] Printing of Multiple Checks using Batch Process

Hi Maybe you could try printing the checks into the print archive and then print them for real from the archive all in one go. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill

RE: [Axapta-Knowledge-Village] Integration between Dynamics AX 2009 and Exchange server.

. You should also make sure that the SMTP server is configured to accept connections from the AOS and that it can relay messages for the AOS. Regards Malcolm Burtt Product Development Manager Touchstone AX T: +44 1865 890012 F: +44 1865 890098 E: malcolm.bu...@touchstone.co.ukmailto:malcolm.bu

RE: [Axapta-Knowledge-Village] Load balancer managing load across various AOS

Hi Jayakumar The AOS load balancing is a simple balancer that ensures that the AOS cluster has an even number of users per AOS. There is no attempt to assess differing CPU loads, etc it's just about number of users. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions

RE: [Axapta-Knowledge-Village] Ax 2009, problem with debugging batch jobs

Hi Moreton Did you try logging on to the AOS server that is executing the batch job using the login account that the AOS service runs under? You might also need to prestart the debugger executable before the breakpoint has been reached. Regards Malcolm Burtt Touchstone Group People

RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0

4 to AX 3 really easy. Malcolm Burtt Touchstone Group People - Partnership - Solutions Malcolm From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 26 March 2009 02:33 To: Axapta-Knowledge-Village@yahoogroups.com

RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0

-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 19:35 To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge

RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 19:35 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0

RE: [Axapta-Knowledge-Village] AX2009 on xp a good idea?

Hi James I'm pretty sure that SharePoint isn't going to run on XP and you might struggle to get the workflow engine running there too but... ...how about installing everything that you can get working directly on XP and then running all the stuff that will only work on a server OS (like

RE: [Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!!

that the assumption is that the report layout worked with that margin and that you'd want to keep that to ensure that the report matched what you saw on the original system. Something of a rambling answer, I know, but hopefully I got the point across. :) Regards Malcolm Burtt Touchstone Group

RE: [Axapta-Knowledge-Village] Create index with first column not dataareaid

means you need to know where in the Ax code the selects are coming from) then it can be a useful tool. Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Agus Riyadi Sent

RE: [Axapta-Knowledge-Village] Space rental / cold storage

Hi James Touchstone's Enterprise Rental System might be what you're looking for. See http://www.touchstone.co.uk/industry_sectors/rental.aspx Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED

RE: [Axapta-Knowledge-Village] Space rental / cold storage

to how to describe the business of my prospect Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Burtt Sent: 18 November 2008 18:35 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta

RE: [Axapta-Knowledge-Village] Axapta getting restarted

and then restart the AOS. Hope that helps Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pradeep itnal Sent: 04 November 2008 07:28 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta

RE: [Axapta-Knowledge-Village] Changing window color

to add a new field that allows the user to select the colour for that company and then implement some code in SysSetupFormRun that sets the colour based on that new field.# Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com

RE: [Axapta-Knowledge-Village] Batch

as being easier to administer. You may also find the article at http://axaptabuilder.blogspot.com/2006/04/how-to-setup-axapta-batch-server.html useful. Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED

RE: [Axapta-Knowledge-Village] Crystal reports 10 with ax4

. Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Alaa Assem Sent: 13 May 2008 14:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Crystal reports 10 with ax4

RE: [Axapta-Knowledge-Village] Problem loging on to SQl server

Hi Lars I'm not sure if this will work as I don't have your setup to test it, but you could try specifying the server on SQL Server settings tab of the configuration tool as servername:port (e.g. myserver:1434). Regards Malcolm Burtt Touchstone People, Partnership, Solutions From: Axapta

RE: [Axapta-Knowledge-Village] Xml document generation

want you want without changing Ax at all using this mechanism. Regards Malcolm Burtt Touchstone People, Partnership, Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of tearstechnologies Sent: 28 January 2008 13:01 To: Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] Error loading vcgantt.ifd in Ax40SP2

-register it by executing the command below regsvr32 /u pathname (where pathname is the full pathname to the vcgantt.ocx file to be unregistered) 3.Now re-register the vcgantt.ocx file for the AX 4.0 SP2 client. regsvr32 pathname That should solve the problem. Regards Malcolm Burtt Touchstone

RE: [Axapta-Knowledge-Village] Disable Prompt for file overwrite

Hi James Not sure if you can do that but have you considered modifying your code so that it first checks whether the file exists and, if it does, deletes it before it goes on to produce the new report? Regards Malcolm Burtt Touchstone People, Partnerships, Solutions From: Axapta-Knowledge

RE: [Axapta-Knowledge-Village] Remote Axapta client software?

DSL and the WTS connects to Axapta. If you need to go over greater distances still than you can look at Citrix as this is better able to cope with the latency. Regards Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto

RE: [Axapta-Knowledge-Village] Print Archive is kept where?

Hi James You'll find it in the system tables PrintJobHeader PrintJobPages...not that you can make much use of that info. :-) I wanted to add some extra stuff to the archive each time a job was sent to it just a few months back, but couldn't find a way to do that. Regards Malcolm Burtt

RE: [Axapta-Knowledge-Village] Pre Printed stationary for Report

Hi Just change the Top and Bottom margins on your report design (go to the report's Design node, right click, select Properties and find Top Margin, etc). That'll take care of it. Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal

them. Regards Malcolm Burtt Touchstone People, Partnership, Solutions -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Özgür Genç Sent: 08 May 2006 13:15 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge

RE: [Axapta-Knowledge-Village] Copy the image from one location to another location-Urgent

...or you could simply do.. WinApi::copyFile(C:\\Image\\blue hills.jpg, C:\\Image1\\blue hills.jpg); Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of sunil padhy Sent: 13 April 2006

RE: [Axapta-Knowledge-Village] How to Speed up the posting process

Hi This change was a hotfix for SP3 which you can get from MBS or your partner. SP4 was supplied with the fix as far as I can remember. Regards Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED

RE: [Axapta-Knowledge-Village] Email sending error - Dundas error 0x80004005

the real cause of the problem. I used the W3C HTML parses at http://validator.w3.org/ and found a few errors in the HTML, so I changed my code so that I got clean HTML and reverted to the original message text and the Dundas error message went away. Regards Malcolm Burtt Touchstone People

RE: [Axapta-Knowledge-Village] Excel Add-ins for Axapta

Hi You could try Vision (http://www.visionreporting.com/Solutions/Microsoft_Business_Solutions.h tml) Malcolm Burtt Touchstone People, Partnerships, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Satish Sent: 31 March 2006 07:03

RE: RE : [Axapta-Knowledge-Village] Re: Batch Processing

Hi Steve There's an article on Partner Source on how to do this. (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYVTQUUXNNZOUKYPPPZYQTZVRLWKRYOZLQNPMMUNNRQMXPSSQKXQPSORTKPWNWMPOX) Regards Malcolm Burtt Touchstone People, Partnerships, Solutions _ From

RE: RE : RE : [Axapta-Knowledge-Village] Re: Batch Processing

the Batch Server service, and then click Properties. c. Click Start. Note: The service only monitors and processes batches that have not been assigned to a specific batch queue. Malcolm Burtt Touchstone People, Partnerships, Solutions _ From: Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] Switch user - Log off without shutdown?

options and just displayed our login screen. This was done using a dummy guest account which was configured with minimum access rights. When you click the logout option, it closes all open Axapta windows, changes the active user account to the guest user and fires up the login form. Regards Malcolm

RE: [Axapta-Knowledge-Village] Multiple branches under single company

to this, however, its tedious amendments to each and every affected form and report. Regards Malcolm Burtt Touchstone Our Trusted Solutions - Your Optimised Business _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of snk19692000 Sent: 10

RE: [Axapta-Knowledge-Village] AOS Connection Problem.

Hi Do you have the windows firewall enabled on the object server. That might be blocking the client from connecting. Regards Malcolm BurttTouchstone Our Trusted Solutions - Your Optimised Business From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [Axapta-Knowledge-Village] Web Access

on the Internet becuase its a public network; this probably won't trouble you unless you are a heavy user (in which case you should look into a managed VPN solution from an ISP or other comms provider who will give you a service level agreement on your connection). Regards Malcolm Burtt Touchstone

RE: [Axapta-Knowledge-Village] Re: Performance

Have you checked whether the process is suffering from lock contention (e.g. by running the sp_who2 database stored procedure from the query profiler)? Regards Malcolm Burtt From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stefan CapiauSent: 21

RE: [Axapta-Knowledge-Village] Load balancing the AOS

user B complain yesterday when user A did not"). Good luck Malcolm Burtt Touchstone Our Trusted Solutions - Your Optimised Business From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon GeorgeSent: 14 December 2005 18:31To: Axapta-Knowledge-Village@ya

RE: [Axapta-Knowledge-Village] Load balancing the AOS

omplaining when user B is not and why the hell did user B complain yesterday when user A did not"). Good luck Malcolm Burtt Touchstone Our Trusted Solutions - Your Optimised Business From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon GeorgeSe

RE: [Axapta-Knowledge-Village] Question : SysMailer

Hi The code looks okay to me on cursory inspection. What you might want to check is whether the relay server you're using is configured to allow you to connect to it. Its common to configure SMTP servers to have a restricted list of machines that are allowed to relay through it and it

RE: [Axapta-Knowledge-Village] Re: Start batch-job automatically

''ApplUpgrade'Each of these command is handled by its own SysStartUpCmd subclass. I've only ever used the 'batch' command, so can't vouch for the effectiveness of the others. Regards Malcolm Burtt Touchstone Our Trusted Solutions - Your Optimised Business From: Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] Batch-Job running on AOS?

Hi I run my batch server via the Windows "Scheduled Tasks" feature by adding a startup command of "batch" to the Axapta configuration. This causes Axapta to execute the batch processing menu point on startup. The ax32.exe Axapta executable effectively runs as a headless client because it

RE: [Axapta-Knowledge-Village] days of month

you the date n months on from the specified date, which means you can just do... if ( dateMthFwd( previousDate, 1) selectedDate ) { error() } Regards Malcolm Burtt Touchstone Our Trusted Solutions - Your Optimised Business From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL

RE: [Axapta-Knowledge-Village] show the error after inputting name and password

Hi Try checking the Windows application event log on the object server machine. That might give a clue as to why the session is terminated. Regards Malcolm Burtt Touchstone Our Trusted Solutions - Your Optimised Business From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL

RE: [Axapta-Knowledge-Village] MDAC to SQL Server

If I understand what you're asking correctly, the answer is that you can't. Version 3.0 does use native connections for Oracle but still uses ODBC for SQL Server. I think I've heard that Axapta 4.0 will support native SQL Server connections. Malcolm Burtt Touchstone Our Trusted

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

Its relatively easy to prove one way or the other. Write a job with a select statement whose where clause fields are in the order of an index on the table. Turn on SQL trace (sent to database is best) then run the job. Now change the order of the fields in the job's select statement and

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

ASFAIK it shouldn't make any difference which order the fields in a where clause are specified as the SQL query optimiser will sort it all out when it calculates the query plan. Regards Malcolm From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Girish

RE: [Axapta-Knowledge-Village] Error on creating EP web site

Hi I came across this problem just last week and managed to solve it as follows... Modify the WebSiteTable.createVirtualDirectory() method around line 53, change the line that reads httpErrorsArray.value(httpErrorsArray.lastIndex(),COMVariant::createFromStr(newHTTPValue)); to...

RE: [Axapta-Knowledge-Village] Error sending e-mail automatically in axapta

will be blocked. That could be what is happening to you. Hope that gives you some help Malcolm Burtt From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Melih DemirSent: 26 August 2005 13:09To: Axapta-Knowledge-Village@yahoogroups.com; development-axapta

RE: [Axapta-Knowledge-Village] Axapta and indexes

age@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 2003I Agree Malcolm. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS "Malcolm Burtt"

RE: [Axapta-Knowledge-Village] Axapta and indexes

Solutions-AxaptaOPEN SOLUTIONS "Malcolm Burtt" [EMAIL PROTECTED] Enviado por: Axapta-Knowledge-Village@yahoogroups.com 24/06/2005 09:35

RE: [Axapta-Knowledge-Village] Adding Built in Functions

. myval = myfunc(1,2); Regards Malcolm Burtt Global IT Group"Business Solutions designed for YOUR business processes"Global IT Group is the trading name of Touchstone Global Business Solutions Ltd. and is part of the Touchstone Group PLC. -Original Message-From: Axapta

RE: [Axapta-Knowledge-Village] Adding Built in Functions

of the list of classes in the AOT) and you can refer to it in code in the same way as kernel functions. e.g. myval = myfunc(1,2); Regards Malcolm Burtt Global IT Group"Business Solutions designed for YOUR business processes"Global IT Group is the trading na

RE: [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 2003

Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS "Malcolm Burtt" [EMAIL PROTECTED] Enviado por: Axapta-Knowledge-Village@y

RE: [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 2003

y. I would install 2.1 as described above from the installation CD (including applying any services packs using the same approach) then replace the Appl directory with your existing one. Hope that helps. Regards Malcolm Burtt Global IT Group"Business Solutions designed for YOUR b

RE: [Axapta-Knowledge-Village] Remote Access Question

with terminal services or Citrix, in fact I would recommend it as it means all your users benefit from the object server caching rather than maintaining their own caches. Regards Malcolm Burtt Global IT Group"Business Solutions designed for YOUR business processes"Global IT Group is t

RE: [Axapta-Knowledge-Village] Axapta Object Servers

Hi Have you had a look in the Windows event log (Application) to see if there are any log entries related to the AOS at the time when you tried to start it. Often clues to failed start-ups are shown in there. Malcolm Burtt Global IT Group"Business Solutions designed for YOUR bus

RE: [Axapta-Knowledge-Village] Two layer customizing

ayer. Note that this changes the table and field Id's that were allocated, so you cannot usethe new application against an existing database. Good luck Malcolm Burtt Global IT Group"Business Solutions designed for YOUR business processes"Global IT Group is the trading name of Touchs

RE: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

, approved date and approved amount. Whena user attempts to post an order that is already approved, the system checks that the order value is still below the approval amount recorded when it was approved. I hope that gives you some ideas on what you could do for your client Regards Malcolm

RE: [Axapta-Knowledge-Village] Adding Conditions to the Range of a Query

Hi Try the following queryBuild.dataSourceTable(tableNum(SalesLine)).addRange(fieldnum(SalesLine,remainSalesFinancial)).value("0"); Malcolm Burtt Global IT Group"Business Solutions designed for YOUR business processes"Global IT Group is the trading name of Touchs

RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards

Malcolm Burtt -Original Message-From: David VanEchaute [mailto:[EMAIL PROTECTED]Sent: 06 October 2004 14:21To: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, I had

RE: [Axapta-Knowledge-Village] Offline Mode

to locallystore some information that is normally held in the Axapta database (Stock items and prices, for example). You'll need to implement something that ensures this stays synchronised with the central database. Good luck. Let us know how you get on. Regards Malcolm Burtt Global IT Group

RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0

see MSPivotTable9 and 10 Regards Matt From: Malcolm Burtt [mailto:[EMAIL PROTECTED] Sent: 27 September 2004 13:47To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0 Hi Matt There was some odd stuff (IMHO

RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0

the Office 2000 pivot table control. I've found that the XP control is faster and more functional, so I wanted to make sure that Axapta could take advantage it if it was available. You'll probably find that SP2 will use the Windows 2000 control. Regards Malcolm Burtt -Original Message-From