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
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
If you go to Item Card and check on the Inventory Tab, you will find most of the information you required
Item card has all these features avaiable .Check the item card
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.
Thanks for your response, will look into it.
On Item Card for that item there are fields such Qty. reserved on sales order.... you need to check those fields.
#1
André Arnaud de Cal...
291,904
Super User 2024 Season 2
#2
Martin Dráb
230,605
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
