Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

View all item commitments in NAV

Posted on by Microsoft Employee

Hi Guys,

New to Nav, however feeling the heat.

Question is there a way to view all commitments on the qty of an item, commitments can include, transfers, Sales order, unposted sale transaction, purchase orders. I'm trying to produce a report that will assist in the item tracking by the operations team, but having trouble isolating how items as committed. I've found the Purchase Order thus far. Any help will be greatly appreciated.

  • Suggested answer
    Ramesh lella Profile Picture
    Ramesh lella 30 on at
    RE: View all item commitments in NAV

    you can try this logic in display method : To get financial dimension values based on personnel number in hcmworker.

    tried for department value in the same way will get all financial dimension value.

    HcmEmployment hcmEmployment;
    DimensionAttributeValueSetItem setItem;
    DimensionAttributeValueSet dimAttrValueSet;
    DimensionAttributeValue dimAttrValue;
    DimensionAttribute dimAttribute;

    select * from hcmEmployment
    where hcmEmployment.Worker == _this.RecId
    join dimAttrValueSet
    where dimAttrValueSet.RecId == hcmEmployment.DefaultDimension
    join DisplayValue from setItem
    where setItem.DimensionAttributeValueSet == dimAttrValueSet.RecId
    join dimAttrValue
    where setItem.DimensionAttributeValue == dimAttrValue.RecId
    join dimAttribute
    where dimAttribute.RecId == dimAttrValue.DimensionAttribute && dimAttribute.Name =="Department";

    {
    info(strFmt("Employee = %1 %2 = %3 ",
    HcmWorker::find(hcmEmployment.Worker).PersonnelNumber,
    dimAttribute.Name, setItem.DisplayValue));
    }

    Thanks & regards

    Ramesh Lella

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: View all item commitments in NAV

    If you go to Item Card and check on the Inventory Tab, you will find most of the information you required

    2017_2D00_04_2D00_04_5F00_17_2D00_24_2D00_16.png

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: View all item commitments in NAV

    Item card has all these features avaiable .Check the item card

  • Suggested answer
    keoma Profile Picture
    keoma 32,671 on at
    RE: View all item commitments in NAV

    check out the item card image on www.dynamicsbusiness.co.uk/.../block-by-default-in-dynamics-nav.html

    in the general tab you find a couple of fields starting with "Qty. on ...". These are the fields you need. edit table item to check, how the fields are defined.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: View all item commitments in NAV

    Thanks for your response, will look into it.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,640 on at
    RE: View all item commitments in NAV

    On Item Card for that item there are fields such Qty. reserved on sales order.... you need to check those fields.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans