Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

Posted on by Microsoft Employee

Hi All,

The issue we are facing the price on the Item card is not getting updated Properly, Whenever we do invocing , all the Products in the PO are getting invoiced, However after including the surcharge, Freight and Other charges, the Item Card Gets updated Correctly For most Items, However For certain Items, the Item Card is Not getting Updated Properly, which Results in FOB Price Lower than the Unit Price, the Method of costing, we are in to Is FIFO, When we look at the Transactions in the Item Card in Manage Inventory, It Shows the Correct Price , how ever on the Card it is not right. Also  on the Other hand , when ever we look at the On hand inventory Report, If there is a transfer, there is a drop in the Price of the Unit cost, I feel there is a disconnect the way the price is getting updated  has a problem , can you please give me some pointers, where look up these, this has a become a major issue now. Please Help me.

Thanks,

Abhy.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    The inventory transfers have a direct impact on the item cost.

    The latest purchase date and cost captures the latest transfer date and cost posted to items inventory transactions instead of the actual latest purchase invoice date and cost.

    Also, as I mentioned in the past, inventory transfers cause a decrease in items unit costs.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Hi Terry,

    I was checking for one PO and one Item , the unit price on the Item card and On the Inventory Transaction where receipt status is Purchased, the Cost is Different. I noticed there are two scenarios  :

    Inventory Transactions:

    1. Purchase order   - Purchased - $ 27.95

    2.Transfer - Purchased - $ 19.03

    When I check here for the PO , and click on invoice and View distributions the Unit cost on this particular item is $20.70 , Excluding the Misc. charges.

    Item card:

    Unit cost:$19.53

    Purchase cost : $20.70

    Anything else that I need to look for ? I strongly feel there is a disconnect somewhere but I don't where and don't know how to figure out because I'm very new to AX 2012 .

    Please help.

    Thanks,

    Abhilasha.

  • Guy Terry Profile Picture
    Guy Terry 28,373 on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Can you find an item which currently has the 'wrong' cost price on the item card. What is that cost price?

    Look at the inventory transactions for that item. Find the most recent transaction which has the Receipt status = Purchased. What is the 'Cost amount' on that transaction?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Hi Terry,

    It does have a tick in that box, yes it matches the cost , however if you have a new PO Posted and for certain Products the price does not get updated, and if there is a Transfer the Price keeps Dropping where as that should not be the Case. or sales Order the product itself was sold at a lower Price, I Don't know this for sure, is there anything that it has got to do with Use Cost by variant, do you think this has to be checked as well.

  • Guy Terry Profile Picture
    Guy Terry 28,373 on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Hi Abhy,

    The last time I tested the 'Latest cost price' tick box on the 'Manage costs' fast tab of the Released products, I decided that this would cause ANY financially updated receipt transaction to update the cost on the item record. If you look at the Inventory transactions for your item, does the cost price of the most recent transaction with the Receipt status = Purchased match the cost on the item record?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Here is the thing, it works perfectly correct for the some of the Items of the Item group. The Cost  is updated after the Misc charges on the Item Card, and on both the Places, purchase order as well as transactions on the manage costs. It is just on the Released Products tab that the unit price is not updated. However Let me check the Item set up.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Okay so you are using miscellaneous charges.

    Is it items that are wrong or certain charges?

    Check the configuration of each charge, also check the item and that the incl. in unit price is selected in the charges section - check purchase order or manage costs.

    Assuming no customizations or ISV impact the fact some are working means you need to identify if it is item related or charge, or locate the common element, but checking the charge and item setup is the starting point.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    After the Item is invoiced , when we allocate charges it is by quantity and check the box which says allocate all.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Okay back to basics - how do you add the freight onto a PO line? Step by step and its allocation to the item cost please :-)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The Price on the Item Card is not getting Updated Properly for certain Products and Transfers the Price keeps Dropping.

    Steven ,

    Thanks for the reply, Process of PO, the unit cost +any Freight+Packaging or any price Variance . It is sometimes allocated by Net amount , and sometime s by Quantity and Allocate All.  But the transactions on the Item card, Manage Inventory , the Price is updated. Not Just on the Item Card.  

    Thanks,

    Abhy.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans