[Axapta-Knowledge-Village] Re: Ax report to excel

I've been trying to use this too. In the File menu there is an option "Export to Excel (ctrl-E)" but it is always greyed out - anyone know how this can be enabled? Hans --- In Axapta-Knowledge-Village@yahoogroups.com, "Irshad" wrote: > > Hi Suneel > > yes you can export the report in micros

[Axapta-Knowledge-Village] Changing default inventory locations - update POs for delivery?

My client likes to change the default receiving locations for some of their items regularly, due to seasonal trading patterns etc. They find that, when there is a delivery from a vendor, the location recorded on the PO is out of date, so they are asking for a way to automatically update the loc

[Axapta-Knowledge-Village] Returning items sold at old VAT rate

Hi all The UK VAT rate changed on 31dec2009. If an item was sold pre-31dec2009 at the old VAT rate (15%) and is now to be returned. The current rate is 17.5%. Ax2009 will not allow selection of Item VAT Group on the return order, resulting in incorrect postings. The only option seems to be

[Axapta-Knowledge-Village] Re: AX high ava and licenses???

Hi Kardo Correct, for database server you should use active-passive cluster. For AOS you need one AOS licence for each AOS you plan to connect to the same database; however you can add a load-sharing instance without using up a licence. This just allocates users on a round-robin basis, and if

[Axapta-Knowledge-Village] Re: URGENT: Customizing Form/Report for GL Dimensions

There is no facility for multiple document formats, but you can add/amend logic in the document report program PurchPurchaseOrder to change layout according to any variables. Also check out 3rd party products e.g. BottomLine Hans --- In Axapta-Knowledge-Village@yahoogroups.com, Ax Consultant

[Axapta-Knowledge-Village] Import ZIP/Postal codes

In the AX2009 ZIP/Postcodes form there is a button to "Import ZIP/Postcodes". The import form asks you to choose a Country/Region code, but only offers Netherlands, Sweden, USA, and Belgium, regardless of the entries in the Country/Region table. Anyone know of a fix for this? Hans

[Axapta-Knowledge-Village] Re: 64 bit

Hi Craig I think you can ignore this error. You will also see, if you go to "Manage Deployments" the error "Enterprise Portal is not deployed on this computer", but the site runs ok. Management of the site has to be done via SharePoint Central. Hans --- In Axapta-Knowledge-Village@yahoogrou

[Axapta-Knowledge-Village] Re: Error while deploying report libraries in AX 2009

Here's the response provided in "SSRS and SSAS Integration for Microsoft Dynamics AX 2009", available here

[Axapta-Knowledge-Village] Re: Error occured during running Enterprise Portal in AX2009

I think you will find that you must start with a fresh server - AX2009 portal cannot coexist with AX4.0 portal on the same server (I think it's because WSS has no way of separating the two sets of web parts). Hans --- In Axapta-Knowledge-Village@yahoogroups.com, narendra singh wrote: > > Hi

[Axapta-Knowledge-Village] Re: AX2009 Project Server Integration

anning bases on. > > Thanks, > Kathy > > > > > > From: hkruiniger <[EMAIL PROTECTED]> > To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Friday, November 7, 2008 6:14:51 AM > Subject: [Axapta-Knowledge-Village] AX2009

[Axapta-Knowledge-Village] AX2009 Project Server Integration

Has anyone worked with this much yet? We're trying to set up a demo for what seems a simple requirement: The PM will manage scheduling of activities in MS Project and synch to AX Projects. Activities in AX have Item Requirements which then get scheduled via Master Planning - all ok. PM the

[Axapta-Knowledge-Village] Re: Commodities trading solution

Hi James My company Touchstone offers a commodity trading solution for AX with a number of UK & European customers. I'll ask someone to get in touch with you, but meanwhole see: http://www.touchstone.co.uk/industry_sectors/commodity_trading.aspx Hans --- In Axapta-Knowledge-Village@yahoogrou

[Axapta-Knowledge-Village] Re: Terminal Services - Ms Office and Emailing

Hi Johan This should all work fine, it is similar to the setup that many of our clients use too. You can solve the issue with office documents by setting up terminal services to map the user's local drives so they are accessible in the TS session. Instal Office and Outlook on the terminal se

[Axapta-Knowledge-Village] Re: problems in Dimension validation in COA

We went through this earlier in the year. This is standard behaviour. You get one or the other. If you want to use dimension set rules, you give up the old-style validations. Then you have to create the sets and rules that you need to give the equivalent validations. Hans --- In Axapta-Kn

[Axapta-Knowledge-Village] Re: Error in Sql Statement

Hi Daniel You need to look in the application event log on the machine running the AOS - you will get more detail about what SQL Server is objecting to. Hans --- In Axapta-Knowledge-Village@yahoogroups.com, "Daniel Zanni" <[EMAIL PROTECTED]> wrote: > > Hello, > > I have a SQL statement lik

[Axapta-Knowledge-Village] Re: How do you Identify different AX4 instances?

Axaptapedia has a helpful solution to this, shows you how to get instance info into the title bar. Go to http://www.axaptapedia.com/Configuration_in_title_bar for details. Hans --- In Axapta-Knowledge-Village@yahoogroups.com, "Steve Wright" <[EMAIL PROTECTED]> wrote: > > In the client AX Conf

[Axapta-Knowledge-Village] Re: Can't create EP site

t; ASP.NET Tab. Check that v2.0.50727 is selected. This > error usually happens when the ASP.NET tab does not have > v.2.0.50727selected. I got this error once. > Hope this helps. > > Arijit Basu > > On 05 Apr 2007 05:28:29 -0700, hkruiniger <[EMAIL PROTECTED]> wrote:

[Axapta-Knowledge-Village] Re: Synchronise error - drop non-existent field

gt; > Any further query is most welcome. > Regards, > Ashwani Jain > > > - Original Message > From: hkruiniger <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: Wednesday, 4 April, 2007 8:53:02 PM > Subject: [Axapta-Knowledge-Village] Synchronise error

[Axapta-Knowledge-Village] Can't create EP site

Installed EP as per documentation. I get to "Top level site successfully created"; I go to the new site and get the Template picker, as expected. I choose either the Enterprise Portal or the EP Public template, and get this error: "Could not load the assembly 'Microsoft.Dynamics.WebParts,Vers

[Axapta-Knowledge-Village] Synchronise error - drop non-existent field

Problem: table definition in AOT specifies a field for which there is no column in the actual SQL Server table. I have turned off the config key responsible for this field and now synchronise wants to remove it from the table, but gives an error since the column is not there to be dropped! I

[Axapta-Knowledge-Village] Using China functionality outside China

Does anyone have any experience of using any of the functionality available under the China-specific config keys? Specifically the extended bank reconciliation, also one or two others. These seem to work ok. The question is, why has MS buried such a widely-applicable and potentially very usef

[Axapta-Knowledge-Village] Components required to access AX OLAP cubes

Dear group I have AX 4.0 SP1 and SQL 2005. I have the standard cubes in the DMO company and when I am logged in as the primary Admin user I can view them fine, from both the normal XP client and from a client on the Terminal Server. When I log in as another user, on the same computer, I get

[Axapta-Knowledge-Village] Retrieving SO and PO data from "void"

My customer had a good idea for limiting the size of the current Sales Order and Purchase Order files, in the interests of usability, and set the flag to "void" these orders once they had been invoiced.  Worked great, and they could even inspect hese "archived" (as they thought of them) orde

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

We have a need for the user of a device to change frequently. Does anyone have a suggestion for logging a user off Axapta back to the login screen? Closing the app and re-starting from a desktop icon takes longer. Also, any way of logging off automatically after an idle period? (Not if chan

[Axapta-Knowledge-Village] Pallet substitution

Here's the scenario: The shipment has reserved a full pallet P1 containing quantity Q of item I. The forklift operator notices that P1 is behind a similar pallet P2, same quantity, same item, so he wants to take P2 instead. He's in WMS - Pallet Transports, he hits the "Select another Pallet"

[Axapta-Knowledge-Village] Re: Demand Planner

Hi Bob We have installed DP with AX 3.0, and have also found "a few challenges" as you politely put it! The most unintuitive piece of software I've come across in a long time! Why on earth is every window modal, so you can't even click Help We've left it alone while we complete other stu

[Axapta-Knowledge-Village] Sales Order reservation logic - full pallets needed

We have a problem with the reservations logic employed during sales order entry. The scenario: Sales orders automatically reserve stock when they are posted. Stock is allocated to the order strictly on a FIFO basis (date controlled or batch#), disregarding picking efficiency. When the shipm

[Axapta-Knowledge-Village] Re: Reserving stock (inventory) vs picking logic

just ATP? Please Hans --- In Axapta-Knowledge-Village@yahoogroups.com, "hkruiniger" <[EMAIL PROTECTED]> wrote: > > Hi team - I'm sure someone must have come across this one: > > My client sells product by the case. For storage and shipping, 60 > cases

[Axapta-Knowledge-Village] Re: Document management templates

What about the local windows setting on the AOS server? --- In Axapta-Knowledge-Village@yahoogroups.com, "Andrew Staples" <[EMAIL PROTECTED]> wrote: > > Yes, everything is correct (if it weren't, all documents would exhibit this > behavior). > > Andrew > > > -Original Message- > > Fr

[Axapta-Knowledge-Village] CRM User training material

My client is on Ax3.0 SP4. The user training materials that I have been able to find for the CRM module appear to date back to version 2.5, and there have been a lot of changes since then! Does anyone have anything or know of anything more up to date? The particular areas needed are: 1. Ent

[Axapta-Knowledge-Village] Can we please de-junk our posts?

I like to scan though the daily email rapidly to spot things of interest.Surely I can't be the only one who finds it tedious in the extreme to scroll past multiple copies of lengthy tails to the various long-running threads?  Especially things like "Sponsored links" which get rendered as text an

[Axapta-Knowledge-Village] Re: 3 Tier setup - Web deployment

Hi spikyface Your symptoms sound like those described in KB article 899039. I've pasted in the details in case you don't have access :-) HTH Hans CAUSE This behavior occurs if .xpo files and .ini files are not defined Multipurpose Internet Mail Extension (MIME) ty

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

On Axapta 3.0 SP3, using the web site wizard, I go right through accepting defaults everywhere, creating a web site based on the standard Enterprise Portal application, which is also configured in a pretty-much default fashion. I hit "Finish" and immediately get the rather unhelpful error messa

[Axapta-Knowledge-Village] Re: Changing App. Title Bar Color?

We get this request frequently, usuallly to be able to readily distinguish between dev/test/live versions of the system. The ideal way for most people would be to set the window back ground colour, or perhaps font colour. Axapta very conveniently sets the BackgroundColor attribute on forms, b

[Axapta-Knowledge-Village] Filtering on a non-filterable field?

Dear all: my client has a requirement to filter the display in the CRM Activities screen by using a wildcard match in the Memo field, which they use as a log of phone calls, interest expressed in products, etc. However the standard filter facilities, ctrl-F etc are not available - how can I c

[Axapta-Knowledge-Village] Re: Aos exam

The correct answers are A and C. Hans Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yah

: [Axapta-Knowledge-Village] Re: Denying user access to form setup

access to form setup > > Hi Hans, > > Very strange.. When I "disconnect" users from the user group allowed to > change the form setup, they actually cannot change anything. > > Hmm, I will take a further look... > > /Jens > > -Oprindelig meddelelse

[Axapta-Knowledge-Village] Re: Denying user access to form setup

> > Hope this helps... > > /Jens > > -Oprindelig meddelelse- > Fra: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] vegne af hkruiniger > Sendt: 11. juli 2005 18:33 > Til: Axapta-Knowledge-Village@yahoogroups.com > Emne: [Axapta-Knowledge-Vill

[Axapta-Knowledge-Village] Denying user access to form setup

This is the setup accessed via a right-click in the form & choosing setup, which allows one to hide fields and re-arrange the way data is displayed. My client wishes to prevent this - does anyone kow how to prevent users from making changes to their forms? I've tried setting a security key

[Axapta-Knowledge-Village] Address - selecting a county directly

The requirement: My client only deals with addresses in England (mainly), Wales and Scotland. They want addresses to show the County field but not the Territory (=StateID field). They do want the County field to be validated from the County table. They don't want to have to enter 'UK' in

[Axapta-Knowledge-Village] DictEnum error on import from Excel

I've been experiencing the following STOP error frequently during imports: Error executing code: DictEnum object not initialised. Stack trace: \Classes\DictEnum\name2Value \Classes\SysDataImportExcelClient\read - line 165 \Classes\SysDataImportExcelServersheet2Table - line 53 \ClassesSysDataI

[Axapta-Knowledge-Village] Re: Request on COM Gateway

Hi Sri Ram. The Commerce Gateway is for exchanging transactions automatically with other organisations, so that's really about buying & selling stuff, hence the links to Sales Orders, Purchase Orders and Invoices. It really wouldn't make sense to have GL journals or HR transactions handled thi

[Axapta-Knowledge-Village] Re: business connector setup

also if you can start Axapta as this identity. > > br > karsten > > --- In Axapta-Knowledge-Village@yahoogroups.com, "hkruiniger" > <[EMAIL PROTECTED]> wrote: > > I get a strange error while trying to set up the Business > Connector - > > it loo

[Axapta-Knowledge-Village] business connector setup

I get a strange error while trying to set up the Business Connector - it looks for a blank config and can't find it. Message in error log reads: "The configuration '' could not be found. Use the Navision Axapta Configuration Utility to verify the configuration." I have a number of configs se

Re: RE : [Axapta-Knowledge-Village] Axapta database access

You should check out Business Views. Extract from some doc: "Using business views, these enum values can be extracted from Axapta, and viewed externally in their human readable format, so for example, instead of seeing the internal value 0, in a business view, you would see the English word 'N

[Axapta-Knowledge-Village] Outlook synch in CRM

I'm in the DMO company. I have linked the login user (Admin) to the demo account (Tina Gold TGO) and set the email address/Outlook user id for both Tina and Admin to be my own internal email account. Each time I enter an Appoinment or Task in CRM Activities I get the Outlook security popup "A

[Axapta-Knowledge-Village] Re: Demand planner XPO

--- In Axapta-Knowledge-Village@yahoogroups.com, "Amit Nirantare" <[EMAIL PROTECTED]> wrote: > I have a evaluation pack of Demand planner for Axapta. Do any one have xpo files for demand planner. I want to evaluate the package and so require the same. > > Need help. > > Amit Nirantare You don

[Axapta-Knowledge-Village] Re: Regarding Axapta Installation

While installation sequence is not important, it IS important to handle the application of the service pack SP3 correctly. I have learned through painful experience that you need to install the base Axapta 3.0 components first, and run through the checklist to compile the system and get at l