View all item commitments in NAV

(0) Share

Report

Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: View all item commitments in NAV

Thanks for your response, will look into it.

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: View all item commitments in NAV

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

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ramesh lella 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No