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
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.
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. :)
Thanks for the detail, I will try to update you regarding the field you are looking for by tomorrow. :)
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/
correct.
The 'Current Promise Date' is located in column SOITEMPROMISEDATE_I of table IS010001.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
