Is there anyway to track which item that was sold in Sales Order was being purchase in which Purchase Order in Navision ?

(0) Share

Report

Posted on by joshtechsolutions

4,947

Hi Community,

I would like to find out how this can be done.

I would like to track which item that was sold in sales order, was from which Purchase Order when we first purchase them...

Anyway to track like this?

Thank you!

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Inge M. Bruvik 1,057 Moderator on at

Like (1)

Report

RE: Is there anyway to track which item that was sold in Sales Order was being purchase in which Purchase Order in Navision ?

If you use the costing method of specific you can trace that if you assign a serial or batch number both at purchase and sales transactions.

docs.microsoft.com/.../design-details-costing-methods

With out that you must look at your purchase transactions and make a decision based on the costing method you have one the item. Most if the inventory movements happens at the FIFO method. So the item you purchase first should be the first to be shipped. But reservations or other functions may change how it actually happens.

So the only safe and really reliable method is to use the item tracking functionality that comes with the "specific" costing method.

docs.microsoft.com/.../inventory-how-work-item-tracking

Was this reply helpful? Yes No
Verified answer

YUN ZHU 93,872 Super User 2025 Season 2 on at

Like (0)

Report

RE: Is there anyway to track which item that was sold in Sales Order was being purchase in which Purchase Order in Navision ?

Hi, I agree with Inge, it requires Lot Tracking to do this. Although it will give the user a lot of additional operations, it is the most accurate.

More details: https://www.youtube.com/watch?v=2kINpCas4is

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
joshtechsolutions 4,947 on at

Like (1)

Report

RE: Is there anyway to track which item that was sold in Sales Order was being purchase in which Purchase Order in Navision ?

Thank you Inge! Your descriptions to the solution is so clear and helpful!

Was this reply helpful? Yes No
joshtechsolutions 4,947 on at

Like (0)

Report

RE: Is there anyway to track which item that was sold in Sales Order was being purchase in which Purchase Order in Navision ?

Thanks Zhu!

Was this reply helpful? Yes No