Transfer order not calculating cost price correctly

(0) Share

Report

Posted on by Hemraj

590

I purchased one item with two separate batch number and Serial number with different cost price. Inventory model group is FIFO used. I also changed Inventory dimension group as per requirement.

Item A, Batch # B001, Sr. number S001, Qty 1, Cost price $100

Item A, Batch # B002, Sr. number S002, Qty 1, Cost price $500

Cost price allocated based on above transactions.

Created Transfer order ( From Warehouse 11 to WH 21)

Transfer order line, Just entered qty 2 and reserve automatically

Picking list registration

It;s created two spearate line based on batch and serial number.

I shipped and received the transfer order.

Now cost price is update # 300 each.

Item A, Batch # B001, Sr. number S001, Qty 1, Cost price $300

Item A, Batch # B002, Sr. number S002, Qty 1, Cost price $300

I did inventory recalculation but no luck.

I also tested same scenerio into AX2009 and AX2012 vanilla and it's same.

Any suggestion will help me lot.

Thanks

Raj

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Themba 15 on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Hi Raj

I am also experiencing in AX2012. Microsoft have said this is is by design. Not sure if FIFO means something different in AX than in does in other systems or accounting

Was this reply helpful? Yes No
Hemraj 590 on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Thanks for your reply!

I already open ticket to Microsoft, I also know what will be their answer

There answer will be "It's way to designed"

Thanks

Raj

Was this reply helpful? Yes No
Hemraj 590 on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Thank you Friends.

I also tested this scenerio in multiple ways and thought it's bug in application.

I also open ticket at MS but I am expecting same answer as you got.

Thanks again for your time and support.

Raj

Was this reply helpful? Yes No
Ryuji Mita 465 on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

I've experienced the same problem and reported it to Microsoft Support. They say that it is by design, and cannot be fixed in the release (AX2009). The only work around they had was to create a transfer order line per batch# (or serial# if you are using serial), which usually is not acceptable to the end-user...

Was this reply helpful? Yes No
Suggested answer

Weaveriski 23,616 Moderator on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Yes I can confirm if you ship it as one line it gets the cost incorrect and the recalculation does not adjust it. I can only suggest you log this with Microsoft because there is no configuration that would stop it doing this.

Was this reply helpful? Yes No
Hemraj 590 on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Yes, First I did the invoice the PO to make sure it's update financial cost.

I just wanted to ask question, did you created two separate line on transfer order ? if so, dont create two different line.

Just create one transfer order with Qty 2(without Batch number and Serial number) and try out. See below

If I create two separate line with Batch number and serial number, it's work for me but scenerio is I would like to create single line with multiple qty.

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

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Have you invoiced the original transaction to have a financial cost?

Setting it up using your settings and purchasing and transfering it works fine as you can see below

Was this reply helpful? Yes No
Hemraj 590 on at

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

Thanks WEAVERISKI,

I did financial inventory checkbox yes for batch and Serial number as well. In my dimension group

Active field=>Site, WH, Batch number, location, Serial number all flag yes. Primary stocking field=> all flag yes, physical inventory field=> all flag yes, financial inventory field => all flag yes. Mandotary field=> only site and WH flag yes.

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

Like (0)

Report

RE: Transfer order not calculating cost price correctly AX2009

In the dimension group which dimensions are you tracking "Financial Inventory" by? I am guessing just Site and Warehouse. If you want to track costs by further dimensions you need to flag it against batch and serial as well.

Was this reply helpful? Yes No