Planned PO converts units wrong and at firming PO the wrong qty is used.

(1) Share

Report

Posted on by Community Member

My problem is that planned PO trade quantity differs from purchase quantity when using unit conversion.

Everything looks fine in net req. and planned po generates the correct qty in requirement profile but when firming the planned PO it uses the stock qty which in this case is pcs but purchase unit is pack. one pack is 4122pcs, firmed PO becomes 4122 packs resulting in 16990884pcs :0

I have the correct units in BOM, on the items different fast tabs and on TA. Unit conversion seems fine as well and net requirement calculates correctly.

Also, I have tried to end the TA with a backdated "To Date" which made no difference.

I'm new on this forum and quite new in AX. I have tried to find any post dealing with this but only found price related or other errors with solutions i already knew, i can't find that i have set up the system wrong.

4784.netreq.JPG

After firm of PlannedPO and recalculate netreq

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Weaveriski 23,620 Moderator on at

Like (0)

Report
Copy link

Link copied!

Trade quantity is not a standard field I believe - what is your customisation to the system doing here? I am presuming that is on the planned order? I would expect that field is your issue

You should also show your unit conversion and how the UOM on the screenshots as it is a UOM issue. It could be you have this the wrong way around as the result is the pcs multiplied by pcs to get a "pack", wheres you want a 1 pack PO for the 4122 inventory

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for the answer. Yes, i checked and the field Trade Quantity is a customisation. Then it's likely the problem lies in that code. I will have it checked.

In the meantime I post the unit conversion. To ensure there is no issues there.

Was this reply helpful? Yes No
Verified answer

Weaveriski 23,620 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes that looks fine, I would add in the reverse to cover that, so the button says 4122 pcs = 1 pack. Will assume the uom on the PO is pack!

If you manually load a PO for one pack the line details should show you the 4122 inventory quantity.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Issue solved. There was a customization in planned PO to consider special fields in Trade Agreement. In that calculation, unit conversion wasn't considered.

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

Like (0)

Report
Copy link

Link copied!

Glad you found it in the end!!

Was this reply helpful? Yes No