When it comes to extracting data from F4211/F42119 to return shipping quantites and tracking numbers, we have multiple options to query the data.
One such option would be to use SQL Access to return the shipping quantites and carrier tracking numbers.
Another option would to incorporate F4211 (F42119) into the outbound ASN schema.
F470371: Below is the initial set-up with F47036 and F470371. We we list the F470371 keys: EDLN, STPC, ANTY and LINS.
F4201: We set-up F4201 as a child record, off of F470371. Instead of using the customary key of EDOC, we will use DOCO, DCTO and KCOO.
F4211: Just as we assigned a key structure to F4201, we will set-up the keys for F4211. In the example below, we use DOCO, DCTO, KCOO, and LINS.
After the outbound 856 (ASN) Schema has been set-up and the keys have been assigned, we will be able to retrieve carrier tracking information from tables such as F4211.
For more information on JDE Hacks and Tips:
By: Sean Hoppe on