Determining the Ship To address for a GL record

kevinp2

Member
Hi,

I have looked around a lot, but cannot seem to find an answer for this.

I am a Business Intelligence developer and am writing a report that starts with the GL. For a given GL record, typically a sale, I can obtain the Bill To address easily enough (GLAN8). Is it possible to look up other tables to find the Ship To address for the transaction in question? I have tried joining to F03B11 (Accounts Receivable) but that table does not seem to contain any Ship To fields.

Any help is appreciated! I am a backend developer and am far from an expert on JDE's workings :)
 

johndanter

Legendary Poster
F03B11 has SHPN (Shipment Number) so can you jump from there to a given F4211 SHPN too. So you can get your F4211.SDSHAN

Plus F03B11 RPSDOC SPDCT SKCO are the F4211 SO key
 
Last edited:
Top