Please find the attached Link to understand my concern.
We are Unable to bring the COST PRICE at 'On-Hand Inventory Warehouse' into Quotation's Line Level.We are using Dynamics 365 Operations and we have come to face a challenge in designing a Customization i.e. Bringing the COST PRICE (which is available in Inventory-->On-Hand-->Inventory Value-->COST PRICE) to Quotation's Line level.
We have analyzed & reviewed the calculation formula coded inside for that COST PRICE value, which has done based on Purchase and Sold type. Based on that, We have applied the formula like: (costamountadjustment+costamountposted)/qty and this is from 'InventoryTrans' table.
Ultimately we are unable to get (not retrieving at Line Level) the exact COST PRICE which is showing at the Inventory Value at ON-HAND.
Can anyone help?I can be reached at: email@example.comLooking forward to hearing from you.Thanks.