Support Alert....!!! Dynamics AX 2012 Customers Import using Excel Add-in

Dynamics AX 2012 Customers Import using Excel Add-in
http://ax2012exceldataimport.blogspot.com/2012/01/dynamics-ax-2012-customers-import-using.html
Assumption: The assumption is that appropriate reference data such as customer groups, etc. was created in advance.
Customers
[Description: image]

Walkthrough:
Connection
[Description: image]
Add Data
[Description: image]
Dynamics AX Error
[Description: image]
Add Tables
[Description: image]
Field Chooser
[Description: image]
CustTable
Field Name

Field Description

Currency

Customer account

Customer group

Name.Party ID

[Description: image]
Customer account - Number sequence
[Description: image]
DirPartyTable (Person)
Field Name

Field Description

Name

Party ID

Party type

Display as

[Description: image]
Address book ID - Number sequence
[Description: image]
LogisticsLocation
Field Name

Field Description

Location ID

Name or description

Postal address

[Description: image]
DirPartyLocation
Field Name

Field Description

Effective:

Location.Location ID

Name.Party ID

Expiration:

Postal address

[Description: image]
DirPartyLocationRole
Field Name

Field Description

Location role.Role

Party location relationships.Effective:

Party location relationships.Location ID

[Description: image]
LogisticsPostalAddress
Field Name

Field Description

Country / region

Effective:

Location.Location ID

State

County

City

District

Street

ZIP / postal code

Expiration:

[Description: image]
LogisticsElectronicAddress
Field Name

Field Description

Effective:

Location.Location ID

Type

Contact number / address

Expiration:

[Description: image][Description: image]
Sequence:
1. DirPartyTable - Publish Selected
2. LogisticsLocation - Publish Selected
3. DirPartyLocation - Publish Selected
4. DirPartyLocationRole - Publish Selected
5. LogisticsElectronicAddress - Publish Selected
6. LogisticsPostalAddress - Publish Selected
7. CustTable - Publish Selected
Result:
Dynamics AX - Address book
[Description: image]
Dynamics AX - Address book Address
[Description: image]
Dynamics AX - Address book Contact information
[Description: image]
Dynamics AX - Customer
[Description: image]
Dynamics AX - Customer Address
[Description: image]
Dynamics AX - Customer Contact information
[Description: image]
SQL Trace:
Summary: For the purposes of small or medium data migration (data conversion) where performance is not a concern Excel can be used for import of customers into Microsoft Dynamics AX 2012. Although Customer AIF Web Service (CustCustomerService) can't be used at the moment in Excel for import of customers, appropriate tables can be used instead. Excel template can be created and used for import of customers.

Support Alert....!!! Accounts payable [AX 2012]

Accounts payable [AX 2012]

Use Accounts payable to track vendor invoices and outgoing expenditures. You can enter vendor invoices manually or receive them electronically through a service, or your vendor can enter the invoices by using a vendor portal. After the invoices are entered or received, you can review and approve the invoices by using an invoice approval journal or the Vendor invoice form. You can use invoice matching, vendor invoice policies, and workflow to automate the review process so that invoices that meet certain criteria are automatically approved, and the remaining invoices are flagged for review by an authorized user.

After vendor invoices are approved, you can pay vendors. If your organization includes multiple legal entities, you can use centralized payments to pay all invoices from a single legal entity. Multiple payment formats are supported. These include checks, promissory notes, and Single Euro Payments Area (SEPA) electronic payments. You can settle invoices with payments or credit notes by using the Settle open transactions form. To view vendor information, use the All vendors list page and related forms.
Business processes<javascript:void(0)>
________________________________
[Description: Business process diagram for Accounts payable]

Support Alert....!!! Process assets created from Accounts payable [AX 2012]

Process assets created from Accounts payable [AX 2012]

There are four methods for integrating Fixed assets and Accounts payable:

1. Manually create a fixed asset record in Fixed assets before you add the fixed asset number to the line in the purchase order or invoice. Post an acquisition transaction for the asset when you post the invoice. This is the default method.

