what is cost price used for in Inventory Close AX 2012

Solution (Verified) This post has 1 verified solution | 3,295 Views | 11 Replies | 2 Followers

510 Posts
3,845 Points
Joined: 2012-11-4
Last Online:
2015-3-9 14:53
Location: Hoboken New Jersey
Patrick Am posted on 2013-2-25 18:59 rated by 0 users

Hi,  there is a step in the inventory close - Check Cost price?  What is this used for and how does the "deviation percentage" change will affect the issue to receipt settlements? 

say if I set the percentage from 30% to 50% on the basis of item cost price, what is the impact?  

From what I have researched,  "it is used to determine receipts that will adversely affect the cost price calculation during the inventory close"    Could someone explain perhaps with an example? 

Cost price is calculated on the basis of running average prior to close; after close, issue transaction is settled to receipts 

say cost price of an item is $10 at the start,  we purchase 3 times 10 QTY @ different prices $8, $9 and $25 due to high demand at one time. (assuming all receipts invoice updated, )  

$80+$90+$250 divided by 30 is the running average = $14; an issue transaction applied for 30 Qty @ $14 

when check cost price is run with 50% deviation, i assume the receipt @25 will show up. then what steps do we need to take? 

how will the cost price is impacted after the inventory close? 

thank you 

 

 

Solution (Verified) Verified Solution

Male
11,553 Posts
151,887 Points
Joined: 2000-11-3
Last Online:
2016-2-12 14:06
Location: UK
DynamicsMVP
ModeratorDynamicsNAV

You can use the Check cost prices report to enter a maximum deviation percentage, and then view the items that will exceed the maximum deviation percentage. The deviation is based on the item cost price, item or median cost price, or median.

 

For example, an item contains a cost price (using the currency of the United States dollar (USD)) of 5.00 USD. When a purchase order invoice is posted for this item, the cost price entered is 15.00 USD. When printing the report, the maximum deviation percentage that is set will be 30 percent and the item cost price will be used as the base. This purchase order would appear on the report because the cost of the item posted, 15.00

 

 

 

 

“Any fool can know. The point is to understand.”
Albert Einstein

  • | Post Points: 106

All Replies

Male
11,553 Posts
151,887 Points
Joined: 2000-11-3
Last Online:
2016-2-12 14:06
Location: UK
DynamicsMVP
ModeratorDynamicsNAV

You can use the Check cost prices report to enter a maximum deviation percentage, and then view the items that will exceed the maximum deviation percentage. The deviation is based on the item cost price, item or median cost price, or median.

 

For example, an item contains a cost price (using the currency of the United States dollar (USD)) of 5.00 USD. When a purchase order invoice is posted for this item, the cost price entered is 15.00 USD. When printing the report, the maximum deviation percentage that is set will be 30 percent and the item cost price will be used as the base. This purchase order would appear on the report because the cost of the item posted, 15.00

 

 

 

 

“Any fool can know. The point is to understand.”
Albert Einstein

  • | Post Points: 106
Female
1,044 Posts
7,110 Points
Joined: 2007-9-25
Last Online:
2015-9-20 20:17

AdamRoue:

You can use the Check cost prices report to enter a maximum deviation percentage

Why we need to know the maximum deviation percentage and how it is related to business scenerio ?

 

  • | Post Points: 6
Male
11,553 Posts
151,887 Points
Joined: 2000-11-3
Last Online:
2016-2-12 14:06
Location: UK
DynamicsMVP
ModeratorDynamicsNAV

You do not need to know it, but it is a tool used where the received cost diverges from the current cost, which in itself will create costs and cause impacts, so if the usual cost is $10 and the user accidentally enters $100 this would be outside of a 30% deviation (as an example) and would highlight that there is a potential rogue transaction adveresely impacting on cost - it is an early warning system for finance at close.

“Any fool can know. The point is to understand.”
Albert Einstein

  • | Post Points: 6
10 Posts
51 Points
Joined: 2013-2-26
Last Online:
2013-8-6 20:37
Location: St. Louis, MO

Hi Patrick,

This report allows you to enter a maximum deviation percentage. Items that appear on this report will be only those exceeding  the maximum deviation percentage. The deviation is based on the item cost price, item or median cost price, or median.

Hope this helps,

Shantanoo, Barry-Wehmiller International Resources

  • | Post Points: 5
Female
1,044 Posts
7,110 Points
Joined: 2007-9-25
Last Online:
2015-9-20 20:17

AdamRoue:

You do not need to know it, but it is a tool used where the received cost diverges from the current cost, which in itself will create costs and cause impacts, so if the usual cost is $10 and the user accidentally enters $100 this would be outside of a 30% deviation (as an example) and would highlight that there is a potential rogue transaction adveresely impacting on cost -

it is an early warning system for finance at close.

Hi Steven ,

 As you said if the usual cost is $10 and the user accidentally enters $100 this would be outside of a 30% deviation , Can i know when the system gives the warning Is it during the PO creation or packing slip ?

 

 

  • | Post Points: 6
Male
11,553 Posts
151,887 Points
Joined: 2000-11-3
Last Online:
2016-2-12 14:06
Location: UK
DynamicsMVP
ModeratorDynamicsNAV

the warning is on the inventory close highlighted as a comment. No impact on user entry of PO or receipt etc. Invoice controls would pick this up so really it is for received not invoiced stock.

“Any fool can know. The point is to understand.”
Albert Einstein

  • | Post Points: 6
Female
1,044 Posts
7,110 Points
Joined: 2007-9-25
Last Online:
2015-9-20 20:17

Hi Steven Sir ,

I am not able to understand the use of the functionality , can you explain in detail about the functionality usage ?

Please help me .

  • | Post Points: 6
Male
11,553 Posts
151,887 Points
Joined: 2000-11-3
Last Online:
2016-2-12 14:06
Location: UK
DynamicsMVP
ModeratorDynamicsNAV

I can only suggest you read the manual and run through the process. It is an early warning built into one specific process of a potential issue. It does nothing but warn you.

“Any fool can know. The point is to understand.”
Albert Einstein

  • | Post Points: 6
Female
1,044 Posts
7,110 Points
Joined: 2007-9-25
Last Online:
2015-9-20 20:17

AdamRoue:

I can only suggest you read the manual and run through the process. .

Could you share the manual name ?

Thanks in advance.

 

  • | Post Points: 6
Male
11,553 Posts
151,887 Points
Joined: 2000-11-3
Last Online:
2016-2-12 14:06
Location: UK
DynamicsMVP
ModeratorDynamicsNAV

I shared the link earlier in this post. Big Smile

“Any fool can know. The point is to understand.”
Albert Einstein

  • | Post Points: 5
Page 1 of 1 (12 items) | Get this RSS feed