Business Central Specific Cost
Business Central Specific Cost
About Specific Cost (general)
The costing method determines if an actual or a budgeted value is capitalized and used in the cost calculation. Together with the posting date and sequence, the costing method also influences how the cost flow is recorded.
The specific cost criterion aims to individually evaluate the inventories, purchased or produced, determining the relative cost separately”
An item’s unit cost is the exact cost at which the particular unit was received; In production or trade of easily identifiable items with fairly high unit costs.
- For items that are subject to regulation
- For items with serial numbers
Specific Cost – Testing case
Costing methods make an assumption about how cost flows from an inventory increase to an inventory decrease. However, if more accurate information about the cost flow exists, then you can override this assumption by creating a fixed application between entries. A fixed application creates a link between an inventory decrease and a specific inventory increase and directs the cost flow accordingly.
For items using the Specific costing method, inventory decreases are valued according to the inventory increase that it is linked to by the fixed application.
The following table shows how inventory decreases are valued for the Specific costing method.
ENTRIES |
||||
---|---|---|---|---|
Posting Date |
Quantity |
Cost Amount (Actual) |
Applies-to Entry |
Entry No. |
02-01-20 |
-1 |
-20.00 |
2 |
4 |
03-01-20 |
-1 |
-10.00 |
1 |
5 |
04-01-20 |
-1 |
-30.00 |
3 |
6 |
EXAMPLES
In the example just shown, the value of the inventory would be equal to:
(10 * 90) = 900 € if the inventories consisted of products purchased on 24/04
(10 * 85) = 850 € if related to products purchased on 29/10, and so on
In the second case, if the remaining quantities were equal to 60 we will have:
(25 * 90 + 35 * 85) = € 5225 if the inventories were made up of products purchased on 24/04 (25 pieces) and 29/10 (35 pieces)
(50 * 90 + 10 * 85) = € 5350 if the inventories were made up of products purchased on 24/04 (50 pieces) and 29/10 (10 pieces), and so on
This method is “not easy to use” since it requires the possibility of correlating, without error, the inventories to the costs incurred for it.
For this reason, it can be adopted in the presence of non-interchangeable (non-fungible) products, or when it is possible to physically keep the different batches of goods in the warehouse physically separate.
Furthermore, although extremely correct, it is very rarely used, especially if you manage thousands of articles, as management becomes very complicated.
About Specific Cost (Microsoft Docs)
Specific |
Specific Cost: An item’s unit cost is the exact cost at which the particular unit was received. |
In production or trade of easily identifiable items with fairly high unit costs. |
https://docs.microsoft.com/en-us/dynamics-nav-app/design-details-costing-methods
Serial Number Tracking for Cost Specific
The specific costing method is intended for use with high value items and those that are produced or purchased one at a time, for example, large capital goods. Each item in the inventory will have its own specific cost; when we choose the “specific” costing method, we must also choose to use “serialized item tracking” (Serial Numbers).
NOTE: you must use serial number tracking if you are using the specific costing method (mandatory)
Inventory Setup
if necessary, use it as a default cost, you can activate the default on the specific cost in the Inventory Setup.
COST ENTRIES
Cost on Item Card
FAQ\ISSUES
Scenario – I have no serials!
The serial number is issued by ourselves. The problem is, we received and post the purchase invoice after we post the sales invoice, hence the Purchase Invoice date must be later than the Sales Invoice date, and we have to map the cost of the item in Sales Invoice to the specific Purchase Invoice. Can we update the serial no to a posted sales invoice?
NO! the process is incorrect in this case, follow the rules, and assign the correct serial number.