Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

No ShipExpireDate in the SO_SalesOrderHistoryHeader table either for these three orders

Posted By Nick J 11 months ago

Running On Time Delivery queries/reports to get historical data, and found SalesOrderNo's Completed a few years ago that have a ShipDate that is years in the future in AR_InvoiceHisturyHeader. No ShipDate on Sales Order Inquiry Screen either.

0 BigLouie 11 months ago

It's called the Promise Date and it's in the SO_SalesOrderHistoryDetail
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 11 months ago in reply to BigLouie

I'd consider using AR_InvoiceHistoryDetail's PromiseDate.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

No ShipExpireDate in the SO_SalesOrderHistoryHeader table either for these three orders

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING