I need to modify the Sales Edit List in Dynamics. My objective is to modify this report so that user can see item unit cost which is going to be used when the invoice is posted.
Our inventory valuation method is average perpetual. Therefore, the most current unit cost will be coming from the current cost field on item maintenance.
Thus, I want to modify this report (which is primarily using SOP10100 table and a TEMP table). I was surprised that I did not see the SOP10200 table as 'available' under relationships. I will research how I can add the SOP10200 table and then possibly the IV00101 table.
2 questions -
1. Can anybody think of a scenario where an average cost item would not be using the current cost from item maintenance at time of invoice posting?
2. Any other ideas of best methodology to preview item profitability before invoice posting? Or ddoes everyone agree this is best methodology?
Thanks in advance for any assistance,
BT
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156