Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Unit Cost with Unit of Measure on Purchase Orders

Posted on by 4
Hello, 
 
I am looking for a clear way that purchasing agents/buyers can see the unit cost and total cost on a PO.

Currently our unit cost is pulling from last direct cost. I updated this so for example:

Purchasing Unit of Measure is 100PK with QTY 100 (want to stock as each)
 
Lets say the total pack is $50/100 then the unit cost is $.50. When placing a PO for this item it only gives the cost of the $50 total. Is there a way to see the conversion on a PO of $.50 - 100PK - = $50.00 total on the purchase order. 
Categories:
  • Ben Baxter Profile Picture
    Ben Baxter 4,497 Super User 2024 Season 2 on at
    Unit Cost with Unit of Measure on Purchase Orders
    I think Kaspars has provided the solution to what you are looking for:
    "You can do a small customization to Purchase Line table (ID 39) (or Purchase Order Subbform page (ID 54) and add a column that will calculate Amount/Quantity(base). It will be 5000$ / 10000 = 0,50$"
     
    Best Regards,
    Ben Baxter
  • Suggested answer
    Unit Cost with Unit of Measure on Purchase Orders
    Thank you all, but I want you to understand the UOM as well. The Posted Purchase Invoice Lines helps a little but still does not seem right. the Direct Unit cost is not taking into account the QTY on the UOM. 
     
    The Base is set as 1 Each. 
     
    The Purchasing Unit of Measure "Code" is 100PK which could really just say pack. The QTY on that Code is what matters and what is stocked to your base. 100 will stock 100 each. 
     
    Currently the Code is 100PK- 100. 
     
    On a purchase order, the PO will take the Last Direct Cost (unit) and multiply by this QTY for the total but this shows as Unit Cost for the whole unit of the pack. 
     
    However; on the PO you can only see the total of the cost of the Pack not the unit cost of the $.50
     
    I am looking for this so the purchasers/buyers can see the conversions. 
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,692 Super User 2024 Season 2 on at
    Unit Cost with Unit of Measure on Purchase Orders
    I think this is visible only after posting in Value entries.
    To have the values for each piece, You would need to define the Base Unit of Measure = Piece  (1 unit)
    Then add additional Unit of Measures for the item
    100PK = 100 Piece
     
    then on the Purchase order You indicate the Unit of Measure 100PK and enter quantity 100, Unit cost 50$ (for one 100PK). System will understand that actually You are buying 100*100 pieces = 10000 units (in table field Quantity (Base) (5415, Decimal)
     
    You can do a small customization to Purchase Line table (ID 39) (or Purchase Order Subbform page (ID 54) and add a column that will calculate Amount/Quantity(base). It will be 5000$ / 10000 = 0,50$
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,842 Super User 2024 Season 2 on at
    Unit Cost with Unit of Measure on Purchase Orders
    Hi, you can try the page below first.
     
    Or search directly on the page below.
     
    Hope this helps
    Thanks.
    ZHU

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans