Can't update Last Purchase Price in BOM n Issure Components

[Former Member]

Dear Experts,

In BOM, I m Using Last Purchase Price for Item Components. The Issue is When I had create BOM The Last Purchase Price of Item (I001 Sugar) was 50 Rs. When i Create a Production order that time Last Purchase Price Was 60 Rs. During Issue Components it pick the price for I001 Sugar is 50, it does not update the last purchase price, is there anyways that it automatically update the last purchase price in issue components. we are using FIFO Method.

Thanx

[former_member204969 · Accepted solution]

The cost the system uses for issue for production transaction is independent of the price list you selected in the BOM.

- The production module uses the current cost price of the actual item with issue for production.

- The price lists selected in the BOM are for setting values in price list of the product. So it is for preliminary calculation of the product cost.

[Former Member]

Hi

Last purchase price is calculated by system.You cannot change it ..It is based either by your GRPO or in some cases by Good receipt .

Hope this helps

Bishal

[Former Member]

Dear,

i do not want to change the last purchase price, but i need it should update in issue component.

[Former Member]

Hi Rahil.........

How many warehouses you are manitaining for sugar and with what warehouse cost?

Regards,

[Former Member]

This Item is in 6 Warehouses

[Former Member]

Ok

What is the warehouse cost of each warehouse for sugar? Actully in FIFO method first in first out comes in picture and thats why it might be one of the reason of capturing 50 instead of 60 as last purchase price.........

Regards,

[Former Member]

Dear,

Sugar is purchase item. its cost will calculate from AP invoice. we need updated last purchase price in issue components, is there anyways,

Regards

Rahil Hassan