web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Modify Sales Edit List

(0) ShareShare
ReportReport
Posted on by 4

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

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans