An Update from AX Decisions 2009

 

With AX Decisions 2009 just a month away on Wednesday October 14th, we'd like to share some of the developments that are getting us so excited about this virtual conference and trade show.

Where to start? How about the tremendous variety of timely and strategic sessions that will inform, educate, and hopefully motivate you to improve the quality and value of your AX investment. Leading off is Ray Wang's Keynote on maximizing your Dynamics ERP investment in tough economic times, and Jeff Onesto and Cindy Jutras's talk on the rise of the Dynamics AX "Value Engineer". And for anyone interested in lean manufacturing, we're fortunate to have one of the true thought leaders on lean manufacturing for AX, Dr. Scott Hamilton.

And we can't say enough about the support and participation of Microsoft leaders including Crispin Read and Kees Hertogh. They'll share the latest views on maximizing value with AX, as well as looking to the future of the product. The goal of this conference from the start was to bring the most timely analysis and strategy of the times in which we live, and we think our speakers live up to that goal. Even better, all the general sessions will be taking questions live. When is the next time you'll have direct access to so many leading Dynamics thinkers from both inside and outside of Microsoft?

There's also the opportunity to talk to representatives from leading vendors for AX add-on solutions in the expo hall. Their sponsorships are what makes this event free to the attendees. And if you consider that these vendors probably have some of the deepest knowledge in their respective competencies, it's worth attending just to get a chance to meet them without the hassle and expense of a physical show.

And don't forget about the great opportunities to connect with your fellow attendees - people who are as interested, informed, and passionate as you about Dynamics AX. Chat about sessions, vendors, and any other AX topics that are your mind.  The virtual conference experience is more than presentations and sponsors, it's about connections with people who share your interests.  If you haven't had a chance, take 3 minutes to view a demo of the virtual environment.

We'll check in again with more thoughts and updates before the live event.  We hope you are anticipating the event as much as we are.  See you there!

Best Regards,
The AX Decisions Team

Support Alert ....!!! How to correct posted transactions that have incorrect exchange rates without reversing each transaction individually in Microsoft Dynamics AX

How to correct posted transactions that have incorrect exchange rates without reversing each transaction individually in Microsoft Dynamics AX

 

Example

In this example, you post a transaction that has an incorrect exchange rate, as follows:

1.	You set the exchange rate as follows: a. Click General ledger, expand Setup, and then click Exchange rates. b. In the Exchange rates dialog box, select EUR, enter the start date in the "Exchange rate" form, and then enter the exchange rate in the "Exchange rate" form. In this example, you set the following exchange rate: 110 United States dollars (USD) = 100 euros (EUR)
2.	You create a free text invoice for customer 4033. The invoice is for 100 euros. Note To open the Free text invoice dialog box, click Accounts receivable, and then click Free text invoice.
3.	You post this free text invoice. Then, you discover that the exchange rate is incorrect. The correct exchange rate should be the following exchange rate: 105 USD = 100 EUR

 

How to correct transactions

To correct posted transactions that have incorrect exchange rates, follow these steps:

1.	Change the "EUR exchange rate" from 110 to 105 for the period when the incorrect transactions were posted. To do this, click General ledger, expand Setup, and then click Exchange rates.
2.	Use the following information to run the Standard method: • The correct exchange rate date • The posting date • The dimension setup • The posting profile from the customer or from the selected account • To run the Standard method, click Accounts receivable, expand Periodic, and then click Exchange adjustment.

The accounts receivable exchange rate adjustment keeps 100 euros as the balance for the customer. However, a zero euro transaction that has a currency rate adjustment of five dollars is created for customer 4033 in the general ledger. The "customer control" account is credited, and the unrealized "exchange rate loss" account is debited.

 

 

Faiqa Usman

Support Manager

Maison Consulting & Solutions ||Your ERP/CRM Partner|| Microsoft Gold Certified || MBS President Club 2008

 

 

Microsoft World Class Affordable ERP

>

Rapid Implementation

>

Fixed Scope Value Delivered

>

Post Installation Support

>

 

 

Maison Global Consulting Locations in Saudi Arabia

 

Al Riyadh

 

Al Khobar

Support Alert....!! Allocating transactions in AX2009

Allocation is the process of distributing monetary amounts to one or more accounts or account/dimension combinations based on allocation rules. There are two types of allocations—fixed and variable. Fixed allocation is used to distribute specified percentages of a transaction amount to distribution accounts/dimensions.

For example, corporate advertising expenses might be shared across specific departments. Department A would get 70 percent of the advertising expense, Department B would get 20 percent, and Department C would get 10 percent.

Variable allocation is used to distribute fluctuating percentages of a transaction amount to various accounts/dimensions.

For example, you could allocate corporate advertising costs based on each department's sales in proportion to total departmental sales.

The following allocation methods are available:

·         Basis

·         Fixed percentage

·         Fixed weight

·         Spread even

Create allocation rule source information

1. Click General ledger > Setup > Posting > Ledger allocation rule.
2. Click the Source button to open the Ledger allocation rule source form.
3. Press CTRL+N to create a new source line.
4. Select to allocate from an account or from an account-dimension combination.
5. If you selected Dimension in the Field setting field, select a dimension.
6. Enter the account or dimension source criteria information to allocate from. You can use wildcards to specify ALL, a RANGE, or a LIST of accounts or dimension codes, or BLANK for a dimension.

For example, suppose that you want to allocate a utility expense, such as phone and fax costs, and the chart of accounts is set up so that a ledger account starting with 61 indicates that the account is where utilities expenses are posted. You could define the source criteria as one of the following.

• 61*
• 6100..6110
• 6100, 6110

