Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Direct unit cost as the value for PO

(0) ShareShare
ReportReport
Posted on by 401

Hi All,

Just wanted to know do we have an option in NAV 2015 to default the unit cost instead of direct unit cost.

4331.Screenshot_5F00_1.png

So that when I select the item in the po line the value will be calculated based on the unit cost and not from the direct unit cost

*This post is locked for comments

  • Suggested answer
    Jens Glathe Profile Picture
    6,092 on at
    RE: Direct unit cost as the value for PO

    Hi there,

    you could set up "Indirect Cost %" for an approximation. Depends a little on what you want to achieve... See here: msdn.microsoft.com/.../hh175422(v=nav.90).aspx

    with best regards

    Jens

  • Suggested answer
    Amol Salvi Profile Picture
    18,694 on at
    RE: Direct unit cost as the value for PO

    When po get created then it picks up laat dirct cost and display in po unless you define the purchase prices.

    Your issue belongs to purchase order line amount and not with item card.

    Best option would be make changes at PO level rather than updating cost on item card.

  • Tina Menezes Profile Picture
    2,582 on at
    RE: Direct unit cost as the value for PO

    Hi Santarzan,

    Yes. You can create a batch. Create a function in a code unit .In OnRun trigger call this function. Now in the function you have to write the following code:

    Itemtable.reset

    If Itemtable.findfirst then begin

    Itemtable.direct unit cost := Itemtable.unit cost;

    Itemtable.modify(true);

    End;

    Now create a job queue and set this codeunit object to run.

  • Suggested answer
    CDsilva Profile Picture
    4,188 on at
    RE: Direct unit cost as the value for PO

    Hi Santarzan,

    You can create an setrange between the Item no in the page and Item table then fetch the Unit cost from Item table.

    In the OnValidate trigger of No field you can code as below

    IF Type=Type::Item THEN BEGIN

     Item.GET(Rec."No.");

     Description:=Item.Description;

     "Unit Cost":=Item."Unit Cost";

     "Unit Of Measure Code":=Item."Base Unit of Measure";

    END;

    This will populate the Unit cost field with the default unit cost from Items

  • ManishS Profile Picture
    80 on at
    RE: Direct unit cost as the value for PO

    Why don't you use purchase price then ?

  • Hasitha Jayasuriya Profile Picture
    645 on at
    RE: Direct unit cost as the value for PO

    Hi Santarza,

    There could be a workaround. Does the Unit cost of your item change frequently ?. What sort of costing method do you use ?

    Regards,

    Hasitha J

  • santarzan Profile Picture
    401 on at
    RE: Direct unit cost as the value for PO

    Hi Amol,

    Thanks for the information I also want to know that will it work if I create a batch update items through journal entries to update the Direct Unit Cost so that it matches the Unit Cost?

  • Suggested answer
    Amol Salvi Profile Picture
    18,694 on at
    RE: Direct unit cost as the value for PO

    You need to customize it

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans