Study on the principle of four inventory ABC analysis method in AX

Inventory ABC classification, simply said to grasp the big put small, is to let us seize the focus, with the greatest effort to manage the most important materials, and for less important materials can be used less energy to manage. It is similar to what we normally call the 82 law.
Now that we're applying the inventory ABC approach, we'll start by deciding which items are the most important class A, which are generally important class B, and which are the least important classes of Class C.
The simplest way is to fill the ABC directly in the Material master table, and then in the daily business, we can always see what kind of material it is, which determines the way we manage it (the most important one can not be poor, the least important, almost the slightest tolerable). To examine the importance of materials from different angles, Ax provides 4 methods, namely:
1) Value: Based on current stock on hand
2) margin margin: Based on inventory transactions over a specified period of time
3) Revenue revenue: based on inventory transactions over a specified period of time
4) Operating costs carrying cost: Based on inventory transactions over a specified period of time and internal interest set
In addition to manually filling out the ABC classification, we can also use the Inventory ABC calculation tool provided by AX, so that we can calculate the corresponding ABC classification from the above 4 angles, and before we calculate it, we could specify how much ABC is accounted for in the above 4 ways.
We can first use the report >ABC classification to simulate the ABC classification, check the confirmation is feasible, and then periodically run the periodic >ABC batch of classification, let the system automatically update the ABC setting in the Item table.
Study on the principle of four inventory ABC analysis method in AX
Study on the principle of four inventory ABC analysis method in AX
The system calculates the classification of each item in the following way:
First, according to the amount of size inverted, starting from the largest material;
Second, calculate the cumulative amount so far to the total amount of the percentage of X, note that each item to take a sum of the classification ratio (if it is the first, then this calculation ratio is 0), compared with the ABC classification ratio;
If x<a, then the material is a class A;
If a<x<a+b;, then the material is class B;
If x>a+b, the item is Class C
Cumulative percentage of raw value of each item of the item XAA+B conclusion
20060.42372881400.30.66A
20140.2245762710.4237288140.30.66B
20130.2245762710.6483050850.30.66B
10110.0847457630.8728813560.30.66C
10050.0423728810.9576271190.30.66C
Let's take a look at how the system actually pulls out the amount according to these 4 methods, in order to illustrate, the interception part of the code shows as follows:
1) value (financial cost)
This is one of the most widely known methods. We can see that the system calculates the financial cost.
Class:inventabc_inventvalue
void Sumupvalue () {
InventTable InventTable;
Amount Amount;
...
Amount= This.calcitem (InventTable);
This.saveamount (Inventtable,amount);
...
}
=>class:inventsumfinancialitem
protected void Setvalueqty () {
...
value = Inventsum.postedvalue;
...
Value-= inventtrans.costamountposted;
...
Value-= inventsettlement.costamountadjustment;
}
2) Gross margin = Invoice does not contain tax amount-this transaction cost
Class:inventabc_contributionmargin
void Sumupvalue () {
Custtransstatistics Transstatistics;
...
This.saveamount (Inventtable,transstatistics.contributionmarginmst ());
...
}
=>table:custinvoicetrans
Display Salescontributionmarginmst Contributionmarginmst () {
Return This.lineamountmst-(-this.inventcostamount ());
}
3) Revenue = Invoice Amount
Class:inventabc_revenue
void Sumupvalue () {
Custtransstatistics Transstatistics;
...
This.saveamount (Inventtable,transstatistics.lineamountmst ());
...
}
=>class:custvendtransstatistics, Method Lineamountmst ()
=>table:custinvoicetrans, Field Lineamountmst

4) Operating Cost = Inventory Cost + internal interest (set before calculation, 365 days per year)
Inventabc_carrcost
void Sumupvalue () {
...
Amount= This.calcitem (InventTable);
This.saveamount (Inventtable,amount)
...
}
Amount Calcitem (InventTable InventTable) {
...
CostValue + = This.calcinterest (inventvalue,lastdate,todate);
...}

Http://blog.sina.com.cn/s/blog_4a91917e010006yu.html

Study on the principle of four inventory ABC analysis method in AX