Create allocation rule destination information

1.      Click General ledger > Setup > Posting > Ledger allocation rule.

2.      Click the Destination button to open the Ledger allocation rule destination form.

3.      If this rule is an intercompany rule, select the company to allocate to.

4.      Select the account to allocate to.

5.      Select a department, cost center, and purpose dimension to allocate to.

6.      Depending on the allocation method selected in the Ledger allocation rule form, enter or select the following information.

o    If the allocation method is Basis, select the basis ID to associate to the destination line.

o    If the allocation method is Fixed weight, enter the fixed weight to assign to each destination line.

o    If the allocation method is Fixed percentage, enter the fixed percentage to assign to each destination line.

Use the Process allocation request form to create an allocation journal.

1.      Click General ledger > Periodic > Process allocation request.

2.      Select an allocation rule.

3.      Select the date to include ledger amounts for allocation in the As of date field.

4.      Select the date to post the allocation journal to the general ledger in the GL posting date field.

5.      Select the action to be taken if a zero source amount is generated during the allocation process.

o    Select Process to create destination distributions, where applicable.

o    Select Stop to create an error to indicate that a zero source amount is selected and stop the allocation process.

6.      Select to view the journal details or post the allocation results directly to the general ledger.

7.      Click OK to create an allocations journal.

 

Faiqa Usman

Support Manager

Maison Consulting & Solutions ||Your ERP/CRM Partner|| Microsoft Gold Certified || MBS President Club 2008 |faiqaq@m-consultants.com|http://www.m-consultants.com

 

Microsoft World Class Affordable ERP

>

Rapid Implementation

>

Fixed Scope Value Delivered

>

Post Installation Support

>

 

Support Alert ....!!!! How to print a Balance Sheet for 2009 when 2008 is an open year using FRx CRM:0027329

How to print a Balance Sheet for 2009 when 2008 is an open year using FRx

To print a Balance Sheet by using FRx for the year 2009 when 2008 is an open year with regard to the Column Layout of your report, follow these steps. The Row Format and the Tree (if applicable) have already been created.

Important The report date should be set to the current date.

 

1.	Create a DESC column.
2.	In the Column Layout, you need a GL Actual Column with the Fiscal Year set to 2008 or BASE-1 (if the user date is XX/XX/2009). The Period Code will be 1 TO 12, and CurrentPer/YTD will be YTD. The Print Control for the column will be NonPrint (NP).
3.	Create another GL Actual Column with the Fiscal Year set to 2009 or BASE (if your user date is XX/XX/2009). The Period Code will be BASE and the CurrentPer/YTD will be YTD. The Print Control for the column will be NonPrint (NP).
4.	Create a CALC column. In the Calc Formula cell, enter the calculation B+C (assuming that your GL Columns are B and C). By using this kind of Column Layout, this report yields information for all of 2008 + the current balance through the end of the period in which the report date falls.

 

 

Faiqa Usman

Support Manager

Maison Consulting & Solutions ||Your ERP/CRM Partner|| Microsoft Gold Certified || MBS President Club 2008 |faiqaq@m-consultants.com|http://www.m-consultants.com

 

Microsoft World Class Affordable ERP

>

Rapid Implementation

>

Fixed Scope Value Delivered

>

Post Installation Support

>

 

 

Support Alert ....!!!! How to Reverse Packing Slip

How to reverse a packing slip updated sales order?

This can be done using 'Deliver now' field on the sales order line, Quantity tab page.

You need to specify a negative quantity value in the 'Deliver now' field and then post the packing slip for the sales order again (remember to set the Quantity parameter to 'Deliver now' on the posting packing slip dialog). This will revert the sales order's inventory transactions with status 'Deducted' to the status 'On order'.

Figure 1. 'Delivery now' field on the sales order line

Figure 2. 'Quantity' parameter in the posting packing slip dialog.

The same functionality exists for purchase orders, but the field where the negative quantity is to be specified in order to revert a packing slip updated purchase order is called 'Receive now'.

 

 

Faiqa Usman

Support Manager

Maison Consulting & Solutions ||Your ERP/CRM Partner|| Microsoft Gold Certified || MBS President Club 2008 |faiqaq@m-consultants.com|http://www.m-consultants.com

 

FW: Support Alert ...!! Folder Structure in Dynamics AX4

What is the folder structure in Dynamics AX4?

The installation of Dynamics AX 4 consists of three main parts:

1) Server installation

2) Client installation

3) Application installation

The path to the installation folders may be changed in the Dynamics AX Setup Wizard. However, if the default paths are used and all three parts are installed on the same machine, then the folder structure will look like below:

Figure 1. Microsoft Dynamics AX 4 folder free.

Folder description:

Application\Appl - contains the application files (business logic) and label files (.ald) for each language. The main application file is Ax<Layer ID>.aod containing the entire application (X++) code per layer.

Application\Appl\Standard\Db - MSDE database files.

Application\Appl\Standard\Tmp - Temporary files generated by the system.

Application\Appl\Standard\Old - during an upgrade the old application files are copied here.

Client\Bin - executable, dll files used on the client side and language dependent text files (.ktd) used by executables.

Server\DynamicsAX\Bin - executable, dll files used on the server side and language dependent text files (.ktd) used by executables. Note, 'DynamicsAX' here is an instance name specified during the Dynamics AX setup. By default it is 'Company1', but it can be changed to something more meaningful.

 

 

Faiqa Usman

Support Manager

Maison Consulting & Solutions ||Your ERP/CRM Partner|| Microsoft Gold Certified || MBS President Club 2008 |faiqaq@m-consultants.com|http://www.m-consultants.com