2. Manually create a fixed asset record in Fixed assets before you add the fixed asset number to the line in the purchase order or invoice. Do not post an acquisition transaction for the asset when you post the invoice.

3. Automatically create a fixed asset record when you post the product receipt or invoice that has the Create asset during product receipt or invoice posting check box selected in the Fixed assets parameters form. Post an acquisition transaction for the asset when you post the invoice.

4. Automatically create a fixed asset record when you post the product receipt or invoice that has the Create asset during product receipt or invoice posting check box selected in the Fixed assets parameters form. Do not post an acquisition transaction for the asset when you post the invoice.

For more information, see About assets acquired through procurement<http://technet.microsoft.com/en-us/library/gg231804.aspx>.

This information discusses how to post acquisition and acquisition adjustment transactions from Fixed assets, which is useful if you do not post an acquisition transaction for the asset when you post the invoice. If you use the first or third integration method, you do not have to follow these steps because an acquisition transaction is posted from Accounts payable.
<javascript:void(0)>Process assets using acquisition or acquisition adjustment proposals
________________________________

1. Open a proposal form to create acquisition or acquisition adjustment transactions for fixed assets that are created from Accounts payable.

o To create acquisition transactions, open the Acquisition proposal form. (Click Fixed assets > Journals > Fixed assets. Click Lines, and then click Proposals > Acquisition proposal.)

o To create acquisition adjustment transactions, open the Acquisition adjustment proposal form. (Click Fixed assets > Journals > Fixed assets. Click Lines, and then click Proposals > Acquisition adjustment proposal.)

2. Click Select.

3. Enter query criteria to select assets that were invoiced.

4. Click OK to create acquisition or acquisition adjustment transactions that you can post for the fixed assets.

Support Alert......!!! Create accrual schemes [AX 2012]

Create accrual schemes [AX 2012]

Ledger accruals redistribute the costs or revenues of a journal line so that the costs and revenues are recognized in the appropriate periods.

The following steps describe how to create an accrual scheme. After you have created an accrual scheme, you can complete allocation key accrual schemes and calendar key or fiscal key accrual schemes. For more information, see the next sections.

1. Click General ledger > Setup > Posting > Accrual schemes.

2. Click New to create an accrual scheme.

3. Enter an accrual identification and a description of the scheme.

4. On the General FastTab, select account numbers in the Debit and Credit fields.

The account numbers are used for posting the accrued debit amounts to an asset account, and for posting the accrued credit amounts to a liability account.

5. In the Voucher field, select how to handle voucher numbers on the accrual transactions:

o Base - The main voucher number should be used for all generated transactions.

o Single - A new voucher number should be used for each transaction date.

o Multiple - A new voucher number should be used for all accrued transactions.

6. If you selected Single or Multiple in step 5, select a number sequence code for the voucher numbers. If you selected Base, the Number sequence code field is not available, because the main voucher number is used.

7. Enter a description that you can use on all the accrued transactions. If there is no description in this field, the description from the main voucher is used.

8. If you select Calendar or Fiscal in the Calendar type field, and select an option other than Day in the Posting frequency field, select when the accrued transactions should be posted in the Posting date field.

________________________________

1. Complete the previous procedure.

2. In the Calendar type field, select the basis for the duration of the accrual:

o Calendar - Accruals are made according to the calendar year.

o Fiscal - Accruals are made according to the fiscal year that is defined in the Fiscal calendars form for the fiscal calendar that is selected in the Ledger form.

3. Select the period frequency, such as Monthly or Quarterly.

4. In the Length field, enter the number of occurrences for the selected period frequency, such as 4 quarters.

5. If you selected Calendar in the Calendar type field, select a posting frequency.
Note

Period frequency and posting frequency are not necessarily the same. For example, a duration of 2 years typically requires postings every month.

o If you selected Monthly or Quarterly in the Posting frequency field, you can indicate if the same amount should be posted all months, or if the amount posted each month should be based on the number of days in the month, relative to the total number of days. Select Even in the Value posting field if all months or quarters should be debited the same amount. Select Scale if each month should be debited based on the number of days in the month, relative to the total numbers of days.

o If you selected Fiscal in the Calendar type field, the Posting frequency field is not available. The posting frequency then is equal to the number of periods in the fiscal year, as defined in the Fiscal calendars form for the fiscal calendar that is selected in the Ledger form.

________________________________

1. Complete the procedure in the "Create accrual schemes" section.

2. In the Calendar type field, select Allocation key as the basis for the duration of the accrual.

Accruals are made according to a period key that is defined in the Period allocation categories form.

3. Select a period key in the Period key field.

Service management [AX 2012]

Service management [AX 2012]
Use Service management to establish service agreements and service subscriptions, handle service orders and customer inquiries, and to manage and analyze the delivery of services to customers. You can use service agreements to define the resources that are used in a typical service visit. You can also use service agreements to view how those resources are invoiced to the customer. A service agreement can also include a service level agreement that specifies standard response times, and offers tools to record the actual time.
You can create service orders to manage information about scheduled and unscheduled visits by a service technician to a customer site. Service orders include information such as:

1. The hours of work that the service technician will perform
2. The type of service or repair
3. The item to repair, including details about the symptoms and diagnosis
4. Any expenses and fees related to the service or repair
Customers can submit service requests through the Internet by using the Enterprise Portal. You can receive, process, and dispatch these requests. After you have created a service order, you can use service stages to monitor progress and specify rules that control what actions are enabled in each stage. When a service order is complete, you can sign off on the order to confirm that it is complete, and then post the order to start the invoice process.
Use the reporting tools to monitor service order margins and subscription transactions, and print work descriptions and work receipts.
Business processes
The following diagram illustrates the high level business processes for Service management, and shows where service processes integrate with other modules in Microsoft Dynamics AX.
[Description: Service management business process diagram]

[INVENTORY MANAGMENT ] About physical and financial updates [AX 2012]

About physical and financial updates [AX 2012]

This topic provides an overview of which types of transactions increase or decrease inventory quantities.

Inventory transactions can be physically updated and financially updated in Microsoft Dynamics AX, and certain types of physical and financial transactions increase inventory quantities, whereas others decrease the quantity.
Physical increases

When a physical transaction is posted, the status of the transaction record is "Received." The following transactions are considered physical increases:

* Purchase order receipt

* Sales order packing slip return

* Production order report as finish

* By-product on a production order picking list
Financial increases

When a financial receipt transaction is posted, the status of the transaction record that increases the quantity is "Purchased." The following transactions are considered financial increases:

* Vendor invoice

* Sales order invoice for a return

* Production order costing

* Positive quantity inventory journals, such as movement, profit loss, counting journals, bills of material, and transfer
Transactions that increase quantity

Transactions that increase quantity are posted at the running average cost price. Microsoft Dynamics AX calculates a running average cost price that is based on the cost of each of these transactions for each inventory dimension that is being tracked financially.
Transactions that decrease quantity

Microsoft Dynamics AX uses the calculated running average cost price when a transaction that decreases quantity is posted, regardless of which inventory model is associates with that inventory. This requires that the transaction that decreases quantity was not previously marked to another transaction before posting.

If the physical on-hand inventory goes negative, Microsoft Dynamics AX uses the inventory cost that is defined for the item in the Item form. Click Inventory and warehouse management > Periodic > Forecast > Entry > Items.
[Description: Note]Note

If multisite functionality is enabled, this cost will instead be the inventory cost that is defined for a site in the Default order settings form.

Physical issues vs. financial issues

When a physical issue transaction is posted, the status of the transaction record is "Deducted." The following transactions are considered physical issues:

* Production order picking list journal

* Sales order packing slip

* Purchase order packing slip return

When a financial transaction is posted, the status of the transaction record is "Sold." The following transactions are considered financial issues:

* Production order ended

* Sales order invoice

* Vendor invoice return

* Negative quantity inventory journals, such as movement, profit loss, counting journal, bills of material, and transfer

Transactions that decrease quantity are posted at the running average cost price. Thus, the inventory close procedure is required to settle issue transactions to receipt transactions based on the inventory model that is assigned to each item.

Set up integration with Microsoft Office Add-ins [AX 2012]

Set up integration with Microsoft Office Add-ins [AX 2012]
Microsoft Dynamics AX can be integrated with Microsoft Word and Microsoft Excel. If your organization uses the Office Add-ins for Microsoft Dynamics AX, users can create Word documents and Excel workbooks that are linked dynamically to the tables in Microsoft Dynamics AX. Integration for the Office Add-ins must be set up before users can use the Office Add-ins to create files.
Use the following procedure to configure data sources for the Office Add-ins.

1. Click Organization administration > Setup > Document management > Document data sources.
2. In the Document data sources form, click New.
3. In the Module field, select the Microsoft Dynamics AX module from which a user can open and create files. For example, select Sales and marketing to enter the settings for a sales quotation.
4. In the Data source type field, select one of the following options:
* If the user wants to create files that other users can modify, select Service.
* If the user wants to create files that only the user can modify, select Query.
5. In the Data source name field, select the applicable data source.
6. Select the Activated check box.

Use budget control on a purchase order [AX 2012] CRM:0003003

Use budget control on a purchase order [AX 2012]

This scenario explains how to use budget control when you create a purchase order. In this scenario, the Department and Cost center dimensions were defined for budget control and purchase orders were enabled for budget control. The budget control configuration has been activated and turned on. For more information, see Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.

You could start a similar scenario by creating a purchase requisition and converting it to a purchase order.

A budget register entry was submitted to establish a budget amount for Department 010 and Cost center 0101. You can view the budget balances for the department and cost center before you create the purchase order. In the Budget control statistics form, you would select the budget cycle and financial dimension values for the department and cost center.

1. Click Procurement and sourcing > Common > Purchase orders > All purchase orders.

2. On the Action Pane, click Purchase order to create a purchase order.

3. Select a vendor account.

4. On the General FastTab, verify the accounting date. The account date determines the fiscal period for the budget check. The current date is the default date, but you can change this.

In the budget control configuration, the budget control interval was set to Fiscal year so that the budget amounts for the fiscal year aggregate for the budget check.

5. Add a line to the purchase order and enter information in the required fields, such as Procurement category, Quantity, and Unit price.

6. Click Financials > Distribute amounts and enter the accounting distributions in the Ledger account field. For example, you might enter 606300-010-0101.

7. Close the Accounting distributions form.

If the Enable budget control for line item on entry check box was selected in the Select source documents area of the Budget control configuration form, a budget check icon is displayed on the purchase order line. If the Enable budget control for line item on entry check box was not selected, you can click Financials > Perform budget checking to perform a budget check on the whole purchase order.
[Description: Note]Note

Budget checking is performed on all lines when the purchase order is confirmed and when the purchase order is submitted to a workflow, and then again when the purchase order is approved in a workflow.

8. Click Budgeting > Inquiries > Budget control statistics. Select the budget cycle and the financial dimension values for the inquiry. For this example, you would select 010-0101 as the dimension values.

The amount of the purchase order line is displayed in the Budget reservations for encumbrances field in the grid.

9. Click Encumbrances.

The Budget reservations for encumbrances form shows detailed information about the purchase order transaction. This includes the status, which is Draft. After the purchase order is confirmed, the status changes to Confirmed.

When the invoice is received and entered, the fields in the Relieved amounts this period grid in the Budget reservations for encumbrances form are updated with information from the invoice. A budget reservation for the actual expenditure is also created.

Budgeting setup overview [AX 2012] CRM:0010055

Budgeting setup overview [AX 2012]

Budgeting configuration keys

Budgeting includes three primary configuration keys. The Budget configuration key enables basic budgeting. The Budget control configuration key adds budget control to basic budgeting. And the Public Sector configuration key adds two budget types to basic budgeting that are used by public sector organizations.

