Microsoft Dynamics AX (Archived)

Can I change unit cost price for an item using FIFO?

(0) Share

Report

Posted on by SteveWhyte

583

Can I change the cost price for an item if the item is assigned to an item model group that is set to FIFO costing?

Or can I only change it if it was assigned to an item model group that is set to Standard?

Steve

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

gkumar 740 on at

Like (0)

Report

Hi Steve,

You can setup a new cost price as Planned cost and activate the same.

System does the requisite adjustments when Inventory is recalculated prior to closing based on FIFO principle.

Thanks,

Ganesh

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Steve,

The price that is used for issue transactions, such as sales, is determined by Ax. You cannot directly influence it if you use a so-called current valuation method as FIFO.

You can, however, override it in special cases. Such a special case is a purchase that has been made especially for a sales order. I this case you can make use of the marking function and thereby channel the purchase price to the sales order and override the FIFO price.

If you provide some additional infos on your case we can possibly give you some more concrete hints.

Best regards

Ludwig

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report

Thanks for the info Ganesh

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report

Ludwig:

Here is the situation:

I go to Inventory and Warehouse Management>Common>On-Hand Inventory.

I select my item number and go to on-hand. At the bottom of the screen it says cost price $112.26. I need it to say $112.21.

Can you walk me through on the steps to change that cost price to $112,21 ?

Steve

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report

Ludwig.

Here is some more information

The unit cost of the item was consistently at $112.21.

A counting journal was then done and 3 batches for the item were adjusted for the stock count and one of the batches is costed at a different price and I don't know how to investigate it and even more importantly how to change the cost price.

Need some help on this

Steve

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

Like (0)

Report

Hi Steve,

Just to help suggest the best solution, I was wondering if the Batch line on your item's Tracking Dimension Group has 'Financial inventory' ticked?

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

Like (0)

Report

I thought about it some more. The answer to that question probably doesn't matter with the method I am going to suggest!

If the batch is still in on-hand inventory, I suggest you adjust it out using one of the journals in the inventory module. You could back date the journal line to match the date of the original count journal if you want. Then you need to use Inventory marking to link the original count journal and this new adjustment. Tim shows how to use Inventory marking in this blog post:

timsaxblog.wordpress.com/.../exactly-reverse-an-inventory-journal-in-ax-2012

This will ensure that inventory close does not assign the 'wrong' cost to something else. Then use another inventory journal (another count journal if you like) to bring the batch into inventory again, this time with the cost price you want. You can back date the journal line here too if you want.

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report

Thanks for your response Guy. Really appreciate the suggestion.

Will real the blog post now

Again,,Thanks

Was this reply helpful? Yes No