Sunday, August 30, 2015

AX 2012 | moving average costing method - Part 3

After we discussed the Handling of price differences between a product receipt and the invoice in part 1 and Revaluation for moving average in part 2. in this post we will discuss the Backdating with moving average.

When you backdate a product receipt or an invoice, it is revalued to the current moving average cost. Also, a backdated issue is posted at the current moving average cost. With backdating, you cannot change the moving average going forward.

AX 2012 | moving average costing method - Part 2

In part 1 we discussed how to set up moving average costing method, then we discussed  how moving average is handling of price differences between a product receipt and the vendor invoice.

Today we are going to learn how to revaluate cost for moving average. To proceed with the next example you must read part 1 of this series or at least do the setup which described there.

If your moving average value is inaccurate because of, for example, a posting mistake, you can adjust the unit price of the on-hand inventory at any time.

The moving average cost can only be adjusted as of the current date, so when you adjust the unit price of an item by using the following procedure, the adjustment date is always set to the current date. You cannot change the date when you post the adjustment.

Friday, August 28, 2015

AX 2012 | moving average costing method - Part 1

In this series we are going to discuss the moving average costing method, by covering the following topics:

Part 1: Handling of price differences between a product receipt and the invoice.
Part 2: Revaluation for moving average.
Part 3: Backdating and moving average.
part 4: Production costing and moving average.
part 5: View how moving average was calculated.

first let's introduce the moving average costing method. Moving average is an inventory evaluation method that reevaluates inventory value in the chronological order of posting transactions, and it can be used to compute the average cost of the current ending inventory.

When a receipt transactions are included chronologically in the moving average calculation, according to the order in which the transactions are recorded in the system.

When Issue transactions are assigned the current active moving average cost at the time of recording, and the costs on inventory issues do not change even if the purchase costs (price in vendor Invoice ) change.

Tuesday, August 25, 2015

AX 2012 | Main account & Dimension value mask

Most likely that you notice the Dimension value mask and Main account mask fields during the setup of financial dimension and the chart of account. These fields give you the ability to enter a format mask to use for creating financial dimension values and main accounts. A format mask limits the amount and type of information that you can enter for dimension values.
the following steps illustrate how to setup and use this functionality :

Thursday, August 20, 2015

Microsoft Dynamics 'AX 7' New, Changed, and Deprecated Features

New or changed features
Financial management What can you do?
AX 2012
‘AX 7’
Why is this important?
Export account structures to Excel
Not supported
You can now select an account structure and export that to Excel.
Many customers have requested the ability to export account structures to Excel for easier filtering.
View ledgers and advanced rule structures associated with an account structure on a single form
In AX 2012, the user has to navigate to multiple forms to see the ledger that the account structure is using.
Fact boxes have been added to the account structure form.
This allows for easier access to key information when defining and editing account structures.
Filter Management Reporter (labeled Financial reporting in ‘AX 7’) reports based on dimension, attributes, dates, and scenarios
All filtering of Management Reporter reports was handled through the design of the report. If a user with viewing privileges wanted to view a report for a different date, for example, this required a report designer to make the modification.
Report options have been added so when viewing a report, different filters can be applied and a new report is generated based on those filters.
Consumers of financial reports can apply different filters for dimensions, dates, attributes, and scenarios without the need for updates in report designs.
View Management Reporter (financial reports) within the ‘AX 7’ client
A separate web client was used for viewing Management Reporter reports.
A list of all financial reports can be accessed within the ‘AX 7’ client. The user selects a report to view, and the report is rendered within the ‘AX 7’ client.
You can now view financial reports without having to access a different client/application.

for more Features you can download the New Changed Deprecated Features whit paper from this link 

AX 2012 | Add invoices to payment groups

Dynamics AX give us the functionality to  add invoices to payment groups to group invoices by a common code. If one invoice in the payment group is settled, the other invoices in the group are included in the same settlement.

Invoices that belong to the same payment group must be settled at the same time. If one invoice in a payment group cannot be settled for any reason, no invoices in the same payment group can be settled. For example, if an invoice in the FIRE payment group is not approved, that invoice must be approved or removed from the payment group before the other invoices in the FIRE payment group can be settled.

the following steps illustrate how to configure and use the payment groups functionality:

Wednesday, August 19, 2015

AX 2012 | Add invoices to invoice groups

Dynamics AX give us the functionality to add invoices to an invoice group so that you can find and update invoices that are grouped together, without using a query. for example we can classify our expenses invoices per department. all what we need to do is add the invoice to custom group code which represent the department.

also we can setup AX to default group code for new invoices: User nameDate, or Custom. For example, select User name to automatically group new invoices by the name of the user who created them. Users can change the code on individual invoices.

the following steps illustrate how to configure and use the Invoice group functionality:

Monday, August 17, 2015

Use the same number with transaction and transaction voucher

In this post i will illustrate how to use same number with transaction and transaction voucher. Microsoft Dynamics AX provide functionality to use the same number for some transactions and transactions voucher in accounts receivable and accounts payable modules as following:

AR Module

1- free text invoice with free text invoice voucher
2- Packing slip with Packing slip voucher
3- Customer invoice with Customer invoice voucher
4- Sales credit note with Sales credit note voucher

AP Module

1- Internal product receipt with Product receipt voucher
2- Internal invoice with Invoice voucher
3- Internal credit note with Credit note voucher

The following steps discus how to use this functionality with free text invoice and the free text invoice voucher.

Saturday, August 15, 2015

Speed Up the demo data import | AX 2012

If you try to import AX 2012 R3 demo data you will notice that the importing process take very long time and it may took more than 24 hours. After a little investigation i found that the cause of this problem is due to the small size of the empty database.

Since the import process end with a huge size (around 16 GB for data and 26 GB for log) MSSQL start using the auto growth to expand the DB file size which will take long time and in some cases the expanding will stop when the DB reach the maximum file size. 

We can reduce the import time to 1 hour or less in very simple way. all what we need is to expand the DB file size before start importing the demo data, the following steps illustrate how we can do it: