How can set up two purchasing prices on an item and display just one price?

(0) Share

Report

Posted on by Lisa in LA

We are importing goods from other countries. I need to setup 2 prices for an item - Price 1 for FOB, Price 2 for DDP. But I just need to display DDP price in Purchasing Order. Where can I set up 2nd unit price and how can I display just DDP price in POs.?

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Nitin Verma 21,794 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Lisa in LA ,

You can define your Items prices based on the Vendor and Item, for this you can use the Purchase price functionality from the Item card, as per the below image.

You can also define the Unit of Measure to select the correct price on PO side.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Lisa,

Adding to Nitin's reply... Since base NAV creates a Unit Cost per UOM, you can setup the DDP and the Base UOM purchase price. As for the FOB price, not sure why you need to load it, since you are never showing on the Purchase Order. If you need to have both Unit Costs to select or insert, on the PO, then you could create a UOM called FOB = 1 and the Unit Cost = FOB value.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I think it is also possible to create two different Variants for this Item to set different prices.
But this requires one more selection of Variant when creating an order.

Hope this also helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Lisa in LA 10 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much, Nitin. This is very helpful.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Lisa in LA ,

Glad to know that its helping you, if you think you question is resolved, you can mark this thread as closed and verify my answer, so that others can take a help fromthis.

Was this reply helpful? Yes No
Lisa in LA 10 on at

Like (0)

Report
Copy link

Link copied!

I got it. Thank you so much Zhu!

Was this reply helpful? Yes No
Lisa in LA 10 on at

Like (0)

Report
Copy link

Link copied!

Zhu, I setup two prices under Unit Price, and FOB and DDP under variant code then created a PO. However the field under Direct Unit Price is empty. What did I do wrong?

Was this reply helpful? Yes No
Suggested answer

Alok.kulshreshtha 934 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Please check following on purchase price -

1. Unit of measure - if UOM is setup on purchase price list than unit price on purchase order will update for that UOM only. if blank than ignore

2. Minimum Order Quantity - if MOQ is setup on purchase price that Unit price will pull through base on the order order quantity, if order quantity fall under MOQ than system will update the unit price. if blank ignore.

3. Start and End Date - if Start and End date is not blank than system will bring the price based on these two date. Posting date/ Order date should fall under start and end date. if both is blank ignore.

4. Vendor No - check vendor no is correctly updated on purchase price. it should be same on purchase order.

Hope this 4 points will help.

Regards,

Alok Kulshreshtha

Please verify my answer if you feel my post is helpful

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, From your screenshot, I think you are using NAV2013.

I tried it. It doesn't seem to be a problem.

So please check the currency, UOM and other information again.

Test Video:

[View:/cfs-file/__key/communityserver-discussions-components-files/34/Test05181112.mp4:965:724]

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No