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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP10 Sales Or...
Microsoft Dynamics GP (Archived)

Dynamics GP10 Sales Order Processsing

(0) ShareShare
ReportReport
Posted on by Elizabeth Nentwig 205

What table contains the SOP 'Customer Promise Date' in GP10?  I've located SOITEMPROMISEDATE  in the IS030001 table but this date is equivalent to Req_Ship_Date in the SOP30300 table.  I'm looking specifically for promise date entered on the 'Additional >> Manufacturing Sales Item Detail' window.

Any help would be greatly appreciated!!

 

*This post is locked for comments

I have the same question (0)
  • Congruent Dynamics Profile Picture
    Congruent Dynamics 735 on at

    The 'Current Promise Date' is located in column SOITEMPROMISEDATE_I of table IS010001.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    correct.

  • Elizabeth Nentwig Profile Picture
    Elizabeth Nentwig 205 on at

    Hello Almas,  Thank you for your quick response.  I am aware of this table (IS010001) however am looking for historical data.  I should have been more specific with my question/problem.

    On our sales orders we assign two dates to the line item using the Additional >> Manufacturing Sales Item Detail screen; customer's requested date (date from customer p/o) and customer promise date (date our company commits/promises against the customer's requirement).  When a product actually ships, we measure our delivery performance against each of these dates....how well are we meeting the customer's requirement and how well are we achieving our internal plan.  IS010001 contains information for invoices but not once they have been posted.  IS030001 SOITEMPROMISEDATE_I is not the correct date field from Manufacturing Sales Item Detail screen....  Does anyone know if the Customer Promise Date is stored in another historical table so that we can establish this performance measure?

    Thanks again all

    B/

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    Thanks for the detail, I will try to update you regarding the field you are looking for by tomorrow. :)

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    I hate when I don't get time to do something which I really want to do.. getting no time to explore this. :(

    but will check tomorrow. :)

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    Elizabeth,

    In fact SOITEMPROMISEDATE_I is the correct promise date field in IS030001.

    Also for posted invoice this table have two records one for sales order and other for sales invoice.

    So you have to look for sop order and sop type=2 for the manufacturing order to check the promise data.

    BTW I didn't find any change in promise date after posting, it remains same for sop type 2 and 3 in this table.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans