RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Title: Message
Hi
Matt
I may
have added MSPivotTable11 myself. Its been a while since I made these
modifications. Have you worked out what the differences are between SP2 and SP3
in this area? I'd like to make sure my application works for Office
2003.
Regards
Malcolm
-Original Message-From: Matt Birtwistle
[mailto:[EMAIL PROTECTED] Sent: 27 September 2004
23:00To:
[EMAIL PROTECTED]Subject: RE:
[Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Gone back to SP2 and
it works fine.
I always thought SPs
were cumulative but I guess not
From: Matt Birtwistle
[mailto:[EMAIL PROTECTED] Sent: 27 September 2004 19:27To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village]
Pivot Tables in Axapta 3.0
Found how to create
reference to MSPivotTable11 in the BaseEnum.
Problem still not
fixed though
From: Matt Birtwistle
[mailto:[EMAIL PROTECTED] Sent: 27 September 2004 18:16To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village]
Pivot Tables in Axapta 3.0
Malcolm
Im unable to compile
your mod as the reference to MSPivotTable11 is not recognised. I only 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) in the OLAPPivotTable class that I modified. I don't have Office
2003, so I can't check if mine works for that, but I did make changes to get
it to work correctly for Office XP. My code
reads
static str getActiveXGuid(OLAPPivotTableVersion _pivotTableVersion)
{
switch (_pivotTableVersion)
{
case OLAPPivotTableVersion::MSPivotTable9:
return '{0002E520---C000-0046}'; case OLAPPivotTableVersion::MSPivotTable10:
return '{0002E552---C000-0046}';
// SYP-Modification SP2 - Begin
case OLAPPivotTableVersion::MSPivotTable11:
return '{0002E55A---C000-0046}';
// SYP-Modification SP2 - End
}
return '';
}static OLAPPivotTableVersion getAvailablePivotTableVersion(boolean _throwError = false)
{
// SYP-Modification SP2 - Begin
if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable11))
return OLAPPivotTableVersion::MSPivotTable11;
// SYP-Modification SP2 - End
if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable10))
// Upgrade Modification on 04 Mar 2004 by MPB - Begin
// Was using version 9 even though 10 was available!!
return OLAPPivotTableVersion::MSPivotTable10;
// Upgrade Modification on 04 Mar 2004 by MPB - End
if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable9))
return OLAPPivotTableVersion::MSPivotTable9;
if (_throwError)
throw error("@SYS75295",'APPLDOC://Help Topics/OLAPPivotTableSetup');
return OLAPPivotTableVersion::None;
}
I hope that helps
some..
If you do find that
it needs extra modification to get it to wokr with Office 2003, would you drop
me a line and let me know what you changed so that I can include it
too.
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:
mattbirtwistle [mailto:[EMAIL PROTECTED]Sent: 27 September 2004
11:46To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village]
Pivot Tables in Axapta 3.0
Is there anybody out there that has
found a fix for Pivot Tables not working with Axapta 3.0 SP3 with Office
2003.I get the following
error message when trying to call a pivot
table:ActiveX
ErrorUnable to create ActiveX
Control(Class ID:
{0002E520---C000-0046})Is not found on the system, Please check if the control
is correctly installed.Followed by an infolog:Unable to call method on ActiveX, wait until object is
fully initialised.My pivot tables used to work fine with
SP2ThanksMattSharing the
knowledge on Axapta. Sharing the
knowledge on Axapta.
Sharing the
knowledge on Axapta.
Sharing the knowledge on
Axapta.
Sharing the knowledge on
Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Malcolm
I'm afraid I haven't worked out the differences, but I'm not a technical person! The
release notes for SP2 make a definitive statement that Office 2003 is supported for
Pivot tables, but no mention is made in the notes for SP3 of any conflicts.
So that you know, when I rebuilt my applications with SP2 last night I didn't need to
apply your fixes. The modifications that SP2 has made that are referenced
SYP-Modification SP2 hadn't carried through to SP3
Regards
Matt
From: Malcolm Burtt [mailto:[EMAIL PROTECTED]
Sent: Tue 28/09/2004 09:20
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Hi Matt
I may have added MSPivotTable11 myself. Its been a while since I made these
modifications. Have you worked out what the differences are between SP2 and SP3 in
this area? I'd like to make sure my application works for Office 2003.
Regards
Malcolm
-Original Message-
From: Matt Birtwistle [mailto:[EMAIL PROTECTED]
Sent: 27 September 2004 23:00
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Gone back to SP2 and it works fine.
I always thought SP's were cumulative but I guess not
From: Matt Birtwistle [mailto:[EMAIL PROTECTED]
Sent: 27 September 2004 19:27
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Found how to create reference to MSPivotTable11 in the BaseEnum.
Problem still not fixed though
From: Matt Birtwistle [mailto:[EMAIL PROTECTED]
Sent: 27 September 2004 18:16
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Malcolm
I'm unable to compile your mod as the reference to MSPivotTable11 is not
recognised. I only see MSPivotTable9 and 10
Regards
Matt
From: Malcolm Burtt [mailto:[EMAIL PROTECTED]
Sent: 27 September 2004 13:47
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Hi Matt
There was some odd stuff (IMHO) in the OLAPPivotTable class that I modified. I
don't have Office 2003, so I can't check if mine works for that, but I did make
changes to get it to work correctly for Office XP. My code reads
static str getActiveXGuid(OLAPPivotTableVersion _pivotTableVersion)
{
switch (_pivotTableVersion)
{
case OLAPPivotTableVersion::MSPivotTable9:
return '{0002E520---C000-0046}';
case OLAPPivotTableVersion::MSPivotTable10:
return '{0002E552---C000-0046}';
// SYP-Modification SP2 - Begin
case OLAPPivotTableVersion::MSPivotTable11:
return '{0002E55A---C000-0046}';
RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Title: Message
I just spoke
to someone with Office 2003. It appears to come with both the Office 10 (2000)
and Office 11 (XP) pivot table controls but no 2003 specific pivot control that
we could find.
Prior to my
modifications, Axapta worked with Office XP, but it always loaded 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: Matt Birtwistle
[mailto:[EMAIL PROTECTED]Sent: 28 September 2004
09:43To:
[EMAIL PROTECTED]Subject: RE:
[Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Malcolm
I'm afraid I haven't worked out the
differences, but I'm not a technical person! The release notes for SP2 make a
definitive statement that Office 2003 is supported for Pivot tables, but no
mention is made in the notes for SP3 of any conflicts.
So that you know, when I rebuilt my
applications with SP2 last night I didn't need to apply your fixes. The
modifications that SP2 has made that are referenced "SYP-Modification SP2"
hadn't carried through to SP3
Regards
Matt
From: Malcolm Burtt
[mailto:[EMAIL PROTECTED]Sent: Tue 28/09/2004
09:20To:
[EMAIL PROTECTED]Subject: RE:
[Axapta-Knowledge-Village] Pivot Tables in Axapta
3.0
Hi
Matt
I
may have added MSPivotTable11 myself. Its been a while since I made these
modifications. Have you worked out what the differences are between SP2 and
SP3 in this area? I'd like to make sure my application works for Office
2003.
Regards
Malcolm
-Original Message-From: Matt
Birtwistle [mailto:[EMAIL PROTECTED] Sent: 27
September 2004 23:00To:
[EMAIL PROTECTED]Subject: RE:
[Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0
Gone back to SP2
and it works fine.
I always thought
SPs were cumulative but I guess not
From: Matt Birtwistle
[mailto:[EMAIL PROTECTED] Sent: 27 September 2004
19:27To:
[EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village]
Pivot Tables in Axapta 3.0
Found how to create
reference to MSPivotTable11 in the BaseEnum.
Problem still not
fixed though
From: Matt Birtwistle
[mailto:[EMAIL PROTECTED] Sent: 27 September 2004
18:16To:
[EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village]
Pivot Tables in Axapta 3.0
Malcolm
Im unable to
compile your mod as the reference to MSPivotTable11 is not recognised. I
only 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) in the OLAPPivotTable class that I modified. I don't have
Office 2003, so I can't check if mine works for that, but I did make changes
to get it to work correctly for Office XP. My code
reads
static str getActiveXGuid(OLAPPivotTableVersion _pivotTableVersion)
{
switch (_pivotTableVersion)
{
case OLAPPivotTableVersion::MSPivotTable9:
return '{0002E520---C000-0046}'; case OLAPPivotTableVersion::MSPivotTable10:
return '{0002E552---C000-0046}';
// SYP-Modification SP2 - Begin
case OLAPPivotTableVersion::MSPivotTable11:
return '{0002E55A---C000-0046}';
// SYP-Modification SP2 - End
}
return '';
}static OLAPPivotTableVersion getAvailablePivotTableVersion(boolean _throwError = false)
{
// SYP-Modification SP2 - Begin
if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable11))
return OLAPPivotTableVersion::MSPivotTable11;
// SYP-Modification SP2 - End
if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable10))
// Upgrade Modification on 04 Mar 2004 by MPB - Begin
// Was using version 9 even though 10 was available!!
return OLAPPivotTableVersion::MSPivotTable10;
// Upgrade Modification on 04 Mar 2004 by MPB - End
if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable9))
return OLAPPivotTableVersion::MSPivotTable9;
if (_throwError)
throw error("@SYS75295",'APPLDOC://Help Topics/OLAPPivotTableSetup');
return OLAPPivotTableVersion::None;
}
I hope that helps
some..
If you do find
that it needs extra modification to get it to wokr with Office 2003, would
you drop me a line and let me know what you changed so that I can include it
too.
[Axapta-Knowledge-Village] Invoice register and approval
Can someone help me with the invoice approval in Ax3.0 SP1 or SP2... I am used to working with this in previous axapta versions but with v3.0 I can register the invoice and see it in the invice pool but when I select Fetch vouchers in the invoice approval journal there are no vouchers shown... Is this a known bug or have I missed some setup? I recall only having to create the register and approval journals but it was so long ago I actually did it in v2.5 I may have missed something. Thanks James Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ attachment: winmail.dat
[Axapta-Knowledge-Village]
Hi all can any one tell me the function of " copy from all " and " copy from lines" in the lines of purchase order form in function menu button. Regards Nitesh Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Invoice register and approval
James There are no bugs that I'm aware of. I've just tried it on my demo system (SP2) and it works fine. When you registered the invoice you did post it? If you don't it won't be visible when you try and fetch invoices. Regards Matt From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Tue 28/09/2004 10:51 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Invoice register and approval Can someone help me with the invoice approval in Ax3.0 SP1 or SP2... I am used to working with this in previous axapta versions but with v3.0 I can register the invoice and see it in the invice pool but when I select Fetch vouchers in the invoice approval journal there are no vouchers shown... Is this a known bug or have I missed some setup? I recall only having to create the register and approval journals but it was so long ago I actually did it in v2.5 I may have missed something. Thanks James Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] AXAPTA
Hey guys, I'm new to Axapta and to this forum.. so cheers to all!! I have a problem regarding changing the input language of the system from axapta. We develope solutions for the middle east region and sometimes they require forms to have fields in English as well as Arabic. So they require us to change the input language locale of windows from english to arabic and vice versa. I have done some research and saw that u can use WINAPI::SendMessage to do it, but I had no luck with it. If any body outhere did that in Axapta of even used SendMessage, please reply.. Thanks a bunch..MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Invoice register and approval
Yep I did post it and can see the voucher for the registered invoice ... I am missing any setup?? -Original Message- From: Matt Birtwistle [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 20:35 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Invoice register and approval James There are no bugs that I'm aware of. I've just tried it on my demo system (SP2) and it works fine. When you registered the invoice you did post it? If you don't it won't be visible when you try and fetch invoices. Regards Matt _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Tue 28/09/2004 10:51 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Invoice register and approval Can someone help me with the invoice approval in Ax3.0 SP1 or SP2... I am used to working with this in previous axapta versions but with v3.0 I can register the invoice and see it in the invice pool but when I select Fetch vouchers in the invoice approval journal there are no vouchers shown... Is this a known bug or have I missed some setup? I recall only having to create the register and approval journals but it was so long ago I actually did it in v2.5 I may have missed something. Thanks James Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ attachment: winmail.dat
[Axapta-Knowledge-Village] Multi-language users
Hi everyone When I created a new user using wizard, there is a language choice from a drop down menu which I believe the default languange for that particular user. When the user has been created, from where should I change that setup? Best regards Hardi Tirtakusuma === Gabung INSTANIA, dapatkan XENIA. Daftar di www.telkomnetinstan.com, langsung dapat akses Internet Gratis.. Dan ..ikuti Instan Smile berhadiah Xenia,Tour S'pore, Komputer,dll, info hub : TELKOM Jatim 0-800-1-467826 === Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Product Builder Error
During 'sales order' entry, I run 'function/configure lines' for a modelling enabled item. After making my selection, I press OK and then I receive the following error: Cannot create a record in Bills of material (BOMTable). BOM: , Product model no. PMD-0003. The record already exists. What are possible causes? I have checked that BOMTable has no duplicates. However, error indicates that record already exists. What should I be looking for? Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Missing buttons
Hello, everyone, I am trying to learn Axapta on my own using a sample database and Axapta Developer Release license. I am on SP3. I use training manuals and online help. As I go through the materials I noticed that there are some buttons, tabs and fields missing in my company compared to the screenshots in the manuals. For example, I am going through a bank account setup and I don't have Checks button. Can I activate/add it? Is there a general approach to see what else might be available that is not currently active in my database? As always, thanks in advance for any help and advice. Serguei Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Aging Analysis Report Problems
The AP and AR Agings are sometimes different because items have been settled against transactions in the next month. Did you check this? If that is the case you can correct the date of settlement. Hope that helps MichelleRoberto Pineda [EMAIL PROTECTED] wrote: Hi to All.I issue an Aging Analysis Report for a prior month for accountspayable or accounts receivable but the total shown for the report doesnot agree the total for this account in the G/L for the same date.I've checked and both have the same transactions posted. Anyone knows why?Thanks a lot Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything.http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM~- 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 Yahoo! Groups is subject to:http://docs.yahoo.com/info/terms/ Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Axapta Programming Question
Hi all, I Have a remainAmountMST display method on the CustTable Table. Ican use it inAxapta. But when I work in the Morphx Explorer, You cannot use the display method from the CustTable Table, on the CustTable Form. Why? A. Cross Reference Has not been update for CustTable Table. B. Cross Reference Has not been update for CustTable form. C. Cross Reference Has not beenshow display mehod in general. D. Cross Reference Has not beenshow display method on the CustTable Form. thanks All. kenan Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
