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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Requested Ship Date

(0) ShareShare
ReportReport
Posted on by 10

Hi, I was wondering if it’s possible to change the requested ship date after posting the sales batch. As we usually have the requested ship date to be the same as our invoice date. However, after posting i realised that although the invoice date was changed to 31/12/2021, the requested ship date remained as 31/12/2022. Is there anyway to amend this? Also, will this affect any other reports?

Categories:
I have the same question (0)
  • Suggested answer
    Josh Page Profile Picture
    Microsoft Employee on at

    In core GP there does not appear to be a way to change the date after posting. With that said, the data is in the below tables (depending on if it's in work or posted).

    select ReqShipDate,* from SOP10100

    select ReqShipDate,* from SOP30200

  • Tim Wappat Profile Picture
    5,713 on at

    You may set up a SQL server SQL job to update the field in SOP10100 to whatever you need, for example each night, based on the the last invoice date for that same MSTRNUMB. ~The exact logic depends on how you use GP.

  • Suggested answer
    ZararMahmood Profile Picture
    25 on at

    Hi reen,

    after posting GP does not allow to change the date from frontend but you can update the date from DB.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans