RE: [Axapta-Knowledge-Village] Multi Currency Setup on Item Master.

2010-05-17 Thread Jim Hummer
As there is only one functional currency per company you would need to setup another company as the prices are based upon currency conversion. Jim To: axapta-knowledge-village@yahoogroups.com From: khalilrehm...@hotmail.com Date: Sun, 16 May 2010 16:00:49 +0600 Subject: [Axapta-Knowled

RE: [Axapta-Knowledge-Village] Oracle configuration with the Axapta 3.0

2009-12-26 Thread Jim Hummer
It has been a few years but that I believe is a Oracle permission error with the TNS. You probably need to give permission to the bmssa user. I would talk to some Oracle folks. Jim To: Axapta-Knowledge-Village@yahoogroups.com From: gihan...@yahoo.com Date: Wed, 23 Dec 2009 22:3

RE: [Axapta-Knowledge-Village] FRx Client Error.

2009-10-08 Thread Jim Hummer
Change the extension from f32 to old and try it again. Jim To: axapta-knowledge-village@yahoogroups.com From: khalilrehm...@hotmail.com Date: Thu, 8 Oct 2009 11:04:15 +0600 Subject: [Axapta-Knowledge-Village] FRx Client Error. Dear All, i am facing problem on FRx Client s

RE: [Axapta-Knowledge-Village] Dimension wise Financial Statements

2009-09-04 Thread Jim Hummer
One option is to use XL Reporter. XLR is an Excel based report writer for Axapta that specializes in Dimension reporting and has a Tree Builder for more difficult reports. Jim Hummer Consultant http://www.xlreporter.com To: axapta-knowledge-village@yahoogroups.com From: dyne

RE: [Axapta-Knowledge-Village] Role Center Dash Boards not populating data MS Dynamics AX 2009.

2009-06-07 Thread Jim Hummer
Are you running your SSIS and Cubes? They need to be updated to see your data. Jim To: Axapta-Knowledge-Village@yahoogroups.com From: consultan...@yahoo.com Date: Sun, 7 Jun 2009 05:49:24 -0700 Subject: [Axapta-Knowledge-Village] Role Center Dash Boards not populating data MS Dynam

RE: [Axapta-Knowledge-Village] Re: FRx and AX 2009

2009-05-28 Thread Jim Hummer
You can do your financials on XL Reporter. It is an Excel based report writer that we had done all 9 dimensions in DAX. http://www.xlreporter.com Jim Hummer Solver Inc. To: Axapta-Knowledge-Village@yahoogroups.com From: ymer...@silverkeys.co.za Date: Thu, 28 May 2009 03:33:50

RE: [Axapta-Knowledge-Village] Consolidations

2009-03-29 Thread Jim Hummer
We can do AP and AR consolidation in XL Reporter. We have many Axapta clients that do so. Jim Hummer Senior Consultant Solver Inc. To: axapta-job-ho...@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com; axapta_documentat...@yahoogroups.com From: mnaeemsar...@gmail.com Date: Sat

RE: [Axapta-Knowledge-Village] Dynamics AX - Advice Needed for a newbie.

2008-11-13 Thread Jim Hummer
I think one big thing is the DAX is in Unicode while the other Ms products are not and will not. I would go to Garnter Group for information on the large ERP market.If you have a MSDN sub you can download and start playing with the applicaiton. To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 1

RE: [Axapta-Knowledge-Village] 2 different financial years within 1 company

2008-11-10 Thread Jim Hummer
That is what the XL Calendar program does. It generates a custom Finanical Period setup so that you can setup multiple finanical years per company. We never have to use the Ledgertrans for financial statements as there is a huge performance hit when you use this table. Jim To: [EMAIL P

RE: [Axapta-Knowledge-Village] 2 different financial years within 1 company

2008-11-09 Thread Jim Hummer
Thanks You wouldn't use Ledgertrans for finanical reporting. Actually the Yearly Beginning balance is in LEDGERBALANCESDIMTRANS and balances are calculated anyway. Is is pretty simple in XLR with a snytax calcuation. Jim To: Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED]: [E

RE: [Axapta-Knowledge-Village] 2 different financial years within 1 company

2008-11-08 Thread Jim Hummer
We have several customers that have this issue. With XL Reporter which is an Excel based report writer for DAX we have made a program called XL Calendar so that you can built your own business calendars. You can build a fiscal and calendar year and two weekly years. This is exposed in the

RE: [Axapta-Knowledge-Village] Consolidated Cash Flow

2008-11-03 Thread Jim Hummer
XL Reporter which is an Excel Report Writer for DAX works across consolidations for DAX and go do a consolidation Cash Flow. http://www.xlreporter.com To: [EMAIL PROTECTED]; Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED]: [EMAIL PROTECTED]: Sun, 2 Nov 2008 12:00:41 +0300Subjec

RE: [Axapta-Knowledge-Village] Db Size

2008-10-24 Thread Jim Hummer
Do the function by file and it will work better. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Fri, 24 Oct 2008 12:00:28 +0200Subject: RE: [Axapta-Knowledge-Village] Db Size Hi, Have tried the shrink function to no avail From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL P

RE: [Axapta-Knowledge-Village] Db Size

2008-10-22 Thread Jim Hummer
Right click on it and go to Tasks > Database and do both Log and Database. I recommend to derive the T-SQL and do this before backups. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Tue, 21 Oct 2008 10:10:53 +0200Subject: [Axapta-Knowledge-Village] Db Size Hi All, When looking at my

Re: [Axapta-Knowledge-Village] Report export to excel in AX

2008-10-15 Thread Jim Hummer
Just a note that there is an Excel Report Writer for DAX.Since you are in Excel when you write the report you do not have any of these issues. http://www.xlreporter.com To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Wed, 15 Oct 2008 22:27:19 +0800Subject: 回复: Re: [Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] Period Ending Financials Extract.

2008-06-25 Thread Jim Hummer
I use the LEDGERBALANCESDIMTRANS with Period Codes it is a lot cleaner. There is also a great application to do this called Profitbase with pre Existing DAX connectors. http://www.profitbase.com/ Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Tue, 24 Jun 2008 12:17:40 +Subje

RE: [Axapta-Knowledge-Village] Consolidation for Customers & Vendors.

2008-06-19 Thread Jim Hummer
If you don't have virtual companies, I think you are going to have to design a report in SRS or XL Reporter to do this function. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Tue, 17 Jun 2008 09:53:37 +0500Subject: RE: [Axapta-Knowledge-Village] Consolidation for Customers & Vendors.

RE: [Axapta-Knowledge-Village] Consolidation for Customers & Vendors.

2008-06-19 Thread Jim Hummer
If you don't have virtual companies, I think you are going to have to design a report in SRS or XL Reporter to do this function. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Tue, 17 Jun 2008 09:53:37 +0500Subject: RE: [Axapta-Knowledge-Village] Consolidation for Customers & Vendors.

RE: [Axapta-Knowledge-Village] Consolidation for Customers & Vendors.

2008-06-16 Thread Jim Hummer
Are you using Virtual Companies? Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Sat, 14 Jun 2008 18:32:52 +0500Subject: [Axapta-Knowledge-Village] Consolidation for Customers & Vendors. Dear All i have three companies and in these three companies i have some customers & Vendors same

RE: [Axapta-Knowledge-Village] Balance sheet

2008-05-25 Thread Jim Hummer
We have done this in XL Reporter. http://www.xlreporter.com You need to calc the Ending Balances and extract the Period Code Beginning Balances to do this function. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 22 May 2008 06:49:50 -0700Subject: [Axapta-Knowledge-Village] Bala

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

2008-05-14 Thread Jim Hummer
Just a note that ODBC doesn't work with DAX 4.0 as it is Unicode. You need to use OLE-DB. You also need to write your Crystal Report in Unicode or they will be 40 to 60 percent slower then DAX 3.0. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Tue, 13 May 2008 10:37:54 -0500Subject:

RE: [Axapta-Knowledge-Village] account statment for an account with type total

2008-05-12 Thread Jim Hummer
I believe this is only available thru the AOS or Atlas.I have heard this is going to change in DAX 2009 so you can write SRS reports with Totals. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Sat, 10 May 2008 04:00:33 -0700Subject: [Axapta-Knowledge-Village] account statment for an a

RE: [Axapta-Knowledge-Village] Reports From AX

2008-03-31 Thread Jim Hummer
Have you looked at XL Reporter? It is an Excel Based Axapta Report Writer. http://www.xlreporter.com To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Mon, 31 Mar 2008 18:24:06 +0500Subject: [Axapta-Knowledge-Village] Reports From AX Hiii Do anyone have any idea how can I get these repo

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

2008-03-06 Thread Jim Hummer
You can use a tool called Profitbase which has built in DAX connecters and can take two data sources and make it into one Datawarehouse. You can then run your cube on the DW. Connect [EMAIL PROTECTED] for more information. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 6 Mar

RE: [Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for?

2008-01-08 Thread Jim Hummer
Are you sure that these are DAX 4.0 tables?I couldn't find them in any DAX 4.0 db that I have. To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Mon, 7 Jan 2008 18:52:03 +0400Subject: [Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for? Sorry i am not su

RE: [Axapta-Knowledge-Village] FRx with AX 3.0

2007-11-17 Thread Jim Hummer
As an alternate solution you might want to look at XL Reporter. It is a fully intergrated DAX Excel Based Report Writer that works great with Dimensions. To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 15 Nov 2007 13:21:43 +Subject: [Axapta-Knowledge-Village] FRx with AX 3.0 I'm t

RE: [Axapta-Knowledge-Village] odbc

2007-11-16 Thread Jim Hummer
I am not sure if you can use Access.I know SRS and Crystal have OLE-DB but I am not sure if Access does. I would check the Microsoft website to check that functino. Jim To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 15 Nov 2007 10:24:58 +0200Subject: RE: [Axapta-Knowledge-Village]

RE: [Axapta-Knowledge-Village] odbc

2007-11-14 Thread Jim Hummer
AX 4.0 in written in Unicode, try OLE-DB instead of ODBC. >From: [EMAIL PROTECTED] >Reply-To: Axapta-Knowledge-Village@yahoogroups.com >To: Axapta-Knowledge-Village@yahoogroups.com >Subject: [Axapta-Knowledge-Village] odbc >Date: Wed, 14 Nov 2007 13:15:37 +0200 (SAST) > >Hi All, > >I am using

Re: [Axapta-Knowledge-Village] Dimension Hierarchy in AX4.0

2007-09-02 Thread Jim Hummer
We have quite a few clients with the same issue. So we developed a AX Tree Dim product that works with an Excel Reporter. Please go to the link below if you are interested. http://www.xlreporter.com Jim Hummer Senior Consultant >From: prasanna govindan <[EMAIL PROTECTED]>

RE: [Axapta-Knowledge-Village] Re:Unit Accounts for statistical purpose

2007-05-14 Thread Jim Hummer
I don't believe there are unit accounts but you can post Qty instead and also budget on it. >From: "Carsten Hoeck" <[EMAIL PROTECTED]> >Reply-To: Axapta-Knowledge-Village@yahoogroups.com >To: >Subject: [Axapta-Knowledge-Village] Re:Unit Accounts for statistical >purpose >Date: Mon, 14 May 20

Re: [Axapta-Knowledge-Village] Need to know Methods to Direct Report to Excel.

2007-02-25 Thread Jim Hummer
FYI There is also an Excel Report Writer named XL Reporter for Ax. http://www.xlreporter.com >From: vijay karthik <[EMAIL PROTECTED]> >Reply-To: Axapta-Knowledge-Village@yahoogroups.com >To: Axapta-Knowledge-Village@yahoogroups.com >Subject: Re: [Axapta-Knowledge-Village] Need to know Methods t

RE: [Axapta-Knowledge-Village] Problem with AX4.0 - Client Server Connectivity

2007-02-25 Thread Jim Hummer
AX 4.0 is not longer on ODBC I believe in Active Directory you can make a trust relationship between the two domains that this would work. >From: Steel Karabela <[EMAIL PROTECTED]> >Reply-To: Axapta-Knowledge-Village@yahoogroups.com >To: >Subject: RE: [Axapta-Knowledge-Village] Problem with A