Updating F4211 from Work Order Form

[Jamie_Yates]

From the Work Order Details form, I want to update the related sales order when the requested date is updated.
I am having problems figuring out how the F4211 and the F4801 tables relate to each other. Which fields do you need from the F4801 to uniquely define a single record in F4211.

Thanks in advance

Jamie

OW XE, SP 15, NT(SP6a), Oracle

 

[Larry_Jones]

Jamie,

if the Sales Orders in question are 'W' line types (that automatically create Work Orders) then the RORN, RCTO, and LNID (Related Order, Related Order Type, and Line Number) should automatically be populated. You may use these three fields to link back to the SO Line. Be aware that that RORN is not a numeric field but instead is a zero filled string, so convert its contents to a variable based on DOCO before doing your fetch.

Regards,

Larry Jones
[email protected]
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials

 

[jdeman]

Extending on the lines what Larry mentioned. Apart from SO# (RORN), SO Type (RCTO), LNID (Line#) you might also be interested in RKCO (Company).
Also you can view all the above mentioned columns (except for LNID) from the following application:-
Menu: G3111
Application: "Enter/Change Order" - P48013/W48013A (Tab: "Addl Detail 2")

jdeman
OW-XE (SP16.1) WINNT
Co-exist AS/400

 

[Jamie_Yates]

Thankyou both for your advice.

I'll give it a go...

Jamie

OW XE, SP 15, NT(SP6a), Oracle