Microsoft Dynamics AX (Archived)

The issue transaction don't get the unit cost

(0) Share

Report

Posted on by Cuong

Dear Friend,

I have a issue:

1/ I created a issue transaction (unit cost is 0)

7382.A1.png

and

1106.A2.png

2/ I created a receipt transaction with unit cost is 20000.

0458.A3.png

Question:

1/ I want to track cost at the serial item level.

2/ I want the issue transaction can automatic adjust unit cost is 2000 according with the receipt transaction.

Could you help.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Yohann Rolland Axcible 3,111 on at

Like (0)

Report
Copy link

Link copied!

Hi,

1/ Try to check the financial stock on the tracking dimension group for serial tracked items.

2/ How do you managed receipts and issues ? with journals ? What are you trying to achieve. With marking between a SO/PO you can do what you want. What is your item model group method ?

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

Like (0)

Report
Copy link

Link copied!

As Yohann says, tick 'Financial inventory' on the Serial Dimension. As long as you are not running Standard Cost, AX should do what you want.

Was this reply helpful? Yes No
Cuong on at

Like (0)

Report
Copy link

Link copied!

Dear Friend,

I setup by your recommend. I use Item Movement. Item model Group is serial, tick 'Financial inventory' on the Serial Dimension.

My expected: I want the issue transaction can automatic adjust unit cost is 2000 according with the receipt transaction.

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

Like (0)

Report
Copy link

Link copied!

It will..

If you post the negative adjustment before the receipt (i.e. if you are allowed negative inventory) AX will set the cost of the negative adjustment the next time you run Inventory close (which is pretty much mandatory if you use most of the Actual Costing methods).

If you post the positive adjustment first, and then post the negative adjustment, AX will use the cost immediately. It might not show it on the Journal line, but you will see it on the related Inventory transaction.

Was this reply helpful? Yes No
Cuong on at

Like (0)

Report
Copy link

Link copied!

Dear Friend,

My business is issue first, receipt then.

I don't understand about "AX will set the cost of the negative adjustment the next time you run Inventory close (which is pretty much mandatory if you use most of the Actual Costing methods)."-->Could you help?.

I'm newbie of Inventory closing.

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

Like (0)

Report
Copy link

Link copied!

Hi Cuong,

I did this video, rather than write everything down and screenshot it. Hope it helps:

https://youtu.be/uy8q9u4r0Y8

My favourite learning resources for Inventory costing were a hands on lab called Costing and Inventory Valuation:

mbs.microsoft.com/.../courseHOLCIVAX2012

and the TechNet pages:

technet.microsoft.com/.../gg213716.aspx

Was this reply helpful? Yes No