Other configuration keys might implement additional budgeting features and features that are related to budgeting requirements in specific countries/regions.

Basic budgeting includes financial dimensions that are defined for Budgeting, budget register entries, and Budgeting workflows.

Budget control is used together with basic budgeting. Budget control includes budget types for pre-encumbrances and encumbrances, budget checking for source documents and accounting journals, and features such as financial dimensions that are defined for budget control, over budget permissions for user groups, and the budget funds available calculation.

The public sector configuration includes the Preliminary budget and Apportionments budget types.

To use budget control, you must set up basic budgeting. If you are using the public sector configuration, you set it up at the same time as you set up basic budgeting.

The following sections describe the information that you should compile before you set up basic budgeting and budget control. These sections also list information that you can view for additional details.
Basic budgeting or budget control

Compile the following information before you set up basic budgeting or budget control.

Information to compile

Additional details

The financial dimensions and main accounts that will be used for Budgeting, and that can have amounts transferred either to or from them

For more information, see Define financial dimensions for Budgeting<http://technet.microsoft.com/en-us/library/hh227432.aspx>.

The currency exchange rates that must be defined, and what those exchange rates are

For more information, see Define budget exchange rates<http://technet.microsoft.com/en-us/library/hh242250.aspx>.

The budget codes that must be set up for each budget type, and which code is the default budget code

At least one budget code is required for each budget type that you want to use.

For more information, see Define budget codes<http://technet.microsoft.com/en-us/library/hh208896.aspx>.

The budget register entries that will use workflows

You assign workflows to budget codes. The budget register entries that are associated with a budget code that has an assigned workflow are automatically submitted to workflow.

For more information, see Create budget register entries<http://technet.microsoft.com/en-us/library/hh227576.aspx> and Set up Budgeting workflows<http://technet.microsoft.com/en-us/library/hh242112.aspx>.

The names of each budget model

For more information, see Create budget models<http://technet.microsoft.com/en-us/library/aa571172.aspx>.

How the budget cycles will be set up

For more information, see Define budget cycles<http://technet.microsoft.com/en-us/library/hh242103.aspx>.

The amounts that will be allocated across periods or to other financial dimension values

You can use a budget register entry to allocate a yearly budget amount across budget periods, or to allocate budget amounts to financial dimension values.

For more information, see Create budget register entries<http://technet.microsoft.com/en-us/library/hh227576.aspx>.

The financial dimensions that will have recurring amounts

You can use a recurring budget account entry to copy an amount to multiple periods for recurring expenses, such as rent.

For more information, see Create budget register entries<http://technet.microsoft.com/en-us/library/hh227576.aspx>.

The budget models that will be used in cash flow forecasts

For more information, see Create budget models<http://technet.microsoft.com/en-us/library/aa571172.aspx>.

Budget control only

If you use budget control, compile the following information in addition to the information in the previous section.

Information to compile

Additional details

The financial dimensions that should be included in budget control rules

For more information, see "Define budget control parameters" in Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.

The user groups that can post entries that exceed the remaining balance for a budget

For more information, see "Define over-budget permissions for user groups" in Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.

The source documents and accounting journals that should be enabled for budget checking

For more information, see "Select source documents for budget control" and "Select accounting journals for budget control" in Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.

The financial dimensions and accounts that must have a budget threshold, and what that threshold is

A budget threshold is the level of budget usage at which you can prevent posting or display warnings. For example, if the threshold is 80, you can warn a user during entry that 80 percent of the budget for the selected account has been used.

For more information, see "Define budget control parameters" in Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.

The formula for calculating the remaining balance of a budget

The budget funds available calculation can be defined for each legal entity instead of always using the following calculation: Original budget - Actual expenses.

For more information, see "Define the calculation that determines the budget funds that are available" in Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.

The interval, such as monthly, quarterly, or yearly, that is used to determine whether the available budget balance is sufficient to cover transactions

For more information, see "Define budget control parameters" in Set up budget control<http://technet.microsoft.com/en-us/library/hh242453.aspx>.