Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Modify Sales Edit List

Posted on by 4,887

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans