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

(0) Share

Report

Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Ho Abhy,

Could you somehow group the items that do not seem behave correctly? That is are those items setup with the same item model group, do the have the same latest cost price parameters selected or anything else that you can find in common?

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

The Cost price is similar to all the Items and they all belong the Same item Group, However there are items which belong to the same item group their unit Cost is updated Correctly.

Thanks,

Abhy

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

What is the process on the PO for the processing of the other charges that uplift the cost?

I presume you are costing by warehouse in the stock dimension group given your costing difference on transfer - so that would be expected depending upon the data and how the "cost" is reported on that report. Look at the cost of the transaction, or the transfer when the destination warehouse has 0 in, it will be correct then I guess.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

can you explain a bit in detail steven .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

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 :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No